retrieve the result from select statment to dataGridView

Question

1.00/5 (4 votes)

See more:

XML

App.config
<?xml version="1.0"?>
<configuration>
  <connectionStrings>
    <add name="DBCS" connectionString="data source=.;Database=MnStores; Integrated Security = True"/>
  </connectionStrings>
</configuration>
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace MnStores
{
    public partial class Form1 : Form
    {
        public Form1()
        {   InitializeComponent();
            string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
            using (SqlConnection con = new SqlConnection(CS))
            {
                string command = "select * from tbl_CategoryProducts";
                SqlCommand cmd = new SqlCommand(command, con);
                cmd.Connection = con;
                con.Open();
                dataGridView1.DataSource = cmd.ExecuteReader();
                con.Close();
            }
        }

Posted 18-Mar-15 8:34am

Member 11280947

Updated 18-Mar-15 17:58pm

Sujith Karivelil

v4

Add a Solution

Comments

Thomas Daniels 18-Mar-15 14:38pm

What error do you get?

Dave Kreskowiak 18-Mar-15 14:42pm

Really!?!?!?! Think about this for a second. Put yourself in someones shoes. We can't see your screen, your hard drive, what you expect this code to do, ..., NOTHING. We're sitting here completely blind, reliant entirely on you to tell us about the problem and you haven't told us ANYTHING at all about it.

Now, how are we supposed to know what's wrong and what to look for?

[no name] 18-Mar-15 15:07pm

He can't be held liable, see here :) http://www.skidmore.edu/~pdwyer/e/eoc/help_vampire.htm

Dave Kreskowiak 18-Mar-15 15:13pm

Oh yes he can be held liable! >(

Participating in a forum environment carries the prerequisite that you can communicate with people and coherently convey a concept.

[no name] 18-Mar-15 15:13pm

Did you read it? ;)

Dave Kreskowiak 18-Mar-15 15:20pm

Read what? His code snippet?

Yes, but I NEVER assume what the error is because I may be able to see a ton of them but the poster may only be [not] "asking" about one particular problem.

[no name] 18-Mar-15 15:21pm

The site I linked :) (mostly the first half)

Dave Kreskowiak 18-Mar-15 16:53pm

Yeah, I've heard the term before. Sadly, there's really no solution to the problem.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vamshi Krishna Naidu · Accepted Answer · 2015-03-18T08:57:00

Try Below

C#

DataTable _dt = new DataTable();
using (SqlConnection sqlcon = new SqlConnection(ConStr))
{
     string sqlstr = "select * from tbl_CategoryProducts";
     using (SqlDataAdapter adap = new SqlDataAdapter(sqlstr, sqlcon))
     {
          adap.Fill(_dt);
          cmbProvider.DataSource = _dt;
     }
}

AVK