GUI APPLICATION WITH SQL CONNECTIVITY

vipan kumar

how to bind database with gui(c sharp) application and after bind data to gui application if we setup create , than application will run on same system

but while install application another system than application run , but data base not show on another system.(i know that how to bind data base with gui

application but my problem is that while i create setup than application run with data base only same os but while i run application another system

than application run but database not show).

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

vipan kumar12y ago
string i; SqlConnection con; SqlCommand com; string ID = "select *from SINUP WHERE PASSWORDS IN ('gulshan')"; private void button1_Click(object sender, EventArgs e) { try { con = new SqlConnection(); con.ConnectionString = "Data Source=NATURE-PC;Initial catalog=IDENTIFICATION;User ID=sa;password=niit"; com = new SqlCommand(ID, con); con.Open(); com.Parameters.AddWithValue("@PASSWORDS", textBox1.Text); SqlDataReader sdr = com.ExecuteReader(); object srt=sdr.HasRows; sdr.Read(); i=sdr[1].ToString (); if (textBox2.Text == i) { NIITWORLD OBJ9 = new NIITWORLD(); OBJ9.Show(); } else { MessageBox.Show("PLEASE ENTER RIGHT USERNAME AND PASSWORD"); } } catch (Exception EX) { MessageBox.Show(EX.Message); } finally { con.Close(); } }
0
Wim Sturkenboom12y ago
If I understand you correctly, you have a database and an application on one computer (let's call it computer A).
You now want to install the application on another computer (let's call it computer B) and use the database on computer A.

Correct?

If this understanding is correct, please show us the connection string that is used to connect to the database; you can replace credentials with dummy values. Also let us know where it is defined (in code, App.config or somewhere else).
+1