How to populate dropdownlist and add values to database.

Question

I have a category page wherein i am adding a textbox data as categoryname and an image as categoryimage to database and also binding to gridview in same page. Now I have another page Subcategory I want to pull the data from category page ie categoryname into dropdownlist and also add another textbox and image under it. In category table ID ImageName Imagepath . could anyone help me with connections in subcategory page as well as sqldatabase design as how to link the two tables. I have pasted the category and subcategory table CATEGORY TABLE Save Images In Folder and Display Images in Gridview from folder .Gridview { font-family:Verdana; font-size:10pt; font-weight:normal; color:black; } function Confirmationbox() { var result = confirm('Are you sure you want to delete selected Category(s)?'); if (result) { return true; } else { return false; } } style=margin-top: 0px> Height=23px> style=margin-top: 0px> DataSourceID=sqldataImages CssClass=Gridview HeaderStyle-BackColor=#61A6F8 onselectedindexchanged=gvImages_SelectedIndexChanged > CommandArgument=' ' CommandName=Delete runat=server> Delete --%>  SelectCommand=select * from Category1 DeleteCommand=delete from Category1 where ID=@ID > .CS file using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.IO; 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; public partial class _Default : System.Web.UI.Page { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[dbconnection].ToString()); protected void Page_Load(object sender EventArgs e) { btnDelete.Attributes.Add(onclick javascript:return Confirmationbox()); //if (!IsPostBack) //{ //} } protected void btnSubmit_Click(object sender EventArgs e) { //Get Filename from fileupload control //string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName); string filename = TextBox1.Text; //Save images into Images folder fileuploadimages.SaveAs(Server.MapPath(Images/ + filename)); //Getting dbconnection from web.config connectionstring //Open the database connection con.Open(); //Query to insert images path and name into database SqlCommand cmd = new SqlCommand(Insert into Category1(ImageNameImagePath) values(@ImageName@ImagePath) con); //Passing parameters to query cmd.Parameters.AddWithValue(@ImageName filename); cmd.Parameters.AddWithValue(@ImagePath Images/ + filename); cmd.ExecuteNonQuery(); //Close dbconnection con.Close(); Response.Redirect(~/Default.aspx); } //protected void gvImages_RowDeleting(object sender GridViewDeleteEventArgs e) //{ // int id = Convert.ToInt32(Gd_GalleryDetails.DataKeys[e.RowIndex].Value); // ad.deletegalleryimage(id); // msg.Show(Image deleted from gallery); // fillgrid(); //private void BindData(string Query) //{ //{ // con.Open(); // using (SqlCommand comm = new SqlCommand(Query + // ; select * from Category1  con)) // { // SqlDataAdapter da = new SqlDataAdapter(con); // DataSet ds = new DataSet(); // da.Fill(ds); // gvImages.DataSource = ds; // gvImages.DataBind(); // } // } //} // protected void gvImages_RowDeleting(object sender GridViewDeleteEventArgs e) //{ // string EmployeeID = gvImages.DataKeys[e.RowIndex].Value.ToString(); // string Query = delete Category1 where Category1.Category1ID = +Category1ID; // BindData(Query); //} //protected void gvImages_RowDataBound(object sender // GridViewRowEventArgs e) //{ // if (e.Row.RowType == DataControlRowType.DataRow) // { // LinkButton l = (LinkButton)e.Row.FindControl(LinkButton1); // l.Attributes.Add(onclick javascript:return  + // confirm('Are you sure you want to delete this record  + // DataBinder.Eval(e.Row.DataItem CategoryID) + ')); // } //} //protected void gvImages_RowCommand(object sender // GridViewCommandEventArgs e) //{ // if (e.CommandName == Delete) // { // // get the categoryID of the clicked row // int ID = Convert.ToInt32(e.CommandArgument); // // Delete the record // DeleteRecordByID(ID); // // Implement this on your own :) // } //} //protected void GridView1_RowDeleting(object sender GridViewDeleteEventArgs e) //{ // int ID = (int)gvImages.DataKeys[e.RowIndex].Value; // DeleteRecordByID(ID); //} protected void gvImages_SelectedIndexChanged(object sender EventArgs e) { } protected void btnDelete_Click(object sender EventArgs e) { //Loop through all the rows in gridview foreach (GridViewRow gvrow in gvImages.Rows) { //Finiding checkbox control in gridview for particular row CheckBox chkdelete = (CheckBox)gvrow.FindControl(chkdelete); //Condition to check checkbox selected or not if (chkdelete.Checked) { //Getting UserId of particular row using datakey value int UID = Convert.ToInt32(gvImages.DataKeys[gvrow.RowIndex].Value); sqldataImages.DeleteParameters[ID].DefaultValue = UID.ToString(); sqldataImages.Delete(); } } } } SUBCATEGORY PAGE             Image                                                  Width=159px>                                 onclick=Button1_Click/>

