日期:2014-05-18 浏览次数:21024 次
//参数sql语句写法
//SqlParameter[] paras =
//{new SqlParameter("@username",SqlDbType.NVarChar),
// new SqlParameter("@ip",SqlDbType.NVarChar),
// new SqlParameter("@time",SqlDbType.DateTime),
// new SqlParameter("@logstate",SqlDbType.Bit),
// new SqlParameter ("@illegal",SqlDbType.Bit),
//};
//paras[0].Value = username;
//paras[1].Value = ip;
//paras[2].Value = time;
//paras[3].Value = logstate;
//paras[4].Value = illegal;
//string sqlcmd = "insert into User_Log (用户名,ip,登陆时间,在线状态,非法登陆) values "+"(" +@username + "," +@ip+ "," +@time+ "," +@logstate+ "," +@illegal+")" ;
SqlCommand cmd = new SqlCommand(sqlcmd, conn);
//cmd.Parameters.Add(paras[0]);
//cmd.Parameters.Add(paras[1]);
//cmd.Parameters.Add(paras[2]);
//cmd.Parameters.Add(paras[3]);
//cmd.Parameters.Add(paras[4]);
//foreach (SqlParameter i in paras)
//{
// cmd.Parameters.Add(paras);
//}
string sqlcmd = "insert into User_Log (用户名,ip,登陆时间,在线状态,非法登陆) values(@username,@ip,@time,@logstate,@illegal)" ;
------解决方案--------------------
//参数sql语句写法
SqlParameter[] paras =
{new SqlParameter("@username",SqlDbType.NVarChar),
new SqlParameter("@ip",SqlDbType.NVarChar),
new SqlParameter("@time",SqlDbType.DateTime),
new SqlParameter("@logstate",SqlDbType.Bit),
new SqlParameter ("@illegal",SqlDbType.Bit),
};
paras[0].Value = username;
paras[1].Value = ip;
paras[2].Value = time;
paras[3].Value = logstate;
paras[4].Value = illegal;
string sqlcmd = "insert into User_Log (用户名,ip,登陆时间,在线状态,非法登陆) values (@username,@ip,@time,@logstate,@illegal)" ;
SqlCommand cmd = new SqlCommand(sqlcmd, conn);
cmd.Parameters.AddRange(paras);