public static DataTable GetDataTable(string prefixText)
{
string connStr = "Data Source=ZL;Initial Catalog=Liketest;Integrated Security=True";
string SQLCMD = "Select name from liketext where name like '%"+prefixText+"%'";
using(SqlConnection con=new SqlConnection(connStr))
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(SQLCMD);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
这样写有没有错,谁能给个指点啊目的是返回一张表....
{
string connStr = "Data Source=ZL;Initial Catalog=Liketest;Integrated Security=True";
string SQLCMD = "Select name from liketext where name like '%"+prefixText+"%'";
using(SqlConnection con=new SqlConnection(connStr))
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(SQLCMD);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
这样写有没有错,谁能给个指点啊目的是返回一张表....
就不用直接定义sqlconnection和sqlcommand了