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 1:05am
firaso394
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
Your Filters
Interested
Ignored
     
0 Guruprasad.K.Basavaraju 424
1 Sergey Alexandrovich Kryukov 326
2 Shai Vashdi 318
3 OriginalGriff 265
4 Abhinav S 160
0 Sergey Alexandrovich Kryukov 9,169
1 OriginalGriff 5,290
2 Peter Leow 4,020
3 Maciej Los 3,535
4 Abhinav S 3,263


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