ASP.NET

gridview problem RSS

1 reply

Last post Aug 05, 2011 11:46 AM by rkbvasanths@hotmail.com

‹ Previous Thread|Next Thread ›

praveen.chin...

None

0 Points

1 Post

gridview problem

Aug 05, 2011 11:43 AM|LINK

how to get the code in gridveiw for the single column is having with each row one button and textbox which i m fing hard to get the updation in the database table only one row is getting updated ..plz help........

-------------Source code----------

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="RoomAvailable.aspx.vb" Inherits="RoomAvailable" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Untitled Page</title>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server" submitdisabledcontrols="False">
    <asp:GridView ID="GridView1" runat="server" BackColor="#CCCCCC" 
        BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" 
        CellSpacing="2" ForeColor="Black" AutoGenerateColumns="False" AllowPaging="True" 
        
        
        style="top: 118px; left: 369px; position: absolute; height: 386px; width: 403px">
        <RowStyle BackColor="White" />
        <Columns>
            <asp:TemplateField HeaderText="RoomNo">
                <ItemTemplate>
                    l<asp:Label ID="Label1" runat="server" Text='<%# eval("RoomNo") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="NoOfBeds">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# eval("No_Of_Beds") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="BedsOccupied">
                <ItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# eval("BedOccupied") %>'></asp:TextBox>
                    &nbsp;
                    <asp:Button ID="btnupdate" runat="server" Text="Update" />
                    <br />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="AvailableBeds">
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%# eval("BedAvailable") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Status">
                <ItemTemplate>
                    <asp:Label ID="Label4" runat="server" Text='<%# eval("Status") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
        <FooterStyle BackColor="#CCCCCC" />
        <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
        <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
    </asp:GridView>
    <div>
    
    </div>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<table class="style1">
        <tr>
            <td align="center">
                <h3>Information about Room Availability  </h3></td>
        </tr>
    </table>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;
    <br />
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <br />
    <br />
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Button ID="btncalculate" runat="server" Text="Calculate" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    </form>
</body>
</html>-------------------design code----------------

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlCommand

