private void Writer()
{
string MyConnectionString="data source=xxx;initial catalog=xx;password=;user id=sa;";
SqlConnection MyConnection = new SqlConnection(MyConnectionString);
Stream st=new FileStream("c:\\kp.bmp",FileMode.Open,FileAccess.Read);
int t=1;
byte[] b_img=new byte[st.Length];
st.Read(b_img,0,(int)st.Length);
MessageBox.Show(st.Length.ToString());
st.Close();
SqlCommand MyCommand=new SqlCommand("insert into cs(id,img) values(@t,@b_img)",MyConnection);
SqlParameter MyParameterI=new SqlParameter("@t",SqlDbType.Int);
MyParameterI.Value=t;
MyCommand.Parameters.Add(MyParameterI);SqlParameter MyParameterB=new SqlParameter("@b_img",SqlDbType.Image);
MyParameterB.Value=b_img;
MyCommand.Parameters.Add(MyParameterB);MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();
}
{
string MyConnectionString="data source=xxx;initial catalog=xx;password=;user id=sa;";
SqlConnection MyConnection = new SqlConnection(MyConnectionString);
Stream st=new FileStream("c:\\kp.bmp",FileMode.Open,FileAccess.Read);
int t=1;
byte[] b_img=new byte[st.Length];
st.Read(b_img,0,(int)st.Length);
MessageBox.Show(st.Length.ToString());
st.Close();
SqlCommand MyCommand=new SqlCommand("insert into cs(id,img) values(@t,@b_img)",MyConnection);
SqlParameter MyParameterI=new SqlParameter("@t",SqlDbType.Int);
MyParameterI.Value=t;
MyCommand.Parameters.Add(MyParameterI);SqlParameter MyParameterB=new SqlParameter("@b_img",SqlDbType.Image);
MyParameterB.Value=b_img;
MyCommand.Parameters.Add(MyParameterB);MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();
}
解决方案 »
- 和大家分享一下用jquery+ashx在页面动态生成无限级下拉菜单
- 收到一个面试题,请大家帮忙找答案(逻辑题+数学题)
- 关于时间格式的一个问题,麻烦大家了!
- treeview控件重装系统后不能用了,项目急需上交,火线急热......
- C# 留言板怎么 弄楼层
- A compatible version of microsoft office is not installed
- 请问如何去除一些空的的事件代码
- 元旦散分了,各位朋友接婚了
- 请教:在C#中如何将一个字符串变量转化为 byte数组? 急!急!急!急!急!急!急!急!急!急!
- 是否所有cpu都可以获得一个唯一的标识码?
- EndPoint和IPEndPoint有什么区别?
- 由C#风潮想起的-给初学编程者的忠告
中间一行MessageBox.Show(st.Length.ToString());多余,我测试用的。
SqlConnection MyConnection = new SqlConnection(MyConnectionString);
Stream st=new FileStream("c:\\kp.bmp",FileMode.Open,FileAccess.Read);
int t=1;
byte[] b_img=new byte[st.Length];
st.Read(b_img,0,(int)st.Length);
MessageBox.Show(st.Length.ToString());
st.Close();
SqlCommand MyCommand=new SqlCommand("insert into cs(id,img) values(@t,@b_img)",MyConnection);
SqlParameter MyParameterI=new SqlParameter("@t",SqlDbType.Int);
MyParameterI.Value=t;
MyCommand.Parameters.Add(MyParameterI);SqlParameter MyParameterB=new SqlParameter("@b_img",SqlDbType.Image);
MyParameterB.Value=b_img;
MyCommand.Parameters.Add(MyParameterB);MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();