求救!!!!!!!!!!!!!!!!!!!!!!!
wnc 2002-05-26 03:11:59 string source="server=(local);"+"Trusted_Connection=yes;"+"database=jcx";
SqlConnection conn=new SqlConnection(source);
conn.Open();
String SelectCmdString = "select * from 库存单";
SqlDataAdapter kuCunDanSqlDataAdapter = new SqlDataAdapter(SelectCmdString, conn);
DataSet jcxDataSet=new DataSet();
SqlCommandBuilder kuCunDanSqlCommandBuilder=new SqlCommandBuilder(kuCunDanSqlDataAdapter);
kuCunDanSqlDataAdapter.MissingSchemaAction=MissingSchemaAction.AddWithKey;
try
{
kuCunDanSqlDataAdapter.Fill(jcxDataSet,"库存单");
}
catch(Exception e2)
{
string MsgString=e2.ToString();
MessageBox.Show(MsgString);
}
finally
{
conn.Close();
}
DataRow kuCunDanDataRow = jcxDataSet.Tables["库存单"].NewRow();
kuCunDanDataRow["库存编号"] =this.textBox2.Text;
kuCunDanDataRow["名称"] = this.textBox3.Text;
kuCunDanDataRow["规格"] = this.textBox4.Text;
kuCunDanDataRow["型号"]=this.textBox5.Text;
kuCunDanDataRow["数量"]=this.textBox6.Text;
kuCunDanDataRow["备注"]=this.textBox7.Text;
kuCunDanDataRow["价格"]=this.textBox8.Text;
kuCunDanDataRow["计量单位"]=this.comboBox1.Text;
jcxDataSet.Tables["库存单"].Rows.Add(kuCunDanDataRow);
MessageBox.Show("一个材料已经添加!");
conn.Close();
}
}
编译没有任何错误,但是就是不能添加到sql server中库存单中
救命啊,老师要东西了!!!!!!!!