1、SqlDataAdapter schedulereader = cmd.ExecuteReader();(错误说无法转换,为什么?)
2、SqlCommand cmd = new SqlCommand("insertnewschedule", myconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("ttitle", title);(错误说 "cmd.Parameters.Add("ttitle", title)"(格式过时,新的格式是什么?,其中ttitle为数据库过程中insertnewschedule的参数,title为类中定义的数据成员)
2、SqlCommand cmd = new SqlCommand("insertnewschedule", myconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("ttitle", title);(错误说 "cmd.Parameters.Add("ttitle", title)"(格式过时,新的格式是什么?,其中ttitle为数据库过程中insertnewschedule的参数,title为类中定义的数据成员)
第一个改成:SqlDataReader schedulereader = cmd.ExecuteReader();
SqlDataReader schedulereader = cmd.ExecuteReader()和
DateReader schedulereader = cmd.ExecuteReader()都不可以解决问题
这是在编译时第一个出现的问题
public bool getschedulebyid(ref SqlConnection myconn, int scheduleid)
{
SqlCommand cmd = new SqlCommand("getschedulebyid", myconn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add(scheduleid);
DataAdapter schedulereader = cmd.ExecuteReader();
要不试试SqlDataReader schedulereader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
SqlDataReader schedulereader = cmd.ExecuteReader();
DataAdapter schedulereader = cmd.ExecuteReader();改成:
SqlDataReader schedulereader = cmd.ExecuteReader();
显示(错误找不到类型或命名空间名称“sqlDataAdapter”(是否缺少 using 指令或程序集引用?))
显示(无法将类型“System.Data.SqlClient.SqlDataReader”隐式转换为“System.Data.SqlClient.SqlDataAdapter”)
{
SqlCommand cmd = new SqlCommand("getschedulebyid", myconn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add(scheduleid);
SqlDataAdapter schedulereader = cmd.ExecuteNonQuery();(错误点)
int tmptaskid =0;
string tmptitle = " ";
string tmpdetail=" ";
DateTime tmpbegintime=DateTime.Now;
DateTime tmpnotifytime=DateTime.Now;
int tmpneednotify=0;
int tmpfinished=0;
int tmptype=0;
int tmppriority=0;
try
{ }
catch
{ }
taskid = tmptaskid;
title = tmptitle;
detail = tmpdetail;
begintime = tmpbegintime;
notifytime = tmpnotifytime;
neednotify = tmpneednotify;
finished = tmpfinished;
type = tmptype;
priority = tmppriority;
return isvalidschedule();
}这是用c#写的一个人类里面的一个函数
这个返回的是整型吧
SqlCommand cmd = new SqlCommand("getschedulebyid", myconn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add(scheduleid);
SqlDataReader sqlrd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while(sqlrd.Read())
{
if(!sqlrd.IsDBNull(0)) taskid = Convert.ToInt32(sqlrd[0]);
//其他依次类推
//title = tmptitle;
//detail = tmpdetail;
//begintime = tmpbegintime;
//notifytime = tmpnotifytime;
//neednotify = tmpneednotify;
//finished = tmpfinished;
//type = tmptype;
//priority = tmppriority;
}
sqlrd.Close();
SqlDataReader schedulereader = cmd.ExecuteReader()
SqlDataAdapter schedulereader = cmd.ExecuteNonQuery()改成
SqlDataReader schedulereader = cmd.ExecuteReader() 还是不可以
这也是我刚看两天的书写的,确实有很多是乱写的 呵呵.....