VB .Net and SQL Server 1

[kristinac]

Would this be the wrong forum to ask about connecting to a SQL Server database through a VB .net application? A web application to be specific. I have found a couple ways to write connection strings, however I need access to the stored procedures. Can you only access the stored procedures through a windows ap or service?

Any insight would be appreciated...

 

[DotNetDoc]

Both windows and web apps use ADO.net to access databases. Both of these can talk to SQL Server using stored proceedures. Detail out what you are trying to do and I will show you the code you need.


DotNetDoc
M.C.S.D.

http://www.DotNetDoc.com

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

Tell me and I forget. Show me and I remember. Involve me and I understand.
- Anonymous Chinese Proverb
-----------------------------------
If you can't explain it simply, you don't understand it well enough.
- A. Einstein

 

[kristinac]

Thanks. To make a long story short, I have this half-done windows ap someone else did in which you can access the stored procedures that are in the SQL database. I see a routine he wrote like this:

Dim Procedure As String = "pUser_LoadBy_UserName"
Dim Names(0) As String
Dim Values(0) As Object
Names(0) = "@UserName" : Values(0) = UserName

Dim ds As DataSet = Me.GetDataSet(Procedure, Names, Values)

I have to rewrite the program in a web application. I can barely figure out how to connect to the SQL Server database, let alone how to access the stored procedures.
I've never worked with SQL Server before...and the way this other guy wrote the windows ap doesn't make a lot of sense.

Is this something I can do with a web ap?

 

[DotNetDoc]

If you would like help with "His" code you would need to post more so I can see what he is doing. Otherwise you can start by reading a few articles to catch you up.

Here are a couple of artices that might help you :

http://www.sqljunkies.com/Tutorial/4EC83A05-37CA-479D-94D9-04EAFE7705F9.scuk

http://www.123aspx.com/directory.aspx?dir=78

DotNetDoc
M.C.S.D.

http://www.DotNetDoc.com

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

Tell me and I forget. Show me and I remember. Involve me and I understand.
- Anonymous Chinese Proverb
-----------------------------------
If you can't explain it simply, you don't understand it well enough.
- A. Einstein

 

[kristinac]

DotNetDoc - Thank you so much! These articles are exactly what I needed. I think I can figure out how to do what I need through this information. Thanks!!