-
Notifications
You must be signed in to change notification settings - Fork 0
/
clsFunc.cs.cs
38 lines (32 loc) · 975 Bytes
/
clsFunc.cs.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.IO;
using System.Data;
namespace CRM
{
class clsFunc
{
DataTable dtable = new DataTable();
SqlConnection con = null;
SqlCommand cmd = null;
DataTable dt = new DataTable();
Connectionstring cs = new Connectionstring();
public void LogFunc(string st1, DateTime st2, string st3)
{
con = new SqlConnection(cs.DBcon);
con.Open();
string cb = "insert into Logs(UserID,Date,Operation) VALUES (@d1,@d2,@d3)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.AddWithValue("@d1", st1);
cmd.Parameters.AddWithValue("@d2", st2);
cmd.Parameters.AddWithValue("@d3", st3);
cmd.ExecuteReader();
con.Close();
}
}
}