本文介绍了如何将oledbcommad参数列表传递给函数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<嗨朋友们,
我需要一点帮助。我编写了一个将值插入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?
推荐答案
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.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;
}
;
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参数列表传递给函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!