ASP.NET

Mavericks523-Jul-07 7:58

23-Jul-07 7:58

Thanks once again Ben, yes I’d def like to see what you’ve got since I’m kind of stuck out here, also I’m using C# as well. In my case too, there’s an object datasource which brings back all the messages ( by calling the method GetAllMessages() and then I’m brinding that object directly against the datagrid (gridview) . The problem I’m having is what to put in protected void Deletebtn_Click(object sender, EventArgs e) Delete’s button’s event handler.

Right now, I’m just calling the DeleteRow method on the GridView from with in the Delete button click event handler.

Also, the actual Row_Deleting event needs to perform the deletion….isn’t that right, so I’d have to do the actual Database delete in the following:

protected void messageGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Perform delete here ????
}

Yes, so your code will def help.
Thanks once again Ben.

kubben23-Jul-07 8:08

23-Jul-07 8:08

For the delete button outside of the grid view here is the code I am using:
NOTE in all my gridviews I have the first column in the gridview be a template column that has a label that contains the database table unique id. I mark this label as not visible, so it doesn't show up on the web page, but it is in the code behind, so I know what datarow I am dealing with.

protected void lBtnDeleteList_Click(object sender, EventArgs e)
{
 if (SomethingChecked() == 0)
 {
  this.custValidatorSendtoEmail.ErrorMessage = "Please check a list to delete.";
  this.custValidatorSendtoEmail.IsValid = false;
  return;
 }

 GridViewRow gvr = null;
 Label listID = null;
 for (int i = 0; i < this.GridView1.Rows.Count; i++)
 {
  gvr = this.GridView1.Rows[i];
  if (((CheckBox)gvr.FindControl("chkBoxSelect")).Checked)
  {
   listID = (Label)gvr.FindControl("lbListID");
   this.ObjectDataSource1.DeleteParameters["ListID"].DefaultValue = listID.Text;

   //Note we have set up a delete method in the object data source to take in the    
   //listid and delete that list.
   this.GridView1.DeleteRow(i);
  }
 }
}

private int SomethingChecked()
{
  int ret = 0;
  foreach (GridViewRow gvr in this.GridView1.Rows)
  {
   if (((CheckBox)gvr.FindControl("chkBoxSelect")).Checked)
   {
    ret += 1;
   }
  }//foreach
 return ret;
}

Hope that helps.
Ben

Mavericks523-Jul-07 8:25

23-Jul-07 8:25

Thanks Ben, SomethingChecked() func makes perfect sense, this is how I did It too; however my data grid’s first column is a checkbox column with the item template like this:

<asp:templatefield headertext="Select All">
<itemtemplate>

<asp:checkbox id="testChkBox" runat="server">

Since I have the message ID that I’m getting from that object I told you about also saved in the database, what I could do is add another column before the checkbox colums with the label displaying the Message ID (and then make it’s visibility attribute false).

So now looking at your code, the part I’m not understanding is
if (((CheckBox)gvr.FindControl("chkBoxSelect")).Checked)
{
listID = (Label)gvr.FindControl("lbListID");
this.ObjectDataSource1.DeleteParameters["ListID"].DefaultValue = listID.Text;

//Note we have set up a delete method in the object data source to take in the
//listid and delete that list.
this.GridView1.DeleteRow(i);
}

Specially where you have ObjectDataSource1.DeleteParameters["ListID"].DefaultValue = listID.Text;

I’m assuming that this method (DeleteParameters) is something that is custom written by you in that ObjectDataSource1 object. I’m getting a little confused here. Could you give me some pointers for my specific situation????

Thanks

kubben23-Jul-07 8:27

23-Jul-07 8:27

To get the code with < and > in it you have to check the box below before posting that says "Ignore HTML tags in this message"

Ben

Mavericks523-Jul-07 8:28

23-Jul-07 8:28

Thanks for the tip Ben, for now though I got it in without the opening angle brackets Smile | :)

