Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

detail code for sql data connections?

Answers were Sorted based on User's Feedback

detail code for sql data connections? ..

Answer / nitin kumar

Steps for 1. Using a SqlConnection
// Fully Commented Code
using System;
using System.Data;
using System.Data.SqlClient;

class SqlConnectionDemo
static void Main()
// 1. Instantiate the connection
SqlConnection conn = new SqlConnection(
"Data Source=(local);Initial
Catalog=Northwind;Integrated Security=SSPI");

SqlDataReader rdr = null;

// 2. Open the connection

// 3. Pass the connection to a command object
SqlCommand cmd = new SqlCommand("select * from
Customers", conn);

// 4. Use the connection

// get query results
rdr = cmd.ExecuteReader();

// print the CustomerID of each record
while (rdr.Read())
// close the reader
if (rdr != null)

// 5. Close the connection
if (conn != null)

Is This Answer Correct ?    7 Yes 0 No

detail code for sql data connections? ..

Answer / bhagwat prasad sharma

Steps: SqlConnection with code
'' Code

Public Class Form1 Inherits System.Windows.Forms.Form
'' createconnection with database

dim con as new sqlconnection("server=bps; database=company; user id=sa; password=admin")

private sub button1_click()

dim str as string="insert into employee (roll_no,name,class) values(@roll_no,@name,@class)"

dim cmd as new sqlcommand =(str,con)

if con.state=connectionstate.closed than
'' parameter passing


cmd.parameters("@roll_no").value= txtroll.text
cmd.parameters("@class").value= txtclass.text

dim i as integer

if i>o
msgbox("addition successful")
msgbox("sum mistakes into add")
end if
' end of connection
end sub
end class

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

What is the difference between server-side scripting and client-side scripting?

0 Answers  

Why would anyone need to implement their own hashtable or linked list?

0 Answers  

can we call web service from the browser?

2 Answers   Keane India Ltd,

what is the difference between console.writeline &console.output.writeline?

2 Answers  

can I use session variable in App_code Class page??

3 Answers   Wipro,

How will you load dynamic assembly? How will create assesblies at run time?

0 Answers  

What is css in

0 Answers  

In a page there is dropdown list with the name of the cities like Bangalore,Pune,Chennai,Other and a text box that would enable the user to enter the name of the city if other is selected. How to enable validation on the text box if other is selected

1 Answers  

Differentiate the session object and application object?

0 Answers  

Why do we need url encoding?

0 Answers  

Can we handle the error and redirect to some pages using web.config?

1 Answers   BirlaSoft,

What tags do you need to add within the asp:datagrid tags to bind columns manually?

5 Answers   Siebel Systems,