1.takes a FileUpload control(i.e. FileUpload1) and a button(i.e. Button1 )
2.create a folder into your web site(i.e. image)
3.write the following code to click event of Button1
code:-
protected void Button1_Click(object sender, EventArgs e) { SqlConnection con; SqlCommand cmd; DataSet ds; SqlDataAdapter adpt; Int32 result; string path = "~\\image" + "\\" + FileUpload1.FileName; con =new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\sunil\\Documents\\Visual Studio 2008\\WebSites\\EMS\\App_Data\\emsbd.mdf;Integrated Security=True;User Instance=True"); //con = new SqlConnection(ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString); con.Open(); cmd = new SqlCommand("INSERT INTO imgtable VALUES ('" + path + "')", con); cmd.CommandType = CommandType.Text; result = cmd.ExecuteNonQuery(); if (result > 0) { FileUpload1.SaveAs(Server.MapPath(path)); //Response.Write("user reg hae been completed successfully (into database)..."); } else { Response.Write("error............."); } con.Close(); }
4.here in above code change connection string to your connection string.
5.create a table name imgtable into database(here we take only one column),column data type like nvarchar/nchar.
What kind of email newsletter would you prefer to receive from CodeAsp.Net?18