forum

Home / DeveloperSection / Forums / How to Add, Edit, Update Records In asp.net

Ask Question

How to Add, Edit, Update Records In asp.net

Simond Gear132203-Jan-2017
Hi Guys

I am beginner in c# and currently work one of the project.I am facing a problem to show records in gridview and edit and update records without refersing.Please help me.

I would really appreciate your help.

Thanks


c#c# 
Updated on 03-Jan-2017
Simond Gear

Simond Gear

Follow

Can you answer this question?

Answer

1 Answers

Manish Kumar

Manish Kumar

03-Jan-2017
answer 521400301015136
make sql table taking id as primary key and identity specification yes

then design html form and add ajax code like this
<%@PageLanguage="C#"AutoEventWireup="true"CodeBehind="WebForm1.aspx.cs"Inherits="test.WebForm1"%>
 
<!DOCTYPEhtml>
 
<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
    <title></title>
<linkhref="Content/Site.css"rel="stylesheet"/>
    <scriptsrc="Scripts/jquery-1.7.1.min.js"></script>
   <style>
       span {
           width:300px;
          
       }
       h3 {
           color:blue;
           font-family:Garamond;
       }
   </style>
</head>
<body>
    
    <formid="form1"runat="server">

        <asp:ScriptManagerID="script1"runat="server"></asp:ScriptManager>
<!--if you want that your page should not flikr during record inseting
 updating and deleting then you can add this code andform should be inside update panel-->
    <asp:UpdatePanelID="panel1"runat="server"><ContentTemplate>
    <div  class="content-wrapper">
        <table>
            <tr>
                <td>
                    <spanid="s1"runat="server"><asp:LabelID="label1"runat="server">User Name</asp:Label></span><br/>
                    <asp:TextBoxID="EmpName"runat="server"/>
                     <spanid="Span1"runat="server"><asp:LabelID="label2"runat="server">Father Name</asp:Label></span>
                    <asp:TextBoxID="FName"runat="server"/>
                </td>
 
            </tr>
             <tr>
                <td>
                    <spanid="Span2"runat="server"><asp:LabelID="label3"  runat="server">Eamil</asp:Label></span><br/>
                    <asp:TextBoxID="email"TextMode="Email"runat="server"  />
                    <spanid="Span3"runat="server"><asp:LabelID="label4"  runat="server">Mobile Number</asp:Label></span>
                    <asp:TextBoxID="mobile"TextMode="Number"runat="server"/>
                </td>
 
            </tr>
            <tr>
                <td>
            <asp:ButtonID="submit"runat="server"OnClick="submit_Click1"Text="Submit"/><asp:LabelID="id"runat="server"Visible="false"></asp:Label>
   <asp:ButtonID="update"runat="server"OnClick="update_Click"Text="Update"Visible="false"/>
<asp:LabelID="message"runat="server"></asp:Label>
                </td>
                </tr>
        </table>
        <hr/>
        <h3><asp:LabelID="Employe"runat="server"Text="Employee Detail"></asp:Label></h3>
        <asp:GridViewID="grid1"DataKeyNames="Id"runat="server"AutoGenerateColumns="false"Width="1024"OnRowDeleting="grid1_RowDeleting"OnRowUpdating="grid1_RowUpdating">
          
             <Columns>
              
                 <asp:TemplateFieldHeaderText="Name">
                     <ItemTemplate>
                         <asp:LabelID="s1"runat="server"Text='<%#Eval("UserName") %>'></asp:Label>
                     </ItemTemplate>
                 </asp:TemplateField>
                  <asp:TemplateFieldHeaderText="Father Name">
                     <ItemTemplate>
                         <asp:LabelID="s2"runat="server"Text='<%#Eval("FName")%>'></asp:Label>
                     </ItemTemplate>
                 </asp:TemplateField>
                  <asp:TemplateFieldHeaderText="Email">
                     <ItemTemplate>
                         <asp:LabelID="s3"runat="server"Text='<%#Eval("Email")%>'></asp:Label>
                     </ItemTemplate>
                 </asp:TemplateField>
                  <asp:TemplateFieldHeaderText="Mobile">
                     <ItemTemplate>
                         <asp:LabelID="s4"runat="server"Text='<%#Eval("Mobile")%>'></asp:Label>
                     </ItemTemplate>
                 </asp:TemplateField>
               
        
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:ButtonID="b1"runat="server"Text="Delete"CommandName="Delete"CausesValidation="false"/>
                       
                    </ItemTemplate>
                </asp:TemplateField>
                  <asp:TemplateField>
                    <ItemTemplate>
                       
                        <asp:ButtonID="Button1"runat="server"Text="Edit"CommandName="Update"CausesValidation="false"/>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
             
    </div>
        </ContentTemplate>
        </asp:UpdatePanel>
    </form>
