62,074
社区成员
发帖
与我相关
我的任务
分享
//根据自己的情况改哟,我象征性的定义三个属性.
public class AddNewRecord
{
private string _FieldOne;
private string _FieldTwo;
private string _FieldThree;
public int FieldOne
{
get { return _FieldOne; }
set { _FieldOne = value; }
}
public int FieldTwo
{
get { return _FieldTwo; }
set { _FieldTwo = value; }
}
public int FieldThree
{
get { return _FieldThree; }
set { _FieldThree = value; }
}
public AddNewRecord()
{
}
public AddNewRecord(string FieldTwo, string FieldTwo, string FieldThree)
{
_FieldTwo = FieldTwo;
_FieldTwo = FieldTwo;
_FieldThree = FieldThree;
}
public int AddNew()
{
string sql = "INSERT INTO Columns (字段一, 字段二, 字段N) VALUES (@字段一, @字段二, @字段N)"; //这里的字段均为假设;
using (SqlConnection conn = new SqlConnection("用于连接数据的字符串"))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.Parameters.Add("@字段一", SqlDbType.VarChar);
cmd.Parameters.Add("@字段二", SqlDbType.VarChar);
cmd.Parameters.Add("@字段N", SqlDbType.VarChar);
cmd.Parameters["@字段一"].Value = this.FieldOne;
cmd.Parameters["@字段二"].Value = this.FieldTwo;
cmd.Parameters["@字段N"].Value = this.FieldThree;
//return FS_cmd.ExecuteNonQuery();这里错了,以前写的代码,忘改了
return cmd.ExecuteNonQuery();
}
}
}
//根据自己的情况改哟,我象征性的定义三个属性.
public class AddNewRecord
{
private string _FieldOne;
private string _FieldTwo;
private string _FieldThree;
public int FieldOne
{
get { return _FieldOne; }
set { _FieldOne = value; }
}
public int FieldTwo
{
get { return _FieldTwo; }
set { _FieldTwo = value; }
}
public int FieldThree
{
get { return _FieldThree; }
set { _FieldThree = value; }
}
public AddNewRecord()
{
}
public AddNewRecord(string FieldTwo, string FieldTwo, string FieldThree)
{
_FieldTwo = FieldTwo;
_FieldTwo = FieldTwo;
_FieldThree = FieldThree;
}
public int AddNew()
{
string sql = "INSERT INTO Columns (字段一, 字段二, 字段N) VALUES (@字段一, @字段二, @字段N)"; //这里的字段均为假设;
using (SqlConnection conn = new SqlConnection("用于连接数据的字符串"))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.Parameters.Add("@字段一", SqlDbType.VarChar);
cmd.Parameters.Add("@字段二", SqlDbType.VarChar);
cmd.Parameters.Add("@字段N", SqlDbType.VarChar);
cmd.Parameters["@字段一"].Value = this.FieldOne;
cmd.Parameters["@字段二"].Value = this.FieldTwo;
cmd.Parameters["@字段N"].Value = this.FieldThree;
return FS_cmd.ExecuteNonQuery();
}
}
}
DataTable TempDataTable = new DataTable();
//假设你已经向TempDataTable中加放数据
AddNewRecord add = new AddNewRecord();
for (int i = 0; i < TempDataTable.Rows.Count; i++)
{
add.FieldOne = TempDataTable.Rows[i]["字段一"].ToString();
add.FieldTwo = TempDataTable.Rows[i]["字段二"].ToString();
add.FieldThree = TempDataTable.Rows[i]["字段N"].ToString();
if (add.AddNew() > 0)
{
//成功增加一条
}
}