using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;
AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "Insert into T_Users(UserName,Password) values('" + username + "','" + password + "')";
cmd.ExecuteNonQuery();
Console.WriteLine("插入成功");
}
}
Console.Write("打开数据库链接成功");
Console.ReadKey();
错误显示
string sql = string.Format("insert into T_Users(UserName,Password) values('{0}','{1}')",username ,password );
cmd.CommandText = sql;
è¿æ ·æ¹å¯ä»¥äºãè½è§£éä¸åæ¬ä¸éè¿çåå åï¼è°¢è°¢
ä¸éè¿å 为æå
¥çæ¶åæ¯è¾è®²ç©¶åµåµï¼æ没ç¹æå»ç 究è¿ã
以ä¸2ç§åæ³éåå é¤ï¼æ¥æ¾çæ¶åç¨ï¼æå
¥çæ¶åå»ºè®®ä½ è¿æ¯ç¨æåä¸ç§æ¯è¾è§èã
é误çåå å°±æ¯å符串æ¼æ¥æé®é¢ï¼åæ£æ°æ®åºå°±æ¯ä¸è¯å«ã
å
å¼è¿æ¯ç»éªä¹è°åï¼ä½ 以ååªè¦ç¥éåçè¿ç§æ
åµå¦ä½è§£å³å°±è¡äºï¼ä½å¿
å»æ·±ç©¶å¢ã
ç¹å«æ¯ç¼ç¨ï¼ä¸æ¡è·¯èµ°ä¸éçæ¶åå«é»çè§å°ï¼æ³æ³å
¶ä»åæ³ã