c# - Dataadaptor 不返回任何值，也没有异常

Question

我从早上就被困住了，有人能帮帮我吗我有一个不返回任何值的 sql 数据适配器。在顶部的同一页中，我有一个工作正常的 SQldataadaptor。我不知道该怎么办 。查询在服务器中运行良好。我正在使用 vs10 和 sqlserver 2008 ..

我也试过删除它仍然不起作用的参数'。我的行数始终为零

这是我的代码

       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;

提前致谢

Answer 1

将 where m.DrName = '@drname2' 替换为 where m.DrName = @drname2