[CODE]
using (SqlConnection connection =
new SqlConnection((@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog=student"))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select * from 档案 where 学号='"+this.textBox1.Text+"' and 姓名='"+this.textBox2.Text+"'", connection);
DataTable dt=new DataTable();
da.Fill(dt);
this.dataGrid1.DataSource=dt;
this.dataGrid1.DataBind();
}

[/CODE]

Fill的不是数据库吧? 就只是一个datatable

string con="uid=sa;pwd=;database=power;server=127.0.0.1";
连接字符串这个样写就足够拉... 最起码winform是够了

看不懂，怎么放啊

SqlConnection con=new SqlConnection("uid=sa;pwd=;database=power;server=127.0.0.1");

SqlConnection thisConnection=new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog=student");


他用的集成驗證

你初始化的是cmd 調用的cmd2 當然錯

private void button1_Click(object sender, System.EventArgs e)
{
SqlConnection thisConnection=new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog=student");
thisConnection.Open();
SqlCommand cmd=new SqlCommand("select * from 档案 where 学号='"+this.textBox1.Text+"' and 姓名='"+this.textBox2.Text+"'",thisConnection);
SqlConnection con=new SqlConnection();
SqlCommand cmd2=new SqlCommand();
cmd2.Connection=con;
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=cmd;
DataTable dt=new DataTable();
da.Fill(dt);
this.dataGrid1.DataSource=dt;
}

我这样编译成功，但是还是按查询后还是没有在DataGrid里面出现数据

SqlCommand cmd=new SqlCommand("select * from 档案 where 学号='"+this.textBox1.Text+"' and 姓名='"+this.textBox2.Text+"'",thisConnection);

SqlCommand cmd2=new SqlCommand();
你用的第2个 是空的 怎么会出现数据呢?


private void button1_Click(object sender, System.EventArgs e)
{
SqlConnection thisConnection=new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog=student");
thisConnection.Open();
SqlCommand cmd2=new SqlCommand("select * from 档案 where 学号='"+this.textBox1.Text+"' and 姓名='"+this.textBox2.Text+"'",thisConnection);
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=cmd;
DataTable dt=new DataTable();
da.Fill(dt);
this.dataGrid1.DataSource=dt;
}

这个样就没问题了

private void button1_Click(object sender, System.EventArgs e)
{
SqlConnection thisConnection=new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog=student");
thisConnection.Open();
SqlCommand cmd2=new SqlCommand("select * from 档案 where 学号='"+this.textBox1.Text+"' and 姓名='"+this.textBox2.Text+"'",thisConnection);
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=cmd;
DataTable dt=new DataTable();
da.Fill(dt);
this.dataGrid1.DataSource=dt;
}

提示 名称“cmd”在类或命名空间“学生管理系统.Main”中不存在


象你这样写，红色地方还是出问题，是不是我哪里设置有问题啊