C# Get data from SQL Server and display it
Posted on 2004-11-10
I want to know How I can make an aspx page with one button "Click Me" and as soon as user clicks on it, I will get data from my database and displays in on the browser in a table and all in C#.
I already have dome tons of readings but I cant put all the parts together.
So far I have added this to my web.config:
<add key="dbconnection" value="server=local;database=MyTesting;uid=testx;password=testy;" />
On my codebehind I have the following namespaces:
using System.Configuration; //For Web Config
using System.Data.SqlClient; //Do I need this one??????
and my Query is:
sSQL = "Select * from Client" ;