Sanjeeb Lenka · Answer

just check this DataKeyNames=SID AutoGenerateColumns=False DataSourceID=sqldataImages CssClass=Gridview HeaderStyle-BackColor=#61A6F8 onselectedindexchanged=GridView1_SelectedIndexChanged > put this DataKeyNames=ID AutoGenerateColumns=False DataSourceID=sqldataImages CssClass=Gridview HeaderStyle-BackColor=#61A6F8 onselectedindexchanged=GridView1_SelectedIndexChanged > check this Id you are binding. if changing this you are getting same problem the share your subcatogory table structure in database

antony victor · Answer

Subcategory.aspx page DataSourceID=sqldataImages CssClass=Gridview HeaderStyle-BackColor=#61A6F8 onselectedindexchanged=GridView1_SelectedIndexChanged >  SelectCommand=select * from Subcategory1 DeleteCommand=delete from Subcategory1 where ID=@ID onselecting=sqldataImages_Selecting > Buttonclick protected void Button1_Click(object sender EventArgs e) { string SID= Convert.ToString(DropDownList1.SelectedItem.Value); con.Open(); SqlCommand cmd = new SqlCommand(Insert into Subcategory1(SIDSimageNameSimagePath) values(@SID@SimageName@SimagePath) con); string filename1 = TextBox1.Text; //Save images into Images folder FileUpload1.SaveAs(Server.MapPath(Images/ + filename1)); //Passing parameters to query cmd.Parameters.AddWithValue(@SimageName filename1); cmd.Parameters.AddWithValue(@SimagePath Images/ + filename1); cmd.ExecuteNonQuery(); //Close dbconnection con.Close(); Response.Redirect(~/Subcategory.aspx); } protected void btnDelete_Click(object sender EventArgs e) { //Loop through all the rows in gridview foreach (GridViewRow gvrow in GridView1.Rows) { //Finiding checkbox control in gridview for particular row CheckBox chkdelete = (CheckBox)GridView1.FindControl(chkdelete); //Condition to check checkbox selected or not if (chkdelete.Checked) { //Getting UserId of particular row using datakey value int UID = Convert.ToInt32(GridView1.DataKeys[gvrow.RowIndex].Value); sqldataImages.DeleteParameters[ID].DefaultValue = UID.ToString(); sqldataImages.Delete(); } } }

Sanjeeb Lenka · Answer

your code not showing check once

antony victor · Answer

This is the code for gridview and sqldatasource  SelectCommand=select * from Subcategory1 DeleteCommand=delete from Subcategory1 where SID=@SID onselecting=sqldataImages_Selecting >

antony victor · Answer

hi sir data is not saving to database

Sanjeeb Lenka · Answer

paste your gridview design code

antony victor · Answer

