SQL connection and command

s = System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString;
        SqlConnection c = new SqlConnection(s);
        c.Open();
        SqlCommand cmd = new SqlCommand("insert into sample(name) values(@name)", c);
        cmd.Parameters.Add("@name", TextBox1.Text);
        cmd.ExecuteNonQuery();
        c.Close();

Local Database Connection in ASP

Web.config:

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\Anvesh\My Documents\Visual Studio 2010\WebSites\WebSite2\App_Data\Database.mdf";Integrated Security=True;User Instance=True


s= System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString;
        SqlConnection c = new SqlConnection(s);
        c.Open();

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">

            <Columns>

                <asp:TemplateField HeaderText="id">

                    <ItemTemplate>

                       <asp:Label ID="lbl" runat="server" Text='<%#Eval("Id") %>'></asp:Label>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="name">

                    <ItemTemplate>

                        <%#Eval("name") %>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <asp:TextBox ID="txtname" runat="server" Text='<%#Eval("name") %>'></asp:TextBox>

                    </EditItemTemplate>

                </asp:TemplateField>

                <asp:CommandField ShowDeleteButton="true" ShowEditButton="true" />

            </Columns>

        </asp:GridView>

public partial class Gridview : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            getdata();

        }

    }

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

    {

        Label l1 = (Label)GridView1.Rows[e.RowIndex].FindControl("lbl");

        TextBox t1=(TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");

        SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anwesh@codem.in\Documents\Visual Studio 2012\WebSites\contact us\App_Data\Database.mdf;Integrated Security=True");

        cn.Open();

        SqlCommand cmd = new SqlCommand("update gridview set name='"+t1.Text+"' where Id='"+l1.Text+"'",cn);

        int a=cmd.ExecuteNonQuery();

        if (a > 0)

        {

            GridView1.EditIndex = -1;

            getdata();

        }

    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

    {

        GridView1.EditIndex = e.NewEditIndex;

        getdata();

    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

    {

        Label l1 = (Label)GridView1.Rows[e.RowIndex].FindControl("lbl");

        SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anwesh@codem.in\Documents\Visual Studio 2012\WebSites\contact us\App_Data\Database.mdf;Integrated Security=True");

        cn.Open();

        SqlCommand cmd = new SqlCommand("delete from gridview where Id='" + l1.Text + "'", cn);

        int a = cmd.ExecuteNonQuery();

        if (a > 0)

        {

            GridView1.EditIndex = -1;

            getdata();

        }

    }

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

    {

        GridView1.EditIndex = -1;

        getdata();

    }

    public void getdata()

    {

        SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anwesh@codem.in\Documents\Visual Studio 2012\WebSites\contact us\App_Data\Database.mdf;Integrated Security=True");

        SqlDataAdapter da = new SqlDataAdapter("select * from gridview",cn);

        DataSet ds = new DataSet();

        da.Fill(ds);

        GridView1.DataSource = ds.Tables[0];

        GridView1.DataBind();

    }

}

progreess bar using threding

private void button1_Click(object sender, EventArgs e)

 {

 for (int i = 1; i <= 100; i++)

 {

 Thread. Sleep(10);

 progressBar1.Value = i;

 }

 }

days calculation

private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

            textBox1.Text = DateTime.Now.ToShortDateString();

          

        }

        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

            textBox2.Text = DateTime.Now.ToShortDateString();

        }

     

        private void button1_Click(object sender, EventArgs e)

        {

            TimeSpan t;

            t = Convert.ToDateTime(textBox2.Text) - Convert.ToDateTime(textBox1.Text);

            label1.Text = t.TotalDays.ToString();

        }

time difference

private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

            textBox1.Text = DateTime.Now.ToString();

        }

        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

           textBox2.Text= DateTime.Now.ToString();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            TimeSpan ts;

            ts = Convert.ToDateTime(textBox2.Text) - Convert.ToDateTime(textBox1.Text);

            textBox3.Text = ts.ToString();

        }

display time &date

private void button1_Click(object sender, EventArgs e)

        {

            textBox1.Text = DateTime.Now.ToString();

            textBox2.Text = DateTime.Now.ToShortTimeString();

            textBox3.Text = DateTime.Now.ToShortDateString();

        }