Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Hoe can i connect the table into the c# application?

Answers were Sorted based on User's Feedback



Hoe can i connect the table into the c# application?..

Answer / umesh shrivastava

if we are using web application
1-open web.config file
<ConnectionString>
<add name="connect" connectionstring="Data Source=
,IntialCatalog= " Username= ,Password=
;providerName="System.Data.SqlClient"
</ConnectionString>
2-write namespace at the top in .cs file System.Data.SqlClient;
2-now write this code to button click event
String
ss=ConfigurationManager.ConnectionString["connect"].ConnectionString;
Sqlconnection con=new SqlConnection(ss);
con.open();
SqlCommand cmd=new SqlCommand("select * from emp",con);
SqlDataReader r=cmd.ExecuteReader();
con.close();

Is This Answer Correct ?    2 Yes 0 No

Hoe can i connect the table into the c# application?..

Answer / gaurav

by writing the connection string on the click event of the
button. by connection string i mean it's the ado.net
structure.firstly you have to include the namespace- using
system.data.sqlclient;
now on the click event of the button( eg u have taken a
sumbit button ) you will be writting- sqlconnenection con=
new sqlconnection........then u'll use
datacommand,dataset,string,databind,gridview.
u can also use read for getting the errors in a specified
manner.for this u will be using try and the catch then your
connection string code and then u'll use the finally
function and then close().

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More C Sharp Interview Questions

How do you generate documentation from the C# file commented properly with a command-line compiler?

1 Answers  


What is the base class in .net from which all the classes are derived from?

0 Answers  


Assignment # 1 Print the pattern given below using single printf statement XX XX XX XX XX XX X X X X XX XX XX XX XX XX Assignment # 2 Print the pattern given below using single printf statement (please do NOT use the string function below) 0 909 89098 7890987 678909876 56789098765 4567890987654 345678909876543 23456789098765432 1234567890987654321

3 Answers   Wipro,


can we create an empty interface with no definitions? If so, how it should be called in the class?

3 Answers   IBM,


What are sorted lists?

0 Answers  


What is the meaning of int parse in c#?

0 Answers  


What is the difference between c and c# programming?

0 Answers  


Explain jagged arrays in c#?

0 Answers  


write a program to find the biggest palindrome in the given string

0 Answers   Microsoft,


What is event and delegates in c#?

0 Answers  


Can you drink alcohol with a loop recorder?

0 Answers  


What do you mean by stack and heap in c#?

0 Answers  


Categories