datagrid最开始加载进去的是一张医生信息表 MIS_Doctor 的全部信息

dname = this.txtname.text; //获得界面输入的医生姓名

///开始 查询
...conn.open();

string selectcmd = SELECT * FROM MIS_Doctor where DoctorName = ' " + dname + " '; //SQL语句

SqlCommand sc2 = new SqlCommand(selectcmd,conn); //

现在我不知道怎么把查询到的结果通过datagrid显示出来


==============================================================
加载datagrid的代码是

connstr =
"Server=LENOVO-8AD35F65;database=ZXMR;uid = sa;pwd = sa;";
selectcmd = "SELECT * FROM MIS_Patient ORDER BY PatientID DESC";
SqlConnection conn;
SqlDataAdapter myadapter;
DataSet mydataset = new DataSet();
conn = new SqlConnection(connstr);
myadapter = new SqlDataAdapter(selectcmd,conn);
myadapter.Fill(mydataset,"MIS_Patient");
dataGrid1.DataSource = mydataset.Tables["MIS_Patient"];

我的意思是把查询结果在datagrid中显示出来

我还有有点不怎么懂，才学一个月的。net

恩

正在弄

谢谢楼上的指点迷津了

还没有解决

我查询结果没有出来 datagrid上面没有任何显示

string connstr,selectcmd;
connstr = "Server=LENOVO-8AD35F65;database=ZXMR;uid = sa;pwd = sa;";

SqlConnection conn = new SqlConnection(connstr);
conn.Open();

selectcmd = "SELECT * FROM MIS_Doctor where DoctorName = '" + dname + "'";

SqlDataAdapter myadapter = new SqlDataAdapter(selectcmd,conn);
DataSet mydataset = new DataSet();

myadapter.Fill(mydataset,"MIS_Doctor");

dataGrid1.DataSource = mydataset;
conn.Close();

没有的啊

MIS_Doctor表里面有DoctorName，DoctorID等列

最开始进入界面加载MIS_Doctor表的代码是

string connstr,selectcmd;
connstr =
"Server=LENOVO-8AD35F65;database=ZXMR;uid = sa;pwd = sa;";
selectcmd = "SELECT * FROM MIS_Doctor ORDER BY DoctorID DESC";
SqlConnection conn;
SqlDataAdapter myadapter;
DataSet mydataset = new DataSet();
conn = new SqlConnection(connstr);
myadapter = new SqlDataAdapter(selectcmd,conn);
myadapter.Fill(mydataset,"MIS_Doctor");
dataGrid1.DataSource = mydataset.Tables["MIS_Doctor"];

private void show()
{
string connstr,selectcmd;
connstr =
"Server=LENOVO-8AD35F65;database=ZXMR;uid = sa;pwd = sa;";
selectcmd = "SELECT * FROM MIS_Doctor ORDER BY DoctorID DESC";
SqlConnection conn;
SqlDataAdapter myadapter;
DataSet mydataset = new DataSet();
conn = new SqlConnection(connstr);
myadapter = new SqlDataAdapter(selectcmd,conn);
myadapter.Fill(mydataset,"MIS_Doctor");
dataGrid1.DataSource = mydataset.Tables["MIS_Doctor"];

}

private void DBasicMessage_Load(object sender, System.EventArgs e)
{
show();
}

private void btnbs_Click(object sender, System.EventArgs e)
{
string dname,dzhicheng,dlevel;
dname = this.textBox1.Text;
dzhicheng = this.textBox2.Text;
dlevel = this.textBox3.Text;

string connstr,selectcmd;
connstr = "Server=LENOVO-8AD35F65;database=ZXMR;uid = sa;pwd = sa;";

SqlConnection conn = new SqlConnection(connstr);
conn.Open();

selectcmd = "SELECT * FROM MIS_Doctor where DoctorName = '" + dname + "'";

SqlDataAdapter myadapter = new SqlDataAdapter(selectcmd,conn);

DataSet mydataset = new DataSet();

myadapter.Fill(mydataset);

dataGrid1.DataSource = mydataset;
conn.Close();

结果出来了 还是有点小问题

朋友加我QQ 125284853谈论

[此贴子已经被作者于2006-11-13 14:13:04编辑过]