Re: C# Populate Multi column (2) combobox with existing dataset (hide record #) - C# Discussion Boards

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

26-Jan-09 1:32

Thank you Dave.

I beleive that should do the trick.

WHEELS

Wheels01228-Jan-09 2:05

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 2:05

Hi Dave.

I have the following code:

ds = d.GeneralDropDown("Dept");

foreach (DataRow dr in ds.Tables[0].Rows)
{
//cboDeptID.Items.Add(dr[constrDeptID].ToString());
//cboDepartment.Items.Add(dr[constrDeptID].ToString() + " " + dr[constrDeptColumn].ToString());
cboDepartment.Items.Add(dr[constrDeptColumn].ToString());
cboDepartment.DisplayMember = dr[constrDeptColumn].ToString();
cboDepartment.ValueMember = dr[constrDeptID].ToString();
}

private void cboDeptID_SelectedIndexChanged(object sender, EventArgs e)
{
//ds = new DataSet();
//ds = d.FillDataGrid(this.cboDepartment,this.cboAcronym);
MessageBox.Show(this.cboDepartment.ValueMember);
MessageBox.Show(this.cboDepartment.DisplayMember);
}

Am I using the DisplayMemeber and ValueMember correctly? The combobox is poppulated, but the MessageBoxes don't come up when the value in the combobox changes.

Any ideas? WHEELS

DaveyM6928-Jan-09 7:08

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 7:08

There's no need to add your items in a loop, just assign the combo's DataSource to the DataSet's DataTable (ds.Tables[0]) and set the DisplayMember and ValueMember to the table's respective ColumnNames and that should fill the combo.

To get the value just get the combobox's SelectedValue. Working example below Smile | :)

void InitializeCombo()
{
    // Constructing data set in code, obviously this would come from your DAL
    DataSet ds = new DataSet();
    ds.Tables.Add();
    ds.Tables[0].Columns.Add("ID");
    ds.Tables[0].Columns.Add("Display");
    ds.Tables[0].Rows.Add(new object[] { 1, "One" });
    ds.Tables[0].Rows.Add(new object[] { 2, "Two" });
    ds.Tables[0].Rows.Add(new object[] { 3, "Three" });
    ds.Tables[0].Rows.Add(new object[] { 4, "Four" });
    ds.Tables[0].Rows.Add(new object[] { 5, "Five" });
    // the next three lines fill your combo and set the members
    comboBox1.DataSource = ds.Tables[0];
    comboBox1.DisplayMember = "Display";
    comboBox1.ValueMember = "ID";
    // subscribe to SelectedIndexChanged event
    comboBox1.SelectedIndexChanged += new EventHandler(
        comboBox1_SelectedIndexChanged);
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    MessageBox.Show(comboBox1.SelectedValue.ToString());
}

P.S. There's no need for all the x.ToString()s that you have everywhere!

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Wheels01228-Jan-09 8:37

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 8:37

Thank you Dave.

I greatly appreciate you help.

WHEELS

DaveyM6928-Jan-09 9:41

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 9:41

No problem, that's what's these forums and all the users are here for Big Grin | :-D

Any more problems, just post back.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

DaveyM6930-Jan-09 9:28

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

30-Jan-09 9:28

Did you get it working OK?

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Wheels01230-Jan-09 9:31

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

30-Jan-09 9:31

Hi Dave.

I am on a differwnt project, but we experiment with the code using the dataset from the DAL layer next Wednesday.

Have a great weekend,

DAVE

Wheels0124-Feb-09 2:47

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

4-Feb-09 2:47

Hi Dave.

Finding it challenging to get it working.

I have a form with a comboBox and the following code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
const string constrLetterColumn = "Letter";
const string constrDeptID = "DeptID";
const string constrDeptColumn = "Department";
const string constrExpandColumn = "Expansion";

DAL d = new DAL();
DataSet ds;
DataTable dt;

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
}

void InitializeCombo()
{
// Constructing data set in code, obviously this would come from your DAL
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("ID");
ds.Tables[0].Columns.Add("Display");
ds.Tables[0].Rows.Add(new object[] { 1, "One" });
ds.Tables[0].Rows.Add(new object[] { 2, "Two" });
ds.Tables[0].Rows.Add(new object[] { 3, "Three" });
ds.Tables[0].Rows.Add(new object[] { 4, "Four" });
ds.Tables[0].Rows.Add(new object[] { 5, "Five" });
// the next three lines fill your combo and set the members
comboBox1.DataSource = ds.Tables[0];
comboBox1.DisplayMember = "Display";
comboBox1.ValueMember = "ID";
// subscribe to SelectedIndexChanged event
comboBox1.SelectedIndexChanged += new EventHandler(comboBox1_SelectedIndexChanged);
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
MessageBox.Show(comboBox1.SelectedValue.ToString());
}
}
}

