gridview update in asp.net

Question

0.00/5 (No votes)

See more:

Hi all

i have created admin screen in order to review data of a users portal serves them as a website using asp.net

in this page admin first choose the table to view it from a dropdownlist
under his choice the grid view display the data with a details view control to insert a new record
i have created 4 sqldatasourses bounded to 4 tables
and after the admin choose the table name from the dropdownlist the grid view fill with its data

my problem is update not working at all its not affect the data
aspx.vb page:

VB

Imports Microsoft.VisualBasic
Imports System.Data.SqlClient

Imports System.Drawing
Imports System.Drawing.Imaging
Imports System.Drawing.Text
Imports System.Data

Partial Public Class admin
    Inherits System.Web.UI.Page
    Dim cls As New clsMainFunctions
    Public ReadOnly sqlCN1 As New SqlConnection(ConfigurationManager.ConnectionStrings("JPRCCS").ConnectionString)
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        GridView1.DataSource = SqlDataSource1
        GridView1.DataBind()
        DetailsView1.DataSourceID = "SqlDataSource1"
        DetailsView1.DataBind()
        If Not IsPostBack Then

            GridView1.DataBind()
            DetailsView1.DataBind()
        End If
    End Sub

    Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles DropDownList1.SelectedIndexChanged


        Dim tablename As String = ""
        Select Case DropDownList1.SelectedIndex
            Case 0
                tablename = "TB_ShareHolders_RG"
                GridView1.DataSource = SqlDataSource1
                GridView1.DataBind()
                DetailsView1.DataSourceID = "SqlDataSource1"
                DetailsView1.DataBind()
            Case 1
                tablename = "SHARE_news"
                GridView1.DataSource = SqlDataSource2
                GridView1.DataBind()
                DetailsView1.DataSourceID = "SqlDataSource2"
                DetailsView1.DataBind()

            Case 2
                tablename = "SH_events"
                GridView1.DataSource = SqlDataSource3
                GridView1.DataBind()
                DetailsView1.DataSourceID = "SqlDataSource3"
                DetailsView1.DataBind()

            Case 3
                tablename = "tb_Announcement"
                GridView1.DataSource = SqlDataSource4
                GridView1.DataBind()
                DetailsView1.DataSourceID = "SqlDataSource4"
                DetailsView1.DataBind()
            Case 4
                tablename = "SharePrice"
                GridView1.DataSource = SqlDataSource5
                GridView1.DataBind()
                DetailsView1.DataSourceID = "SqlDataSource5"
                DetailsView1.DataBind()
        End Select
    End Sub

    Private Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging
        GridView1.PageIndex = e.NewPageIndex
    End Sub   

    Private Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowCreated

    End Sub

    Private Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting


        GridView1.DataBind()
    End Sub

    Private Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing
        GridView1.EditIndex = e.NewEditIndex
        GridView1.DataBind()

    End Sub

    Private Sub GridView1_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles GridView1.RowUpdated
        GridView1.EditIndex = -1
        'Bind the grid
       
        GridView1.DataBind()
    End Sub

    Private Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating
        GridView1.EditIndex = -1
        'Bind the grid
      
        GridView1.DataBind()
    End Sub
    
    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles GridView1.SelectedIndexChanged    

    End Sub   
End Class

.aspx page:

XML

