在C#中的gridview中插入行 [英] insert row in gridview in c#

问题描述

嗨 如果有人帮助我
我想在C#中将数据插入到gridview中
我曾在班上工作过mgr
公共静态布尔AddWorkers(字符串名称，字符串dept_name，int薪水，int排序)
{
布尔b;
字符串strconn = AlShehabi.Properties.Settings.Default.SalariesConnectionString;
OleDbConnection conn =新的OleDbConnection(strconn);

如果(conn.State == ConnectionState.Closed)
{
conn.Open();
}

OleDbCommand cmd =新的OleDbCommand("INSERT INTO worker(Full_Name，Department_Name，Salary，sort)VALUES(@name，@ dept_name，@ salary，@ sort);"，conn);
cmd.Parameters.Add(new OleDbParameter("@ name"，名称));
cmd.Parameters.Add(new OleDbParameter("@ dept_name"，dept_name));
cmd.Parameters.Add(new OleDbParameter("@ salary"，薪水));
cmd.Parameters.Add(new OleDbParameter("@ sort"，sort));

int i = cmd.ExecuteNonQuery();

如果(i< = 0)
b =假；
其他
b = true;
conn.Close();
返回b;


然后在按钮中单击

 私有 无效 button2_Click(对象发​​件人，EventArgs e)
       {

           如果(WorkersMgr.AddWorkers(textBox1.Text.Trim()，
               textBox2.Text，
               textBox3.Text，
               textBox4.Text))
           {
           }
           其他
           {

           }
       } 

如何在datagridview中放入新行
我想提供完整的代码

解决方案

请参见此处的示例:
http://stackoverflow.com/questions/5699423/adding-row- by-row-in-gridview-in-runtime [ ^ ]

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

解决方案

See example is given over here:
http://stackoverflow.com/questions/5699423/adding-row-by-row-in-gridview-in-runtime[^]

这篇关于在C#中的gridview中插入行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！