110,499
社区成员
发帖
与我相关
我的任务
分享
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "Data Source=(local);Password=密码;User ID=sa;Initial Catalog=数据库名称";
cn.Open();
//插入数据测试
String sql = "Insert Into Table1(UserName) Values(@UserName)";
SqlCommand cmd = new SqlCommand(sql, cn);
String UserName = "测试的文字";
cmd.Parameters.AddWithValue("@UserName", System.Text.Encoding.GetEncoding("GB2312").GetBytes(UserName));
cmd.ExecuteNonQuery();
//读取测试
sql = "Select UserName From Table1";
cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Byte[] raw = (Byte[])dr[0];
string result = System.Text.Encoding.GetEncoding("GB2312").GetString(raw);
Response.Write("<li>" + result);
}
cn.Close();