winform吗?SqlConnection con = new SqlConnection("Data Source=.;DataBase=Test;User Id=sa; Pwd=");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = 你的sql语句(select * from table)
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);