connection to sql server with connected architecture

Posted Date: 28 Nov 2008	Resource Type: Code Snippets	Category: SQL
Author: bob	Member Level: Gold
Rating:	Points: 7

There are two types of architecture in dotnet while connecting with sql server

1.connected architecture
2.disconnected architecture

Here is a small example with connected architecture,in this type of architecture we have to open and close the connection



SqlConnection con = new SqlConnection("server=localhost;database=raja;integrated security=sspi");
string SqlCmd = "insert into friends5 values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')";
SqlCommand cmd = new SqlCommand(SqlCmd, con);
con.Open();
cmd.ExecuteNonQuery();
Response.Write("values inserted");
con.Close();

For more details, visit http://dotnetmaterial9.blogspot.com/2008/11/worked-code-for-reference.html

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Sql server . Http://dotnetmaterial9.blogspot.com/2008/11/worked-code-for-reference.html . Connection . Connected architectu .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Simple stored procedure for insertion
	Previous Resource: Store and retrieve file with SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources