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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
SqlParameter string
strSql = "Insert into News(TypeId,NewsCaption,NewsContent) values(@TypeId,@NewsCaption,@NewsContent)" ;
SqlParameter[] paras ={
new
SqlParameter( "@TypeId" ,SqlDbType.Int),
new
SqlParameter( "@NewsCaption" ,SqlDbType.NVarChar,200),
new
SqlParameter( "@NewsContent" ,SqlDbType.NText)
};
paras[0].Value = typeId;
paras[1].Value = caption;
paras[2].Value = content;
int
rows = new
SqlHelp().ExecuteNonQuery(strSql, paras);
public
SqlHelp() {
connString = ConfigurationManager.AppSettings[ "sqlServer2005DbName" ];
}
public
int ExecuteNonQuery( string
strQuery, SqlParameter[] paras) {
int
rows = 0; //影响行数
try
{
using
(SqlConnection conn = new
SqlConnection(connString)) {
using
(SqlCommand command = new
SqlCommand()) {
PrepareCommand(conn, command, strQuery, paras);
rows = command.ExecuteNonQuery();
return
rows;
}
}
} catch
{
throw ;
}
}
//带参数的DML操作 private
void PrepareCommand(SqlConnection conn, SqlCommand command, string
strQuery, SqlParameter[] paras) {
if
(conn.State != ConnectionState.Open) {
conn.Open();
}
command.Connection = conn;
command.CommandText = strQuery;
command.CommandType = CommandType.Text;
if
(paras != null ) {
foreach
(SqlParameter parm in
paras)
command.Parameters.Add(parm);
}
}
|