using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
{
if (conn.State == ConnectionState.Closed) conn.Open(); SqlDataAdapter oleda = new SqlDataAdapter("telephoneCheck", conn);
SqlParameter spt = new SqlParameter("@telepHoneNumber", SqlDbType.VarChar, 50);
spt.Direction = ParameterDirection.Input;
spt.Value = telepHoneNumber;
oleda.SelectCommand.Parameters.Add(spt);
DataTable dt = new DataTable();
oleda.Fill(dt);
if (dt.Rows.Count < 1)
{
conn.Close();
return false;
}
conn.Close();
return true;
}
CREATE PROCEDURE telephoneCheck
@telepHoneNumber varchar(50)
AS
select city,cardtype from list2 where num=@telepHoneNumber;
GO那里出错了!!为什么提示附近有语法错误啊!!!如果不用存储过程就可以啊!!
{
if (conn.State == ConnectionState.Closed) conn.Open(); SqlDataAdapter oleda = new SqlDataAdapter("telephoneCheck", conn);
SqlParameter spt = new SqlParameter("@telepHoneNumber", SqlDbType.VarChar, 50);
spt.Direction = ParameterDirection.Input;
spt.Value = telepHoneNumber;
oleda.SelectCommand.Parameters.Add(spt);
DataTable dt = new DataTable();
oleda.Fill(dt);
if (dt.Rows.Count < 1)
{
conn.Close();
return false;
}
conn.Close();
return true;
}
CREATE PROCEDURE telephoneCheck
@telepHoneNumber varchar(50)
AS
select city,cardtype from list2 where num=@telepHoneNumber;
GO那里出错了!!为什么提示附近有语法错误啊!!!如果不用存储过程就可以啊!!
加上试一下