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

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

Christian Graus · Answer 1 · 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.

Krunal Rohit · Answer 2 · 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

sql database is not showing the full data

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

sql database is not showing the full data

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us