DataGrid Edit/Update problem

[thebison]

Hi all,

I hope someone can help with this relatively simple problem.
I am building a timesheet application using ASP.NET C# with Visual
Studio 2003.As it is only a protoype application, my database has been
made in MSDE.

My problem is to do with a DataGrid. I have successfully coded the
DataGrid so that you can Edit, Update, Cancel. However as my Update
Stored Procedure only updates certain columns I would like to make
certain columns not appear as 'editable' when the user clicks on
'Edit'. (Even though the stored procedure ignores any changes they
make, I just want the option to edit removed to avoid confusion!...)

My update method looks like this:

private void Update_DataGrid (object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
System.Web.UI.W ebControls.Text Box cId = new
System.Web.UI.W ebControls.Text Box();
System.Web.UI.W ebControls.Text Box cName = new
System.Web.UI.W ebControls.Text Box();
cId = (System.Web.UI. WebControls.Tex tBox) e.Item.Cells[0].Controls[0];
cName = (System.Web.UI. WebControls.Tex tBox)
e.Item.Cells[1].Controls[0];
SqlCommand myCommand = new SqlCommand("New UpdateDept",sql Connection1);
myCommand.Comma ndType = CommandType.Sto redProcedure;
myCommand.Param eters.Add(new SqlParameter("@ DeptID",SqlDbTy pe.Int,4));
myCommand.Param eters["@DeptID"].Value = cId.Text;
myCommand.Param eters.Add(new
SqlParameter("@ DeptName",SqlDb Type.VarChar,50 ));
myCommand.Param eters["@DeptName"].Value = cName.Text;
sqlConnection1. Open();

followed by the usual try-catch......let me re-iterate that this works
fine. I believe that I need to do something to make the e.Item.Cells
part not visible on the cells I wish to exclude from the Edit mode.
However I do not know what I need to do exactly?

I hope this is clear enough, thanks in advance!

Al

[Patrick.O.Ige]

You can do something like this in the EditCommand event:-
private void somedatagrid_Ed itCommand(objec t source,
DataGridCommand EventArgs e)
{
Button b = new Button();
b= (Button)e.Item. Cells[4].FindControl("W hat is the name of the
control");
b.Enabled = false;
return;
}

Patrick

"thebison" <al************ @btinternet.com > wrote in message
news:11******** *************@i 39g2000cwa.goog legroups.com...

Hi all,

I hope someone can help with this relatively simple problem.
I am building a timesheet application using ASP.NET C# with Visual
Studio 2003.As it is only a protoype application, my database has been
made in MSDE.

My problem is to do with a DataGrid. I have successfully coded the
DataGrid so that you can Edit, Update, Cancel. However as my Update
Stored Procedure only updates certain columns I would like to make
certain columns not appear as 'editable' when the user clicks on
'Edit'. (Even though the stored procedure ignores any changes they
make, I just want the option to edit removed to avoid confusion!...)

My update method looks like this:

private void Update_DataGrid (object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
System.Web.UI.W ebControls.Text Box cId = new
System.Web.UI.W ebControls.Text Box();
System.Web.UI.W ebControls.Text Box cName = new
System.Web.UI.W ebControls.Text Box();
cId = (System.Web.UI. WebControls.Tex tBox) e.Item.Cells[0].Controls[0];
cName = (System.Web.UI. WebControls.Tex tBox)
e.Item.Cells[1].Controls[0];
SqlCommand myCommand = new SqlCommand("New UpdateDept",sql Connection1);
myCommand.Comma ndType = CommandType.Sto redProcedure;
myCommand.Param eters.Add(new SqlParameter("@ DeptID",SqlDbTy pe.Int,4));
myCommand.Param eters["@DeptID"].Value = cId.Text;
myCommand.Param eters.Add(new
SqlParameter("@ DeptName",SqlDb Type.VarChar,50 ));
myCommand.Param eters["@DeptName"].Value = cName.Text;
sqlConnection1. Open();

followed by the usual try-catch......let me re-iterate that this works
fine. I believe that I need to do something to make the e.Item.Cells
part not visible on the cells I wish to exclude from the Edit mode.
However I do not know what I need to do exactly?

I hope this is clear enough, thanks in advance!

Al

[thebison]

Hi,

Thanks for your reply. I have solved the first part of the problem by
making the relevant columns 'read only' in the DataGrid property
builder. The problem now however is that my Stored Procedure is not
working, as it references the Primary Key unique identifier column in
the DataGrid. To explain further, the code reads as follows:

private void Update_DataGrid (object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
System.Web.UI.W ebControls.Text Box tId = new
System.Web.UI.W ebControls.Text Box();
System.Web.UI.W ebControls.Text Box tHrs = new
System.Web.UI.W ebControls.Text Box();
//This is the problem line!
tId = (System.Web.UI. WebControls.Tex tBox) e.Item.Cells[4].Controls[0];
tHrs = (System.Web.UI. WebControls.Tex tBox) e.Item.Cells[3].Controls[0];

SqlCommand myCommand = new
SqlCommand("New UpdateTimeSheet ",sqlConnection 1);
myCommand.Comma ndType = CommandType.Sto redProcedure;
myCommand.Param eters.Add(new
SqlParameter("@ TimeSheetID",Sq lDbType.Int,4)) ;
myCommand.Param eters["@TimeSheet ID"].Value = tId.Text;
myCommand.Param eters.Add(new SqlParameter("@ Hrs",SqlDbType. Float,8));
myCommand.Param eters["@Hrs"].Value = Convert.ToSingl e (tHrs.Text);

This code worked fine before I made TimeSheetID 'read only'. The reason
I want it read only is because I do not want the user to be able to
update it. However it needs to be included as it is the unique
identifier that is used in the Stored Procedure 'WHERE' clause (WHERE
TimesheetID = @TimesheetID). The reason it is not working is that
whereas before the cell was editable, you could assign the value in the
editable cell to the 'tId.Text', now this is not possible. What code
would I use to tell the Update command to take the value from a normal
DataGrid cell - not in edit mode basically?..

Sorry if that seems unclear, I am basically looking for a way of
referencing the TimeSheetID in the DataGrid when performing my update
stored procedure.

I tried

myCommand.Param eters["@TimeSheet ID"].Value =
e.Item.Cells[4].Controls[0];

however this returned the "System.Argumen tOutOfRangeExce ption:
Specified argument was out of the range of valid values. Parameter
name: index" error message.

Any suggestions on how to do this?

Thanks

Al

[Patrick.O.Ige]

What you can do is
place a label control in you aspx page (in an itemtemplate) and then
databind it to your
"TimeSheetI D"
<asp:Label ID="TimeSheetID " text='<%# DataBinder.Eval (Container.Data Item,
"TimeSheetI D") %>' Runat="server" BorderWidth="0" >
in your codebehind grab the label id as follows using TimeSheetID.tex t
and assign it to your
myCommand.Param eters["@TimeSheet ID"].Value = TimeSheetID.Tex t
Since you don't need the TimeSheetID label in your aspx just set it to
visible=false
Hope that helps
Patrick

"thebison" <al************ @btinternet.com > wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Hi,

Thanks for your reply. I have solved the first part of the problem by
making the relevant columns 'read only' in the DataGrid property
builder. The problem now however is that my Stored Procedure is not
working, as it references the Primary Key unique identifier column in
the DataGrid. To explain further, the code reads as follows:

private void Update_DataGrid (object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
System.Web.UI.W ebControls.Text Box tId = new
System.Web.UI.W ebControls.Text Box();
System.Web.UI.W ebControls.Text Box tHrs = new
System.Web.UI.W ebControls.Text Box();
//This is the problem line!
tId = (System.Web.UI. WebControls.Tex tBox) e.Item.Cells[4].Controls[0];
tHrs = (System.Web.UI. WebControls.Tex tBox) e.Item.Cells[3].Controls[0];

SqlCommand myCommand = new
SqlCommand("New UpdateTimeSheet ",sqlConnection 1);
myCommand.Comma ndType = CommandType.Sto redProcedure;
myCommand.Param eters.Add(new
SqlParameter("@ TimeSheetID",Sq lDbType.Int,4)) ;
myCommand.Param eters["@TimeSheet ID"].Value = tId.Text;
myCommand.Param eters.Add(new SqlParameter("@ Hrs",SqlDbType. Float,8));
myCommand.Param eters["@Hrs"].Value = Convert.ToSingl e (tHrs.Text);

This code worked fine before I made TimeSheetID 'read only'. The reason
I want it read only is because I do not want the user to be able to
update it. However it needs to be included as it is the unique
identifier that is used in the Stored Procedure 'WHERE' clause (WHERE
TimesheetID = @TimesheetID). The reason it is not working is that
whereas before the cell was editable, you could assign the value in the
editable cell to the 'tId.Text', now this is not possible. What code
would I use to tell the Update command to take the value from a normal
DataGrid cell - not in edit mode basically?..

Sorry if that seems unclear, I am basically looking for a way of
referencing the TimeSheetID in the DataGrid when performing my update
stored procedure.

I tried

myCommand.Param eters["@TimeSheet ID"].Value =
e.Item.Cells[4].Controls[0];

however this returned the "System.Argumen tOutOfRangeExce ption:
Specified argument was out of the range of valid values. Parameter
name: index" error message.

Any suggestions on how to do this?

Thanks

Al