估计是调用部分错了,给你看一段c#调用sqlserver的:
public DataTable FetchAllAssets()
{
string sproc = "fetch_all_assets";//存储过程名称
OleDbCommand oCommand = new OleDbCommand(sproc);
oCommand.CommandType = CommandType.StoredProcedure;
//如果有参数还得在此设置、赋值.....
DataSet oDataSet = new DataSet();
OleDbDataAdapter oData = new OleDbDataAdapter(oCommand);
DataSet oDataSet = new DataSet();
oData.Fill(oDataSet); DataTable oTable = oDataSet.Tables[0];
return oTable;
}
如下:public int InsertAsset(
string assetTitle,
string assetText,
int subjectID1,
int subjectID2,
int subjectID3,
int subjectID4,
int subjectID5)
{
string sproc = "insert_asset";
OleDbCommand oCommand = new OleDbCommand(sproc);
oCommand.CommandType = CommandType.StoredProcedure;
OleDbParameter p1 = new OleDbParameter("@title", OleDbType.VarChar, 100);
p1.Value = assetTitle;
oCommand.Parameters.Add(p1); OleDbParameter p2 = new OleDbParameter("@asset", OleDbType.Text);
p2.Value = assetText;
oCommand.Parameters.Add(p2);
OleDbParameter p3 = new OleDbParameter("@subject_id_1", OleDbType.Int, 4);
p3.Value = subjectID1;
oCommand.Parameters.Add(p3); OleDbParameter p4 = new OleDbParameter("@subject_id_2", OleDbType.Int, 4);
p4.Value = subjectID2;
oCommand.Parameters.Add(p4); OleDbParameter p5 = new OleDbParameter("@subject_id_3", OleDbType.Int, 4);
p5.Value = subjectID3;
oCommand.Parameters.Add(p5); OleDbParameter p6 = new OleDbParameter("@subject_id_4", OleDbType.Int, 4);
p6.Value = subjectID4;
oCommand.Parameters.Add(p6); OleDbParameter p7 = new OleDbParameter("@subject_id_5", OleDbType.Int, 4);
p7.Value = subjectID5;
oCommand.Parameters.Add(p7); oConnection.Open();
if (oConnection.State != ConnectionState.Open)
{
string msg = "Error: Could not open the database.";
Exception ConnectionFailure = new Exception(msg);
throw ConnectionFailure;
}
int affRows = oCommand.ExecuteNonQuery();
oConnection.Close();
return affRows;
}
public DataTable FetchAllAssets()
{
string sproc = "fetch_all_assets";//存储过程名称
OleDbCommand oCommand = new OleDbCommand(sproc);
oCommand.CommandType = CommandType.StoredProcedure;
//如果有参数还得在此设置、赋值.....
DataSet oDataSet = new DataSet();
OleDbDataAdapter oData = new OleDbDataAdapter(oCommand);
DataSet oDataSet = new DataSet();
oData.Fill(oDataSet); DataTable oTable = oDataSet.Tables[0];
return oTable;
}
如下:public int InsertAsset(
string assetTitle,
string assetText,
int subjectID1,
int subjectID2,
int subjectID3,
int subjectID4,
int subjectID5)
{
string sproc = "insert_asset";
OleDbCommand oCommand = new OleDbCommand(sproc);
oCommand.CommandType = CommandType.StoredProcedure;
OleDbParameter p1 = new OleDbParameter("@title", OleDbType.VarChar, 100);
p1.Value = assetTitle;
oCommand.Parameters.Add(p1); OleDbParameter p2 = new OleDbParameter("@asset", OleDbType.Text);
p2.Value = assetText;
oCommand.Parameters.Add(p2);
OleDbParameter p3 = new OleDbParameter("@subject_id_1", OleDbType.Int, 4);
p3.Value = subjectID1;
oCommand.Parameters.Add(p3); OleDbParameter p4 = new OleDbParameter("@subject_id_2", OleDbType.Int, 4);
p4.Value = subjectID2;
oCommand.Parameters.Add(p4); OleDbParameter p5 = new OleDbParameter("@subject_id_3", OleDbType.Int, 4);
p5.Value = subjectID3;
oCommand.Parameters.Add(p5); OleDbParameter p6 = new OleDbParameter("@subject_id_4", OleDbType.Int, 4);
p6.Value = subjectID4;
oCommand.Parameters.Add(p6); OleDbParameter p7 = new OleDbParameter("@subject_id_5", OleDbType.Int, 4);
p7.Value = subjectID5;
oCommand.Parameters.Add(p7); oConnection.Open();
if (oConnection.State != ConnectionState.Open)
{
string msg = "Error: Could not open the database.";
Exception ConnectionFailure = new Exception(msg);
throw ConnectionFailure;
}
int affRows = oCommand.ExecuteNonQuery();
oConnection.Close();
return affRows;
}
解决方案 »
- |zyciis| 如何将用户控件做成有DropdownList的子项功能,谢谢,照庖丁解牛做有示例代码
- 用asp.net调用excel模板把数据填充了但是打开的excel却是在服务器??
- 去什么样的公司可以更有效率的学习ASP.NET
- 跪求一个利用Global.asax定时执行函数的问题(涉及C#转换至Vb)
- 关于用代码实现ie8中更改网页在选项卡中显示的方式
- |M| 以前公司做的网站,出现Timeout expired错误,不解决不给我发工资 200分 超急要钱交房租了
- showModalDialog传参数问题
- 求如何在客户端实现限制上传文件的大小,不在WEB.CONFIG中,100分!
- 请高手指教===在公网上如何获取某一个固定IP局域网内有多少PC访问过网站,每台PC访问过多少次网页。===
- 关于父页和子页的一个小问题
- 请教各位:把DataGrid 的数据导入word中,怎样独立启动客户端的word程序???高分请教!
- TextBox内包含html元素时出错,提示检测到有潜在危险的 Request.Form 值,如何解决?
只对INSERT,DELETE,UPDATE有效
如果是验证身份的话,应该用ExecuteScalar()
conn.CursorLocation=3
即可