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.SqlClient;

using System.Configuration;

using System.IO;

using System.Data;

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

{

//public string connstr= conf

protected void Page_Load(object sender, EventArgs e)

{

string connStr = ConfigurationSettings.AppSettings["MyConn"];

// SqlConnection connStr = new SqlConnection(ConfigurationManager.AppSettings["MyConn"]);

using(SqlConnection conn= new SqlConnection(connStr))

{

string str = "select * from ee";

SqlDataAdapter sda = new SqlDataAdapter(str,connStr);

DataSet ds=new DataSet();

sda.Fill(ds);

GridtblEE.DataSource = ds;

GridtblEE.DataBind();

//string sqlQuery = "SELECT * from Table1";

//SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

//SqlDataAdapter sda = new SqlDataAdapter(sqlQuery, conn);

//DataTable dtData = new DataTable();

//sda.Fill(dtData);

//gvResults.DataSource = dtData.DefaultView;

//gvResults.DataBind();

}

}

protected void btnSave_Click(object sender, EventArgs e)

{

// SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["exam_moduleConnectionString"].ConnectionString);

// cmd.Parameters.Add()

//cmd.CommandText = "INSERT INTO EE VALUES(60,NamefrmFE,1285)";

//string sql = "INSERT INTO EE VALUES(60,'NamefrmFE',1285)";

// int sal = Convert.ToInt32(tbSalary.Text.ToString());

//string sql = "insert into ee(eid,ename,sal) values(200,"+ tbName.Text + ",'" + tbSalary.Text + "')";

string sql = "insert into ee values('"+ tbName.Text + "','" + tbSalary.Text + "')";

string connStr = ConfigurationSettings.AppSettings["MyConn"];

SqlConnection cnn = new SqlConnection(connStr);

SqlCommand cmd = new SqlCommand();

try

{

cnn.Open();

cmd = new SqlCommand(sql, cnn);

cmd.ExecuteNonQuery();

cmd.Dispose();

cnn.Close();

//MessageBox.Show (" ExecuteNonQuery in SqlCommand executed !!");

}

catch (Exception ex)

{

//MessageBox.Show("Can not open connection ! ");

}

Clearvalues();

}

void Clearvalues()

{

tbSalary.Text = "";

tbName.Text = "";

}

}