Solved

asp.net c# insert data into databse table

Posted on 2011-09-20
3
219 Views
Last Modified: 2012-05-12
Hello,

I have an application where I'm attempting to add data to a database table and I'm having difficulties with my code. Spefically, I have a page with a gridview control populated from a database table.

My *.aspx code follows:
-----------------
<asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0">
                                <asp:View ID="View_Bureau" runat="server">
                                    <table class="style1" width="500" cellpadding="0" cellspacing="0" border="0">
                                        <tr>
                                            <td>
                                                &nbsp;
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <table class="modalpnl">
                                                    <tr>
                                                        <td> &nbsp;
                                                         </td>
                                                    </tr>
                                                    <tr>
                                                        <td>
                                                            <asp:GridView ID="grdBureau" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan"  AllowSorting="True" ForeColor="Black" AutoGenerateColumns="False" CellPadding="2" DataKeyNames="BureauID" DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display." Font-Names="Arial" Font-Size="Small" GridLines="None" BorderWidth="1px">
                                                                <Columns>
                                                                    <asp:CommandField ShowEditButton="True" />
                                                                    <asp:BoundField DataField="Bureau" HeaderText="Bureau" SortExpression="Bureau" />
                                                                    <asp:BoundField DataField="Activate" HeaderText="Activate" SortExpression="Activate" />
                                                                    <asp:BoundField DataField="EnterBy" HeaderText="EnterBy" SortExpression="EnterBy" />
                                                                    <asp:BoundField DataField="EnterDate" HeaderText="EnterDate" SortExpression="EnterDate" />
                                                                </Columns>
                                                                <FooterStyle BackColor="Tan" />
                                                                <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
                                                                <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                                                                <HeaderStyle BackColor="Tan" Font-Bold="True" />
                                                                <AlternatingRowStyle BackColor="PaleGoldenrod" />
                                                            </asp:GridView>
                                                            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BadgeCodeTablesConnectionString1 %>"
                                                                DeleteCommand="DELETE FROM [Bureau] WHERE [BureauID] = @BureauID" InsertCommand="INSERT INTO [Bureau] ([BureauID], [Bureau], [Activate], [EnterBy], [EnterDate]) VALUES (@BureauID, @Bureau, @Activate, @EnterBy, @EnterDate)"
                                                                ProviderName="<%$ ConnectionStrings:BadgeCodeTablesConnectionString1.ProviderName %>"
                                                                SelectCommand="SELECT [BureauID], [Bureau], [Activate], [EnterBy], [EnterDate] FROM [Bureau]"
                                                                UpdateCommand="UPDATE [Bureau] SET [Bureau] = @Bureau, [Activate] = @Activate, [EnterBy] = @EnterBy, [EnterDate] = @EnterDate WHERE [BureauID] = @BureauID">
                                                                <DeleteParameters>
                                                                    <asp:Parameter Name="BureauID" Type="Int32" />
                                                                </DeleteParameters>
                                                                <InsertParameters>
                                                                    <asp:Parameter Name="BureauID" Type="Int32" />
                                                                    <asp:Parameter Name="Bureau" Type="String" />
                                                                    <asp:Parameter Name="Activate" Type="String" />
                                                                    <asp:Parameter Name="EnterBy" Type="String" />
                                                                    <asp:Parameter Name="EnterDate" Type="DateTime" />
                                                                </InsertParameters>
                                                                <UpdateParameters>
                                                                    <asp:Parameter Name="Bureau" Type="String" />
                                                                    <asp:Parameter Name="Activate" Type="String" />
                                                                    <asp:Parameter Name="EnterBy" Type="String" />
                                                                    <asp:Parameter Name="EnterDate" Type="DateTime" />
                                                                    <asp:Parameter Name="BureauID" Type="Int32" />
                                                                </UpdateParameters>
                                                            </asp:SqlDataSource>

--------------

My codebehind follows:
--------------
 protected void btnsavebureau_Click(object sender, EventArgs e)
        {
                        con = new SqlConnection(ConfigurationManager.ConnectionStrings["BadgeCodeTablesConnectionString"].ConnectionString);


            SqlCommand cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            con.Open();

            cmd.CommandText = @"INSERT INTO [[BadgeCodeTables] ([Bureau], [Activate],[enterby], [enterdate]) VALUES (@bureauname,'True',@username, getdate))";

           

            cmd.Parameters.AddWithValue("@bureauname", txtAddBureauname.Text);
            cmd.Parameters.AddWithValue("@Activate", 1);
            cmd.Parameters.AddWithValue("@username", 1);
            cmd.Parameters.AddWithValue("@getdate", 1);

            cmd.ExecuteNonQuery();
            con.Close();

            txtAddBureauname.Text = " ";
                 
            con.Dispose();

            Response.Redirect("Administration.aspx");



        }

        private string Username()
        {
            string username = HttpContext.Current.User.Identity.Name.ToString();
            return username;
        }
-------------

I would like help with my codebehind so that I can add new items to this table (dbo.bureau) and refresh the page so the user can see the new data upon page reload.

ANY help would be greatly appreciated.


0
Comment
Question by:Codeaddict7423
  • 2
3 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 36573238
I see that you have a CommandField, with an Edit button.

<asp:CommandField ShowEditButton="True" />

Are you having a problem with btnsavebureau_Click?  What does that do differently from the CommandField?
0
 

Author Comment

by:Codeaddict7423
ID: 36575977
TheLearnedOne:

Thank you for your reply.  Indeed, I'm having a problem with the btnsavebureau_Click in that it does not seem to save.

Any code block that you could provide to add to this database table would be appreciated.  
The screen only needs the name of the bureau (bureauname), I'd insert the values: 'True',@username, getdate.

0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 36576087
If CommandField is an Edit button for the row, and you are updating a BoundField, then you shouldn't have to write your own code.  If you are trying to insert, then I would set ShowInsertButton="true" for the CommandField.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now