Hi,
I am new to csharp, I cannot update the dataadapter , Here is the code
namespace app1
{
public partial class Form1 : Form
{
MySql.Data.MySqlClient.MySqlConnection conn;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{ }
private void radPageViewPage1_Paint(object sender, PaintEventArgs e)
{
}
public void radButton2_Click(object sender, EventArgs e)
{
string myConnectionString;
myConnectionString = "server=localhost;uid=root;" +
"pwd=xxxx;database=ldis;";
conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
conn.Open();
DataTable dtusers = new DataTable() ;
dtusers = Getusers();
radGridView2.DataSource = dtusers;
conn.Close();
}
private DataTable Getusers()
{
string query = "select userid,password,user_group,status,expiry from users";
MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
adapter.UpdateCommand = new MySqlCommand(
"UPDATE users SET password=@password, user_group=@user_group,status=@status WHERE userid=@userid;", conn);
adapter.UpdateCommand.Parameters.Add("@userid", MySqlDbType.VarChar, 25, "userrid");
adapter.UpdateCommand.Parameters.Add("@password", MySqlDbType.VarChar, 45, "password");
adapter.UpdateCommand.Parameters.Add("@user_group", MySqlDbType.VarChar, 45, "user_group");
adapter.UpdateCommand.Parameters.Add("@status", MySqlDbType.VarChar, 10, "status");
adapter.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
return ds.Tables[0];
}
public void save()
{
}
private void button1_Click(object sender, EventArgs e)
{
}
private void radButton1_Click(object sender, EventArgs e)
{
adapter.update();
}
}
}
I am able to retrieve the data.
but when I want to add the command
adapter.update()
in other buttons event, I get this error called ,
The name adapter does not exists in current context.
Checked lots of examples, but no one seems to get this current context errors.
Thanks in advance
Omer