I Am Update Only Two Column In Gridview. This Is My Update Coding I Get Error In This Coding..

Question

0.00/5 (No votes)

See more:

ASP design page:

XML

<asp:GridView ID="GridView2" runat="server" AlternatingRowStyle-BackColor="#C2D69B"
                            HeaderStyle-BackColor="green" AutoGenerateEditButton="True"
                            onrowcancelingedit="GridView2_RowCancelingEdit"
                            onrowediting="GridView2_RowEditing" onrowupdating="GridView2_RowUpdating">
                            <HeaderStyle BackColor="Green" />
                            <AlternatingRowStyle BackColor="#C2D69B" />

                        </asp:GridView>

table:

SQL

SELECT TOP 1000 [BookingRefNo]
      ,[DateIn]
      ,[JobCode]
      ,[RequestedBy]
      ,[TargetDept]
      ,[DescriptionofJob]
      ,[NeedBy]
      ,[JobLocation]
      ,[ContactPerson]
      ,[ReqPriority]
      ,[AssignedPriority]
      ,[STATUS]
  FROM [FIMSONE_P2].[dbo].[TSafetyMaster]

code page:

C#

 protected void Page_Load(object sender, EventArgs e)
   {

      BindGridViewPageLoad();


   }

   private void BindGridViewPageLoad()
   {
       SqlConnection con1 = new SqlConnection(constr);
       con1.Open();
       SqlCommand cmd = new SqlCommand("select * from TSafetyMaster", con1);
       SqlDataAdapter da = new SqlDataAdapter(cmd);
       DataSet ds = new DataSet();
       da.Fill(ds);
       GridView2.DataSource = ds.Tables[0];
       GridView2.DataBind();


   }

protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
   {
       GridView2.EditIndex = e.NewEditIndex;
       GridView2.DataBind();
   }

   protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
   {
       GridView2.EditIndex = -1;
       GridView2.DataBind();
   }

   protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
   {


       GridViewRow row = (GridViewRow)GridView2.Rows[e.RowIndex];
       int BookingRefNo=int.Parse(GridView2.DataKeys[e.RowIndex].Value.ToString());
       //Label lblBookingRefNo = (Label)row.FindControl("BookingRefNo");
       TextBox txtAssignedPriority = (TextBox)row.FindControl("AssignedPriority");
       TextBox txtStatus = (TextBox)row.FindControl("Status");
       SqlConnection con1 = new SqlConnection(constr);
       SqlCommand cmd = new SqlCommand("Update TSafetyMaster set AssignedPriority=@AssignedPriority,Status=@Status where BookingRefNo=@BookingRefNo", con1);
       cmd.Parameters.Add("@BookingRefNo", SqlDbType.Int).Value = BookingRefNo;
       cmd.Parameters.Add("@AssignedPriority", SqlDbType.NVarChar).Value = txtAssignedPriority;
       cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = txtStatus;
       cmd.ExecuteNonQuery();
       GridView2.EditIndex=-1;
       GridView2.DataBind();



   }

Posted 14-May-14 19:17pm

safihur Rahuman

Updated 14-May-14 19:58pm

Thanks7872

v4

Add a Solution

Comments

DamithSL 15-May-14 1:25am

what is the error? you need to set BookingRefNo parameter and value

safihur Rahuman 15-May-14 1:34am

txtAssignedpriority,txtstatus its take null value

DamithSL 15-May-14 1:38am

update the question with full gridview code

safihur Rahuman 15-May-14 1:40am

ok

safihur Rahuman 15-May-14 1:47am

hi frd now i am update my code pls check ...

safihur Rahuman 15-May-14 1:40am

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

David_Wimbley 15-May-14 1:29am

Its hard to tell you what the solution to your error is when we dont even know what the error is. My VPN to your computer broke and i can't run this code on my own so you probably should post your stack trace so we can see what the error is.

safihur Rahuman 15-May-14 1:47am

hi frd now i am update my code pls check...

David_Wimbley 15-May-14 1:55am

