test

DropDownList1.DataSource = ds;
DropDownList1.DataValueField = "id";
DropDownList1.DataTextField = "username";
DropDownList1.Items.Clear();
DropDownList1.Items.Insert(0, new ListItem("Select", "Select"));
DropDownList1.DataBind();


GridView1.DataKeys[e.RowIndex][0].ToString();


 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        BindGrid();
    }


protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        BindGrid();
    }


if (con != null)
            {
                con.Close();
            }
            if (cmd != null)
            {
                cmd.Dispose();
            }

Insert      

string scon = "Data Source=MAYANKSHARMA-PC;Initial Catalog=aman;Persist Security       Info=True;User ID=sa;password=getsetgo";
        con = new SqlConnection(scon);
        cmd = new SqlCommand("",con);
        con.Open();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("",SqlDbType.VarChar,50).Value = TextBox1.Text.Trim();
        cmd.Parameters.Add("",SqlDbType.VarChar,50).Value = TextBox2.Text.Trim();
        cmd.ExecuteNonQuery();

Fetch


string connec = "Data Source=MAYANKSHARMA-PC;Initial Catalog=aman;Persist Security Info=True;User ID=sa;password=getsetgo";
        con = new SqlConnection(connec);
        cmd = new SqlCommand("",con);
        con.Open();
        cmd.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();