这是代码,可是连接后出现的问题是:System.Data.SqlClient.SqlException: 列前缀 'name' 与查询中所用的表名或别名不匹配。
数据库teacher表中name为主键,根据name 查询表信息

public class Service1 : System.Web.Services.WebService
{
private SqlConnection cn;
private SqlDataAdapter da;

public Service1()
{
//CODEGEN: 该调用是 ASP.NET Web 服务设计器所必需的
cn= new SqlConnection("server=localhost;database=TeacherInfo;user id=hao;pwd=;");
InitializeComponent();
}

[WebMethod]
public DataSet GetData(string name)
{
string sql;
DataSet dataSet = new DataSet();
sql = "SELECT * FROM teacher WHERE name = " + "name.ToString";
da = new SqlDataAdapter(sql, cn);
da.Fill(dataSet, "teacher");
return dataSet;
}

public class Service1 : System.Web.Services.WebService
{
private SqlConnection cn;
private SqlDataAdapter da;

public Service1()
{
//CODEGEN: 该调用是 ASP.NET Web 服务设计器所必需的
cn= new SqlConnection("server=localhost;database=TeacherInfo;user id=hao;pwd=;");
InitializeComponent();
}

[WebMethod]
public DataSet GetData(string name)
{
string sql;
DataSet dataSet = new DataSet();
sql = "SELECT * FROM teacher WHERE [name] = '" + name.ToString()+"'";
da = new SqlDataAdapter(sql, cn);
da.Fill(dataSet, "teacher");
return dataSet;
}

[此贴子已经被作者于2006-5-15 17:50:04编辑过]

原来是这里错了，真是太感谢了