Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The Simplest Thing...Connection To DB

Status
Not open for further replies.
neroe

neroe

Technical User
Feb 27, 2003
54
GB
any help with this would be greatly appreciated.

i have my .aspx with a very empty looking DataGrid on it. i would like to populate it with data from a table i have just constructed in sql server 2000.

what is the best way to do this . . . ? does the connection go in the Web.config file. if so, where? and how do i reference it from the .aspx that has the DataGrid on it.
 
Sort by date Sort by votes
You should place your connection string in the web.config file but first let's get you started with a simple DataGrid before we come to that. Add this to your page load and change the necessary lines:
Code: 
    Dim MyConnection As System.Data.SQLClient.SqlConnection
    Dim MyDataAdapter As SQLClient.SQLDataAdapter
    Dim MyDataTable As New DataTable
    Dim MyDataRow As DataRow
    Dim strSQL As String = "SELECT FIELD1, FIELD2 FROM MYTABLE"

    MyConnection = New System.Data.SQLClient.SqlConnection("server=127.0.0.1; initial catalog=MyDatabase;uid=USERNAME;pwd=PASSWORD")
    MyConnection.Open()
    MyDataAdapter = New SQLClient.SQLDataAdapter(strSQL, MyConnection)
    MyDataAdapter.Fill(MyDataTable)

DataGrid1.Datasource = MyDataTable
DataGrid1.DataBind



--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility ( or read FAQ222-2244 on how to get better results.
 
Upvote 0 Downvote
thats not c# is it?! i'm using c# to do this . . . sorry, i should have said
 
Upvote 0 Downvote
No - that's VB.NET - there's not much difference though so it can easily be converted. Something like the following should work:
Code: 
System.Data.SQLClient.SqlConnection MyConnection;
SQLClient.SQLDataAdapter MyDataAdapter;
DataTable MyDataTable = new DataTable();
DataRow MyDataRow;
string strSQL = "SELECT FIELD1, FIELD2 FROM MYTABLE";
MyConnection = new System.Data.SQLClient.SqlConnection("server=127.0.0.1; initial catalog=MyDatabase;uid=USERNAME;pwd=PASSWORD");
MyConnection.Open();
MyDataAdapter = new SQLClient.SQLDataAdapter(strSQL, MyConnection);
MyDataAdapter.Fill(MyDataTable);
DataGrid1.Datasource = MyDataTable;
DataGrid1.DataBind();

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility ( or read FAQ222-2244 on how to get better results.
 
Upvote 0 Downvote
ok, entire page looks like;

<%@ Page language="c#" Codebehind="Listing.aspx.cs" AutoEventWireup="false" Inherits="BF_PROffice.Listing" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>Listing</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content=" </HEAD>
<body MS_POSITIONING="GridLayout">

System.Data.SQLClient.SqlConnection MyConnection;
SQLClient.SQLDataAdapter MyDataAdapter;
DataTable MyDataTable = new DataTable();
DataRow MyDataRow;
string strSQL = "SELECT FIELD1, FIELD2 FROM MYTABLE";
MyConnection = new System.Data.SQLClient.SqlConnection("server=127.0.0.1; initial catalog=MyDatabase;uid=USERNAME;pwd=PASSWORD");
MyConnection.Open();
MyDataAdapter = new SQLClient.SQLDataAdapter(strSQL, MyConnection);
MyDataAdapter.Fill(MyDataTable);
DataGrid1.Datasource = MyDataTable;
DataGrid1.DataBind();

</body>
</HTML>
 
Upvote 0 Downvote
No that's not correct. You code needs to go in the Page Load event not in the HTML.

I suggest you start reading the basics of ASP.NET and follow some tutorials rather that trying to dive straight in as you will just end up making simple mistakes like the one above. A really good site to start with is where you will find lots of help and tutorials to guide you.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility ( or read FAQ222-2244 on how to get better results.
 
Upvote 0 Downvote
i mean, it looks like this;

private void Page_Load(object sender, System.EventArgs e)
{
System.Data.SQLClient.SqlConnection MyConnection;
SQLClient.SQLDataAdapter MyDataAdapter;
DataTable MyDataTable = new DataTable();
DataRow MyDataRow;
string strSQL = "SELECT FIELD1, FIELD2 FROM MYTABLE";
MyConnection = new System.Data.SQLClient.SqlConnection("server=127.0.0.1; initial catalog=MyDatabase;uid=USERNAME;pwd=PASSWORD");
MyConnection.Open();
MyDataAdapter = new SQLClient.SQLDataAdapter(strSQL, MyConnection);
MyDataAdapter.Fill(MyDataTable);
DataGrid1.Datasource = MyDataTable;
DataGrid1.DataBind();
}
 
Upvote 0 Downvote
Is that page load sub in the code-behind page or the aspx page?

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility ( or read FAQ222-2244 on how to get better results.
 
Upvote 0 Downvote
OK...so what's your question then?

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility ( or read FAQ222-2244 on how to get better results.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Makumbi256
  • Locked
  • Question
How to make days vertical and grid view editable using asp.net vb
Replies
0
Views
251
Makumbi256
Makumbi256
AhmedAzizBarbary
  • Locked
  • Question
How to read data response body after success login razor page ?
Replies
0
Views
364
AhmedAzizBarbary
AhmedAzizBarbary
AhmedAzizBarbary
  • Locked
  • Question
How to pass list of checkboxes not checked on page model razor page?
Replies
0
Views
399
AhmedAzizBarbary
AhmedAzizBarbary
a6green
  • Locked
  • Question
How to configure AT&T / Avaya Definity G3 incoming ISDN trunk
Replies
2
Views
361
a6green
a6green
Makumbi256
  • Locked
  • Question
how can i convert this code to cshap
Replies
1
Views
318
xwb
xwb

Part and Inventory Search

Sponsor

Back
Top