ASP.NET

12-May-09 23:58

Good day

On RowDataBound event i have hidden the Field called ID that will appear after the Check Box like this

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
   {
       e.Row.Cells[1].Visible = false;
   }

Now its time to Delete the Selected Records from a Gridview and i have the Following code on the Delete Button

foreach (GridViewRow row in GridView1.Rows)
          {
              CheckBox chkbx = (CheckBox)row.FindControl("myCheckBox");
              // only add non empty staff names
              if (chkbx != null && chkbx.Checked)
              {
                  List.Add(GridView1.Columns[1]);

                  Userarr.Add(GridView1.Columns[2]);

                  for(int i = 0 ; i < List.Count ; i++)
                  {
                      int Staff_ID  = obj.Get_User_Id(Convert.ToString(Userarr[i]),Convert.ToString(Session["ActiveDatabase"]));

                      obj.Responsibility_Caretaker_Remove(Convert.ToInt32(List[i]), Staff_ID,Convert.ToString(Session["ActiveDatabase"]));
                  }


              }

          }

I know you will complain about Arraylist, lets look at the Solution, i will change later.
Now what am doing here is: I add the Value of the second Field and the third to Different Arraylist and using for loop and calling a method that will call a Sp that will Delete the record based on those two Fields. Now my Problem is that the Field

List.Add(GridView1.Columns[1]);

has been set to false in the Visible Property as you have seen above. And am getting index out of bounds errors. How can i get the value on that hidden Field.

Thanks

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

binarymax13-May-09 1:53

binarymax

13-May-09 1:53

You can access the text property for the cell even if it is invisible. I'm not sure why you are grabbing the column object from the grid and expecting to get a value from that. I'm also not sure why you are adding to the List in a foreach and then looping through the entire list every foreach iteration?

I think you might want to try something this instead:

foreach (GridViewRow row in GridView1.Rows)
          {
              CheckBox chkbx = (CheckBox)row.FindControl("myCheckBox");
              // only add non empty staff names
              if (chkbx != null && chkbx.Checked)
              {
                      int Staff_ID  = obj.Get_User_Id(Convert.ToString(row.Cells[2].Text),Convert.ToString(Session["ActiveDatabase"]));

                      obj.Responsibility_Caretaker_Remove(Convert.ToInt32(row.Cells[1].Text), Staff_ID,Convert.ToString(Session["ActiveDatabase"]));
              }

          }

Hope this helps.

Vimalsoft(Pty) Ltd13-May-09 2:01

13-May-09 2:01

Thank you very much it Helped.

Resolved

Thanks

Ibrahim Bello14-May-09 6:25

Ibrahim Bello

14-May-09 6:25

Oh can see you've already got the solution. Regards Smile | :)

Ibrahim Bello14-May-09 6:22

Ibrahim Bello

14-May-09 6:22

Hi,
1. At what point are you getting the IndexOutOfRangeException? Have you stepped through your code?

2. Instead of hiding the ID column you can decide not to bind the ID column to the gridview in the first place, by not specifying it in the gridview boundfield collections.

You can set the ID column of the datasource as a Primary Key to the GridView Rows which you can use for your delete.

hope this helps,

Ibrahim

HTML Table Cell value

Girish48112-May-09 23:40

Girish481

12-May-09 23:40

Hello,
I have placed a html table control on my web page. I wish to fill the rows and columns with dataset's rows and column. Please tell me the easy the faster way to fill the html table with dataset.

Dataset is carrying 20 rows and 8 columns.

Thanks & Regards
Girish Sharma

Ramesh Swaminathan12-May-09 23:59

12-May-09 23:59

The easiest way is go for a GridView control in asp.net 2.0. You can display the dataset content in a tabular format by writing few lines of code.

It will also maintain the ViewState between postback.

You can also provide the sorting, paging and filter options.

Girish48113-May-09 2:37

Girish481

13-May-09 2:37

So, finally, i am using GridView control, but one little question more:

How do i set column name as per query column; i.e. suppose select query is :
select Cname as "Candidate Name" from table1. So i wish to give the column name "Candidate Name" like wise.

Thanks & Regards
Girish Sharma

Baran M13-May-09 18:19

Baran M

13-May-09 18:19

You can use RowDataBound event. Google it. you can do it like in that event,

"If e.Row.RowType = DataControlRowType.Header Then

do somthing

End If"

Display image in Detailsvew control....

saanj13-May-09 2:29

saanj

13-May-09 2:29

You can't use a HTML table in the code-behind to bind it to the dataset. You need to set runat="server" attribute to true. You can also use the HTMLTextWrite class to generate the table. Otherwise, you can always use the grid view control with out writing so many lines of code. But it totally depends on the requirement.

Either you love IT or leave IT...

pranavcool12-May-09 23:18

pranavcool

12-May-09 23:18

Hi,
I have never used this control.Cay any one tell me:-

1) how to display image in detailsview control.I have store that image path in database.I want to display that image using the path store in that database.
2) and i want to hide columns of the detailsview control.Is it possible?.If yes how it is possible.

Can any one provide me the example..........if possible.

