ASP.NET

Connect to SQL

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 324

Reputation: sonia sardana has a little shameless behaviour in the past

Solved Threads: 7

sonia sardana sonia sardana is offline

Offline

Posting Whiz

Connect to SQL

-1

Jun 29th, 2009

hey frnds, tell me one thing as in VB.Net suppose if we want to connnect to SQL,then in form coding itself.We create the database,Create table ...& insert values...

WE do that cz if we run the project at Client side,even if no database is there our project automatically creates it So that no error is there,Is it also possible in ASP.net...

Is yes,can somebody tell me from where to start...

•

Join Date: Jun 2009

Posts: 132

Reputation: stevenpetersen is an unknown quantity at this point

Solved Threads: 1

stevenpetersen stevenpetersen is offline

Offline

Junior Poster

Re: Connect to SQL

-2

Jun 29th, 2009

Tell me if this helps.....

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
<script languae="PHP">
	open_database("location","username","password");
	display_page("PAGE_ID");
	close_database();
</script>
<script languae="PHP">
	open_database("location","username","password");
	display_page("PAGE_ID");
	close_database();
</script>

Last edited by peter_budo; Jun 30th, 2009 at 2:09 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Steven Petersen
Web Designer / Web Master

•

Join Date: Sep 2007

Posts: 95

Reputation: reach_yousuf is an unknown quantity at this point

Solved Threads: 16

reach_yousuf reach_yousuf is offline

Offline

Junior Poster in Training

Re: Connect to SQL

Jun 30th, 2009

Hi

This is not a recommended solution... it's not a good programming practice... the maintenance would be a big issue as you move in development stage.

Try keep n-tier architecture.
1) keep db as separate with ur scripts
2) Dataaccess layer
3) business layer
4) presentation layer

$Yousuf$
$Software Developer$

•

Join Date: Jun 2009

Posts: 88

Reputation: IdanS is an unknown quantity at this point

Solved Threads: 12

IdanS

Offline

Junior Poster in Training

Re: Connect to SQL

Jun 30th, 2009

Hi,

Read this to how to create the DB on runtime:
http://www.codeproject.com/KB/database/CreateDB.aspx

•

Join Date: May 2008

Posts: 164

Reputation: dnanetwork has a little shameless behaviour in the past

Solved Threads: 24

dnanetwork dnanetwork is offline

Offline

Junior Poster

Re: Connect to SQL

Jun 30th, 2009

hi it's me again...i was little curious about u r sql server version...? is it 2000/2005/2008?

•

Join Date: Feb 2009

Posts: 3,442

Reputation: sknake has much to be proud of

Solved Threads: 626

sknake

Offline

.NET Enthusiast

Re: Connect to SQL

Jun 30th, 2009

This will create a table named "Test123"

 Help with Code Tags 
 vb.net Syntax (Toggle Plain Text) 
	Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
		Dim conn As SqlClient.SqlConnection = New SqlClient.SqlConnection("Data Source=APEX2006SQL;Initial Catalog=ServManLeather;Integrated Security=True")
		conn.Open()
		Dim cmd As SqlClient.SqlCommand = New SqlClient.SqlCommand("Create Table Test123 ( someColumn varchar(123) )", conn)
		cmd.ExecuteNonQuery()
		cmd.Dispose()
		conn.Close()
		conn.Dispose()
	End Sub
	Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
		Dim conn As SqlClient.SqlConnection = New SqlClient.SqlConnection("Data Source=APEX2006SQL;Initial Catalog=ServManLeather;Integrated Security=True")
		conn.Open()
		Dim cmd As SqlClient.SqlCommand = New SqlClient.SqlCommand("Create Table Test123 ( someColumn varchar(123) )", conn)
		cmd.ExecuteNonQuery()
		cmd.Dispose()
		conn.Close()
		conn.Dispose()
	End Sub