SQL Server Interface ASP.NET (Either C# or Visual Basic)

michiganblkman
michiganblkman used Ask the Experts™
on
Can someone direct me to a QL Server interface that is done in C# or Visual Basic (ASP.NET) that has source code available. Online link

Preferably a walk thru tutorial on how to construct it would be nice but not required. The source code is the most important thing.  The source does not have to be free.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi, This is useful to you

using System.Data
using System.Data.SqlClient

sqlconnection con = new sqlconnection("Your Connection String")


if you want to get data, use this

sqldataadapter dap = new sqldataadapter("Your query",con)
dataset ds = new dataset()
con.open()
dap.fill(ds)
gridview.datasource = ds.tables[0].defaultview
gridview.databind()
con.close()


Try this

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx

is there anything specific you are trying to do?

Author

Commented:
This helped some

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial