gridview editing

[radhikamrudhu]

hi i am not getting the editable gridview using code behind...... i am using mysql and vb for coding please help me.......



asp:DataGrid ID="dg1" Style="z-index: 101; left: 160px; position: absolute; top: 112px"
runat="server" AutoGenerateColumns="False" DataKeyField="statesId" OnEditCommand="DoItemEdit"
OnDeleteCommand="DoItemDelete" OnUpdateCommand="DoItemUpdate" BackColor="White"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black"
GridLines="Vertical">
<Columns>
<asp:BoundColumn Visible="False" DataField="stateName" HeaderText="stateName"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="stateName">
<ItemTemplate>
<asp:Label ID="Label3" Text='<%# Container.DataItem("stateName") %>' runat="server">
</asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtrolesDes" runat="server"></asp:TextBox>
</FooterTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtrolesDes" runat="server" Text='<%# container.dataitem("stateName") %>'>
</asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Delete" Text="Delete"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Modify">
<ItemTemplate>
<asp:LinkButton ID="Linkbutton2" runat="server" CausesValidation="false" CommandName="Edit"
Text="Edit"></asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:Button CommandName="Insert" Text="Add" ID="btnAdd" runat="server" />
</FooterTemplate>
<EditItemTemplate>
<asp:LinkButton ID="LinkButton3" runat="server" CommandName="Update" Text="Update"></asp:LinkButton>&nbsp;&nbsp;&nbsp;&nbsp;
<asp:LinkButton ID="Linkbutton4" runat="server" CausesValidation="false" CommandName="Cancel"
Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<SelectedItemStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="#CCCCCC" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
</asp:DataGrid>
</div>




Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim strcon As String
strcon = "server=localhost; user id=root; password=showoff; database=perry24"
Dim conn2 As New MySqlConnection(strcon)
Dim strSQL2 As String
strSQL2 = "SELECT * FROM limostates"
Try
conn2.Open()
Dim dataadapter As New MySqlDataAdapter(strSQL2, strcon)
Dim dataset1 As New DataSet
dataadapter.Fill(dataset1)
dg1.DataSource = dataset1
dg1.DataBind()
Catch ex As MySql.Data.MySqlClient.MySqlException
Response.Write(ex.Message)
End Try
conn2.Close()
End Sub
Sub DoItemDelete(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
Dim strcon As String
strcon = "server=localhost; user id=root; password=showoff; database=perry24"
Dim conn2 As New MySqlConnection(strcon)
Dim strSQL2 As String
Try
conn2.Open()
strSQL2 = "DELETE FROM limostates WHERE statesId=?statesId"
Dim cmd As New MySqlCommand(strSQL2, conn2)
cmd.ExecuteNonQuery()
strSQL2 = "SELECT * FROM limostates"
Dim dataadapter As New MySqlDataAdapter(strSQL2, strcon)
Dim dataset1 As New DataSet
dataadapter.Fill(dataset1)
dg1.DataSource = dataset1
dg1.DataBind()
Catch ex As MySql.Data.MySqlClient.MySqlException
Response.Write(ex.Message)
End Try
conn2.Close()
End Sub

Sub DoItemEdit(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
dg1.EditItemIndex = objArgs.Item.ItemIndex
End Sub

Sub DoItemCancel(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
dg1.EditItemIndex = -1
End Sub

Sub DoItemUpdate(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
Dim rolesDes As TextBox
Dim statesId As Integer
Dim qstring As String
rolesDes = CType(objArgs.Item.FindControl("rolesDes"), TextBox)
statesId = dg1.DataKeys(objArgs.Item.ItemIndex)
Dim strcon As String
strcon = "server=localhost; user id=root; password=showoff; database=perry24"
Dim conn2 As New MySqlConnection(strcon)
Try
conn2.Open()
qstring = "UPDATE limostates set stateName='" & rolesDes.Text & "' WHERE statesId=?statesId"
Dim cmd As New MySqlCommand(qstring, conn2)
cmd.ExecuteNonQuery()
dg1.EditItemIndex = -1
qstring = "SELECT * FROM limostates"
Dim dataadapter As New MySqlDataAdapter(qstring, conn2)
Dim dataset1 As New DataSet
dataadapter.Fill(dataset1)
dg1.DataSource = dataset1
dg1.DataBind()
Catch ex As MySql.Data.MySqlClient.MySqlException
Response.Write(ex.Message)
End Try
conn2.Close()
End Sub
End Class

[maheshmrk22]

Hi,

I have gone through your code. But i did not get one thing that why did you make the states column as visible false.

<asp:BoundColumn Visible="False" DataField="stateName" HeaderText="stateName"></asp:BoundColumn>


If you are facing any perticular exception then you can post that here.

Thanks
Mahesh

hi i am not getting the editable gridview using code behind...... i am using mysql and vb for coding please help me.......



asp:DataGrid ID="dg1" Style="z-index: 101; left: 160px; position: absolute; top: 112px"
runat="server" AutoGenerateColumns="False" DataKeyField="statesId" OnEditCommand="DoItemEdit"
OnDeleteCommand="DoItemDelete" OnUpdateCommand="DoItemUpdate" BackColor="White"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black"
GridLines="Vertical">
<Columns>
<asp:BoundColumn Visible="False" DataField="stateName" HeaderText="stateName"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="stateName">
<ItemTemplate>
<asp:Label ID="Label3" Text='<%# Container.DataItem("stateName") %>' runat="server">
</asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtrolesDes" runat="server"></asp:TextBox>
</FooterTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtrolesDes" runat="server" Text='<%# container.dataitem("stateName") %>'>
</asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Delete" Text="Delete"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Modify">
<ItemTemplate>
<asp:LinkButton ID="Linkbutton2" runat="server" CausesValidation="false" CommandName="Edit"
Text="Edit"></asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:Button CommandName="Insert" Text="Add" ID="btnAdd" runat="server" />
</FooterTemplate>
<EditItemTemplate>
<asp:LinkButton ID="LinkButton3" runat="server" CommandName="Update" Text="Update"></asp:LinkButton>&nbsp;&nbsp;&nbsp;&nbsp;
<asp:LinkButton ID="Linkbutton4" runat="server" CausesValidation="false" CommandName="Cancel"
Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<SelectedItemStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="#CCCCCC" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
</asp:DataGrid>
</div>




Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim strcon As String
strcon = "server=localhost; user id=root; password=showoff; database=perry24"
Dim conn2 As New MySqlConnection(strcon)
Dim strSQL2 As String
strSQL2 = "SELECT * FROM limostates"
Try
conn2.Open()
Dim dataadapter As New MySqlDataAdapter(strSQL2, strcon)
Dim dataset1 As New DataSet
dataadapter.Fill(dataset1)
dg1.DataSource = dataset1
dg1.DataBind()
Catch ex As MySql.Data.MySqlClient.MySqlException
Response.Write(ex.Message)
End Try
conn2.Close()
End Sub
Sub DoItemDelete(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
Dim strcon As String
strcon = "server=localhost; user id=root; password=showoff; database=perry24"
Dim conn2 As New MySqlConnection(strcon)
Dim strSQL2 As String
Try
conn2.Open()
strSQL2 = "DELETE FROM limostates WHERE statesId=?statesId"
Dim cmd As New MySqlCommand(strSQL2, conn2)
cmd.ExecuteNonQuery()
strSQL2 = "SELECT * FROM limostates"
Dim dataadapter As New MySqlDataAdapter(strSQL2, strcon)
Dim dataset1 As New DataSet
dataadapter.Fill(dataset1)
dg1.DataSource = dataset1
dg1.DataBind()
Catch ex As MySql.Data.MySqlClient.MySqlException
Response.Write(ex.Message)
End Try
conn2.Close()
End Sub

Sub DoItemEdit(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
dg1.EditItemIndex = objArgs.Item.ItemIndex
End Sub

Sub DoItemCancel(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
dg1.EditItemIndex = -1
End Sub

Sub DoItemUpdate(ByVal objSource As Object, ByVal objArgs As DataGridCommandEventArgs)
Dim rolesDes As TextBox
Dim statesId As Integer
Dim qstring As String
rolesDes = CType(objArgs.Item.FindControl("rolesDes"), TextBox)
statesId = dg1.DataKeys(objArgs.Item.ItemIndex)
Dim strcon As String
strcon = "server=localhost; user id=root; password=showoff; database=perry24"
Dim conn2 As New MySqlConnection(strcon)
Try
conn2.Open()
qstring = "UPDATE limostates set stateName='" & rolesDes.Text & "' WHERE statesId=?statesId"
Dim cmd As New MySqlCommand(qstring, conn2)
cmd.ExecuteNonQuery()
dg1.EditItemIndex = -1
qstring = "SELECT * FROM limostates"
Dim dataadapter As New MySqlDataAdapter(qstring, conn2)
Dim dataset1 As New DataSet
dataadapter.Fill(dataset1)
dg1.DataSource = dataset1
dg1.DataBind()
Catch ex As MySql.Data.MySqlClient.MySqlException
Response.Write(ex.Message)
End Try
conn2.Close()
End Sub
End Class

[radhikamrudhu]

thanks mahesh. i solved that problem..... is it possible to display the gridview vertically in the source code....

[maheshmrk22]

Hi,

What do you mean by Vertical....do you mean in landscape format?

Thanks
Mahesh

thanks mahesh. i solved that problem..... is it possible to display the gridview vertically in the source code....

[radhikamrudhu]

colulmns datas should be displayed in row.....

[maheshmrk22]

Hi,

That is possible. What you have to do is

1. Take your dataset in one datatable.

2. for intj=0;j<datatable.columns.count-1;j++
datarow dr = new datarow()
datatable2.rows.add(dr)
for i=0;i<datatable.rows.count-1;i++
dr[i] =datatable2[i][j]

Like wise you have to transfer data from column to rows of new datatatble.

And then bind that datatble to datagrid.

Thanks
Mahesh