Gridview With Textbox

[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