ADD and Retrieve IMAGES from sql server 2008 in datalist c#

Question

i need code to insert images in database and retrieve from database in to datalist .. so give the full code ... thank in advance...

Satyapriya Nayak · Answer

CREATE PROCEDURE insert_test ( @name varchar(50), @pic varchar(50) ) AS Insert into test values (@name,@pic) Untitled Page Name ControlToValidate="txt_name" ErrorMessage="Please enter the name"> Picture ControlToValidate="FileUpload1" ErrorMessage="Please browse the image"> Text="Insert" /> Photo Details Name Picture ' height="50px" width="50px"/> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.IO; namespace ADD_Retrieve_IMAGES_datalist { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string s1; string path; SqlConnection cnn = new SqlConnection(); SqlCommand com = new SqlCommand(); SqlDataAdapter sqlda; DataTable dt; protected void btn_insert_Click(object sender, EventArgs e) { if (FileUpload1.PostedFile.ContentLength > 0) { s1 = Path.GetFileName(FileUpload1.FileName); path = Server.MapPath("images") + "/" + s1; FileUpload1.SaveAs(path); } SqlConnection con = new SqlConnection(strConnString); con.Open(); SqlCommand com = new SqlCommand("insert_test", con); com.CommandType = CommandType.StoredProcedure; com.Connection = con; com.Parameters.AddWithValue("@name", txt_name.Text); com.Parameters.AddWithValue("@pic", s1); com.ExecuteNonQuery(); com.Dispose(); binddatalist(); con.Close(); clear(); } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { binddatalist(); } } private void clear() { txt_name.Text = ""; } private void binddatalist() { SqlConnection con = new SqlConnection(strConnString); con.Open(); sqlda = new SqlDataAdapter("SELECT * FROM test ", con); dt = new DataTable(); sqlda.Fill(dt); sqlda.Dispose(); DataList1.DataSource = dt; DataList1.DataBind(); con.Close(); } } }

sagar patil · Answer

thanks its working..... Sir In data list i need Edit And Delete Buttons.. If i clicked edit button then all data fields should be display in their respective text box .. so give me code for that... Thank U in advance

ADD and Retrieve IMAGES from sql server 2008 in datalist c#

Answers (2)