GUI APPLICATION WITH SQL CONNECTIVITY

Question

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).

Wim Sturkenboom · Answer

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).

vipan kumar · Answer

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(); } }