sqlcmd.CommandText="[qqq]";
sqlcmd.CommandType=CommandType.StoredProcedure;
这样是调用存储过程,qqq是存储过程,如果qqq带有参数,应该怎么写?
sqlcmd.CommandType=CommandType.StoredProcedure;
这样是调用存储过程,qqq是存储过程,如果qqq带有参数,应该怎么写?
解决方案 »
- .master和.aspx和.ascx中pageload谁先加载的问题
- asp.net和sql2005怎么判断是否正常连接
- 如何将一个textbox(多行且带滚动条)中的数据打印、导出?
- 遇到个有难度的PlaceHolder生成控件和控件事件的问题,求助高手,帮顶有分!
- gridview显示数据的问题
- C#的一个查询语句 带变量的问题
- datagrid 我不想要显示它的headstyle行不行啊?怎么实现啊?
- 纯C#写的无级分类树,可以添加、删除、修改、移动、隐藏等功能。现完成了一部分,请大家提点意见,谢谢。
- web.config问题
- 关于多个radiobuttonlist的选择问题。
- 为什么我下载的源码的Tree不能显示出层次结构来??
- 问一个捕捉错误的问题
OleDbCommand1.CommandType = System.Data.CommandType.StoredProcedure;
OleDbCommand1.Parameters["au_id"].Value = listAuthorID.Text;
OleDbCommand1.Parameters["au_lname"].Value = txtAuthorLName.Text;
OleDbCommand1.Parameters["au_fname"].Value = txtAuthorFName.Text;
OleDbConnection1.Open();
OleDbCommand1.ExecuteNonQuery();
OleDbConnection1.Close();
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;namespace jsfw
{
/// <summary>
/// DataAccessBase 的摘要说明。
/// </summary>
public class DataAccessBase
{
public DataAccessBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public DataSet Runprocedure(string strConn,string strSpname,SqlParameter[] arrayParameters,string strTablename)
{
SqlConnection myconnection = new SqlConnection(strConn);
DataSet dsData = new DataSet();
SqlDataAdapter mycommand = new SqlDataAdapter(strSpname, myconnection);
mycommand.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter arrayParameter = new SqlParameter();
foreach(SqlParameter sq in arrayParameters)
{
mycommand.SelectCommand.Parameters.Add(sq);
}
mycommand.Fill(dsData, strTablename);
myconnection.Close();
return dsData; } public void Runprocedure(string strConn,string strSpname,SqlParameter[] arrayParameters)
{
SqlConnection myconnection = new SqlConnection(strConn);
myconnection.Open();
SqlCommand mycommand = new SqlCommand(strSpname, myconnection);
mycommand.CommandType = CommandType.StoredProcedure;
SqlParameter arrayParameter = new SqlParameter();
foreach(SqlParameter sq in arrayParameters)
{
mycommand.Parameters.Add(sq);
}
mycommand.ExecuteNonQuery();
myconnection.Close(); } public int Runprocedure(string strConn,string strSpname,SqlParameter[] arrayParameters,int nEffectedrows)
{
SqlConnection myconnection = new SqlConnection(strConn);
myconnection.Open();
SqlCommand mycommand = new SqlCommand(strSpname, myconnection);
mycommand.CommandType = CommandType.StoredProcedure;
SqlParameter arrayParameter = new SqlParameter();
foreach(SqlParameter sq in arrayParameters)
{
mycommand.Parameters.Add(sq);
}
nEffectedrows = mycommand.ExecuteNonQuery();
myconnection.Close();
return nEffectedrows;
} public DataSet Runprocedure(string strConn,string strSpname,string strTablename)
{
DataSet dsData = new DataSet();
SqlConnection myconnection = new SqlConnection(strConn);
myconnection.Open();
SqlDataAdapter mycommand = new SqlDataAdapter(strSpname, myconnection);
mycommand.SelectCommand.CommandType = CommandType.StoredProcedure;
mycommand.Fill(dsData,strTablename);
myconnection.Close();
return dsData; } public bool CheckEOF(DataSet dsData)
{
bool bReturn = false;
if(dsData != null)
{
if(dsData.Tables.Count > 0)
{
for(int i = 0 ; i < dsData.Tables.Count ; i++)
{
if(dsData.Tables[i].Rows.Count >0)
{
bReturn = true;
break;
}
}
}
}
return bReturn;
} }
}调用时:
public class clsAds:DataAccessBase
{ public string strConn = ConfigurationSettings.AppSetting["connString"].ToString();
public clsAds()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public DataSet GetAds(int nPositionID)
{
DataSet dsData = new DataSet();
SqlParameter[] sql = {new SqlParameter("@PositionID", SqlDbType.Int)};
sql[0].Value = nPositionID;
dsData = this.Runprocedure(strConn, "sp_GetAds", sql, "ads");
return dsData; }
}
parameterID.Value=Value;
myCommand.Parameters.Add(parameterID);
@zcID是存储过程里的变量Value是你输进去的值。
写到数据层
www.jyklzz.net/web/jyk/index.asp
应该是对的
好像是如此,方向向外的参数
我用的vb,所以只记得大致的了
SqlParameter[] parameters = { new SqlParameter("@StartRow",SqlDbType.Int), new SqlParameter("@StopRow",SqlDbType.Int), new SqlParameter("@AgentID",SqlDbType.Char,20)
}
parameters[0].Value = StartRow;
parameters[1].Value = StopRow;
parameters[2].Value = AgentID;dataset = new DataSet();
sqlcmd.CommandText="Your_Procedure";
sqlcmd.CommandType=CommandType.StoredProcedure;
SqlDataAdapter sqldapt = new SqlDataAdapter(sqlcmd);
sqldapt.Fill(dataset);
return dataset;
SqlParameter[] parameters = { new SqlParameter("@StartRow",SqlDbType.Int), new SqlParameter("@StopRow",SqlDbType.Int), new SqlParameter("@AgentID",SqlDbType.Char,20)
}
parameters[0].Value = StartRow;
parameters[1].Value = StopRow;
parameters[2].Value = AgentID;dataset = new DataSet();
sqlcmd.CommandText="Your_Procedure";
sqlcmd.CommandType=CommandType.StoredProcedure;
SqlDataAdapter sqldapt = new SqlDataAdapter(sqlcmd);
sqldapt.Fill(dataset);
return dataset;