添加事件!!!
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 求教啊!!大侠们!!
解决方案 »
- mysql AUTO_INCREMENT 字段 转成字符型输出,我用的asp
- 急~~~~~~~~~~~~postgres数据库间数据倒换问题~~~~~~~~~~~~~~~·
- 连接mySQL数据库失败频繁,主要是什么原因造成的?
- 老问题:找不到libmysqlclient.so.10和libmysqlclient_r.so.10
- varchar(50) 改为varcher(150),怎么改?
- 关于备份数据库的问题,用的是mysql front这个软件
- 一个数据库中有两种存储引擎 myisam innodb
- 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直接运行结果是否正确