I am trying to connect to a sql server database called TEST, the table i am thryng to access is called staff, could you please help?? I need the code to make the link between the database and the ASP pages, to query tables...I just wrote my first simple example of this yesterday with the new data grid. I don't know if this is the best way to display info from a table since yesterday was my first day of asp.net, or even if I did everything right, but it worked on my server! If something in here could be improved or commented upon please let me know.<BR><BR><BR><%@ Import Namespace="System.Data" %><BR><%@ Import Namespace="System.Data.SqlClient" %><BR><BR><html><BR><BR> <script language="VB" runat=server><BR> Sub GetGrid(Sender As Object, E As EventArgs)<BR> Dim objDS As DataSet<BR> Dim objConn As SqlConnection<BR> Dim objCommand As SqlDataAdapter<BR><BR> objConn=New SqlConnection("server=SERVER(or IP);database=DATABASENAME;uid=USERID;pwd=PASSWORD;")<BR> objCommand=New SqlDataAdapter("SELECT * FROM staff", objConn)<BR><BR> objDS=new DataSet()<BR> objCommand.Fill(objDS, "staff")<BR><BR> objList.DataSource = objDS.Tables("staff").DefaultView<BR> objList.DataBind()<BR> End Sub<BR> </script><BR><BR><body><BR><BR> <center><BR><BR> <ASP
ataGrid onLoad="GetGrid" id="objList" HeaderStyle-BackColor="#CCCCCC" BackColor="#EEEEEE" runat="server"/><BR><BR> </center><BR><BR></body><BR></html><BR>
ataGrid onLoad="GetGrid" id="objList" HeaderStyle-BackColor="#CCCCCC" BackColor="#EEEEEE" runat="server"/><BR><BR> </center><BR><BR></body><BR></html><BR>