数据适配器不返回值,也不返回异常
本文关键字:返回 异常 返回值 适配器 数据 | 更新日期: 2023-09-27 18:04:54
我从早上就被卡住了,有人能帮我吗我有一个SQL数据适配器,它不返回任何值。在顶部的同一页面中,我有一个工作良好的sqldataadapter。我不知道该怎么办。该查询在服务器中运行良好。我使用的是vs10和sqlserver 2008 ..
我也试过通过删除参数,它仍然不工作'。rowcount总是0
这是我的代码
doc = dr["DrName"].ToString();
sql1 = "select w.Day, w.Start,[End] from WeeklyScheduleDays w where w.Start is not null and w.Day = @day1 and WeeklyScheduleID = (select WeeklyScheduleID from DoctorsBusinessHours db inner join drmast m on m.DoctorId = db.DcotorID where m.DrName = '@drname2') order by Start ";
SqlCommand m1 = new SqlCommand(sql1,myConnection);
m1.Parameters.AddWithValue("@day1", i);
m1.Parameters.AddWithValue("@drname2", doc);
SqlDataAdapter ad = new SqlDataAdapter(m1);
DataTable t1 = new DataTable();
ad.Fill(t1);
rowcount = t1.Rows.Count;
Thanks in advance
将where m.DrName = '@drname2'
替换为where m.DrName = @drname2