国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

C#中更新一條數(shù)據(jù)庫記錄寫法為： SqlConnection conn = new SqlConnection(connStr); string cmd1 = "update userInfo set xc02='" + xxx + "' WHERE userName='" + cUser + "'"; SqlCommand sqlcmd = new SqlCommand(cmd1, conn);//conn為上面的連接; conn.Open(); sqlcmd.ExecuteNonQuery(); 但當(dāng)我要更新數(shù)據(jù)列很多的時(shí)候，這個(gè)update語句長得很難對(duì)哪個(gè)是哪個(gè)。 ASP中要清楚得多： set rs=server.createobject("adodb.recordset") sql="select * from [user] where userName='"&cUser&"'" rs.open sql,conn,1,3 if rs.eof then rs.addnew rs("userName")=username rs("passWord")=password rs("ask")=pwwt rs("answer")=pwda rs("zctime")=now() rs("vip")=0 rs.update C#中有沒有這樣的寫法，請(qǐng)給個(gè)例子，謝！

SqlConnection conn = new SqlConnection(connStr); string sql= "update [userInfo] set xc02= @xc02,passWord = @password, ask = @ask WHERE userName= @username"; SqlCommand cmd = new SqlCommand(sql,conn) sqlParameter[] sqlParas = new sqlPararmeter[]{ new SqlParameter("@xc02",string xc02), new SqlParameter("@password",string password), new SqlParameter("@username",string username) } foreach(SqlParameter sp in sqlParas) { cmd.Parameters.add(sp); } conn.open(); cmd.ExecuteNonQuery();