如何将图像插入DATABASE。使用存储过程。 [英] how to insert image into DATABASE.? using Stored Procedures.

问题描述

这是我的代码，插入empno，empname，IMAGE与商店程序名称emp_insert

请帮助我

  protected   void  btnSave_Click（ object  sender，EventArgs e） 
 {
 con.Open（）; 
 cmd =  new  SqlCommand（  emp_insert ，con）; 
 cmd.CommandType = CommandType.StoredProcedure; 
 cmd.Parameters.AddWithValue（  @ empno，TextBox1.Text）; 
 cmd.Parameters.AddWithValue（  @ empname，TextBox2.Text）; 
 cmd.Parameters.AddWithValue（  @ Picture，FileUpload1.FileName）; 
 cmd.Parameters.AddWithValue（  @ action，  i）; 
 cmd.ExecuteNonQuery（）; 
 Label3.Text =  已插入; 
 con.Close（）; 
} 
 

解决方案

http://www.dotnetcurry.com/ShowArticle.aspx?ID=129 [ ^ ]

http：// aspalliance。 com / 138_Inserting_Images_to_SqlServer_in_ASP_NET [ ^ ]

< blockquote>查看此链接：



http://prashanthchindam.wordpress.com/2010/10/10/inserting-retrieving-images-from-database-using-stored-procedures-3/ [ ^ ]



http://www.dotnetfunda.com/ article / article1546-how-to-save-an-image-into-the database-using-stored-procedure-in-aspnet-.aspx [ ^ ]



可以帮助你

尝试如下：

 cmd.CommandType = CommandType.StoredProcedure; 
 
 
 
 SqlParameter [] prms =  new  SqlParameter [ 3 < /跨度>]; 
 
 prms [ 0 ] =  new  SqlParameter（  @ fileName，SqlDbType.VarChar， 50 ）; 
 
 prms [ 0 ]。Value = fileName; 
 
 prms [ 1 ] =  new  SqlParameter（  @ fileContent，SqlDbType.Image）; 
 
 prms [ 1 ]。Value = imageBytes; 
 
 prms [ 2 ] =  new  SqlParameter（  @ active，SqlDbType.Bit）; 
 
 prms [ 2 ]。值=  true ;  //  硬编码值 
 
 
 cmd.Parameters.AddRange （PRMS）; 
 
 
 
 conn.Open（）; 
 
 cmd.ExecuteNonQuery（）; 
 
 conn.Close（）; 

更多参考： http://www.dotnetfunda.com/articles/article1546-how-to-save-an-image-into-the-database-using-stored-procedure- in-aspnet-.aspx [ ^ ]

This is my code to insert empno,empname,IMAGE with store procedure name "emp_insert"
Please Help me

protected void btnSave_Click(object sender, EventArgs e)
   {
       con.Open();
       cmd = new SqlCommand("emp_insert", con);
       cmd.CommandType = CommandType.StoredProcedure;
       cmd.Parameters.AddWithValue("@empno", TextBox1.Text);
       cmd.Parameters.AddWithValue("@empname", TextBox2.Text);
       cmd.Parameters.AddWithValue("@Picture", FileUpload1.FileName);
       cmd.Parameters.AddWithValue("@action", "i");
       cmd.ExecuteNonQuery();
       Label3.Text = "Inserted";
       con.Close();
   }

解决方案

http://www.dotnetcurry.com/ShowArticle.aspx?ID=129[^]
http://aspalliance.com/138_Inserting_Images_to_SqlServer_in_ASP_NET[^]

See this Link:

http://prashanthchindam.wordpress.com/2010/10/10/inserting-retrieving-images-from-database-using-stored-procedures-3/[^]

http://www.dotnetfunda.com/articles/article1546-how-to-save-an-image-into-the-database-using-stored-procedure-in-aspnet-.aspx[^]

May help you

try as follows :

cmd.CommandType = CommandType.StoredProcedure;



SqlParameter[] prms = new SqlParameter[3];

prms[0] = new SqlParameter("@fileName", SqlDbType.VarChar, 50);

prms[0].Value = fileName;

prms[1] = new SqlParameter("@fileContent", SqlDbType.Image);

prms[1].Value = imageBytes;

prms[2] = new SqlParameter("@active", SqlDbType.Bit);

prms[2].Value = true; // hard coded value


cmd.Parameters.AddRange(prms);



conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

for more refer:http://www.dotnetfunda.com/articles/article1546-how-to-save-an-image-into-the-database-using-stored-procedure-in-aspnet-.aspx[^]

这篇关于如何将图像插入DATABASE。使用存储过程。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！