what database are you using?see
http://www.able-consulting.com/MDAC/ADO/Connection/MSRemote.htmorhttp://www.able-consulting.com/dotnet/adonet/Data_Providers.htm
http://www.able-consulting.com/MDAC/ADO/Connection/MSRemote.htmorhttp://www.able-consulting.com/dotnet/adonet/Data_Providers.htm
string strConnect1 = "User Id=stat;Password=stat2003;Data Source = webapp;";
OracleConnection objConnect1 = new OracleConnection(strConnect1);
OracleDataAdapter myDataAdapter = new OracleDataAdapter(strSql, strConnect1);
DataSet ds = new DataSet();
myDataAdapter.Fill(ds, "t1");
DataGrid1.DataSource=ds.Tables["t1"].DefaultView;
DataGrid1.DataBind();