How to connect SQL Server database to Windows Form Apps

Question

How to connect SQL Server database to Windows Form Applications. I am trying to connect to Data Grid View. But It is showing Exception Error to Open Connection. Please Help Me to Create Application. I am uploaded source code to here: I am using Visual Studio Community 2015.

Rafnas T P · Answer

first open sql server management studio and check whether it is connecting  if it is working then provide same server name and password to your code then check again

Chetan Ranpariya · Answer

Hi Prathamesh Thanks for sharing the error capture. There is nothing wrong in your code. The error shows that the SqlConnection is not able to connect to the SQL Server (.\SQLExpress) specified in the connection string. So you need to check if SQL Server is installed on your machine or not. If it's installed then you need to check if SQLExpress instance is running or not. https://msdn.microsoft.com/en-us/library/ms366339.aspx You also can check if you can connect to the .\SQLExpress from Server Explorer in Visual Studio. If nothing is installed on your machine then you need to install SQL Server or SQL Express on it. Below link explains how to install SQL Express. https://technet.microsoft.com/en-us/library/ms143722(v=sql.90).aspx Thanks and regards Chetan Ranpariya

Prathamesh More · Answer

Here the original source code with DataGridView. Help Me Please

Prathamesh More · Answer

I am getting this error

Mangesh Gaherwar · Answer

You have Sql server installled On Ur machine

Chetan Ranpariya · Answer

I do not see any code which is setting data sourc for data grid view. There is only one database related code which is inserting data in to table1 on bttnSaveCustomer_Click. So there is no code related to datagrid view. Did you try searching google about how to bind datagrid to the data from SQL? Did you try any of the solution provided in google search? Sorry Prathamesh but I think you are expecting a ready-made code provided to you by the developers here. Developers here will not provide you ready made solution. We can help you if you are getting error in the code you have written or improving your existing code. Thanks and regards Chetan Ranpariya

Chetan Ranpariya · Answer

Did you try writig any code? What error you are getting at ' Object of Connection : con.Open(); Can you share the code of connection and setting datasource of grid?

Chetan Ranpariya · Answer

What code you have written to load data from database to your grid? At which line you are getting error? What error ? Thanks and regards Chetan Ranpariya

Prathamesh More · Answer

Here it is!

Prathamesh More · Answer

Check out source code attached with this question

Prathamesh More · Answer

Object of Connection : con.Open(); How to attact grid view to SQL server database in form application