C# Discussion Boards - CodeProject

Re: Getting Data from DataReader

8-Dec-07 3:12

Don't use the code below but:

someTextBox.Text = (string)someDataReader[0];

Really there are a lot of intermediary steps that need to be taken before something like this can be done in production code.

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

half-life8-Dec-07 6:38

half-life

8-Dec-07 6:38

<code>
TextBox.Text = DataReader.Get.....(...);
</code>

DataReader.Get... Has : GetString(),GetInt() and so on

while the the parameter in the Get...(...) is the Column number

Have Fun
Never forget it

Get Data From Data Reader!

tr_thorn8-Dec-07 2:55

tr_thorn

8-Dec-07 2:55

Hi how can i get from oledb or sql data reader data to messagebox or a Textbox ?

Can someone gimme an example.

solution for primary key

sajid.salim.khan8-Dec-07 2:45

sajid.salim.khan

8-Dec-07 2:45

The problem is that i have a primary key whose dbtype is Bigint i dont want to keep auto to generate the primary key in sql2000 table by code and return that value. Then when entering next record increment must be made to the previous number and inserted as a primary key
next question is if i delete any resord then how to sort the primary keys in ascending order
sas

Re: solution for primary key

Ennis Ray Lynch, Jr.8-Dec-07 2:51

Re: solution for primary key

8-Dec-07 2:51

@@Identity will give you the last identity from an insert statement. and SCOPE_Idendity() will give you the last value in an insert in your current scope.

Primary Keys are stored by the database in ascending order, usually, so they will always be sorted. I think what you be asking is for sequential primary keys by changing the identity_seed on a deletion. This is possible with the undocumented SQL 2000 system stored procedures but it is not recommended by MS.

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Mark Churchill9-Dec-07 3:38

Mark Churchill

9-Dec-07 3:38

You should create another column to satisfy your requirements of a contiguous numbering system. A primary key identifies the record and shouldn't change.

I wouldn't want to be dealing with Customer#1234 and then send an update to the database, but it turns out my Customer is now #1233 because someone deleted a record while. Customer#1234 (who is now Customer#1233) would be especially annoyed when his shipment of goods gets sent to the old Customer#1235, who is now Customer#1234. Wow. You can see what I'm getting at already!

Mark Churchill
Director
Dunn & Churchill
Diamond Binding: Zero to Data Layer in 3 mins

Sorting an Array

electriac8-Dec-07 1:37

8-Dec-07 1:37

I have an Array arraylist

arraylist.Sort(); sorts the array on character 0-end of each element of the array.

How do I make it sort on the 60th charaacter to the end of each element of the array.

Anthony Mushrow8-Dec-07 2:07

Anthony Mushrow

8-Dec-07 2:07

You could do a bubble sort yourself, its only a few lines of code. You could even make your own little function out of it.

My current favourite word is: Bauble!

-SK Genius

electriac8-Dec-07 2:17

Re: Sorting an Array [modified]

8-Dec-07 2:17

Could you show me an example of the few lines of code.

TNX

Anthony Mushrow8-Dec-07 2:25

Anthony Mushrow

8-Dec-07 2:25

Just a simple bubble sort. Say you had an array of numbers ranging from 1 - 10 in any order:

do {
 bool Continue;
 for(int i=0; i<array.length-1; i++) {
  if(array[i] > array[i+1]) {
    int temp = array[i];
    array[i] = array[i+1];
    array[i+1] = temp;
    Continue = true;
  }
 }
}while(Continue);

Of course to start at 60 and go to the end, you would just start int i at 60, rather than 0. If you have something like a string in your array, the string class has methods that compare two strings, so you'd need to check those out.

EDIT:Fixed the code, stupid < Roll eyes | :rolleyes:

My current favourite word is: Bauble!

-SK Genius

modified on Saturday, December 08, 2007 8:39:46 AM

electriac8-Dec-07 2:35

8-Dec-07 2:35

Yes it is a string. I have been able to solve the problem by writing the array to a text file unsorted.txt and then doing a DOS sort /+60 usorted.txt > sorted.txt and reading the file back into the array but thats really messy.

I will try to implement your suggestion

