SqlCommand 与 SqlDataAdapter

                                       SqlConnection con = new SqlConnection("server=.;database=xxx;uid=sa;pwd=;");   
                                       string  sqlstring = "select * from table"; 
                                       con.open();   
SqlCommand
                                
                             SqlCommand cmd = new SqlCommand(sqlstring,con);
                             SqlDataReader dr = cmd.ExecuteReader();
                             dr做数据源
SqlDataAdapater
                             SqlDataAdapter da = new SqlDataAdapter(sqlstring,con);
                              DataSet            ds = new DataSet();
                             da.Fill(ds,"table");
                             ds做数据源
                                               也可以DataView做数据源 DataView dv = ds.Tables["table"].DefaultView;
存储过程
                              SqlCommand  cmd = new  SqlCommand();
                              cmd.CommandText = "存储过程名";
                              cmd.CommandType= CommandType.StoredProcedre;
                              cmd.Parameters.Add("@xx", SqlDbType.NVarChar, 10).Value = DropList.SelectedItem.Text;
                             
                             SqlDataReader dr = cmd.ExecuteReader();