Partial Class RoomAvailable
    Inherits System.Web.UI.Page
    Dim con As SqlConnection
    Dim ds As New DataSet
    Dim cmd As New SqlCommand
    Dim adp As New SqlDataAdapter
    Dim sql As String
    Dim sql1 As String


    Sub conn()
        con = New SqlConnection("Data Source=192.168.0.109;Initial Catalog=HostelDB;User ID=sa;password=T102t2a1l")

        If con.State = ConnectionState.Closed Then

        End If
        con.Open()
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Call conn()
        If Not IsPostBack Then


            sql = "select * from BedAvailable1"
            adp = New SqlDataAdapter(sql, con)
            adp.Fill(ds)
            GridView1.DataSource = ds
            GridView1.DataBind()
        End If
    End Sub

    

    Protected Sub btncalculate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btncalculate.Click
        Dim a1, a2 As String
        Dim b1, b2 As Integer

        Dim BedOccupied, BedOccupied1 As TextBox
        Dim RoomNo, RoomNo1 As Label

        Dim i As Integer

        For i = 0 To GridView1.Rows.Count - 1
            BedOccupied = CType(GridView1.Rows(0).Cells(0).FindControl("Textbox1"), TextBox)
            a1 = BedOccupied.Text
            RoomNo = CType(GridView1.Rows(0).Cells(0).FindControl("Label1"), Label)
            b1 = RoomNo.Text

            sql = "update BedAvailable1 set BedOccupied = '" & a1 & "'where RoomNo ='" & b1 & "' "

            BedOccupied1 = CType(GridView1.Rows(1).Cells(0).FindControl("Textbox1"), TextBox)
            a2 = BedOccupied1.Text
            RoomNo1 = CType(GridView1.Rows(1).Cells(0).FindControl("Label1"), Label)
            b2 = RoomNo1.Text
            sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

        Next


        cmd = New SqlCommand(sql, con)
        cmd.ExecuteNonQuery()

    End Sub

    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged

    End Sub

    Protected Sub btnupdate_Click(ByVal sender As Object, ByVal e As System.EventArgs)

        'Dim sql As String
        'Dim a1, a2, a3, a4, a5, a6, a7, a8, a9 As String
        'Dim b1, b2, b3, b4, b5, b6, b7, b8, b9 As Integer


        'Dim BedOccupied As TextBox
        'Dim RoomNo As Label

        'BedOccupied = CType(GridView1.Rows(0).Cells(0).FindControl("Textbox1"), TextBox)
        'a1 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(0).Cells(0).FindControl("Label1"), Label)
        'b1 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(1).Cells(1).FindControl("Textbox1"), TextBox)
        'a2 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(1).Cells(1).FindControl("Label1"), Label)
        'b2 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(2).Cells(2).FindControl("Textbox1"), TextBox)
        'a3 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(2).Cells(2).FindControl("Label1"), Label)
        'b3 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(3).Cells(3).FindControl("Textbox4"), TextBox)
        'a4 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(3).Cells(3).FindControl("Label4"), Label)
        'b4 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(4).Cells(4).FindControl("Textbox5"), TextBox)
        'a5 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(4).Cells(4).FindControl("Label5"), Label)
        'b5 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(5).Cells(5).FindControl("Textbox6"), TextBox)
        'a6 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(5).Cells(5).FindControl("Label6"), Label)
        'b6 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(6).Cells(6).FindControl("Textbox7"), TextBox)
        'a7 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(6).Cells(6).FindControl("Label7"), Label)
        'b7 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(7).Cells(7).FindControl("Textbox8"), TextBox)
        'a8 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(7).Cells(7).FindControl("Label8"), Label)
        'b8 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(8).Cells(8).FindControl("Textbox9"), TextBox)
        'a9 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(8).Cells(8).FindControl("Label9"), Label)
        'b9 = RoomNo.Text

        '  sql = "update BedAvailable1 set BedOccupied ='" & a1 & "' where RoomNo ='" & b1 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a2 & "' where RoomNo ='" & b2 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a3 & "' where RoomNo ='" & b3 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a4 & "' where RoomNo ='" & b4 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a5 & "' where RoomNo ='" & b5 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a6 & "' where RoomNo ='" & b6 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a7 & "' where RoomNo ='" & b7 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a8 & "' where RoomNo ='" & b8 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a9 & "' where RoomNo ='" & b9 & "' "

        
        cmd = New SqlCommand(sql, con)
        cmd.ExecuteNonQuery()



    End Sub
End Class

--------------------Yesterdays code i have added in this way but its not working---------------------

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlCommand

