using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

private void Form1_Load(object sender, System.EventArgs e)
{
string Constr=@"server=local"+"uid=toby"+"database=student";
string SQL="SELECT*FROM table";
SqlConnection conn=new SqlConnection(Constr);
SqlDataAdpater da= new SqlDataAdapter(SQL,conn);
DataSet ds=new DataSet();
da.Fill(ds,"table");
textBox1.DataBindings.Add("Text",ds,"table.name");
textBox2.DataBindings.Add("Text",ds,"table.name");

}

请问下报错是什么问题~~~搞郁闷了
谢谢~~

系统报的是什么错误

C:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\WindowsApplication9\WindowsApplication9\Form1.cs(105): 找不到类型或命名空间名称“SqlDataAdpater”(是否缺少 using 指令或程序集引用？)
C:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\WindowsApplication9\WindowsApplication9\Form1.cs(107): 找不到类型或命名空间名称“da”(是否缺少 using 指令或程序集引用？)

哦 单词打错了.....但是还是报系统错误....


未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 system.data.dll 中。

其他信息: 系统错误。

没有open

private void Form1_Load(object sender, System.EventArgs e)
{
string Constr=@"server=local"+"Integrated Security = True"+"uid=toby"+"database=student";
string SQL="SELECT*FROM table";
SqlConnection conn=new SqlConnection(Constr);
conn.Open();
SqlDataAdapter da= new SqlDataAdapter(SQL,conn);
DataSet ds=new DataSet();
da.Fill(ds,"table");
textBox1.DataBindings.Add("Text",ds,"table.number");
textBox2.DataBindings.Add("Text",ds,"table.name");
conn.Close();
}
加了open也是一样的错......

这个就是把student数据库的table表中的number列第1个和name列第1个绑定到txtBox...怎么实现不了？

string Constr=@"server=local"+"uid=toby"+"database=student";
string SQL="SELECT*FROM table1";

--------------------------------------------------------------------------------
string Constr=@"server=(local);"+"uid=toby;"+"pwd=***;"+"database=student,";
string SQL="SELECT * FROM table1";

[此贴子已经被作者于2007-4-24 10:02:58编辑过]

还是这个错误~大哥帮帮我

你加个 try..catch..就知道是什么错了.

private void Form1_Load(object sender, System.EventArgs e)
{
//string Constr = @"server=local" + "uid=YANJIU" + "database=northwind";
//string SQL = "SELECT*FROM table";

SqlConnection conn = new SqlConnection(@"server=(local);Integrated Security=True;"+"Database=student");
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from table", conn);
//SqlDataAdpater da = new SqlDataAdapter(SQL, conn);
DataSet ds = new DataSet();
da.Fill(ds, "table");
textBox1.DataBindings.Add("Text", ds, "table.name");
textBox2.DataBindings.Add("Text", ds, "table.name");