DataSet ds = new DataSet();
SqlDataAdapter sda;
private void btn1_Click(object sender, EventArgs e)
{
ds.Tables.Clear();
sda = new SqlDataAdapter("select * from Tb", conn);
sda.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
}
private void btn2_Click(object sender, EventArgs e)
{
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Update(ds);
this.dataGridView1.DataSource = ds.Tables[0];
}
SqlDataAdapter sda;
private void btn1_Click(object sender, EventArgs e)
{
ds.Tables.Clear();
sda = new SqlDataAdapter("select * from Tb", conn);
sda.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
}
private void btn2_Click(object sender, EventArgs e)
{
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Update(ds);
this.dataGridView1.DataSource = ds.Tables[0];
}
SqlDataAdapter sda;
private void btn1_Click(object sender, EventArgs e)
{
ds.Tables.Clear(); //点击按钮时首先清除一下原有的DataSet对象中的表.
sda = new SqlDataAdapter("select * from Tb", conn); //创建SqlDataAdapter 对象
sda.Fill(ds); // 将新建好的DataSet对象填充至SqlDataAdapter
this.dataGridView1.DataSource = ds.Tables[0]; //数据源指定为DataSet中的表.
}
private void btn2_Click(object sender, EventArgs e)
{
SqlCommandBuilder scb = new SqlCommandBuilder(sda); //创建CommandBuilder 对象为的是建立 sql command
sda.Update(ds); // 调用更新命令使表中作出改变
this.dataGridView1.DataSource = ds.Tables[0]; //将数据源重新绑定一下表.
}
{
if (!IsPostBack)
{
SetBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string connStr = @"Data Source=mydata; user id=sa; password=123 ;";
string user_name = tbuser_name.Text;
string user_tel = tbuser_tel.Text;
OracleConnection conn = new OracleConnection(connStr);
string sql = "insert into test(user_name,user_tel) values ('"+user_name+"','"+user_tel+"')";
OracleCommand cmd = new OracleCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
SetBind();
}
protected void SetBind()
{
string connStr = @"Data Source=mydata; user id=sa; password=123 ;";
OracleConnection conn = new OracleConnection(connStr);
string sql = "select user_name, user_tel from test ";
OracleDataAdapter da = new OracleDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}