C# how to use table from sqlserver show in listbox. When select from listbox can edit in datagridview.

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

private void button4_Click(object sender, EventArgs e)
        {
            
            SqlConnection conn = new SqlConnection(this.connetionString);
            string sql = @"SELECT * from amd_err;";
            SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
            DataTable dt = new DataTable();         
            sda.Fill(dt);
                      
            this.listBox1.DataSource = result;
            this.listBox1.DataSource = dt;       
            listBox1.DisplayMember = "amd_err";

            //DataSet tblData = new DataSet();
            //string sql = @"SELECT * from amd_err;";
            //SqlConnection conn = new SqlConnection(this.connetionString);
            //SqlDataAdapter sda = new SqlDataAdapter(sql, conn);           
            //sda.Fill(tblData, "amd_err");
            //MessageBox.Show("Rows Count:   !" );           
            //bindingSource1.DataSource = tblData;          
            //dataGridView1.ReadOnly = true;

            //this.dataGridView1.DataSource = bindingSource1;
            //dataGridView1.DataMember = "amd_err";
            //this.dataGridView1.Refresh();

What I have tried:

<pre>using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace connectDatabase
{
    public partial class Form1 : Form
    {
        private string DBUID;
        private string DBPWD;
        private string DBSVR;
        private string DBNAME;
        private string connetionString;
        public Form1()
        {
            InitializeComponent();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void label4_Click(object sender, EventArgs e)
        {

        }

        private void button3_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void bindingSource1_CurrentChanged(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            
            this.DBSVR = DBSname.Text;
            this.DBPWD = DBPass.Text;
            this.DBUID = DBUname.Text;
            this.DBNAME = DBname.Text;
            SqlConnection cnn;
            connetionString = @"Data Source=" + this.DBSVR + ";Initial Catalog=" + this.DBNAME + ";User ID=" +this.DBUID+ ";Password="+ this.DBPWD+ ";";
            cnn = new SqlConnection(connetionString);

            try
            {
                cnn.Open();
            }catch (Exception ex) {
                
                MessageBox.Show("Connection Can't connect  !" + ex.Message);
                return;
            }
            MessageBox.Show("Connection Open  !");
            cnn.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            
            SqlConnection conn = new SqlConnection(this.connetionString);
            string sql = @"SELECT * from amd_err;";
            SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
            DataTable dt = new DataTable();         
            sda.Fill(dt);
                      
            this.listBox1.DataSource = result;
            this.listBox1.DataSource = dt;       
            listBox1.DisplayMember = "amd_err";

            //DataSet tblData = new DataSet();
            //string sql = @"SELECT * from amd_err;";
            //SqlConnection conn = new SqlConnection(this.connetionString);
            //SqlDataAdapter sda = new SqlDataAdapter(sql, conn);           
            //sda.Fill(tblData, "amd_err");
            //MessageBox.Show("Rows Count:   !" );           
            //bindingSource1.DataSource = tblData;          
            //dataGridView1.ReadOnly = true;

            //this.dataGridView1.DataSource = bindingSource1;
            //dataGridView1.DataMember = "amd_err";
            //this.dataGridView1.Refresh();
        }
    }
}

Posted 2-Jul-19 19:22pm

momothedog

Updated 2-Jul-19 23:43pm

Add a Solution

Comments

Sinisa Hajnal 3-Jul-19 2:18am

What is the problem with the code? What error do you get? Where?

[no name] 3-Jul-19 3:27am

One of those is probably redundant.

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)

OriginalGriff · Answer 1 · 2019-07-02T22:24:00

Solution 1

Probably, it's your DisplayMember setting that is wrong - that should be a column name, not the table name:

            string sql = @"SELECT * from amd_err;";
...
            listBox1.DisplayMember = "amd_err";

Posted 2-Jul-19 22:24pm

OriginalGriff

mohamedenew · Answer 2 · 2019-07-02T23:44:00

C#

//We can make seperated function to load data
private DataTable GetResult(string sqlStatment)
{
  SqlConnection conn = new SqlConnection(this.connetionString);
  SqlDataAdapter sda = new SqlDataAdapter(sqlStatment, conn);
  DataTable dt = new DataTable();         
  sda.Fill(dt);
  return dt
}

C#

this.listBox1.DataSource =this.GetResult("SELECT * from amd_err");
this.listBox1.ValueMember  = "ERROR_ID" //e.g. Column ID NAME;
this.listBox1.DisplayMember= "ERROR_DESC" //e.g. Colum description what user will see;