Do you get an exception on this? Can you post the stack trace? Right now the only way for me to find what your error says is to create a project with all of your source (which i don't have in its entirety...just the bits above) and see if the error occurs on my machine.

The stack trace would help if you are getting one...or more clarification on where exactly your error is occurring.

Jinu _George 15-May-14 1:58am

What error you are getting?

safihur Rahuman 15-May-14 2:06am

error:Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Sunasara Imdadhusen 15-May-14 2:04am

What type of error are you getting?

safihur Rahuman 15-May-14 2:06am

error:Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Sunasara Imdadhusen 15-May-14 2:24am

You haven't mentioned datakeynames="BookingRefNo" in <asp:GridView>

safihur Rahuman 15-May-14 2:54am

ok fine now i am get Bookingrefno but another 2 columns get null value

Nandakishore G N 15-May-14 2:27am

safihur .. try placing this method BindGridViewPageLoad(); within If(!IsPostBack) in pageload..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-05-14T20:01:00

Solution 1

you need to set Data Key Names property as BookingRefNo. then only you can get the Data Key value

ASP.NET

<asp:gridview id="GridView2" runat="server" datakeynames="BookingRefNo" xmlns:asp="#unknown"></asp:gridview>

now below line you will have BookingRefNo

C#

int BookingRefNo=int.Parse(GridView2.DataKeys[e.RowIndex].Value.ToString());

when you get values, try like below

C#

var DateIn =GridView2.Rows[e.RowIndex].Cells[1].Text;
var JobCode =GridView2.Rows[e.RowIndex].Cells[2].Text;
var RequestedBy=GridView2.Rows[e.RowIndex].Cells[3].Text;

PageLoad code Updated

C#

protected void Page_Load(object sender, EventArgs e)
   {
      if(!IsPostBack()) { 
          BindGridViewPageLoad();
      }
   }

Posted 14-May-14 20:01pm

DamithSL

Updated 14-May-14 20:58pm

v4

Comments

safihur Rahuman 15-May-14 2:11am

hello frd now i am add datakeyname its work but another two column assidnedpriority,status getting null value.
cmd.Parameters.Add("@AssignedPriority", SqlDbType.NVarChar).Value = txtAssignedPriority;
cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = txtStatus;

DamithSL 15-May-14 2:14am

check my update, try to get the cell value of the cell you want, like var DateIn =GridView2.Rows[e.RowIndex].Cells[1]Value.ToString();

safihur Rahuman 15-May-14 2:20am

show error in value.tostring();

DamithSL 15-May-14 2:27am

debug and check the values you get as each cell

safihur Rahuman 15-May-14 2:30am

var AssignedPriority=GridView2.Rows[e.RowIndex].Cells[10]value.ToString();
var Status = GridView2.Rows[e.RowIndex].Cells[11]value.ToString();

error in var :type or namespace could not be found .....

DamithSL 15-May-14 2:35am

string AssignedPriority=GridView2.Rows[e.RowIndex].Cells[10]value.ToString();
string Status = GridView2.Rows[e.RowIndex].Cells[11]value.ToString();

safihur Rahuman 15-May-14 2:44am

error: cannot implicity convert type system.web.ui.webcontrols.tablecell to string

DamithSL 15-May-14 2:50am

string AssignedPriority=GridView2.Rows[e.RowIndex].Cells[10].value.ToString();
string Status = GridView2.Rows[e.RowIndex].Cells[11].value.ToString();

safihur Rahuman 15-May-14 2:52am

.value is not come

DamithSL 15-May-14 3:01am

I'm sorry, I can't debug your app from here, or otherwise need to create application similar to your and tell what is exactly going on. Final try check below
string AssignedPriority = GridView2.Rows[e.RowIndex].Cells[10].Text;

safihur Rahuman 15-May-14 3:17am

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{

GridViewRow row = (GridViewRow)GridView2.Rows[e.RowIndex];
int BookingRefNo=int.Parse(GridView2.DataKeys[e.RowIndex].Value.ToString());

string AssignedPriority = ((TextBox)row.Cells[11].Controls[0]).Text;
string Status = ((TextBox)row.Cells[12].Controls[0]).Text;

SqlConnection con1 = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("Update TSafetyMaster set AssignedPriority=@AssignedPriority,Status=@Status where BookingRefNo=@BookingRefNo", con1);
cmd.Parameters.Add("@BookingRefNo", SqlDbType.Int).Value = BookingRefNo;
cmd.Parameters.Add("@AssignedPriority", SqlDbType.VarChar).Value = AssignedPriority;
cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Status;
con1.Open();
cmd.ExecuteNonQuery();
GridView2.EditIndex=-1;
GridView2.DataBind();

}

now this coding work but it get only old value .... not get update value