id 递增了。其它字段为null
解决方案 »
- 两个aspx页面在一个htm页面上,怎么点击一个aspx上的内容,另外一个aspx页面会刷新?
- javascript 读取数据库字段
- 怎么实现的??????????在线等
- DataGrid模板列的问题
- gridview里面的文字怎么有html效果了?
- 获得textbox总行数
- asp.net问题! xmlhttp post过来的xml无法接收是怎么回事???
- frame的问题请帮忙
- if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem) 是什么意思,作什么用?
- 下拉列表框的选项如何可以模糊的查询!
- 请教个mvc2 中的问题。。。
- RewritePath问题
public int ADD_ExecuteNonQuery(MODEL.Student st)
{
StringBuilder builder = new StringBuilder();
builder.Append("(");
builder.Append("`usname`,`usage`,`usclass`)");
builder.Append(" values (");
builder.Append("@usname,@usage,@usclass)");
DbParameter[] cmdParms = { mydb.CreateInDbParameter("@usname", DbType.String, st.Usname), mydb.CreateInDbParameter("@usage", DbType.Int32, st.Usage), mydb.CreateInDbParameter("@usclass", DbType.String, st.Usclass) };
return mydb.ADD_ExecuteNonQuery(tablename, builder.ToString(), cmdParms);
}
----------------
public DbParameter CreateDbParameter(string paraName, DbType dbType, int size, object value, ParameterDirection direction)
{
MySqlParameter parameter = new MySqlParameter();
parameter.ParameterName = paraName;
if (size != 0)
{
parameter.Size = size;
}
parameter.DbType = dbType;
if (value == null)
{
parameter.Value = DBNull.Value;
}
else
{
parameter.Value = value;
}
parameter.Direction = direction;
return parameter;
}
--------------
foreach (MySqlParameter p in cmdParms)
{
p.ParameterName = p.ParameterName.Replace("?", "@").Replace(":", "@");
cmd.Parameters.Add(p);
}---------------------
public int ADD_ExecuteNonQuery(string tablename, string fieldsValues, DbParameter[] cmdParms)
{
StringBuilder builder = new StringBuilder();
builder.Append(string.Format("insert into {0} {1}", tablename, fieldsValues));
return this.ExecuteNonQuery(CommandType.Text, builder.ToString(), cmdParms);
}好多,,,就贴重点
con.Open();
string sql = "INSERT INTO student (`usname`,`usage`,`usclass`)" +
"VALUES(@usname, @usage, @usclass) "; MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
cmd.Parameters.Add("@usname",MySqlDbType.VarChar,10).Value = "sdf";
cmd.Parameters["@usname"].Direction = ParameterDirection.Input; cmd.Parameters.Add("@usage", MySqlDbType.Int32,10).Value =34;
cmd.Parameters["@usage"].Direction = ParameterDirection.Input; cmd.Parameters.Add("@usclass", MySqlDbType.VarChar,10).Value = "sdf";
cmd.Parameters["@usclass"].Direction = ParameterDirection.Input;
Response.Write( cmd.ExecuteNonQuery());简化
string sql = "INSERT INTO student (`usname`,`usage`,`usclass`)" +
"VALUES('kjkl', 88, 'lkl') "; MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
Response.Write( cmd.ExecuteNonQuery());//这样就能插入。我晕。。问题出在那儿?