<!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 runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
        .style2
        {
            height: 151px;
        }
        .style3
        {}
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <table class="style1">
            <tr>
                <td class="style2" colspan="2">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style3">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style3">
                    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
                        <asp:ListItem>Users</asp:ListItem>
                        <asp:ListItem>News</asp:ListItem>
                        <asp:ListItem>Events</asp:ListItem>
                        <asp:ListItem>Announcements</asp:ListItem>
                        <asp:ListItem>Share Price</asp:ListItem>
                    </asp:DropDownList>
                    <br />
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style3" colspan="2">
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" CellPadding="4"
                        ForeColor="#333333" GridLines="None" AllowSorting="True"
                        AutoGenerateEditButton="True" AutoGenerateSelectButton="True"
                        AutoGenerateDeleteButton="True" Height="310px" Width="1060px">
                        <RowStyle BackColor="#E3EAEB" />
                        <Columns>
                            <asp:CommandField />
                        </Columns>
                        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                        <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                        <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <EditRowStyle BackColor="#7C6F57" />
                        <AlternatingRowStyle BackColor="White" />
                    </asp:GridView>
                    <asp:DetailsView ID="DetailsView1" runat="server"
                        AutoGenerateInsertButton="True" Height="76px" Width="1064px"
                        BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
                        CellPadding="3" GridLines="Horizontal">
                        <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
                        <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
                        <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
                        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
                        <EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
                        <AlternatingRowStyle BackColor="#F7F7F7" />
                    </asp:DetailsView>
                    <asp:Label ID="ErrorMessageLabel" runat="server"></asp:Label>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                        ConnectionString="<%$ ConnectionStrings:JPRCnewConnectionString %>"
                        DeleteCommand="DELETE FROM [TB_ShareHolders_RG] WHERE [HolderNo] = @HolderNo"
                        InsertCommand="INSERT INTO [TB_ShareHolders_RG] ([HolderNo], [Password]) VALUES (@HolderNo, @Password)"
                        SelectCommand="SELECT [HolderNo], [Password] FROM [TB_ShareHolders_RG]"

                        UpdateCommand="UPDATE [TB_ShareHolders_RG] SET [Password] = @Password WHERE [HolderNo] = @HolderNo">
                        <DeleteParameters>
                            <asp:Parameter Name="HolderNo" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="Password" Type="String" />
                            <asp:Parameter Name="HolderNo" Type="String" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="HolderNo" />
                            <asp:ControlParameter ControlID="TextBox2" Name="Password" PropertyName="Text"
                                Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                    <br />
                </td>
            </tr>
            <tr>
                <td class="style3" colspan="2">
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
                        ConnectionString="<%$ ConnectionStrings:JPRCnewConnectionString %>"
                        DeleteCommand="DELETE FROM [SHARE_news] WHERE [NewsId] = @NewsId"
                        InsertCommand="INSERT INTO [SHARE_news] ([NewsId], [NewsTitle], [NewsImg], [NewsFull], [NewsStatus], [NewsEntry], [NewsEntryDateAndTime], [NewsDate]) VALUES (@NewsId, @NewsTitle, @NewsImg, @NewsFull, @NewsStatus, @NewsEntry, @NewsEntryDateAndTime, @NewsDate)"
                        SelectCommand="SELECT * FROM [SHARE_news]"
                        UpdateCommand="UPDATE [SHARE_news] SET [NewsTitle] = @NewsTitle, [NewsImg] = @NewsImg, [NewsFull] = @NewsFull, [NewsStatus] = @NewsStatus, [NewsEntry] = @NewsEntry, [NewsEntryDateAndTime] = @NewsEntryDateAndTime, [NewsDate] = @NewsDate WHERE [NewsId] = @NewsId">
                        <DeleteParameters>
                            <asp:Parameter Name="NewsId" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="NewsTitle" Type="String" />
                            <asp:Parameter Name="NewsImg" Type="String" />
                            <asp:Parameter Name="NewsFull" Type="String" />
                            <asp:Parameter Name="NewsStatus" Type="String" />
                            <asp:Parameter Name="NewsEntry" Type="String" />
                            <asp:Parameter Name="NewsEntryDateAndTime" Type="DateTime" />
                            <asp:Parameter Name="NewsDate" Type="String" />
                            <asp:Parameter Name="NewsId" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="NewsId" Type="Int32" />
                            <asp:Parameter Name="NewsTitle" Type="String" />
                            <asp:Parameter Name="NewsImg" Type="String" />
                            <asp:Parameter Name="NewsFull" Type="String" />
                            <asp:Parameter Name="NewsStatus" Type="String" />
                            <asp:Parameter Name="NewsEntry" Type="String" />
                            <asp:Parameter Name="NewsEntryDateAndTime" Type="DateTime" />
                            <asp:Parameter Name="NewsDate" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                    <br />
                </td>
            </tr>
            <tr>
                <td class="style3" colspan="2">
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server"
                        ConnectionString="<%$ ConnectionStrings:JPRCnewConnectionString %>"
                        DeleteCommand="DELETE FROM [SH_events] WHERE [eventID] = @eventID"
                        InsertCommand="INSERT INTO [SH_events] ([eventID], [eventDate], [eventTitle], [eventdesc]) VALUES (@eventID, @eventDate, @eventTitle, @eventdesc)"
                        SelectCommand="SELECT * FROM [SH_events]"
                        UpdateCommand="UPDATE [SH_events] SET [eventDate] = @eventDate, [eventTitle] = @eventTitle, [eventdesc] = @eventdesc WHERE [eventID] = @eventID">
                        <DeleteParameters>
                            <asp:Parameter Name="eventID" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter DbType="Date" Name="eventDate" />
                            <asp:Parameter Name="eventTitle" Type="String" />
                            <asp:Parameter Name="eventdesc" Type="String" />
                            <asp:Parameter Name="eventID" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="eventID" Type="Int32" />
                            <asp:Parameter DbType="Date" Name="eventDate" />
                            <asp:Parameter Name="eventTitle" Type="String" />
                            <asp:Parameter Name="eventdesc" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td class="style3" colspan="2">
                    <asp:SqlDataSource ID="SqlDataSource4" runat="server"
                        ConnectionString="<%$ ConnectionStrings:JPRCnewConnectionString %>"
                        DeleteCommand="DELETE FROM [tb_Announcement] WHERE [AnnoucmentID] = @AnnoucmentID"
                        InsertCommand="INSERT INTO [tb_Announcement] ([Ann_Title], [Ann_Des], [Ann_Date], [Ann_Status], [Ann_Lang]) VALUES (@Ann_Title, @Ann_Des, @Ann_Date, @Ann_Status, @Ann_Lang)"
                        SelectCommand="SELECT * FROM [tb_Announcement]"

                        UpdateCommand="UPDATE [tb_Announcement] SET [Ann_Title] = @Ann_Title, [Ann_Des] = @Ann_Des, [Ann_Date] = @Ann_Date, [Ann_Status] = @Ann_Status, [Ann_Lang] = @Ann_Lang WHERE [AnnoucmentID] = @AnnoucmentID">
                        <DeleteParameters>
                            <asp:Parameter Name="AnnoucmentID" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="Ann_Title" Type="String" />
                            <asp:Parameter Name="Ann_Des" Type="String" />
                            <asp:Parameter Name="Ann_Date" DbType="Date" />
                            <asp:Parameter Name="Ann_Status" Type="String" />
                            <asp:Parameter Name="Ann_Lang" Type="String" />
                            <asp:Parameter Name="AnnoucmentID" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="Ann_Title" Type="String" />
                            <asp:Parameter Name="Ann_Des" Type="String" />
                            <asp:Parameter DbType="Date" Name="Ann_Date" />
                            <asp:Parameter Name="Ann_Status" Type="String" />
                            <asp:Parameter Name="Ann_Lang" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td class="style3" colspan="2">
                    <asp:SqlDataSource ID="SqlDataSource5" runat="server"
                        ConnectionString="<%$ ConnectionStrings:JPRCnewConnectionString %>"
                        DeleteCommand="DELETE FROM [SharePrice] WHERE [ID] = @ID"
                        InsertCommand="INSERT INTO [SharePrice] ([shareprice], [date]) VALUES (@shareprice, @date)"
                        SelectCommand="SELECT * FROM [SharePrice]"

                        UpdateCommand="UPDATE [SharePrice] SET [shareprice] = @shareprice, [date] = @date WHERE [ID] = @ID">
                        <DeleteParameters>
                            <asp:Parameter Name="ID" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="shareprice" Type="Int32" />
                            <asp:Parameter Name="date" DbType="Date" />
                            <asp:Parameter Name="ID" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="shareprice" Type="Int32" />
                            <asp:Parameter Name="date" DbType="Date" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
        </table>

    </div>
    </form>
</body>
</html>

Posted 28-Jun-13 21:04pm

Sarah MQ

Updated 28-Jun-13 21:25pm

_Amy

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raju Bollam · Answer 1 · 2013-06-28T21:19:00

Solution 1

hi this is helped to u...

http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html[^]

Posted 28-Jun-13 21:19pm

Raju Bollam

Comments

Sarah MQ 29-Jun-13 5:17am

thank you Raju
but i am assigned data to gridview at run time and every time the user select a choice the data will change so i need a method to make update and insert command at the run time differ from table to another
is there any way to do this