TNX

Ennis Ray Lynch, Jr.8-Dec-07 2:32

8-Dec-07 2:32

Write a comparer for the object you are storing int the array. Several of the .NET list objects will take, as a parameter to sort, the comparer to use. In fact, even if you don't pass one the default comparer will likely use your version.

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

electriac8-Dec-07 2:38

8-Dec-07 2:38

I have spent a whole day trying to write a comarer and make sence out of MSDN's convoluted instructions but have not been able to get something that compiles and works.

Ennis Ray Lynch, Jr.8-Dec-07 2:47

8-Dec-07 2:47

public class Foo : Comparer<foo> {
private string mMyString = new string('c', 100);
public override int Compare(Foo one, Foo two) {
return one.mMyString.Substring(59).CompareTo(two.mMyString.Substring(59));
}
}

Use System.Collections.Generic.List<foo> as the list.

Also, you may have to vary the code in the Compare method as I did not bother to test it.

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Re: Sorting an Array [modified]

Guffa8-Dec-07 3:55

Guffa

8-Dec-07 3:55

A comparer is pretty simple. It's just a class with a Compare method that works like any other Compare method (like string.Compare for example).

Try this:

class SubstringComparer : IComparer<string> {
   private int _offset, _len;
   public SubstringComparer(int offset, int len) { _offset = offset; _len = len; }
   public override int Compare(string x, string y) {
      return string.Compare(x, _offset, y, _offset, _len);
   }
}

Array.Sort(myArray, new SubstringComparer(59, int.MaxValue));

modified on Saturday, December 08, 2007 2:31:24 PM

electriac8-Dec-07 4:17

8-Dec-07 4:17

This is my code that will not compile.

<br />
<br />
<br />
 class SubstringComparer : IComparer<string> <br />
        {   <br />
            private int _offset, _len;   <br />
            public SubstringComparer(int offset, int len) <br />
            { <br />
                _offset = offset; _len = len; <br />
            }   <br />
            public override int Compare(string x, string y) <br />
  //---------------------------------------------------------<br />
  // I get no suitable method found to override Compare<br />
  //--------------------------------------------------------- <br />
            {      <br />
                return string.Compare(x, _offset, y, _offset, _len);   <br />
            }<br />
        }<br />
        <br />
        private void button13_Click(object sender, EventArgs e)<br />
        {<br />
            ArrayList arraylist = new ArrayList();<br />
            for (int i = 0; i < listBox1.Items.Count; i++)<br />
            {<br />
                string temp = listBox1.Items[i].ToString();<br />
                if (temp.Length>65)<br />
                {<br />
                        arraylist.Add(temp);<br />
                }<br />
            }<br />
            Array.Sort(arraylist, new SubstringComparer(59, int.MaxValue));<br />
            listBox1.Items.Clear();<br />
            for (int i = 0; i < arraylist.Count; i++)<br />
                listBox1.Items.Add(arraylist[i]);<br />
        }<br />
    }<br />

TNX for the help

modified on Saturday, December 08, 2007 10:45:32 AM

Luc Pattyn8-Dec-07 7:53

Luc Pattyn

8-Dec-07 7:53

Hi George,

there are basically two ways (old and new):

1.
if you want to sort an ArrayList in a special way, you need to create an object
that implements IComparer (without < string> ) and knows how to compare
two items. Its signature MUST be public int Compare(object obj1, object obj2)

There is no override, by writing ": Icomparer" you promise to implement the formentioned method.

And you need to cast the arguments to strings explicitly, as in:
string str1=(string)obj1

2.
Starting with .NET 2.0 you can also use generic collections.

The code Guffa showed you is fine if you keep the strings in a generic list, that is
a List< string>. In that case you inherit
from IComparer< string> and your Compare method takes string
arguments directly, but still there is no override involved.
The generics stuff basically makes all the castings redundant.

Regards,

Luc Pattyn [Forum Guidelines] [My Articles]

Sorry for any delays in replying, I currently don't get e-mail notifications.

electriac8-Dec-07 9:36

8-Dec-07 9:36

Is it possible that my problem is associated with the fact that I am using .NET 3.5 and Visual 2008.