</body>
</html>
 

for bind grid use this code
void bind()
        {
            DataSet ds = newDataSet();
            using (SqlConnection con = newSqlConnection(@"Data Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial Catalog = testdata"))
            {
                con.Open();
                SqlCommand cmd = newSqlCommand("select * from EmpDetail", con);
                SqlDataAdapter da = newSqlDataAdapter(cmd);
                da.Fill(ds);
                con.Close();
                grid1.DataSource = ds;
                grid1.DataBind();
            }
        }
For saving records in database
  protectedvoid submit_Click1(object sender, EventArgs e)        {            SqlConnection cnn = newSqlConnection();            cnn.ConnectionString = @"Data Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial Catalog = testdata;"
Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial
Catalog = testdata;";            cnn.Open();             SqlCommand cmd = newSqlCommand();            cmd.CommandText = "insert into EmpDetail values('"
EmpDetail values('"
+ EmpName.Text + "','"
+ FName.Text + "','"
+ email.Text + "','"
+ mobile.Text + "')";            cmd.Connection = cnn;            int i = cmd.ExecuteNonQuery();            if (i == 1)                message.Text = "Saved Succesfully!!"
Succesfully!!";            else                message.Text = "Error in saveing!!! try again!!"
saveing!!! try again!!";                        bind();         }

for deleting and eding record throuh grid view
  protectedvoid grid1_RowDeleting(object sender, GridViewDeleteEventArgs e)        {             try            {                string Id = grid1.DataKeys[e.RowIndex].Values[
grid1.DataKeys[e.RowIndex].Values["Id"].ToString();                SqlConnection cnn = newSqlConnection();                cnn.ConnectionString = @"Data Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial Catalog = testdata;"
Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial
Catalog = testdata;";                cnn.Open();                 SqlCommand cmd = newSqlCommand();                cmd.CommandText="delete from EmpDetail where Id='"
EmpDetail where Id='"+Id+"' ";                cmd.Connection = cnn;                 int i = cmd.ExecuteNonQuery();
cmd.ExecuteNonQuery();                if (i == 1)                {                    bind();                    message.Text = "Record deleted"
deleted";                }                else                {                    message.Text = "error";                }             }            catch (Exception ex)            {                message.Text =
ex.Message.ToString();            }         } <--for clearing textboxes after submitting records-->        protectedvoid ClearInputs(ControlCollection ctrls)        {            foreach (Control ctrl in ctrls)            {                if (ctrl isTextBox)                                    ((TextBox)ctrl).Text = string.Empty;                ClearInputs(ctrl.Controls);                            }        }                     protectedvoid grid1_RowUpdating(object sender, GridViewUpdateEventArgs e)        {            submit.Visible = false;            update.Visible = true;            string Id = grid1.DataKeys[e.RowIndex].Values["Id"].ToString();            SqlConnection cnn = newSqlConnection();            cnn.ConnectionString = @"Data Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial Catalog = testdata;"
Source=MSCLIENT-003\MSSQLSERVER2014;User id=sa;Password=mindstick;Initial
Catalog = testdata;";            cnn.Open();            SqlCommand cmd = newSqlCommand("select * from EmpDetail where Id="
from EmpDetail where Id=" + Id, cnn);                        SqlDataReader dr = cmd.ExecuteReader();
cmd.ExecuteReader();            if (dr.HasRows == true)            {                dr.Read();                id.Text = dr["Id"].ToString();                EmpName.Text = dr["UserName"].ToString();                FName.Text = dr["FName"].ToString();                email.Text = dr["Email"].ToString();                mobile.Text = dr["Mobile"].ToString();                 dr.Close();                cnn.Close();            }        }  

Liked By