Windows Form With MSSQL Connectivity

amjad islam amjad

How to connect my winform application with other computer MSSQL

5 Replies

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

aman deep9y ago
Just Make Few Changes Into Connection String Like This If You are Not Using App.Config
-----------------------------------------------------------------------------------------------------------------------
SqlConnection con = new SqlConnection("server="IP ADDRESS OF THAT COMPUTER GOES HERE ";user=Users;password=password;database=Example1;integrated security = true;")
Jitendra Shekhawat9y ago
SqlConnection con = new SqlConnection("server=192.168.0.21;Initial Catalog=Database_Name;integrated security = true;");
Rajkiran Swain9y ago
1. SqlConnection con = new SqlConnection("server=192.168.0.100,1400;user=Users;password=password;database=Example1;integrated security = true;");
3. SqlDataAdapter sda = new SqlDataAdapter();
4. DataTable dbdataset = new DataTable();
6. BindingSource bsource = new BindingSource();
7. SqlCommand cmd = new SqlCommand();
9. public void loaddata()
10. {
11. try
12. {
13. SqlCommand cmdatabbase = new SqlCommand(" select * from Example1.dbo.Users ;", con);
15. sda.SelectCommand = cmdatabbase;
17. sda.Fill(dbdataset);
19. bsource.DataSource = dbdataset;
20. dataGridView1.DataSource = bsource;
21. }
22. catch (Exception ex)
23. {
24. MessageBox.Show(ex.ToString());
25. }