Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C#
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)
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;
b = true;
return b;

and in button click
private void button2_Click(object sender, EventArgs e)
           if (WorkersMgr.AddWorkers(textBox1.Text.Trim(),
how to put new row in datagridview
i want to help in complete code
Posted 27-Nov-12 2:05am
vinod kumar from bangalore at 27-Nov-12 7:27am
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 it correct or any thing else?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 255
1 CHill60 240
2 Peter Leow 170
3 Richard MacCutchan 169
4 Zoltán Zörgő 150
0 Sergey Alexandrovich Kryukov 9,238
1 OriginalGriff 6,806
2 Peter Leow 4,432
3 Zoltán Zörgő 3,919
4 Richard MacCutchan 2,782

Advertise | Privacy | Mobile
Web02 | 2.8.150128.1 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100