Click here to Skip to main content
15,890,512 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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

C#
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
Posted
Comments
vinod kumar from bangalore 27-Nov-12 7:27am    
hi,
if u can clarify your question a little bit then i will try to help u on this..
like are you inserting a record in database and you want inserted record to be added in gridview...is it correct or any thing else?

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900