读书人

dataset更新数据库该怎么解决

发布时间: 2011-12-28 22:45:21 作者: rapoo

dataset更新数据库,急~~~!
this.pub_CorpInfoTableAdapter.Fill(this.db_Mis_mhDataSet_Pub_CorpInfo.Pub_CorpInfo);//在load中填充数据集
DataRow NewCorpInfo = db_Mis_mhDataSet_Pub_CorpInfo.Pub_CorpInfo.NewRow();
NewCorpInfo[ "CorpName "] = this.tbxCorpName.Text;
NewCorpInfo[ "ECorpName "] = this.tbxECorpName.Text;
NewCorpInfo[ "PostalCode "] = this.tbxPostalCode.text;
this.pub_CorpInfoTableAdapter.Update(this.db_Mis_mhDataSet_Pub_CorpInfo.Pub_CorpInfo);//更新数据库

为什么更新不了!

另外数据库中PostalCode字段可以为空,但是如果tbxPostalCode的值不填,就出现异常提示“输入字符串的格式不正确。不能在 PostalCode 列中存储 <> 。所需类型是 Int32。”

急~!!!
在线等待!!!

[解决办法]
DataTable dt1 = new DataTable();

dt1.Columns.Add( "id ");
dt1.Columns.Add( "carId ");
dt1.Columns.Add( "picName ");
dt1.Columns.Add( "picSize ");
dt1.Columns.Add( "picMemo ");
dt1.Columns.Add( "CarNum ");
dt1.Columns.Add( "PgPrice ");

DataRow dr = dt1.NewRow();

dr[ "id "] = dr1[ "id "];
dr[ "carId "] = dr1[ "carId "];
dr[ "picName "] = dr1[ "picName "];
dr[ "picSize "] = dr1[ "picSize "];
dr[ "picMemo "] = dr1[ "picMemo "];
dr[ "CarNum "] = dr1[ "CarNum "];
dr[ "PgPrice "] = dr1[ "PgPrice "];

dt1.Rows.Add(dr);
[解决办法]
插入之前判断文本框的值,如果为空,则赋值System.DBNull.Value

读书人网 >.NET

热点推荐