How can I populate my sql query results into a C# Datagridviewer

Question

UPDATE: This great answer from Steve https://stackoverflow.com/a/57692761/5758150 plus needing to include: Integrated Security=SSPI in my connection string has resolved this issue. Many thanks to all for their assistance.

I am a C# newb and this is my first project. The code is designed to query a sql server table and return the results into a datagridviewer on a windows Form. The form compiles with no errors but simply shows a blank datagridviewer.

Can anyone advise what I am doing wrong please? I have checked the server name db name etc and they are all correct.

using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using System;
using System.Data.SqlClient; //For SQL Connection


namespace Reference_Table_Updater
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }


    void GetList()
    {

        String strConnection = "server;" +
                   "Database='Scratchpad';";

        SqlConnection con = new SqlConnection(strConnection);

        SqlCommand sqlCmd = new SqlCommand();
        sqlCmd.Connection = con;
        sqlCmd.CommandType = CommandType.Text;
        sqlCmd.CommandText = "Select * from dbo.UPDATE_Test";
        SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd);

        DataTable dtRecord = new DataTable();
        sqlDataAdap.Fill(dtRecord);
        dataGridView1.DataSource = dtRecord;

    }

    private void Form1_Load()
    {
        GetList();
    }




}



}

Have you tried calling dataGridView1.Refresh(); after assigning datasource — sujith karivelil
– sujith karivelil, Commented Aug 28, 2019 at 12:32
The code seems to be correct. However that connectionstring seems to be a fake, In that form It shouldn't work but you should have an error when executing the Fill method. What is the real connectionstring? — Steve
– Steve, Commented Aug 28, 2019 at 12:38
String strConnection = "server= uk-DEV-dtwh-01\\WH02;" + "Database='Scratchpad';"; — Dave Edmonds
– Dave Edmonds, Commented Aug 28, 2019 at 12:41

Steve · Accepted Answer · 2019-08-28 12:57:13Z

1

That Form_Load is not correct. Probably you have added it manually and it is never called. Of course the grid is not filled.

To have your Form_Load called you need to bind it to the Load event

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
        this.Load += Form_Load;    
    }
    private void Form_Load(object sender, EventArgs e)
    {
        GetList();
    }

Of course, this binding of event handlers to events is usually done using the Form Designer, double clicking on the event that you want to handle. (and thus is not required to write the binding in your form constructor)

Now, your GetList should be called and if there are errors there they should be raised with an exception. The GetList code seems to be correct, unless there is a problem with the connectionstring or the database table.

edited Aug 28, 2019 at 12:57

answered Aug 28, 2019 at 12:45

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Dave Edmonds Over a year ago

Ok so this has got somewhere now but is throwing Additional information: Login failed for user ''. I am using windows auth so a bit confused.

Steve Over a year ago

If you use Windows Authentication then you shouldn't provide a username and a password.

Dave Edmonds Over a year ago

"Integrated Security=SSPI";

Steve Over a year ago

Yes but no username and password.

Jeremy Thompson Over a year ago

ConnectionStrings.com or create a UDL file and use it to create a connection string, then read the UDL file as a text file.

Rampage Programming · Accepted Answer · 2019-08-28 12:42:49Z

0

Here you need to use user and password String strConnection = "server;" + "Database='Scratchpad';"; Like this example: "SERVER=localhost; user id=root; password=; database=Scratchpad"; Or are you using windows autentication?

answered Aug 28, 2019 at 12:42

Rampage Programming

1161 silver badge10 bronze badges

2 Comments

Dave Edmonds Over a year ago

windows auth all the way mate

Dave Edmonds Over a year ago

Yes, please see the update at the top of the original post. Cheers.

Collectives™ on Stack Overflow

How can I populate my sql query results into a C# Datagridviewer

2 Answers 2

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related