Hoe can i connect the table into the c# application?
Answers were Sorted based on User's Feedback
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 |
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 |
How do you generate documentation from the C# file commented properly with a command-line compiler?
What is the base class in .net from which all the classes are derived from?
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
can we create an empty interface with no definitions? If so, how it should be called in the class?
What are sorted lists?
What is the meaning of int parse in c#?
What is the difference between c and c# programming?
Explain jagged arrays in c#?
write a program to find the biggest palindrome in the given string
What is event and delegates in c#?
Can you drink alcohol with a loop recorder?
What do you mean by stack and heap in c#?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)