sos-数据库的问题(给分)
//为什么插入不进去,应该没有问题的???????
[WebMethod]
public int InsertCustomer(string customerName,string customerAdd,string mailID,int classID,string xuqiou,string fadinren,string weituoren,string telephone,string chuanzhen,string bank,string zhanghao,string suihao,string addressID )
{
int retNum=0;
string insertText ="(" +customerName+","+customerAdd+","+mailID+","+classID+","+xuqiou+","+fadinren+","+weituoren+","+telephone+","+chuanzhen+","+bank+","+zhanghao+","+suihao+","+addressID+")";
string sqlInsertCustomer ="INSERT INTO 客户表 (客户名称,地址,邮编,工号,需求,法定人,委托人,电话,传真,银行,帐号,税号,地区ID) VALUES"+insertText;
try
{
dataSet11.AcceptChanges();
sqlConnection2.Open();
//插入客户语句
//sqlInsertCommand2 = new SqlCommand(sqlInsertCustomer,sqlConnection2);
//retNum =sqlInsertCommand2.ExecuteNonQuery();
sqlDataAdapter2.InsertCommand.CommandText=sqlInsertCustomer;
sqlInsertCommand2.ExecuteNonQuery();
//return retNum;
dataSet11.Clear();
}
catch
{
}
finally
{
sqlConnection2.Close();
}
return retNum;
}
[WebMethod]
public int InsertCustomer(string customerName,string customerAdd,string mailID,int classID,string xuqiou,string fadinren,string weituoren,string telephone,string chuanzhen,string bank,string zhanghao,string suihao,string addressID )
{
int retNum=0;
string insertText ="(" +customerName+","+customerAdd+","+mailID+","+classID+","+xuqiou+","+fadinren+","+weituoren+","+telephone+","+chuanzhen+","+bank+","+zhanghao+","+suihao+","+addressID+")";
string sqlInsertCustomer ="INSERT INTO 客户表 (客户名称,地址,邮编,工号,需求,法定人,委托人,电话,传真,银行,帐号,税号,地区ID) VALUES"+insertText;
try
{
dataSet11.AcceptChanges();
sqlConnection2.Open();
//插入客户语句
//sqlInsertCommand2 = new SqlCommand(sqlInsertCustomer,sqlConnection2);
//retNum =sqlInsertCommand2.ExecuteNonQuery();
sqlDataAdapter2.InsertCommand.CommandText=sqlInsertCustomer;
sqlInsertCommand2.ExecuteNonQuery();
//return retNum;
dataSet11.Clear();
}
catch
{
}
finally
{
sqlConnection2.Close();
}
return retNum;
}
...全文
相关推荐
Wcf生成客户端服务文件svcutil.exe
Wcf生成客户端服务文件svcutil.exe,找不到的可直接下载使用。使用说明百度下svcutil.exe就有了
利用SOS扩展库进入高阶.NET6程序的调试
????欢迎点赞 :???? 收藏 ⭐留言 ???? 如有错误敬请指正,赐人玫瑰,手留余香! ????本文作者:由webmote 原创,首发于 【掘金】 ????作者格言: 生活在于折腾,当你不折腾生活时,生活就开始折腾你,让我们一起加油!???????????? 有时候我们可能想深入到程序的运行核心,去观察下内存分配情况以及堆栈内保存的东东,那么作为编程新贵的底层框架.NET6,又为我们提供了什么可用的观测工具呢? 1.SOS 扩展是什么? SOS扩展库是Windows 附带的调试扩展库,它允许开
Svcutil.exe
ServiceModel Metadata Utility Tool (Svcutil.exe)访问Service的Metadata Endpoint来生成我们的客户段代码
客户端使用SVCUTIL.EXE调用WCF示例
客户端使用SVCUTIL.EXE调用WCF示例 生成的配置文件相对简洁
WCF客户端实例
摘自http://blog.sina.com.cn/s/blog_586b6c050100c6pw.html


