Demand: Can you convert the following code into vb. Thanks.
// Open the connection

sqlConnection1.Open();

// Create a new DataReader and assign it to select command

System.Data.SqlClient.SqlDataReader sqlDataReader1 = sqlSelectCommand1.ExecuteReader();

// Loop through the DataReader

while(sqlDataReader1.Read())

{

// Display the value inside the Title column

Response.Write(sqlDataReader1["Title"] + " - ");

// And the value inside the URL column

Response.Write(sqlDataReader1["URL"] + "<br />");

}

asdfadsf

Great tutorial! Thanks

¿como guardo datos en la base?

how save datas on the DB?

Simple and best, I like this site...

Good job! You guys have exposed me to how to connect to msde database. God bless u all.

I follow all the steps, everything goes very fine but except the last step to view the page in IE, error msg: SQL Server does not exist or access denied.

Pls advise, many thanks!!!

:<

I believe that the cause of this error is that SQL Server does not exist or access denied.

hwo to write a function to connect any database, any table

It is a very very good tutorial. I follow all the steps but
the code behind file is a bit confusing. The extension for
my code behind file is WebForm1.aspx.vb and not WebForm1.aspx.cs. I tried to copy the code and compile
all the same but generated a lot of errors. Please help.
thanks in advance!

You are using Visual Basic .NET, and this is a C# tutorial. You'll need to create an C# ASP.NET website instead of a Visual Basic .NET ASP.NET website for the code to work. You can choose the type of project in Visual Studio when you create a new solution.

Then the code-behind file will have the .aspx.cs extension and the code will work.

Good luck!

Great job Andrei ! It works using c#. Do you know any useful tutorial that address connecting to MsSQL using
vb.net?

The sample code at <a href="http://www.startvbdotnet.com/ado/sqlserver.aspx" target="_blank">http://www.startvbdotnet.com/ado/sqlserver.aspx</a> should do it.

hey great tutorial it helps me alot

Db connection works fine. thanks alot frienz

excellent

nice

hii
This is the worst article that i have ever read
dont ever publish this again
beware bye


frnd

hii
hahaha

This is the worst article that i have ever read
dont ever publish this again
beware bye

I Like It ,Its Really HelpFul For Me
thanks

Thank you...excellent

' Open the connection

sqlConnection1.Open()

' Create a new DataReader and assign it to select command

Dim sqlDataReader1 As System.Data.SqlClient.SqlDataReader = sqlSelectCommand1.ExecuteReader()

' Loop through the DataReader

While sqlDataReader1.Read()


' Display the value inside the Title column

Response.Write(sqlDataReader1("Title") + " - ")

' And the value inside the URL column


Response.Write(sqlDataReader1("URL") + "<br />")
End While

Thank goodness, you guys just let my cat out of its bag; I am overlly impressed. Thanks

It's very helpful for me to start my work unsing ASP.NET and SQL SERVER.

its very useful for my career

Regarding ASP.Net i have one doubt,when i am trying to connect the webapplication with sql server database it showing the following error
Server Error in '/Sample' Application.

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

INSERT permission denied on object 'Info', database 'master', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: INSERT permission denied on object 'Info', database 'master', schema 'dbo'.

but in windows application i can able to work
please give one solution

Looks like you don't have permission over the Insert command. Check the user's credentials.

I need the query "How to connect the two and more table in the database and how can fetch the data from the connected database.
I am using SQL 2000 Server

dfg

I have 1 doubt in sql server.I made a website on asp.net and when I tried 2 connect to sql server it gave an error #26..how to resolve it?It says that sql server does not allow remote connections..

doesn't clear my doubts at all

dffsdf

keko keka

not satisfied

Hello
I want the connectivity code withsql server in asp.net application with is property.

Plzzzzzzzz
help its really very important to me..........

After reading this code, I serioulsy wish that I was a programmer rather than an actor. Great minds!!!

Certinaly, it helped, if you want the code in vb, get the converter from google

Certinaly, it helped, if you want the code in vb, get the converter from google

hi this is subhani ,i fell ver happy.and i need qurees on sql server 2000. plz send me pdfs

hi friends,
i want to know how to connect sql 7.0 to Asp.net .i know only through c# ,but can you tell how through vb

Hi friends,

I just wanna sql database connection by asp.net using c#...

please send me some pdf tutorials with examples...

Thanx a lot....

Error 1 The name 'sqlConnection1' does not exist in the current context C:\Documents and Settings\jayan\My Documents\Visual Studio 2008\Projects\SQLConnection1\SQLConnection1\Default.aspx.cs 14 13 SQLConnection1

Error 1 A namespace does not directly contain members such as fields or methods C:\Documents and Settings\jayan\My Documents\Visual Studio 2008\Projects\SQLconnection\SQLconnection\Default.aspx.cs 3 1 SQLconnection

I want upload and download files in sql data table using asp.net with C# and also how i can manage or delete,retrieve,edit and update the uploaded file please send me tutorial with code

./,./.,

Sir
i want db connections using asp.net globally
web.config file but i unable to access these connection to our remaining business logics forms

thanks

Public Function CreateChart() As String

Dim util As New Utilities.Util()
'Database Objects - Initialization
Dim oRs As DbConn, strQuery As String
'strXML will be used to store the entire XML document generated
Dim strXML As String

'Generate the graph element
strXML = "<graph caption='WHOLESALE-REPORT' xAxisName='ITEM' yAxisName='COST'numberprefix='$' palette='3' showValues='0' formatNumberScale='0' showBorder='1'>"
'strXML = "<graph caption='wholesalepricereport' subCaption='item' decimalPrecision='0' showNames='1' numberSuffix='Units' pieSliceDepth='30' formatNumberScale='0'>"

' SQL Query
strQuery = "select ITEM,Cost from WholeSaleCost"

' Open Data Reader
oRs = New DbConn(strQuery)
'Iterate through each factory
If oRs.ReadData Is Nothing Then
Response.Write("<br> Connection error")
Response.End()
Return ""
End If
While oRs.ReadData.Read()

'Generate <set name='..' value='..' />
strXML = strXML

This is a very good article.

For a similar article on connecting to SQL Server from C#.NET and Java, embedding SQL, calling stored procedures, passing parameters, retrieving results etc, check: http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html

Shahriar Nour Khondokar: http://www.shahriarnk.com/

Can you write the code in Visual Studio 2008 and with SQL Server 2005 Compact Edition (.sdf database)?

plixx help me with code for connecting asp.net to sql server. plizz help

how to connectdatabase a asp.net

the first part of this tutorial is very useful.

gfcmb.c

plix help me with the ASP code, for login. i want the registered users to login.When logging in the details should be retrieved from the database.

PLIXX HELP ME GUYS

plix help me with the ASP code, for login. i want the registered users to login.When logging in the details should be retrieved from the database.

PLIXX HELP ME GUYS

plix help me with the ASP code, for login. i want the registered users to login.When logging in the details should be retrieved from the database.

PLIXX HELP ME GUYS

plix help me with the ASP code, for login. i want the registered users to login.When logging in the details should be retrieved from the database.

PLIXX HELP ME GUYS

plix help me with the ASP code, for login. i want the registered users to login.When logging in the details should be retrieved from the database.

PLIXX HELP ME GUYS

plix help me with the ASP code, for login. i want the registered users to login.When logging in the details should be retrieved from the database.

PLIXX HELP ME GUYS

plix help me with the ASP code, for login. i want the registered users to login.When logging in the details should be retrieved from the database.

PLIXX HELP ME GUYS

hi m aditya