sql database is not showing the full data

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

C#

SQL-Server

, +

Hi

this is my c# code in form

C#

public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
            SqlConnection connection = new SqlConnection();
            connection.ConnectionString = "Data Source=ASA-PC\\SQLEXPRESS; Initial Catalog=Material_database; User ID=sa;Password=sa;Integrated Security=false;Connect Timeout=10";

            connection.Open();

            SqlCommand command = new SqlCommand("select * from Code", connection);

            DataTable ds = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(command);
            cmbcode1.DataSource = ds;

            da.Fill(ds);
            cmbcode1.DisplayMember = "Codes";
            cmbcode1.ValueMember = "Codes";   

        }

in search button code is

C#

if (cmbcode1.SelectedIndex >= 0)
            {
                SqlConnection connection = new SqlConnection();
                connection.ConnectionString = "Data Source=ASA-PC\\SQLEXPRESS; Initial Catalog=Material_database; User ID=sa;Password=sa;Integrated Security=false;Connect Timeout=10";
                connection.Open();
                DataSet dl = new DataSet();
                string a = cmbcode1.SelectedValue.ToString();

                SqlCommand com = new SqlCommand("select * from Code where Codes='" + a + "'", connection);
                DataSet dts = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(com);
                dataGridView2.DataSource = dts;

                da.Fill(dts);
                dataGridView2.DataMember = dts.Tables[0].ToString();
            }

I need to get full data from database to datagridview .... but it just shows only one data
can you kindly help me to solve this problem?

Posted 23-Jan-14 16:43pm

Asa code

Updated 23-Jan-14 17:06pm

Christian Graus

v3

Add a Solution

2 solutions

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)

Krunal Rohit · Answer 1 · 2014-01-23T17:40:00

DataSet

C#

SqlCommand com = new SqlCommand("select * from Code where Codes='" + a + "'", connection);
DataSet dts = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(com);
da.Fill(dts);
dataGridView2.DataSource = dts.Tables[0];

DataTable

C#

SqlCommand com = new SqlCommand("select * from Code where Codes='" + a + "'", connection);
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable dt = new DataTable
da.Fill(dt);
dataGridView2.DataSource = dt;

You can either of the options to fill your gridview.!

Good Luck

Christian Graus · Answer 2 · 2014-01-23T16:54:00

DataSet dts = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(com);
                dataGridView2.DataSource = dts;

Where do you fill the data set using your connection ?

dataGridView2.DataMember = dts.Tables[0].ToString();

What ever you think this does, you are wildly mistaken.

I suggest that you both read up on SQL injection attacks, to fix your code at the core, and on how to use C# to access a database, because you clearly don't know. Overall, I'd suggest using entity framework instead, because it's perhaps more intuitive than using a straight data layer, and you're clearly lost right now.

Here[^] is an article on assigning data to a datagridview. After you work through it, if you're still stuck, by all means, ask more questions and we'd love to help.

sql database is not showing the full data

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0