How can i get the connectivity between my front end (c#_ and back end (sql) please

Question

1.00/5 (1 vote)

See more:

C#

How can i get the connectivity between my front end (c#_ and back end (sql) please ?

Posted 13-Apr-12 18:46pm

MRUNMAY

Updated 13-Apr-12 23:36pm

Bala Selvanayagam

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

VJ Reddy · Answer 1 · 2012-04-13T22:46:00

Apart from the answers already given, which will suit the purpose specified in the question, I think this Code Project article
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection[^]
in which a general purpose class to easily read data from a database and to save data to database is given, may also be helpful.

Kuldeep B · Answer 2 · 2012-04-13T19:42:00

Solution 3

Try This Mrunmay...

C#

SqlConnection con = new SqlConnection("server=servername;database=databasename;integrated security=SSPI;MultipleActiveResultSets=true");

On Insert Button Click

C#

SqlCommand cmd = new SqlCommand("insert  into employee values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text  + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Inserted!");

Enjoy Coding

Posted 13-Apr-12 19:42pm

Kuldeep B

Comments

VJ Reddy 14-Apr-12 4:51am

Good answer. 5!

[no name] 14-Apr-12 6:01am

You have just advised that the OP open himself to SQL injection attacks. He should use a parametrized query instead.

Kuldeep B 14-Apr-12 12:40pm

Thank U VJ..

Dipesh202 · Answer 3 · 2012-04-13T19:41:00

You can Add Namespace as system.data.sqlclient
and then you can use
sqlconnection class and sqlcommand class to establish
connection with backend sql server

like this

C#

sqlconnection cn = new sqlconnection();
sqlcommand cm = new sqlcommand();

cn.connectionstring = "your connection string goes here";
cm.connection = cn;
cn.open();
cm.commandtext = "your sql query";
sqldataadapter da = new sqldataadapter(cm);
dataset ds = new dataset();
da.fill(ds);
cn.close();

uspatel · Answer 4 · 2012-04-13T18:51:00

Solution 1

you can do this with visual studio
Using Visual Studio to find a database connection string[^]

and you can write connection string manually
see http://www.connectionstrings.com/[^]

Posted 13-Apr-12 18:51pm

uspatel

Comments

VJ Reddy 14-Apr-12 4:50am

Good links. 5!

uspatel 14-Apr-12 4:51am

Thanks Reddy.....

How can i get the connectivity between my front end (c#_ and back end (sql) please

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0