Gridview With Textbox

[yardly]

i cant save the gridview values in the databse...

[yardly]

totally i am having 7 txtbox . but i cant insert it into my table

[yardly]

i am using empty gridrow in my webpage

[_AK_]

How exactly are you trying to insert the value in your database? Are you getting any problem in accessing the value of the textbox or getting the problem in inserting the data into the database?

Apurva Kaushal

[Imran Khan Pathan]

have you bound the gridview with some datasource?

please don't forget to vote on the post that helped you.

[yardly]

i am getting error while inserting into the database.. shall i send my coding to u

[yardly]

no i didnt bound with datasource

[_AK_]

What is that error?

Apurva Kaushal

[Imran Khan Pathan]

So you have to bind it first. Can you tell me what exactly you want

please don't forget to vote on the post that helped you.

[yardly]

i am getting this error: procedure r function not specified for @part_Number..

[yardly]

i have binded gridview like this

[_AK_]

Are you attaching the parameter correctly to the command object?

Apurva Kaushal

[yardly]

[yardly]

this s my gridview desingn:

[yardly]

did u recevied my coding

[_AK_]

Put you code in code tag. Then it will be visible properly.

Apurva Kaushal

[Imran Khan Pathan]

check "Ignore HTML tags in this message (good for code snippets)" check box and then post your code

please don't forget to vote on the post that helped you.

[yardly]

hi good morning.. private void BindGrid() { List items = new List(); for (int i = 0; i < 50; i++) { ItemEntry c = new ItemEntry(); items.Add(c); } grdPurEntry.DataSource = items; grdPurEntry.DataBind(); } public void PON_selectedIndexChanged(object src, EventArgs e) { string strPONumber; strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString(); //BindData(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ToString()); SqlCommand cmd = new SqlCommand("select MachineName from tbl_PurchaseOrderMaster where Pur_Order_No='" + strPONumber + "'", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); // ddlpurchaseOredernumber.Items.Clear(); while (dr.Read()) { txtMachineName.Text = dr["MachineName"].ToString(); //txtInvoiceNum.Text = dr["Invoice_No"].ToString(); } con.Close(); // Load Grid //string strPONumber; //strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString(); string strPartNumber = ""; string strPartDescription = ""; string strOrderedQuantity = ""; //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlDataAdapter ad = new SqlDataAdapter("SELECT Part_Number,Part_Description,Ordered_Quantity FROM tbl_PurchaseOrderDetails where Pur_Order_No ='" + strPONumber + "'", con);// where MachineName='" + txtMachineName.Text + "'", con); DataSet ds = new DataSet(); ad.Fill(ds, "PurOrderNum"); DataTable dt = ds.Tables[0]; foreach (DataRow dr1 in dt.Rows) { strPartNumber = dr1["Part_Number"].ToString(); strPartDescription = dr1["Part_Description"].ToString(); strOrderedQuantity = dr1["Ordered_Quantity"].ToString(); } //string strPONumber; //strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString(); foreach (GridViewRow row in grdPurEntry.Rows) { if (row.RowType == DataControlRowType.DataRow) { if (String.IsNullOrEmpty(((TextBox)row.FindControl("txtPartNumber")).Text)) { ((TextBox)row.FindCont

[yardly]

hi good morning.. private void BindGrid() { List items = new List(); for (int i = 0; i < 50; i++) { ItemEntry c = new ItemEntry(); items.Add(c); } grdPurEntry.DataSource = items; grdPurEntry.DataBind(); } public void PON_selectedIndexChanged(object src, EventArgs e) { string strPONumber; strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString(); //BindData(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ToString()); SqlCommand cmd = new SqlCommand("select MachineName from tbl_PurchaseOrderMaster where Pur_Order_No='" + strPONumber + "'", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); // ddlpurchaseOredernumber.Items.Clear(); while (dr.Read()) { txtMachineName.Text = dr["MachineName"].ToString(); //txtInvoiceNum.Text = dr["Invoice_No"].ToString(); } con.Close(); // Load Grid //string strPONumber; //strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString(); string strPartNumber = ""; string strPartDescription = ""; string strOrderedQuantity = ""; //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlDataAdapter ad = new SqlDataAdapter("SELECT Part_Number,Part_Description,Ordered_Quantity FROM tbl_PurchaseOrderDetails where Pur_Order_No ='" + strPONumber + "'", con);// where MachineName='" + txtMachineName.Text + "'", con); DataSet ds = new DataSet(); ad.Fill(ds, "PurOrderNum"); DataTable dt = ds.Tables[0]; foreach (DataRow dr1 in dt.Rows) { strPartNumber = dr1["Part_Number"].ToString(); strPartDescription = dr1["Part_Description"].ToString(); strOrderedQuantity = dr1["Ordered_Quantity"].ToString(); } //string strPONumber; //strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString(); foreach (GridViewRow row in grdPurEntry.Rows) { if (row.RowType == DataControlRowType.DataRow) { if (String.IsNullOrEmpty(((TextBox)row.FindControl("txtPartNumber")).Text)) { ((TextBox)row.FindCont