kubben23-Jul-07 8:28

23-Jul-07 8:28

Here is my objectdatasource:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetListsByUser" TypeName="ManageListLogic"
UpdateMethod="UpdateListOnly" DeleteMethod="DeleteList" >
<SelectParameters>
<asp:SessionParameter Name="p_user" Direction="Input" SessionField="CurrentUser" />
<asp:Parameter Name="p_sortExpression" Type="String" DefaultValue="ModifiedDtm" />
<asp:Parameter Name="p_sortDirection" Type="String" DefaultValue="Descending" />
<asp:Parameter Name ="p_discount" Direction="input" />
</SelectParameters>
<UpdateParameters>
<asp:SessionParameter Name="p_user" Direction="Input" SessionField="CurrentUser" />
<asp:Parameter Name ="p_discount" Direction="input" />
</UpdateParameters>
<DeleteParameters>
<asp:SessionParameter Name="p_user" Direction="Input" SessionField="CurrentUser" />
<asp:Parameter Name ="ListID" Direction="input" />
</DeleteParameters>
</asp:ObjectDataSource>

Ben

Mavericks523-Jul-07 8:51

23-Jul-07 8:51

Hi Ben, I guess I'm not really familiar with the whole concept of Parameters tags <parameter> as you are showing in your code. Can you please tell me how do I/ or what should I do in the Grid’s event handler for deletion i.e. protected void messageGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)

I mean is it where I should be actually calling a method such as DeleteMessages() or something which will have a delete query???? I know I’m being annoying, but I am pretty new..hope you can help. Thanks Ben.

Mavericks523-Jul-07 8:26

23-Jul-07 8:26

Thanks Ben, SomethingChecked() func makes perfect sense, this is how I did It too; however my data grid’s first column is a checkbox column with the item template like this:

<br />
<asp:TemplateField  HeaderText ="Select All"><br />
            <ItemTemplate><br />
            <br />
            <br />
            <asp:CheckBox ID="testChkBox" runat="server" /><br />
            <br />
            </ItemTemplate><br />
 </asp:TemplateField><br />
<br />

Since I have the message ID that I’m getting from that object I told you about also saved in the database, what I could do is add another column before the checkbox colums with the label displaying the Message ID (and then make it’s visibility attribute false).

So now looking at your code, the part I’m not understanding is
if (((CheckBox)gvr.FindControl("chkBoxSelect")).Checked)
{
listID = (Label)gvr.FindControl("lbListID");
this.ObjectDataSource1.DeleteParameters["ListID"].DefaultValue = listID.Text;

//Note we have set up a delete method in the object data source to take in the
//listid and delete that list.
this.GridView1.DeleteRow(i);
}

Specially where you have ObjectDataSource1.DeleteParameters["ListID"].DefaultValue = listID.Text;

I’m assuming that this method (DeleteParameters) is something that is custom written by you in that ObjectDataSource1 object. I’m getting a little confused here. Could you give me some pointers for my specific situation????

Thanks

Mavericks523-Jul-07 8:27

23-Jul-07 8:27

Thanks Ben, SomethingChecked() func makes perfect sense, this is how I did It too; however my data grid’s first column is a checkbox column with the item template like this:

<br />
asp:TemplateField  HeaderText ="Select All"><br />
            ItemTemplate><br />
            <br />
            <br />
            asp:CheckBox ID="testChkBox" runat="server" /><br />
            <br />
            /ItemTemplate><br />
 /asp:TemplateField><br />
<br />

kubben23-Jul-07 8:32

23-Jul-07 8:32

Since you are using an object data source you can put all of the select update and delete methods in a sepparate class. So my site has a middle tier logic layer that is accessed before the database layer. You don't have to do it that way, you can have the methods in the code behind of your page as well.

Ben

Mavericks523-Jul-07 8:52

23-Jul-07 8:52

