从SQL Server中读写大数据列,从SQL Server中读写大数据列。
【 tulaoshi.com - ASP.NET 】
{
//写入大对象到SqlServer FileStream fs = new FileStream("C:test.bmp",FileMode.OPen,FileAccess.Read); BinaryReader br = new BinaryReader(fs); SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=sa;database=northwind"); string cmdText = "UPDATE EMPLOYEES" + "SET Photo=@image where EmployeeId=1"; SqlCommand cmd = new SqlCommand(cmdText,conn); cmd.Parameters.Add("@image",SqlDbType.Image); cmd.Parameters["@image"].Value = br.ReadBytes((int)br.BaseStream.Length); conn.Open(); int i=cmd.ExecuteNoQuery(); //从SQL Server中读取大对象 string cmdtext = "SELECT employeeid,photo" + " from employees where employeeid = 1"; SqlCommand cmd2 = new SqlCommand(cmdtext,conn);
来源:https://www.tulaoshi.com/n/20160129/1486444.html
看过《从SQL Server中读写大数据列》的人还看了以下文章 更多>>