Where am I going wrong?

WHEELS

Wheels0124-Feb-09 8:08

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

4-Feb-09 8:08

HI Dave.

I had a coworker work with me on the code.

It works well.

When I cut and pasted some code from another project, it didn't work because I was missing an event handler.

Thank you,

DAVE

DaveyM694-Feb-09 13:16

Splash Screen / Init question

4-Feb-09 13:16

Cool - glad to help Big Grin | :-D

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

EliottA23-Jan-09 8:50

EliottA

23-Jan-09 8:50

Hello all, sometimes the easiest things are the things you oversee the most.

I have an application, it's generally finished so-to speak. Now all that's left is just general cosmetics. My question lies herein; I have a splash screen. I want to put a progress bar on it to keep the user occupied while initialization and connections are established. My question is, how would I upgrade the progress bar so it actually reflects true progress of loading? This includes downloading tables from MySQL DB (and establishing a connection), loading RSS feeds etc.

How would you go about it, AFAIK there isn't a callback to determine how much data from a table has been loaded or how many feeds out of x have been downloaded.

Direction?

Re: Splash Screen / Init question

DaveyM6923-Jan-09 9:10

Re: Splash Screen / Init question

23-Jan-09 9:10

I think that's why progress bars never seem to progress evenly but jump around.
Easy solution is to set the style to Marquee then you're just indicating that it's doing something... but not how much.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

User 665823-Jan-09 10:01

User 6658

23-Jan-09 10:01

Additionally to what Dave said, you might split up the loading process into steps like:

- 10% Initializing GUI
- 40% Loading DB
- 30% Downloading feeds
- 20% Calculating some stuff

Of course this will not be accurate, but there's not much you can do against it, it too much depends on the internet/DB connection and lots of other stuff.
If your DB driver supports it, then you can at least find out how many rows have already been fetched.

regards

modified 12-Sep-18 21:01pm.

Error: RegularExpression can't be found [modified]

u060509423-Jan-09 8:35

23-Jan-09 8:35

This is my 1st time doing a C# assignment for my sch, and i need some string matching function...
Why am I getting this error and how do I solve it?

re.cs(2,19): error CS0234: The type or namespace name 'RegularExpressions' does
not exist in the namespace 'System.Text' (are you missing an assembly
reference?)

Thanks...

[Updated: I actually alr added "using System.Text.RegularExpressions; using System;", tt's why I am puzzled y cannot]

modified on Friday, January 23, 2009 2:44 PM

DaveyM6923-Jan-09 8:41

23-Jan-09 8:41

Add this to the usings at the top of your .cs file
using System.Text.RegularExpressions;
or use that followed by . to access the classes in that namespace.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

u060509423-Jan-09 8:43

23-Jan-09 8:43

Actually I got these alr:
using System.Text.RegularExpressions;
using System;

but cannot...

DaveyM6923-Jan-09 8:51

23-Jan-09 8:51

Check your project references and make sure you have System there (System.dll), if not, add it.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

u060509423-Jan-09 8:57

23-Jan-09 8:57

Where to check? I am editing using Notepad++ and running using cmd.
If cannot find how to add?

DaveyM6923-Jan-09 9:06

23-Jan-09 9:06

Sorry - out of my realm there, I use Visual Studio to handle all this stuff for me!
There's some 'hardcore' people around on these forums that like to do stuff without an IDE, wait for one of them to help you - or download Visual C# Express[^] for free and get a shiny IDE.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

PIEBALDconsult23-Jan-09 9:43

PIEBALDconsult

23-Jan-09 9:43

DaveyM69 wrote:
wait for one of them

You rang?

DaveyM6923-Jan-09 10:05

23-Jan-09 10:05

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

u060509423-Jan-09 16:53

23-Jan-09 16:53

I actually had Visual Studio installed alr, but cos current one is a small assignment, so I thought no need to use.
The System.dll is automatically added to my project references. Will come in handy for future big assignments.

User 665823-Jan-09 9:48

User 6658

23-Jan-09 9:48

using System.Text.RegularExpressions;
using System;

namespace Test
{
	public class Test
	{
		public static void Main(string[] args)
		{
			Console.WriteLine("Hello");
			
			Console.ReadKey();
		}
	}
}

This compiles prefectly for me just using this without any parameters:

csc test.cs

/edit: And yes, it tested it using pure 'hardcore' notepad++ (well, at least it has syntax highlighting!) and cmd OMG | :OMG:

modified 12-Sep-18 21:01pm.

PIEBALDconsult23-Jan-09 12:42

PIEBALDconsult

23-Jan-09 12:42

So what's the problem?

u060509423-Jan-09 16:46