Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
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
Posted 27-Nov-12 2:05am
firaso395
Comments
vinod kumar from bangalore at 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

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

Solution 1

  Permalink  

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 398
1 DamithSL 255
2 OriginalGriff 230
3 Zoltán Zörgő 149
4 Dave Kreskowiak 120
0 OriginalGriff 7,575
1 DamithSL 5,529
2 Sergey Alexandrovich Kryukov 5,279
3 Maciej Los 4,961
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2014
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