ASP.NET

Mavericks523-Jul-07 5:57

23-Jul-07 5:57

Can someone please help me with this....THanks

Not Active23-Jul-07 8:25

Not Active

23-Jul-07 8:25

Don't be so impatient. No one is required to answer your questions, it is all voluntary here. If you want immediate answers call the support number.

only two letters away from being an asset

kubben23-Jul-07 7:11

23-Jul-07 7:11

You have a couple of options with this. First you can put the delete button outside of the gridview all together. I have done that before when you have a check box to say which row to delete. Otherwise if you want the delete button to only show up once, I have used the pager template for that. There are a few issues that have to be overcome. Like you need to turn paging on and if the number of items is less then your page size your pager template hides it self so you have to make it visible again. So by far the easiest thing to do is put the delete button outside of the gridview.

Hope that helps.
Ben

Mavericks523-Jul-07 7:18

23-Jul-07 7:18

Thanks Ben, that’s probably what I’m going to end up doing. Since you did it as you mentioned, would you be able to show me some code sample…I mean there’s help available online if you are using the built in grid view Delete row feature (without the checkbox and one delete button implementation)…but I couldn’t find any code examples for the scenario we are dealing with. Could you please help me out???

Thanks

kubben23-Jul-07 7:42

23-Jul-07 7:42

I can send you some code, but it is in C# I don't know if that matters and I was using a object datasource that was returning a generic collection of an interface. So that might not be exactly what you are dealing with. Let me know if you still want to see the code.

Ben

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