如何将oledbcommad参数列表传递给函数 [英] How to pass oledbcommad parameter list to a function

问题描述

<嗨朋友们，



我需要一点帮助。我编写了一个将值插入DB的函数。功能如下：

<Hi Friends,

I need a small help. I have written a function to insert values into DB. Function is given Below

public bool insertfamily(OleDbCommand cmd)
       {
           if (conn.State == ConnectionState.Closed)
           { conn.Open(); }
           string strqry = "INSERT INTO Family(Hno,Hname,Landphone,FullName,Mobile,DOB,Status,Gender)" +                          " Values(@HNO,@Hname,@Landphone,@Name,@Mobile,@Dob,@Status,@Gender)";
           cmd = new OleDbCommand(strqry, conn);
           var resultSet = cmd.ExecuteNonQuery();
           if (resultSet.Equals(0))
           {
               MessageBox.Show("Records not inserted.please check", "My Application");
               return false;
           }
           return true;
       }

我的要求是将参数列表传递给函数

My Requirement is to pass the parameter list to the function

databaseclass dc = new databaseclass();
               OleDbCommand cmd = new OleDbCommand();
               cmd.Parameters.AddWithValue("HNO", txthouseno.Text);
               cmd.Parameters.AddWithValue("Hname", txtHouseName.Text);
               cmd.Parameters.AddWithValue("Landphone", txtland.Text);
               cmd.Parameters.AddWithValue("Name", txtname.Text);
               cmd.Parameters.AddWithValue("Mobile", txtmobile.Text);
               cmd.Parameters.AddWithValue("Dob", mtxtdob.Text);
               cmd.Parameters.AddWithValue("Status", cmbstatus.Text);
               cmd.Parameters.AddWithValue("Gender", cmbgender.Text);
               dc.insertfamily(cmd);

我怎样才能做到这一点？什么是最好的方法？

How can i achieve this? What is the best Method?

推荐答案

更改

Change

cmd.Parameters.AddWithValue("HNO", txthouseno.Text);

到

to

cmd.Parameters.AddWithValue("@HNO", txthouseno.Text);

等......



它应该像以下一样工作你已经完成了。



[更新]

and so on...

It should work as you have done it.

[UPDATE]

public bool insertfamily(OleDbCommand cmd)
{
    if (conn.State == ConnectionState.Closed)
    { conn.Open(); }
    string strqry = "INSERT INTO Family(Hno,Hname,Landphone,FullName,Mobile,DOB,Status,Gender)" +                          " Values(@HNO,@Hname,@Landphone,@Name,@Mobile,@Dob,@Status,@Gender)";
    cmd = new OleDbCommand(strqry, conn);
    cmd.Connection = conn;
    cmd.CommandText = strqry;
    cmd.CommandType = CommandType.Text;  // Default
    var resultSet = cmd.ExecuteNonQuery();
    if (resultSet.Equals(0))
    {
        MessageBox.Show("Records not inserted.please check", "My Application");
        return false;
    }
    return true;
}

;

创建接受参数列表的方法，然后在调用该方法时可以发送参数列表。例如

create method to accept list of parameters and then you can send the parameter list when you calling that method. for example

public static int ExecuteSqlStatement(string sqlStr, List<OleDbParameter> parameters)
{
            using(OleDbConnection conn = new OleDbConnection(connectionString))
	    using(OleDbCommand cmd = new OleDbCommand(sqlStr, conn))
            {
              if (parameters!= null)
              {
                  foreach (OleDbParameter parm in parameters)
                  {
                      cmd.Parameters.Add(parm);
                  }
              }
              con.Open();
	      return cmd.ExecuteNonQuery();
            }
}

这篇关于如何将oledbcommad参数列表传递给函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！