Re: Finding column names of a dataset?? - C# Discussion Boards

Re: Conversion of legacy COBOL

Paul Conrad31-Oct-07 13:55

Paul Conrad

31-Oct-07 13:55

busyone1 wrote:
Have you done this before

Thankfully, no. I have heard from others that have though Suspicious | :suss:

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Format Strings

mehrdadc4831-Oct-07 10:24

mehrdadc48

31-Oct-07 10:24

Hi,
How can I form my strings to be in two character format?
My strings is on or two characters, if it's two character so nothing should to be happened, if it's one char, a 0 char must be added to it.
with "If" statement I can implement this, but is it possible to define format for strings?

Best wishes

Re: Format Strings

pmarfleet31-Oct-07 10:29

pmarfleet

31-Oct-07 10:29

Yes, with something like:

String.Format("{0}0", mystring).Substring(0,2)

Paul Marfleet

Re: Format Strings

Anthony Mushrow31-Oct-07 10:46

Anthony Mushrow

31-Oct-07 10:46

You can also use string.PadLeft(totalWidth, char), or string.PadRight(totalWidth, char):

string myString = "9";<br />
string newString = myString.PadLeft(2, '0');

So newString would now equal "09".

Or with just the one string:

myString = myString.PadLeft(2, '0');

My current favourite word is: Waffle

Cheese is still good though.

Re: Format Strings

Luc Pattyn31-Oct-07 11:37

Luc Pattyn

31-Oct-07 11:37

And if it happens to be a hex number you want to show, use a width specifier as
in byte.ToString("X2")

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google

Binding with BindingSource

~~~Johnny~~~31-Oct-07 10:18

~~~Johnny~~~

31-Oct-07 10:18

I have a strnge situation thta I just can't understand, any help or leads would be appreciated

In my data layer I create BindingSource objects:

public abstract class SimpleObjects : System.Data.DataTable
{
protected BindingSource binding = new BindingSource();

protected void Init()
{
sqlAdap.SelectCommand = selectCommand;
sqlAdap.TableMappings.Add(tableMapping);
sqlAdap.FillSchema(this, SchemaType.Mapped);
binding.DataSource = this;
}
public BindingSource Binding
{
get { return binding; }
}
}

I make the BindingSource (binding) object available as a property for all my SimpleObjects for forms to use. Wrks well in most cases but my problem is sometimes the binding goes berzerk when I add DataRows to certain SimpleObjects and it seems to happen when you add rows to child Tables. What happens most of the time is a DataGridView showing a child object will show a row in blue but if I ask the currently binded Object to the BindingSource, it returns me usually the first row. This definitelly happens only if a DataRow was added. Not sure What is happenning and not sure what to do. Any help would be greatly appreciated.

Finding column names of a dataset??

Goalie3531-Oct-07 10:15

Goalie35

31-Oct-07 10:15

Is there a way to return the resultset of a stored procedure to a dataset and then programatically "read" the names of each column in the dataset?

So in other words, if a stored procedure returns 3 columns of data(customerID, customerName, and qtyOrdered) and I insert that data into a dataset, how could I set an array to read the names of each column. This way the final array would ultimately look like the following:
array[0] = "customerID";
array[1] = "customerName";
array[2] = "qtyOrdered";

Can this be done?
Thanks.
-Goalie35

Re: Finding column names of a dataset??

pmarfleet31-Oct-07 10:25

pmarfleet

31-Oct-07 10:25

Goalie35 wrote:
Is there a way to return the resultset of a stored procedure to a dataset and then programatically "read" the names of each column in the dataset?

DataSets don't have columns. DataSets act as a repository for DataTable objects. It is the DataTable objects that have columns.

Query the Columns collection of your DataTable to get the names of the columns.

Paul Marfleet

tabcontrol

8213001231-Oct-07 9:55

82130012

31-Oct-07 9:55

Hi friends Rose | [Rose]

I want writ a code that show a special tabpage when form load. How I can do it?
thanks

Re: tabcontrol

Hesham Amin31-Oct-07 11:36

Hesham Amin

31-Oct-07 11:36

this code selects the second tab on form load:

private void Form1_Load(object sender, EventArgs e)
{
    tabControl1.SelectedIndex = 1;
}

Hesham A. Amin
My blog

Applying Object values to another object dynamically

shwaguy31-Oct-07 9:30

shwaguy

31-Oct-07 9:30

-I am querying MS AD Objects and want to transfer the properties to my own object with as little code as possible.
-I know that there are other ways around this like creating an XLM table to store values but think that might be too much overhead.

-If I cannot do something like what is below I will have to write a line for each propertry I want to retrieve.

-If I simply copy(not sure how to do this, I dont want to keep running the query) the object I will not be able to see a list of available properties in my IDE.:

Any comments or help?

<br />
Class MyClass<br />
{<br />
        private string cn;<br />
        private string sn;<br />
<br />
        public void GetADObjectInfo(string dn)<br />
        {<br />
            DirectoryEntry entry = new DirectoryEntry("LDAP://"+ dn);<br />
            foreach (string strAttrName in entry.Properties.PropertyNames)<br />
            {<br />
                try<br />
                {<br />
                    //this is the part I want done dynamically<br />
                    this.strAttrName =  (string)result.Properties[strAttName][0];               }<br />
                catch<br />
                {<br />
                }<br />
            }<br />
          }<br />
}<br />

with Regards,

shwa guy

Re: Applying Object values to another object dynamically

eggsovereasy31-Oct-07 10:30

eggsovereasy

31-Oct-07 10:30

