UC知道C#&.NET在线等您的解答
来源：百度知道 编辑：UC知道 时间：2024/05/30 05:01:43
public partial class teacherlist : System.Web.UI.Page
{
SqlConnection sms_conn;
string sms_sqlstr;
protected void Page_Load(object sender, EventArgs e)
{
string sms_connstr = System.Configuration.ConfigurationManager.AppSettings["sms_dbconn"];
sms_conn = new SqlConnection(sms_connstr);
if (!IsPostBack)
SMS_BindGrid();
}
public void SMS_BindGrid()
{
tbteacherid.Text = Request.QueryString["teacherid"];
sms_sqlstr = "select * from Teacher ,Department where teacherID='" + tbteacherid.Text + " 'and Teacher.DepartmentID = Department.DepartmentID";
sms_conn.Open();
SqlDataAdapter sms_da = new SqlDataAdapter(sms_sqlstr, sms_conn);
DataSet sms_ds = new DataSet();
sms_da.Fill(sms_ds, "Teacher");
rbl1.SelectedValue
{
SqlConnection sms_conn;
string sms_sqlstr;
protected void Page_Load(object sender, EventArgs e)
{
string sms_connstr = System.Configuration.ConfigurationManager.AppSettings["sms_dbconn"];
sms_conn = new SqlConnection(sms_connstr);
if (!IsPostBack)
SMS_BindGrid();
}
public void SMS_BindGrid()
{
tbteacherid.Text = Request.QueryString["teacherid"];
sms_sqlstr = "select * from Teacher ,Department where teacherID='" + tbteacherid.Text + " 'and Teacher.DepartmentID = Department.DepartmentID";
sms_conn.Open();
SqlDataAdapter sms_da = new SqlDataAdapter(sms_sqlstr, sms_conn);
DataSet sms_ds = new DataSet();
sms_da.Fill(sms_ds, "Teacher");
rbl1.SelectedValue
追踪此句
SqlDataAdapter sms_da = new SqlDataAdapter(sms_sqlstr, sms_conn);
查看运行到此处时,sms_sqlstr, sms_conn是否为理想值,并查看
DataSet sms_ds = new DataSet()中sms_ds是否有数据
看不出来~~~
单从你贴出来的代码看~~
除了最后少了半个大括号以外没什么问题~~
将你的查询语句sms_sqlstr复制到数据库查询里面看看能否有数据返回！～
应该是sql语句的问题，看看是不是这个语句搜不到数据啊，所以那个sms_ds没有任何行，推荐用LINQ，她的智能感知能很方便的帮你拒绝错误
SQL语句有问题，你在SQL SERVER 上运行看看。好像是空格问题。
你要实在搞不出来就设置一个断点然后按F10逐步运行撒