Actually sir i figured it out its not the error in buttonclick but in sqldatasource so trying to figure out the error... This is the error line The DataSourceID of 'GridView1' must be the ID of a control of type IDataSource. A control with ID 'sqldataImages' could not be found. I am pasting the code of sqldatasource in aspx page as well as the backend code Subcategory.aspx  SelectCommand=select * from Subcategory1 DeleteCommand=delete from Subcategory1 where SID=@SID onselecting=sqldataImages_Selecting > buttonclick protected void Button1_Click(object sender EventArgs e) { string ID= Convert.ToString(DropDownList1.SelectedItem.Value); con.Open(); SqlCommand cmd = new SqlCommand(Insert into Subcategory1(SimageNameSimagePath) values(@SimageName@SimagePath) con); string filename = TextBox1.Text; //Save images into Images folder FileUpload1.SaveAs(Server.MapPath(Images/ + filename)); //Passing parameters to query cmd.Parameters.AddWithValue(@SimageName filename); cmd.Parameters.AddWithValue(@SimagePath Images/ + filename); cmd.ExecuteNonQuery(); //Close dbconnection con.Close(); Response.Redirect(~/Subcategory.aspx); } protected void btnDelete_Click(object sender EventArgs e) { //Loop through all the rows in gridview foreach (GridViewRow gvrow in GridView1.Rows) { //Finiding checkbox control in gridview for particular row CheckBox chkdelete = (CheckBox)GridView1.FindControl(chkdelete); //Condition to check checkbox selected or not if (chkdelete.Checked) { //Getting UserId of particular row using datakey value int UID = Convert.ToInt32(GridView1.DataKeys[gvrow.RowIndex].Value); sqldataImages1.DeleteParameters[SID].DefaultValue = UID.ToString(); sqldataImages1.Delete(); } } }

Sanjeeb Lenka · Answer

on which line of your button click you are getting exception

antony victor · Answer

I m getting an error. A field or property with the name 'ImageName' was not found on the selected data source. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: A field or property with the name 'ImageName' was not found on the selected data source. My Button click event. string ID= Convert.ToString(DropDownList1.SelectedItem.Value); con.Open(); SqlCommand cmd = new SqlCommand(Insert into Subcategory1(SimageNameSimagePath) values(@SimageName@SimagePath) con); string filename = TextBox1.Text; //Save images into Images folder FileUpload1.SaveAs(Server.MapPath(Images/ + filename)); //Passing parameters to query cmd.Parameters.AddWithValue(@SimageName filename); cmd.Parameters.AddWithValue(@SimagePath Images/ + filename); cmd.ExecuteNonQuery(); //Close dbconnection con.Close(); Response.Redirect(~/Subcategory.aspx);

Sanjeeb Lenka · Answer

now what the problem you are getting explain clearly.. your design completed . db design completed so what the problem actually you are facing

antony victor · Answer

s i did create... i am able to bind category in ddl later i m stuck..

Sanjeeb Lenka · Answer

Did you create your table for subcategory in database.

antony victor · Answer

sir can u help me out with ado connections for the subcategory page.

antony victor · Answer

Dear Pankaj sir  in page 2(subcategory ) there is a ddl and 1 textbox and 1 fileupload control.

Pankaj Pandey · Answer

the number of textbox and image is fixed or vary with data in ddl?

Sanjeeb Lenka · Answer

hi antony just follow this sample table for subcategory SubCategoryID categoryId SubcategoryName subCategoryImagepath subcategryId should be primary key with identity. in your form take one dropdown bind it to category name and id one textbox for subcategoryname and file upload conrol. if any problem reply.

antony victor · Answer

Sirthanks but I know the binding code from database to ddl but when i pull data to ddl later i need to add an textbox and image and bind to gridview... so how shd i design database n also ado code

Bhabani prasad Dash · Answer

if u want to bind the data from database into dropdown just write like this cmd = new SqlCommand(select Distinct colname from tablename order by colname asc  con); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds tablename); ddl_state.DataSource = ds; ddl_state.DataValueField = colname; ddl_state.DataBind();