解决方案 »
- 求高人指点。磁盘文件权限问题
- MFC UDP 第一次sendto不成功,要关闭再次打开才成功
- AJAX Accordion +Repeater 绑数据
- 关于DataGrid的问题!!!急啊!
- 求.net下如何获得mssql2008自增列的预定值?
- ----------------100分的编程题(难度),给出思路和流程即可,马上给分------------------
- 在水晶报表里能画斜线吗?我画出来的都是水平或垂直的线,我想要45度的斜线.
- Oracle9i系列,那个版本可以用Ado.net连?
- 我的问题太有挑战性还是极其简单?
- arraylist怎么用啊
- IIS的web目录在哪里?怎么找啊?? 是在本机的!!
- 求助关于autocomplete时灵时不灵问题
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=sa;database=test");
conn.Open();
string sqlStr = "getlist";
SqlCommand comm = new SqlCommand(sqlStr, conn);
comm.CommandType = CommandType.StoredProcedure;
SqlParameter tableName = new SqlParameter("@Tables", SqlDbType.VarChar, 200);
tableName.Value = "mess";
comm.Parameters.Add(tableName);
using (SqlDataReader sqldatar = comm.ExecuteReader())
{
Response.Write(sqldatar.HasRows.ToString());
}那我这么做是不是不对呢?
conn.Open();
string sqlStr = "exec getlist"; SqlCommand comm = new SqlCommand(sqlStr, conn);
comm.CommandType = CommandType.StoredProcedure;
SqlParameter tableName = new SqlParameter("@Tables", SqlDbType.VarChar, 200);
tableName.Value = "mess";
comm.Parameters.Add(tableName);
using (SqlDataReader sqldatar = comm.ExecuteReader())
{
Response.Write(sqldatar.HasRows.ToString());
}
(1)执行一个没有参数的存储过程的代码如下: SqlConnection conn=new SqlConnection(“connectionString”);
SqlDataAdapter da = new SqlDataAdapter();
da.selectCommand = new SqlCommand();
da.selectCommand.Connection = conn;
da.selectCommand.CommandText = "NameOfProcedure";
da.selectCommand.CommandType = CommandType.StoredProcedure;
(2)执行一个有参数的存储过程的代码如下SqlConnection conn=new SqlConnection(“connectionString”);
SqlDataAdapter da = new SqlDataAdapter();
da.selectCommand = new SqlCommand();
da.selectCommand.Connection = conn;
da.selectCommand.CommandText = "NameOfProcedure";
da.selectCommand.CommandType = CommandType.StoredProcedure;
param = new SqlParameter("@ParameterName", SqlDbType.DateTime);
param.Direction = ParameterDirection.Input;
param.Value = Convert.ToDateTime(inputdate);
da.selectCommand.Parameters.Add(param);
若需要添加输出参数: param = new SqlParameter("@ParameterName", SqlDbType.DateTime);
param.Direction = ParameterDirection.Output;
param.Value = Convert.ToDateTime(inputdate);
da.selectCommand.Parameters.Add(param);
若要获得参储过程的返回值: param = new SqlParameter("@ParameterName", SqlDbType.DateTime);
param.Direction = ParameterDirection.ReturnValue;
param.Value = Convert.ToDateTime(inputdate);
da.selectCommand.Parameters.Add(param);
建议你学习哥的代码风格 protected bool IfCustomerVisitSuccess(string customerID,string taskID)
{
bool flag = false;
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["DVTeConnectionString"].ToString()))
{
string sql = " select count(*) from DC_VISITUSER where CUSTOMERID=" + customerID;
sql += " and TASKID=" + taskID;
sql += " and RESULT=1";
connection.Open();
OracleCommand command = connection.CreateCommand();
command.CommandText = sql; if (command.ExecuteOracleScalar() == null)
{
return flag;
}
if (int.Parse(command.ExecuteOracleScalar().ToString()) > 0)
{
flag = true;
}
}
return flag;
}
2.设置断点,看sql语句
3.在数据库了运行一下就知道有没有值了