hi
if anyone help me
i want to insert data to gridview in c#
i have worked class workersmgr
public static bool AddWorkers(string name, string dept_name,int salary, int sort)
{
bool b;
string strconn = AlShehabi.Properties.Settings.Default.SalariesConnectionString;
OleDbConnection conn = new OleDbConnection(strconn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
OleDbCommand cmd = new OleDbCommand("INSERT INTO workers(Full_Name,Department_Name,Salary,sort) VALUES (@name, @dept_name,@salary,@sort) ;", conn);
cmd.Parameters.Add(new OleDbParameter("@name", name));
cmd.Parameters.Add(new OleDbParameter("@dept_name", dept_name));
cmd.Parameters.Add(new OleDbParameter("@salary", salary));
cmd.Parameters.Add(new OleDbParameter("@sort", sort));
int i = cmd.ExecuteNonQuery();
if (i <= 0)
b = false;
else
b = true;
conn.Close();
return b;
and in button click
private void button2_Click(object sender, EventArgs e)
{
if (WorkersMgr.AddWorkers(textBox1.Text.Trim(),
textBox2.Text,
textBox3.Text,
textBox4.Text))
{
}
else
{
}
}
how to put new row in datagridview
i want to help in complete code