110,539
社区成员
发帖
与我相关
我的任务
分享
select * from Savemodelone
改成select 生产数量,重量,体积,机械重量,PLTFM,电子复杂度,HSINT,机械复杂度,估算成本 from Savemodelone
public DataSet Insert_Sdp()
{
SqlConnection con = new SqlConnection(Configuration.Conn);
SqlDataAdapter sdp = new SqlDataAdapter();
DataSet dt = new DataSet();
SqlCommand comm = new SqlCommand();
comm.Connection = con;
comm.CommandText = "select Names,Address,Pid,Image from Users";
sdp.SelectCommand = comm;//首先要指定selectitem,并且字段要制定清楚,和insert字段个数和名称一直
SqlCommandBuilder scom = new SqlCommandBuilder(sdp);
sdp.Fill(dt, "Users");
comm.CommandText = "Insert into Users values(@Pid,@Names,@Address,@Image)";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@Pid",SqlDbType.Int,4,"Pid")
,new SqlParameter("@Names",SqlDbType.VarChar,10,"Names")
,new SqlParameter("@Address",SqlDbType.NVarChar,20,"Address")
,new SqlParameter("@Image",SqlDbType.Image,200,"Image")
};
foreach (SqlParameter par in pars)
{
comm.Parameters.Add(par);
}//update不用给parameters赋值
DataRow dr = null;
for (int i = 7; i < 10; i++)
{
dr = dt.Tables[0].NewRow();
dr["Names"] = "Jeep" + i.ToString();
dr["Address"] = "第" + i.ToString() + "街道";
dr["Pid"] = i+8;
dt.Tables[0].Rows.Add(dr);
}//通过对表值的修改,实现方法Update(table)
SqlCommandBuilder icom = new SqlCommandBuilder(sdp);
sdp.InsertCommand = comm;//insert com语句
sdp.Update(dt.Tables["Users"]);
dt.AcceptChanges();
return dt;
}
public void MyMethod()
{
try
{
string connstr = @"Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source=Savemodelone.mdb";
OleDbConnection conn = new OleDbConnection(connstr);
OleDbCommand Selectcom=new OleDbCommand();
Selectcom.CommandText=(@"select * from Savemodelone");
Selectcom.Connection=conn;
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand=Selectcom;
OleDbCommandBuilder sbuilder = new OleDbCommandBuilder(da);
DataSet dt=new DataSet("Savemodelone");
da.Fill(dt,"Savemodelone");
DataTable ds = dt.Tables["savemodelone"];
DataRow dm = ds.NewRow();
dm["生产数量"] = 1;
dm["重量"] = 1;
dm["体积"] = 1;
dm["机械重量"] = 1;
dm["PLTFM"] = 1;
dm["电子复杂度"] = 1;
dm["HSINT"] = 1;
dm["机械复杂度"] = 1;
dm["估算成本"] = 8;
ds.Rows.Add(dm);
string Insert = @"insert into Savemodelone(生产数量,重量,体积,机械重量,PLTFM,电子复杂度,HSINT,机械复杂度,估算成本)values(@生产数量,@重量,@体积,@机械重量,@PLTFM,@电子复杂度,@HSINT,@机械复杂度,@估算成本)";
OleDbCommand insert = new OleDbCommand(Insert, conn);
insert.Parameters.Add("@生产数量", OleDbType.VarChar, 10, "生产数量");
insert.Parameters.Add("@重量", OleDbType.VarChar, 10, "重量");
insert.Parameters.Add("@体积", OleDbType.VarChar, 10, "体积");
insert.Parameters.Add("@机械重量", OleDbType.VarChar, 10, "机械重量");
insert.Parameters.Add("@PLTFM", OleDbType.VarChar, 10, "PLTFM");
insert.Parameters.Add("@电子复杂度", OleDbType.VarChar, 10, "电子复杂度");
insert.Parameters.Add("@HSINT", OleDbType.VarChar, 10, "HSINT");
insert.Parameters.Add("@机械复杂度", OleDbType.VarChar, 10, "机械复杂度");
insert.Parameters.Add("@估算成本", OleDbType.VarChar, 10, "估算成本");
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
da.InsertCommand = insert;
da.Update(dt,"Savemodelone");
Console.WriteLine("连接成功");
...............
public void MyMethod()
{
try
{
string connstr = @"Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source=Savemodelone.mdb";
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommand comquery= new OleDbCommand(@"select 生产数量,重量,体积,机械重量,PLTFM,电子复杂度,HSINT,机械复杂度,估算成本 from Savemodelone", connstr);//这里的列要和插入的列一一对应
da.SelectCommand=comquery;
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
DataSet dt=new DataSet("Savemodelone");
da.Fill(dt,"Savemodelone");
DataTable ds = dt.Tables["savemodelone"];
DataRow dm = ds.NewRow();
dm["生产数量"] = 1;
dm["重量"] = 1;
dm["体积"] = 1;
dm["机械重量"] = 1;
dm["PLTFM"] = 1;
dm["电子复杂度"] = 1;
dm["HSINT"] = 1;
dm["机械复杂度"] = 1;
dm["估算成本"] = 8;
ds.Rows.Add(dm);
string Insert = @"insert into Savemodelone(生产数量,重量,体积,机械重量,PLTFM,电子复杂度,HSINT,机械复杂度,估算成本)values(@生产数量,@重量,@体积,@机械重量,@PLTFM,@电子复杂度,@HSINT,@机械复杂度,@估算成本)";
OleDbCommand insert = new OleDbCommand(Insert, conn);
insert.Parameters.Add("@生产数量", OleDbType.VarChar, 10, "生产数量");
insert.Parameters.Add("@重量", OleDbType.VarChar, 10, "重量");
insert.Parameters.Add("@体积", OleDbType.VarChar, 10, "体积");
insert.Parameters.Add("@机械重量", OleDbType.VarChar, 10, "机械重量");
insert.Parameters.Add("@PLTFM", OleDbType.VarChar, 10, "PLTFM");
insert.Parameters.Add("@电子复杂度", OleDbType.VarChar, 10, "电子复杂度");
insert.Parameters.Add("@HSINT", OleDbType.VarChar, 10, "HSINT");
insert.Parameters.Add("@机械复杂度", OleDbType.VarChar, 10, "机械复杂度");
insert.Parameters.Add("@估算成本", OleDbType.VarChar, 10, "估算成本");
da.InsertCommand = insert;
SqlCommandBuilder scom = new SqlCommandBuilder(da);
da.Update(dt,"Savemodelone");
Console.WriteLine("连接成功");
OleDbCommand comm= new OleDbCommand("select * from Savemodelone",conn);
conn.Open();
OleDbDataReader dr = comm.ExecuteReader();
}
insert.Parameters.Add("@生产数量", OleDbType.VarChar, 10, "生产数量");
insert.Parameters.Add("@重量", OleDbType.VarChar, 10, "重量");
insert.Parameters.Add("@体积", OleDbType.VarChar, 10, "体积");
insert.Parameters.Add("@机械重量", OleDbType.VarChar, 10, "机械重量");
insert.Parameters.Add("@PLTFM", OleDbType.VarChar, 10, "PLTFM");
insert.Parameters.Add("@电子复杂度", OleDbType.VarChar, 10, "电子复杂度");
insert.Parameters.Add("@HSINT", OleDbType.VarChar, 10, "HSINT");
insert.Parameters.Add("@机械复杂度", OleDbType.VarChar, 10, "机械复杂度");
insert.Parameters.Add("@估算成本", OleDbType.VarChar, 10, "估算成本");
你参考下我写的。 SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@Pid",SqlDbType.Int,4,"Pid")
,new SqlParameter("@Names",SqlDbType.VarChar,10,"Names")
,new SqlParameter("@Address",SqlDbType.NVarChar,20,"Address")
};
pars[0].Value = names;
pars[1].Value = address;
pars[2].Value = pid;
foreach (SqlParameter par in pars)
{
insert.Parameters.Add(par);
}
sdp.InsertCommand = comm;
SqlCommandBuilder scom = new SqlCommandBuilder(sdp);//这句话是必要的