<br />
public class MyClass<br />
{<br />
  private readonly Dictionary<string, string> properties = new Dictionary<string, string>();<br />
<br />
  public string this[string name]<br />
  {<br />
    get { return properties[name]; }<br />
    set<br />
    {<br />
      if (properties.ContainsKey(name))<br />
        properties[name] = value;<br />
      else<br />
        properties.Add(name, value);<br />
    }<br />
  }<br />
<br />
  public void GetADObjectInfo(string dn)<br />
  {<br />
    DirectoryEntry entry = new DirectoryEntry("LDAP://" + dn);<br />
<br />
    foreach (string strAttrName in entry.Properties.PropertyNames)<br />
    {<br />
      this[strAttrName] = entry.Properties[strAttrName][0] as string;<br />
    }<br />
  }<br />
}<br />

Then access it like:

<br />
string myString = MyClass["PropertyName"];<br />

But you can't get it strongly typed (MyClass.PropertyName) without doing it one at a time I think.

Debug Application Plug-in

CJ131-Oct-07 8:42

CJ1

31-Oct-07 8:42

I have an application that uses C# as the script language. The C# is compiled on the fly from within the application and executed.

I would like to be able to allow the user to debug their C# code from within my application.

I read an article somewhere on this a year or two ago and I can't fint it any more and I can't remember where.

I remember that it was just a slight variation on the standard CodeDom Compile-Load sequence. Searched MSDN and several other sites, but no luck.

Anyone know the answer?

Re: Debug Application Plug-in

Pete O'Hanlon31-Oct-07 11:31

Pete O'Hanlon

31-Oct-07 11:31

This[^] might help you with some information.

Deja View - the feeling that you've seen this post before.

Re: Debug Application Plug-in

Pete O'Hanlon31-Oct-07 11:40

Pete O'Hanlon

31-Oct-07 11:40

This[^] forum is also interesting.

Deja View - the feeling that you've seen this post before.

Re: Debug Application Plug-in

CJ11-Nov-07 4:47

CJ1

1-Nov-07 4:47

Thanks, the article does not apply, but the forum looks interesting.

arraylist as datagrid source [modified]

The Onslaught31-Oct-07 8:20

The Onslaught

31-Oct-07 8:20

When I bind a Datagrid to an arraylist (the items are strings), only one column
appears and it only shows me the lengths of the strings

Can anyone help me?

Thanks
-- modified at 14:41 Wednesday 31st October, 2007

After reading this message you will realize that you have wasted 5 seconds of your life

Re: arraylist as datagrid source

eggsovereasy31-Oct-07 9:00

eggsovereasy

31-Oct-07 9:00

Use List<string> instead.

Re: arraylist as datagrid source

The Onslaught1-Nov-07 6:48

The Onslaught

1-Nov-07 6:48

Thanks, but I need to use the Arraylist

Have you tried binding an arraylist to a datagrid?

I am using Microsoft Visual Studio 7.1

Thanks for the reply

Guarantee MainForm Focus on Startup

Sukhjinder_K31-Oct-07 8:19

Sukhjinder_K

31-Oct-07 8:19

How Can I Guarantee that my Application, upon its startup, Always Comes to Front and Has Input Focus no matter which application is currently having the Focus.

My MainForm is BorderLess, Maximized

Thanks...

Re: Guarantee MainForm Focus on Startup

Judah Gabriel Himango31-Oct-07 8:19

Judah Gabriel Himango

31-Oct-07 8:19

Set the Topmost property to true.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: No, Not I - A poem by Holocaust escapee, chief rabbi, and Messiah-follower Daniel Zion
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

how to turn a datatabel on sql interrogation ?

eraydeniz31-Oct-07 8:04

eraydeniz

31-Oct-07 8:04

Hi,

My Table

Column A Column B Columns C

Apple Apple Apricot

Pear Grape Peach

Grape Apricot

Banana

turn a datatable for below table With SQL (ColumA+ColumnB+ColumnC)

Apple 2 Unit
Pear 1 Unit
Grape 2 Unit
Banana 1 Unit
Aoricot 1 Unit
Peach 1 Unit

I want to turn a datatable with SQL this table.
Help me please, Thanks..

Re: how to turn a datatabel on sql interrogation ?

pmarfleet31-Oct-07 8:20

pmarfleet

31-Oct-07 8:20

Write a query that:

1. Uses the UNION operator to concatenate the data in columns A, B & C into 1 column.
2. Uses the GROUP BY clause and COUNT aggregate function to count the instances of each fruit.

Hope this helps.

Paul Marfleet

why does my meesage box take attention twice?

gizmokaka31-Oct-07 6:39

gizmokaka

31-Oct-07 6:39

Hello to all.

I guess I don't really understand how things(especially threads).

I have a function that runs in a separate thread then the rest of my application.

in the end of the function I print to a messageBox info I need for debugging.

the problem is I get to the messageBox twice.

the function is:

private void checkProblematicValves()
        {
            int dCount = 0;
            int numMessagesLost = 0;
            if (valveCheckedListBox.InvokeRequired)
                {
                    checkProblematicValvesHendler d = new checkProblematicValvesHendler(checkProblematicValves);
                    valveCheckedListBox.Invoke(d);
                }    
            else
            {
                foreach (long key in messageArr.Keys)
                {
                    if (messageArr[key] != null)
                    {


                        doing some stuff here!!!!!!!!!!!!!!

                            
                    }
                }
            }
            MessageBox.Show(numMessagesLost.ToString());
        }

I get to this "MessageBox.Show(numMessagesLost.ToString());" line twice, once with a true value
that prints to messageBox and right after I return to the same spot and it prints 0;

Can any one explain to me how come????

thanks in advanced.

Re: why does my meesage box take attention twice?

gizmokaka31-Oct-07 6:49

gizmokaka

31-Oct-07 6:49

Sorry for the stupid question, I realized my problem Smile | :)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.