1.SqlDataSource控件:
这个得建类,再类里面绑定,同时也得和数据绑定控件(如 GridView、FormView 和 DetailsView 控件)一起使用;
例如:建一个Student类:
public class Student
{
private string strCnn;
public Student()
{
strCnn = ConfigurationManager.ConnectionStrings["studentConnectionString"].ConnectionString;
}
public DataTable StudentSelect()
{
DataSet ds = new DataSet();
using (SqlConnection sqlcnn=new SqlConnection(strCnn))
{
SqlCommand sqlcmm = sqlcnn.CreateCommand();
sqlcmm.CommandText = "select sid,sname,sex,photo from student";
SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
da.Fill(ds);
}
return ds.Tables[0];
}
}