string connString = "Server = XCCN_NETDUST; uid = sa; pwd = 83996193; database = pubs"; SqlConnection myconn = new SqlConnection (connString); SqlDataAdapter myda = new SqlDataAdapter ( "Select * from authors", myconn); DataSet ds = new DataSet (); MyDa.Fill (DS, "Authors"); DataGrid1.datasource = DS; DATAGRID1.DATABIND ();