Hi Ben, I guess I'm not really familiar with the whole concept of Parameters tags as you are showing in your code. Can you please tell me how do I/ or what should I do in the Grid’s event handler for deletion i.e. protected void messageGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)

I mean is it where I should be actually calling a method such as DeleteMessages() or something which will have a delete query???? I know I’m being annoying, but I am pretty new..hope you can help. Thanks Ben.

kubben23-Jul-07 9:01

23-Jul-07 9:01

If you want to use the objectdatasource to do the deletes, you have to tell it in the objectdatasource which method it is to call. Since the object datasource delete tend to work off one record at a time, you will need to pass the id of the record you want to delete. So the code I have posted calls the delete method defined in the objectdatasource for each of the ids that I get based off which items are checked. So you need to make a method that accepts one parameter set it up in the object datasource and then call it like the code I posted.

Ben

Mavericks523-Jul-07 10:00

23-Jul-07 10:00

I'm not too sure what you mean by that. I mean when you say that if you want to use objectdatasource to do deletes, I’m thinking there’s gotta be a way without it too. See my Message class has a method that has the query along with the ADO.Net code to perform the delete, it only requires the message ID that I will be able to extract. So question is how do I set it all up…. I mean right now in the code behind file I have protected void Deletebtn_Click(object sender, EventArgs e) and

protected void messageGridView_RowDeleting(object sender, GridViewDeleteEventArgs e).

Where messageGridView is the Data grid. Could you please send me something that would work with this sort of setup. In other words how do I call deleteMessage() and from where in this situation. Or if I use that obJectdatasource (which I totally could and add the name of the method for the DeleteMethod property, how would I hook it up to the event handler of the DELETE button?? Please help? Thanks Ben

kubben23-Jul-07 12:06

23-Jul-07 12:06

Ok the easy way is:
If you have a delete button outside of the gridview I believe that is your Deletebtn_Click, inside of that method loop through the grid view items see if they are checked. If they are then call your deleteMesage() method, passing it the id of the item you want to delete. Do worry about setting the objectdatasource delete method.

Ben

Mavericks523-Jul-07 12:07

23-Jul-07 12:07

Thanks Ben, i'm assuming in the end you meant, DON'T worry about setting the objectsource??? Correct?

kubben24-Jul-07 1:10

Sorting Data of Data Grid Control

24-Jul-07 1:10

Sorry about that yes DON't worry about the objectdatasource. I guess what I am thinking in my head doesn't always make it to my fingers.

Ben

Khan.Bangash23-Jul-07 4:50

Khan.Bangash

23-Jul-07 4:50

Hi all, I have developed in asp.net with vb.net. There is a Data Grid on that page. I bring Data from Different tables to this Data Grid.
Now I want to sort the data of this Data Grid.
Is it possible ?
If yes then how ?
Any Example ?

Pls Help its very urgent.
Thanks in Advance.

jcdevnet23-Jul-07 5:34

jcdevnet

23-Jul-07 5:34

Actually what you can do is sort the actual table, you can either provide a sort expression on the default view of the of the DataTable and bind your DataGrid to that view using the DataSource property of the DataGrid

Greets! Joel

sathesh pandian23-Jul-07 5:35

sathesh pandian

23-Jul-07 5:35

you can use dataview to sort the records.

assign the table.defaultview with the dataview.

Then you can sort it with the column name.

dim dtview as new dataview=table.defaultview

dtview.sort(columnName)

All The Best

Sathesh Pandian

Khan.Bangash23-Jul-07 5:48

Khan.Bangash

23-Jul-07 5:48

Dear Actually I have a Data Grid and its different columns are set by different functions. For example first column is set by func1,2nd column is set by func2, similiry other columns are set by different functions.
Now there is a column Customer Name,
I want to sort this Data Grid with the help of this column. Is there any method with the help of which I can sort it. I want to sort this Data with the Data Which is in this Column, not with Data base table.

How is that possible.