Partial Class RoomAvailable
    Inherits System.Web.UI.Page
    Dim con As SqlConnection
    Dim ds As New DataSet
    Dim cmd As New SqlCommand
    Dim adp As New SqlDataAdapter
    Dim sql As String
    Dim sql1 As String


    Sub conn()
        con = New SqlConnection("Data Source=192.168.0.109;Initial Catalog=HostelDB;User ID=sa;password=T102t2a1l")

        If con.State = ConnectionState.Closed Then

        End If
        con.Open()
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Call conn()
        If Not IsPostBack Then


            sql = "select * from BedAvailable1"
            adp = New SqlDataAdapter(sql, con)
            adp.Fill(ds)
            GridView1.DataSource = ds
            GridView1.DataBind()
        End If
    End Sub

    

    Protected Sub btncalculate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btncalculate.Click
        Dim a1, a2, a3, a4, a5, a6, a7, a8, a9 As String
        Dim b1, b2, b3, b4, b5, b6, b7, b8, b9 As Integer

        Dim BedOccupied, BedOccupied1, BedOccupied2, BedOccupied3, BedOccupied4, BedOccupied5, BedOccupied6, BedOccupied7, BedOccupied8 As TextBox
        Dim RoomNo, RoomNo1, RoomNo2, RoomNo3, RoomNo4, RoomNo5, RoomNo6, RoomNo7, RoomNo8 As Label

        Dim i As Integer

        For i = 0 To GridView1.Rows.Count - 1
            BedOccupied = CType(GridView1.Rows(i).Cells(0).FindControl("Textbox1"), TextBox)
            a1 = BedOccupied.Text
            RoomNo = CType(GridView1.Rows(i).Cells(0).FindControl("Label1"), Label)
            b1 = RoomNo.Text

            sql = "update BedAvailable1 set BedOccupied = '" & a1 & "'where RoomNo ='" & b1 & "' "

            'BedOccupied1 = CType(GridView1.Rows(i + 1).Cells(0).FindControl("Textbox1"), TextBox)
            'a2 = BedOccupied1.Text
            'RoomNo1 = CType(GridView1.Rows(i + 1).Cells(0).FindControl("Label1"), Label)
            'b2 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

            'BedOccupied2 = CType(GridView1.Rows(i + 2).Cells(0).FindControl("Textbox1"), TextBox)
            'a3 = BedOccupied1.Text
            'RoomNo2 = CType(GridView1.Rows(i + 2).Cells(0).FindControl("Label1"), Label)
            'b3 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

            'BedOccupied3 = CType(GridView1.Rows(i + 3).Cells(0).FindControl("Textbox1"), TextBox)
            'a4 = BedOccupied1.Text
            'RoomNo3 = CType(GridView1.Rows(i + 3).Cells(0).FindControl("Label1"), Label)
            'b4 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

            'BedOccupied4 = CType(GridView1.Rows(i + 4).Cells(0).FindControl("Textbox1"), TextBox)
            'a5 = BedOccupied1.Text
            'RoomNo4 = CType(GridView1.Rows(i + 4).Cells(0).FindControl("Label1"), Label)
            'b5 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

            'BedOccupied5 = CType(GridView1.Rows(i + 5).Cells(0).FindControl("Textbox1"), TextBox)
            'a6 = BedOccupied1.Text
            'RoomNo5 = CType(GridView1.Rows(i + 5).Cells(0).FindControl("Label1"), Label)
            'b6 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

            'BedOccupied6 = CType(GridView1.Rows(i + 6).Cells(0).FindControl("Textbox1"), TextBox)
            'a7 = BedOccupied1.Text
            'RoomNo6 = CType(GridView1.Rows(i + 6).Cells(0).FindControl("Label1"), Label)
            'b7 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

            'BedOccupied7 = CType(GridView1.Rows(i + 7).Cells(0).FindControl("Textbox1"), TextBox)
            'a8 = BedOccupied1.Text
            'RoomNo7 = CType(GridView1.Rows(i + 7).Cells(0).FindControl("Label1"), Label)
            'b8 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

            'BedOccupied8 = CType(GridView1.Rows(i + 8).Cells(0).FindControl("Textbox1"), TextBox)
            'a9 = BedOccupied1.Text
            'RoomNo8 = CType(GridView1.Rows(i + 8).Cells(0).FindControl("Label1"), Label)
            'b9 = RoomNo1.Text
            'sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "



        Next



        cmd = New SqlCommand(sql, con)
        cmd.ExecuteNonQuery()

    End Sub

    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged

    End Sub

    Protected Sub btnupdate_Click(ByVal sender As Object, ByVal e As System.EventArgs)

        'Dim sql As String
        'Dim a1, a2, a3, a4, a5, a6, a7, a8, a9 As String
        'Dim b1, b2, b3, b4, b5, b6, b7, b8, b9 As Integer


        'Dim BedOccupied As TextBox
        'Dim RoomNo As Label

        'BedOccupied = CType(GridView1.Rows(0).Cells(0).FindControl("Textbox1"), TextBox)
        'a1 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(0).Cells(0).FindControl("Label1"), Label)
        'b1 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(1).Cells(1).FindControl("Textbox1"), TextBox)
        'a2 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(1).Cells(1).FindControl("Label1"), Label)
        'b2 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(2).Cells(2).FindControl("Textbox1"), TextBox)
        'a3 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(2).Cells(2).FindControl("Label1"), Label)
        'b3 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(3).Cells(3).FindControl("Textbox4"), TextBox)
        'a4 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(3).Cells(3).FindControl("Label4"), Label)
        'b4 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(4).Cells(4).FindControl("Textbox5"), TextBox)
        'a5 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(4).Cells(4).FindControl("Label5"), Label)
        'b5 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(5).Cells(5).FindControl("Textbox6"), TextBox)
        'a6 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(5).Cells(5).FindControl("Label6"), Label)
        'b6 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(6).Cells(6).FindControl("Textbox7"), TextBox)
        'a7 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(6).Cells(6).FindControl("Label7"), Label)
        'b7 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(7).Cells(7).FindControl("Textbox8"), TextBox)
        'a8 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(7).Cells(7).FindControl("Label8"), Label)
        'b8 = RoomNo.Text

        'BedOccupied = CType(GridView1.Rows(8).Cells(8).FindControl("Textbox9"), TextBox)
        'a9 = BedOccupied.Text
        'RoomNo = CType(GridView1.Rows(8).Cells(8).FindControl("Label9"), Label)
        'b9 = RoomNo.Text

        '  sql = "update BedAvailable1 set BedOccupied ='" & a1 & "' where RoomNo ='" & b1 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a2 & "' where RoomNo ='" & b2 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a3 & "' where RoomNo ='" & b3 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a4 & "' where RoomNo ='" & b4 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a5 & "' where RoomNo ='" & b5 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a6 & "' where RoomNo ='" & b6 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a7 & "' where RoomNo ='" & b7 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a8 & "' where RoomNo ='" & b8 & "' "
        'sql = "update BedAvailable1 set BedOccupied ='" & a9 & "' where RoomNo ='" & b9 & "' "

        
        cmd = New SqlCommand(sql, con)
        cmd.ExecuteNonQuery()



    End Sub
