arvsha
asked on
Update table bind to datagrid
I want to update the table that is bind to the datagrid through dataset.
her is what i am doing
private void FrmTemplateNew_Load(object sender, System.EventArgs e)
{
AsaCon= new SqlConnection("user id=sa;" +
"password=sa;server=harbin ger;" +
"database=oct29_2004; " +
"connection timeout=30");
AsaCon.Open();
AsaCmd=new SqlCommand("Select * from TblTemplate",AsaCon);
AsaDptr=new SqlDataAdapter(AsaCmd);
Dset=new DataSet("tblTemplate");
AsaDptr.Fill(Dset,"tblTemp late");
dataGrid1.SetDataBinding(D set,"tblTe mplate");
dataGrid1.DataSource=Dset;
}
private void button1_Click(object sender, System.EventArgs e)
{
Dset.AcceptChanges();//I used this becz without it the update was giving error that I
//must specifiy a valid update statement
AsaDptr.Update(Dset,"tblTe mplate");
}
Now it is not giving the error but is also not updatting the table.
Please help me out. Its urgent.
her is what i am doing
private void FrmTemplateNew_Load(object
{
AsaCon= new SqlConnection("user id=sa;" +
"password=sa;server=harbin
"database=oct29_2004; " +
"connection timeout=30");
AsaCon.Open();
AsaCmd=new SqlCommand("Select * from TblTemplate",AsaCon);
AsaDptr=new SqlDataAdapter(AsaCmd);
Dset=new DataSet("tblTemplate");
AsaDptr.Fill(Dset,"tblTemp
dataGrid1.SetDataBinding(D
dataGrid1.DataSource=Dset;
}
private void button1_Click(object sender, System.EventArgs e)
{
Dset.AcceptChanges();//I used this becz without it the update was giving error that I
//must specifiy a valid update statement
AsaDptr.Update(Dset,"tblTe
}
Now it is not giving the error but is also not updatting the table.
Please help me out. Its urgent.
ASKER
I tried it
private void FrmTemplateNew_Load(object sender, System.EventArgs e)
{
AsaCon= new SqlConnection("user id=sa;" +
"password=sa;server=harbin ger;" +
"database=oct29_2004; " +
"connection timeout=30");
AsaCon.Open();
AsaCmd=new SqlCommand("Select * from dt_Account",AsaCon);
custCB = new SqlCommandBuilder(AsaDptr) ; // A commandbuilder is required
AsaDptr=new SqlDataAdapter(AsaCmd);
Dset=new DataSet("dt_Account");
AsaDptr.Fill(Dset,"dt_Acco unt");
dataGrid1.SetDataBinding(D set,"dt_Ac count");
dataGrid1.DataSource=Dset. Tables["dt _Account"] ;
}
private void button1_Click(object sender, System.EventArgs e)
{
//dataGrid1.Update();
Dset.AcceptChanges(); //added this because without it the next stetement is generating error.
AsaDptr.Update(Dset,"dt_Ac count");
//dataGrid1.Update();
}
but still its not updating the table
private void FrmTemplateNew_Load(object
{
AsaCon= new SqlConnection("user id=sa;" +
"password=sa;server=harbin
"database=oct29_2004; " +
"connection timeout=30");
AsaCon.Open();
AsaCmd=new SqlCommand("Select * from dt_Account",AsaCon);
custCB = new SqlCommandBuilder(AsaDptr)
AsaDptr=new SqlDataAdapter(AsaCmd);
Dset=new DataSet("dt_Account");
AsaDptr.Fill(Dset,"dt_Acco
dataGrid1.SetDataBinding(D
dataGrid1.DataSource=Dset.
}
private void button1_Click(object sender, System.EventArgs e)
{
//dataGrid1.Update();
Dset.AcceptChanges(); //added this because without it the next stetement is generating error.
AsaDptr.Update(Dset,"dt_Ac
//dataGrid1.Update();
}
but still its not updating the table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ya it hasa primary key but still its not working what should I do.
Its urgent please you techi people help me
Its urgent please you techi people help me
private void FrmTemplateNew_Load(object
{
AsaCon= new SqlConnection("user id=sa;" +
"password=sa;server=harbin
"database=oct29_2004; " +
"connection timeout=30");
AsaCon.Open();
AsaCmd=new SqlCommand("Select * from TblTemplate",AsaCon);
SqlCommandBuilder custCB = new SqlCommandBuilder(AsaDptr)
AsaDptr=new SqlDataAdapter(AsaCmd);
Dset=new DataSet("tblTemplate");
AsaDptr.Fill(Dset,"tblTemp
dataGrid1.SetDataBinding(D
dataGrid1.DataSource=Dset;
}
private void button1_Click(object sender, System.EventArgs e)
{
AsaDptr.Update(Dset,"tblTe
}