protected void btnadd_Click(object sender, EventArgs e) { List <int> noofrows = new List <int>(); int rows = 10; int.TryParse(txtnofrows.Text.Trim(), out rows); for (int i = 0; i < rows; i++) { noofrows.Add(i); } GridViewlisting.DataSource = noofrows; GridViewlisting.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { try { ////////Load Data Into Master Table Store string storename = txtstorename.Text; string yourname = txtname.Text; string contactno = txtcontact.Text; string email = txtemail.Text; string sociallink1 = txtsociallink1.Text; string sociallink2 = txtsociallink2.Text; string address = txtaddress.Text; string state = ddlstate.SelectedItem.ToString(); string city = ddlcity.SelectedItem.ToString(); string area = txtarea.Text; string town = txttown.Text; string country = txtcountry.Text; long zipcode = long.Parse(txtzipcode.Text); string description = txtstoredescription.Text; con.Open(); SqlCommand cmd0 = new SqlCommand(@"INSERT INTO Storemaster(Storename,Yourname,Contactno,Email,Sociallink1,Sociallink2,Address,State,City,Area,Town,Country,Zipcode,Description,ListingPriority,Package) values('" + storename + "','" + yourname + "','" + contactno + "','" + email + "','" + sociallink1 + "','" + sociallink2 + "','" + address + "','" + state + "','" + city + "','" + area + "','" + town + "','" + country + "','" + zipcode + "','" + description + "','low','Free');", con); cmd0.ExecuteNonQuery(); SqlCommand cmd1 = new SqlCommand("Select MAX(StoreId) from Storemaster;", con); cmd1.ExecuteNonQuery(); SqlDataReader dr0 = cmd1.ExecuteReader(); while (dr0.Read()) // This is how record is read. Loop through the each record { var storeid = long.Parse(dr0[0].ToString()); lblstoreid.Text = storeid.ToString(); } dr0.Close(); int Store_id = int.Parse(lblstoreid.Text.ToString()); foreach (GridViewRow g1 in GridViewlisting.Rows) { int StoreId = Store_id; string productname = (g1.FindControl("txtprodname") as TextBox).Text; string productcategory = (g1.FindControl("txtprodcategory") as TextBox).Text; decimal productprice = decimal.Parse((g1.FindControl("txtprodprice") as TextBox).Text); FileUpload fuploadFile = (FileUpload)g1.FindControl("FUproductimage"); //string Description = (g1.FindControl("lblDescription") as TextBox).Text; if (fuploadFile.HasFile) { FileInfo fi = new FileInfo(fuploadFile.FileName); string name = fi.Name; byte[] documentcontent = fuploadFile.FileBytes; SqlCommand com = new SqlCommand("Insert into Storeproducts (StoreId,Productname,Productcategory,Productprice,Productimage) values (@StoreId,@Productname,@Productcategory,@Productprice,@Productimage)", con); com.Parameters.AddWithValue("@StoreId", SqlDbType.Int).Value = StoreId; com.Parameters.AddWithValue("@Productname", SqlDbType.VarChar).Value = productname; com.Parameters.AddWithValue("@Productcategory", SqlDbType.VarChar).Value = productcategory; com.Parameters.AddWithValue("@Productprice", SqlDbType.Decimal).Value = productprice; com.Parameters.AddWithValue("@Productimage", SqlDbType.VarBinary).Value = documentcontent; com.ExecuteNonQuery(); } } if (imageupload1.HasFile && imageupload2.HasFile && imageupload3.HasFile) { FileInfo fi1 = new FileInfo(imageupload1.FileName); string name1 = fi1.Name; byte[] image1 = imageupload1.FileBytes; FileInfo fi2 = new FileInfo(imageupload2.FileName); string name2 = fi2.Name; byte[] image2 = imageupload2.FileBytes; FileInfo fi3 = new FileInfo(imageupload3.FileName); string name3 = fi3.Name; byte[] image3 = imageupload3.FileBytes; SqlCommand com = new SqlCommand("Insert into StoreImages (StoreId,Image1,Image2,Image3) values (@StoreId,@Image1,@Image2,@Image3)", con); com.Parameters.AddWithValue("@StoreId", SqlDbType.VarChar).Value = Store_id; com.Parameters.AddWithValue("@Image1", SqlDbType.VarBinary).Value = image1; com.Parameters.AddWithValue("@Image2", SqlDbType.VarBinary).Value = image2; com.Parameters.AddWithValue("@Image3", SqlDbType.VarBinary).Value = image3; com.ExecuteNonQuery(); } else if (imageupload1.HasFile && !imageupload2.HasFile && !imageupload3.HasFile) { FileInfo fi1 = new FileInfo(imageupload1.FileName); string name1 = fi1.Name; byte[] image1 = imageupload1.FileBytes; SqlCommand com = new SqlCommand("Insert into StoreImages (StoreId,Image1 ) values (@StoreId,@Image1)", con); com.Parameters.AddWithValue("@StoreId", SqlDbType.VarChar).Value = Store_id; com.Parameters.AddWithValue("@Image1", SqlDbType.VarBinary).Value = image1; com.ExecuteNonQuery(); } else if (!imageupload1.HasFile && imageupload2.HasFile && !imageupload3.HasFile) { FileInfo fi2 = new FileInfo(imageupload2.FileName); string name2 = fi2.Name; byte[] image2 = imageupload2.FileBytes; SqlCommand com = new SqlCommand("Insert into StoreImages (StoreId, Image2) values (@StoreId, @Image2)", con); com.Parameters.AddWithValue("@StoreId", SqlDbType.VarChar).Value = Store_id; com.Parameters.AddWithValue("@Image2", SqlDbType.VarBinary).Value = image2; com.ExecuteNonQuery(); } else if (!imageupload1.HasFile && !imageupload2.HasFile && imageupload3.HasFile) { FileInfo fi3 = new FileInfo(imageupload3.FileName); string name3 = fi3.Name; byte[] image3 = imageupload3.FileBytes; SqlCommand com = new SqlCommand("Insert into StoreImages (StoreId,Image3) values (@StoreId,@Image3)", con); com.Parameters.AddWithValue("@StoreId", SqlDbType.VarChar).Value = Store_id; com.Parameters.AddWithValue("@Image3", SqlDbType.VarBinary).Value = image3; com.ExecuteNonQuery(); } else if (imageupload1.HasFile && !imageupload2.HasFile && !imageupload3.HasFile) { FileInfo fi1 = new FileInfo(imageupload1.FileName); string name1 = fi1.Name; byte[] image1 = imageupload1.FileBytes; SqlCommand com = new SqlCommand("Insert into StoreImages (StoreId,Image1) values (@StoreId,@Image1)", con); com.Parameters.AddWithValue("@StoreId", SqlDbType.VarChar).Value = Store_id; com.Parameters.AddWithValue("@Image1", SqlDbType.VarBinary).Value = image1; com.ExecuteNonQuery(); } else if (imageupload1.HasFile && imageupload2.HasFile && !imageupload3.HasFile) { FileInfo fi1 = new FileInfo(imageupload1.FileName); string name1 = fi1.Name; byte[] image1 = imageupload1.FileBytes; FileInfo fi2 = new FileInfo(imageupload2.FileName); string name2 = fi2.Name; byte[] image2 = imageupload2.FileBytes; SqlCommand com = new SqlCommand("Insert into StoreImages (StoreId,Image1,Image2) values (@StoreId,@Image1,@Image2)", con); com.Parameters.AddWithValue("@StoreId", SqlDbType.VarChar).Value = Store_id; com.Parameters.AddWithValue("@Image1", SqlDbType.VarBinary).Value = image1; com.Parameters.AddWithValue("@Image2", SqlDbType.VarBinary).Value = image2; com.ExecuteNonQuery(); } con.Close(); string display = "Store Added Successfully!"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); txtstorename.Text = ""; txtname.Text = ""; txtcontact.Text = ""; txtemail.Text = ""; txtsociallink1.Text = ""; txtsociallink2.Text = ""; txtaddress.Text = ""; ddlstate.ClearSelection(); ddlcity.ClearSelection(); txtarea.Text = ""; txttown.Text = ""; txtzipcode.Text = ""; txtstoredescription.Text = ""; txtnofrows.Text = ""; DataTable ds = new DataTable(); ds = null; GridViewlisting.DataSource = ds; GridViewlisting.DataBind(); } catch (Exception ex) { string display1 = ex.Message; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display1 + "');", true); } //string display = "Coaching Class Added Successfully!"; //ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); //txtinstitutename.Text = ""; //txtname.Text = ""; //txtcontact.Text = ""; //txtemail.Text = ""; //txtsociallink1.Text = ""; //txtsociallink2.Text = ""; //txtaddress.Text = ""; //ddlstate.ClearSelection(); //ddlcity.ClearSelection(); //txtarea.Text = ""; //txttown.Text = ""; //txtzipcode.Text = ""; //txtClassdescription.Text = ""; //cblfacilities.ClearSelection(); //cbl8board.ClearSelection(); //cbl9board.ClearSelection(); //cbl10board.ClearSelection(); //logoupload.Dispose(); //image2.Dispose(); //image3.Dispose(); }