Thanks in advance.

Regards,
Pranav.

Pranav Dave

Re: Display image in Detailsvew control....

Ramesh Swaminathan12-May-09 23:35

12-May-09 23:35

Put this code in .aspx page
<asp:DataList ID="dataListImages" runat="server" RepeatColumns="3" RepeatDirection="Horizontal"
Width="100%" CellPadding="2" CellSpacing="0">
<ItemTemplate>
<img alt="" src='<%#DataBinder.Eval(Container.DataItem, "Image_Path")%>' />
</ItemTemplate>
</asp:DataList>

In code behind .cs file

private void BindDataList()
{

using (SqlConnection connection = new SqlConnection("Database=DOTNET;Server=HELLO-COMP;Integrated Security=SSPI"))
{
string queryString = "SELECT Image_Path FROM Image_Table";
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);

dataListImages.DataSource = dt;
dataListImages.DataBind();
}
}

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

Web.config

Xpycm12-May-09 22:24

Xpycm

12-May-09 22:24

Tell me, please, how to delete individual pages from auntifikatsii file web.config
Thanks

Ramesh Swaminathan12-May-09 22:30

12-May-09 22:30

What ...?

You question is not clear.

What is auntifikatsii file?

Xpycm13-May-09 0:09

Xpycm

13-May-09 0:09

Sorry,
authentication...individual pages from authentication in the Web.Config file

Baran M12-May-09 22:51

Baran M

12-May-09 22:51

Do you want to delete pages from web.config file ? D'Oh! | :doh:

Abhijit Jana12-May-09 22:53

Abhijit Jana

12-May-09 22:53

Xpycm wrote:
how to delete individual pages from auntifikatsii file web.config

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Xpycm13-May-09 0:37

Xpycm

13-May-09 0:37

Sorry,
authentication ... individual pages from authentication in the Web.Config

Adding a Checkbox in a Gridview

specialdreamsin13-May-09 0:50

specialdreamsin

13-May-09 0:50

Hi,

See...Until you won't clearly express your problem, it won't be solved.

Ramesh Sambari

Vimalsoft(Pty) Ltd12-May-09 22:12

Re: Adding a Checkbox in a Gridview

12-May-09 22:12

Good Morning

i have the Following

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" PageSize="20"
      Width="99%" OnPageIndexChanging="GridView1_PageIndexChanging" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">

      </asp:GridView>

I want to a checkbox in the First Column, i will use this Check box to find the Record to Update.

Thanks

Ramesh Swaminathan12-May-09 22:23

Re: Adding a Checkbox in a Gridview

12-May-09 22:23

Use TemplateField to add an asp.net control within a gridview column

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" PageSize="20" Width="99%" OnPageIndexChanging="GridView1_PageIndexChanging" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"><br />
<asp:TemplateField HeaderText="Edit/Update"><br />
     <ItemTemplate><br />
	 <asp:CheckBox ID="CheckBox1" runat="server" /><br />
     </ItemTemplate><br />
 </asp:TemplateField><br />
</asp:GridView><br />

Vimalsoft(Pty) Ltd12-May-09 22:41

Re: Adding a Checkbox in a Gridview

12-May-09 22:41

Good Morning Ramesh

Thank you for your Answer, my Problem is that am not using a wizard to do a Connection. Let me explain in Detail what am doing. The Code has changed a little bit i was able to bring the checkbox but here is something more

Now my Gridview will look like this

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" PageSize="20"
                         Width="99%" OnPageIndexChanging="GridView1_PageIndexChanging" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
                            <Columns>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <asp:CheckBox ID="CheckBox1" runat="server" />
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField HeaderText="User" />
                                <asp:BoundField HeaderText="Resource" />
                                <asp:BoundField HeaderText="Type" />
                            </Columns>
                            <EmptyDataTemplate>
                                <asp:CheckBox ID="chk" runat="server" />
                            </EmptyDataTemplate>
             
                         </asp:GridView>

Now am Binding my Grid like this

private void Bind_Responsibility()
   {
       BLL.BLL obj = new BLL.BLL();

       DataSet ds = new DataSet();

       ds = obj.Responsibilities_View_details(Convert.ToString(Session["Selected"]), Convert.ToString(Session["ActiveDatabase"]));

       GridView1.Visible = true;

       grdViewResponsibilities.Visible = false;

       GridView1.DataSource = ds;

       GridView1.DataMember = "Response";

       GridView1.DataBind();
   }

Now my Results are like this

checkbox User     Resource    TypeUser           Resource                 Type 
=========================================================================================                             
[]           |             |         |  Administrator | E3 - Ekonomiese Wet.| Gebou |
----------------------------------------------------------------------                              
[]           |             |         |  Administrator | E7 - FP Biblioteek  | Gebou |
----------------------------------------------------------------------  
[X]          |             |         |  Administrator | E8 - JC Coetzee     | Gebou |
==========================================================================================

Now my Problem is that First 3 Columns are Empty. How can i remove the Empty part. Am Binding from a Dataset.

Thank you

Ramesh Swaminathan12-May-09 23:12