Insert Data in database and bind to gridview

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace Prartice1
{
    public partial class Registration : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                GetEmpDetails();
            }
        }

        private void GetEmpDetails()
        {
            DataTable dt = new DataTable();

            try
            {
                if (con.State != ConnectionState.Open)
                    con.Open();
                using (SqlCommand cmd = new SqlCommand(@"Sp_BindEmpData", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    da.Fill(dt);
                    if(dt.Rows.Count>0)
                    {
                        gvEmpData.DataSource = dt;
                        gvEmpData.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {
                lblerror.Text = "Error at GetEmpDetails()" + ex.Message;
            }
            finally
            {
                if (con.State != ConnectionState.Open)
                    con.Open();
            }
        }
        protected void btnsave_Click(object sender, EventArgs e)
        {
            try
            {
                if (con.State != ConnectionState.Open)
                    con.Open();
                using (SqlCommand cmd = new SqlCommand(@"Sp_SaveEmployeeData", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Flag", "INSERT");
                    cmd.Parameters.AddWithValue("@EmpName",txtName.Text);
                    cmd.Parameters.AddWithValue("@Surname", txtSurname.Text);
                    cmd.Parameters.AddWithValue("@BirthDate",Convert.ToDateTime(txtbirthdate.Text));
                    cmd.Parameters.AddWithValue("@Emailid", txtEmailid.Text);
                    cmd.Parameters.AddWithValue("@Gender", rdgender.SelectedValue);
                 
                    if(chkisprobation.Checked==true)
                    {
                        cmd.Parameters.AddWithValue("@Isprobation",1);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@Isprobation",0);
                    }

                    int i=cmd.ExecuteNonQuery();
                    if(i>0)
                    {
                        lblsuccesfull.Text = "Save Successfull";
                    }
                }
            }
            catch (Exception ex)
            {
                lblerror.Text = "Error At btnSave_Click" + ex.Message;
            }
            finally
            {
                if (con.State != ConnectionState.Closed)
                    con.Close();
            }
        }
    }
}

Comments

Post a Comment

Popular posts from this blog

String Program in C#

using System; using System.Linq; 1)Reverse Name String  in C# String Name="Sudam"; int Len=Name.Length-1; while(Len>=0) { Console.Write(Name[Len]); Len--; } ----------------------------------------- Output --madus ----------------------------------------- 2)Reverse Words of a String in C# string s = "I Name Is Sudam"; string[] a = s.Split(' '); int temp= a.Length - 1; while (temp >= 0) {     Console.Write(a[temp] + ' ');     temp--; } ------------------------------------------ Output --Sudam Is Name I ---------------------------------------- 3) How to Fine count how many double letters are in a string? int doubleLetters = 0; string characters = "Hello"; for (int i = 0; i < characters.Length - 1; i++) {     if (characters[i] == characters[i + 1])     {         doubleLetters++;         i++;     }     Console.WriteLine(doubleLetters); } -----------------------------------------...
Read more

CSV using XmlNode

 To create a CSV from an XmlNode in C#, you can follow these steps: 1. Parse the XML structure using XmlNode. 2. Extract the data you need from child nodes. 3. Write the CSV content using a StringBuilder or directly with StreamWriter. Here's a sample code snippet: using System; using System.IO; using System.Text; using System.Xml; public class XmlToCsvConverter {     public static void ConvertXmlNodeToCsv(XmlNode rootNode, string csvFilePath)     {         StringBuilder csvContent = new StringBuilder();         // Assuming all child nodes have the same structure         // Add header         if (rootNode.HasChildNodes)         {             XmlNode firstRow = rootNode.FirstChild;             for (int i = 0; i < firstRow.ChildNodes.Count; i++)             {     ...
Read more

Extension Method & Partial Class

  Extension - extension method allows you to add new methods in the existing class or in the structure without modifying the source code of the original type and you do not require any kind of special permission from the original type and there is no need to re-compile the original type. Partial Class- It provides a special ability to implement the functionality of a single class into multiple files and all these files are combined into a single class file when the application is compiled. A partial class is created by using a partial keyword. First(): it returns the first element from a sequence means when we query in a collection on specific criteria, if multiple elements are found in a collection of given criteria then the first element of a sequence will return. -First it can't handle the null value. var emp = Employee.GetAllEmp().Where(x => x.Name == "Ashutosh").First();   FirstOrDefault(): FirstOrDefault works same as First() does, FirstOrDefault returns the ...
Read more