OdbcCommand cmd = new OdbcCommand("INSERT INTO test(name, id) VALUES (@name, @id)", m_dbConnection.m_DBConn);
cmd.Parameters.Add("@name", OdbcType.VarChar, 16,"name").Value = "2";
cmd.Parameters.Add("@id", OdbcType.Int, 11,"id").Value = "1";
int iRet = cmd.ExecuteNonQuery();
cmd.Dispose();//Release all resources used by System.ComponentModel.Component
代码如上,插入数据库的值全为空,不知道怎么回事,请高手指点
cmd.Parameters.Add("@name", OdbcType.VarChar, 16,"name").Value = "2";
cmd.Parameters.Add("@id", OdbcType.Int, 11,"id").Value = "1";
int iRet = cmd.ExecuteNonQuery();
cmd.Dispose();//Release all resources used by System.ComponentModel.Component
代码如上,插入数据库的值全为空,不知道怎么回事,请高手指点
OdbcParameter param= new OdbcParameter("@name",OdbcType.VarChar);
param.Value = "2"
cmd.Parameters.Add(param);
BinaryReader br = new BinaryReader(fs); byte[] photo = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close(); m_dbConnection.execUpdate("delete from test");
string sql = "insert into image(name,image) values('1','"+photo+"')";
m_dbConnection.execUpdate(sql);整个程序我是想将一个图片存入到数据库中,然后再取出来,但是发现取出来显示不了,上边是我存入数据库部分的代码,请两位高手帮忙看下是否有问题,谢谢先。