添加事件!!!
DBConnection db = new DBConnection();
string sql = "insert into liuzhuan (biaoti,qixian,lzfangshi,tdleixing,tdxingzhi,mianji,synianxian,lznianxian,jiage,dlweizhi,xxmiaoshu,lxren,lxdianhua,faburen)";
sql += "values(@biaoti,@qixian,@lzfangshi,@tdleixing,@tdxingzhi,@mianji,@synianxian,@lznianxian,@jiage,@dlweizhi,@xxmiaoshu,@lxren,@lxdianhua,@faburen)"; MySqlParameter[] parme = new MySqlParameter[]
{
new MySqlParameter("biaoti",xxbiaoti.Text),
new MySqlParameter("@qixian",yxqixian.SelectedValue.ToString()),
new MySqlParameter("@lzfangshi",fanshi.SelectedItem.Text),
new MySqlParameter("@tdleixing",Dtdlx.SelectedItem.Text),
new MySqlParameter("@tdxingzhi",tdxingzhi.SelectedItem.Text),
new MySqlParameter("@mianji",TextBox4.Text),
new MySqlParameter("@synianxian",TextBox3.Text),
new MySqlParameter("@lznianxian",TextBox2.Text),
new MySqlParameter("@jiage",TextBox1.Text),
new MySqlParameter("@dlweizhi",diliweihzi.Text),
new MySqlParameter("@xxmiaoshu",HtmlEditor.Text),
new MySqlParameter("@lxren",tlxren.Text),
new MySqlParameter("@lxdianhua",tlxdh.Text),
new MySqlParameter("@faburen","aaa"),//先默认以后改
db.ExecuteCommand(Sql, CommandType.Text, parme);2.数据库执行方法 public int @ExecuteCommand(string commandText, CommandType commandType, MySqlParameter[] pars)
{
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = GetConnection();
cmd.CommandText = commandText;
cmd.CommandType = commandType;
if (pars != null)
{
// cmd.Parameters.AddRange(pars);
foreach (MySqlParameter p in pars)
{
cmd.Parameters.Add(p);
// System.IO.File.AppendAllText("E:\\1.txt",p.ParameterName.ToString());
}
}
try
{
return cmd.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}提示添加成功 就是每行数据都为NUll 求教啊!!大侠们!!
解决方案 »
- 这样的sql怎么写?我混乱了关于left join
- MySQL FROM_UNIXTIME和UNIX_TIMESTAMP
- 小妹儿请教VS2008 如何与MySql连接。
- Postgres 如何把数据表中一列的值累加起来?
- 急!!!在LINUX下如何清除MYSQL的当前连接呀?
- 怎样吧mysql中用户的mail用sql导到.txt里呀!!!!在线等
- 求教:怎样远程连接一个MySQL服务器
- 我敲mysql确显示"Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)";刚才那个没分了,用这个,SORRY
- MySQL异地同步问题
- 求mysql排序语句
- 拼音首字母到数据库查对应的汉字
- 插入的联表操作
!
{
console.writeline( cmd.Parameters[i].ToString() ;
}
{
new MySqlParameter("biaoti",xxbiaoti.Text),
new MySqlParameter("@qixian",yxqixian.SelectedValue.ToString()),
new MySqlParameter("@lzfangshi",fanshi.SelectedItem.Text),
new MySqlParameter("@tdleixing",Dtdlx.SelectedItem.Text),
new MySqlParameter("@tdxingzhi",tdxingzhi.SelectedItem.Text),
new MySqlParameter("@mianji",TextBox4.Text),
new MySqlParameter("@synianxian",TextBox3.Text),
new MySqlParameter("@lznianxian",TextBox2.Text),
new MySqlParameter("@jiage",TextBox1.Text),
new MySqlParameter("@dlweizhi",diliweihzi.Text),
new MySqlParameter("@xxmiaoshu",HtmlEditor.Text),
new MySqlParameter("@lxren",tlxren.Text),
new MySqlParameter("@lxdianhua",tlxdh.Text),
new MySqlParameter("@faburen","aaa"),//先默认以后改
db.ExecuteCommand(Sql, CommandType.Text, parme);
}
要是这就是你的全部代码的话,能编译过吗?
db.ExecuteCommand(Sql, CommandType.Text, parme);
是在括号外的。
SQL语句的内容是什么;
2、在MYSQL直接运行结果是否正确