End Class

Edited by praveen.chinmalli on Aug 05, 2011 11:44 AM
Edited by praveen.chinmalli on Aug 05, 2011 11:44 AM
Edited by praveen.chinmalli on Aug 06, 2011 06:46 AM

- Reply
rkbvasanths@...

Participant

957 Points

236 Posts

Re: gridview problem

Aug 05, 2011 11:46 AM|LINK

For i = 0 To GridView1.Rows.Count - 1
            BedOccupied = CType(GridView1.Rows(i).Cells(0).FindControl("Textbox1"), TextBox)
            a1 = BedOccupied.Text
            RoomNo = CType(GridView1.Rows(i).Cells(0).FindControl("Label1"), Label)
            b1 = RoomNo.Text

            sql = "update BedAvailable1 set BedOccupied = '" & a1 & "'where RoomNo ='" & b1 & "' "

            BedOccupied1 = CType(GridView1.Rows(i+1).Cells(0).FindControl("Textbox1"), TextBox)
            a2 = BedOccupied1.Text
            RoomNo1 = CType(GridView1.Rows(i+1).Cells(0).FindControl("Label1"), Label)
            b2 = RoomNo1.Text
sql1 = "update BedAvailable1 set BedOccupied = '" & a2 & "'where RoomNo ='" & b2 & "' "

        Next

Mark it as Answer if it helps

Thanks,
Vasanth R, MCTS(SQL 2005 & SQL 2008 BI), MCP
http://dotnetcodeguide.blogspot.com
- Marked as answer by Zhongqing Tang - MSFT on Aug 11, 2011 06:13 AM

‹ Previous Thread|Next Thread ›

gridview problem RSS

1 reply

praveen.chin...

gridview problem

rkbvasanths@...

Re: gridview problem

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft