Re: Help With DataSets - C# Discussion Boards

jparsons22-Jul-02 5:30

22-Jul-02 5:30

I've run into a problem like this before with a server i wrote. I couldn't find any elegant solution. Logic tells you that you should be able to make this class but for some reason it won't allow it. What I ended up doing was creating an Array of the more specific type ( PADS.InventoryRow ) and then manually putting every element from the array returned from select into the more sepcific array.

If you find an easier way to od that please post it.

Jared
jparsons@jparsons.org
www.prism.gatech.edu/~gte477n

Re: Typed DataSets and casing problems

Andrew Connell22-Jul-02 6:55

Andrew Connell

22-Jul-02 6:55

Yikes!

That's something I definatley don't want to get into. I'd much rather deal with the native DataRow objects than manually add each item into the typed object. That seems like a TON of overhead. If I find anything I'll be sure to post it.

In the meantime, I'm investigating MAPPING and merging the two different types. If I can do that in my data access layer/components, and just continue on with the application development, then I'm fine with that.

Andrew Connell, MCDBA
IM on MSN
andrew@aconnell.com

Scrolling in a RichTexBox

jpeg22-Jul-02 3:51

jpeg

22-Jul-02 3:51

I'm trying to develop my first C# app. I chose to develop a chat software because I wanted to use the sockets' classes.
I've develop a chat server and a chat client. In the last one, I have to display the incoming messages in a RichTextBox control.
The problem is that it doesn't automatically scroll to the end of this control when I append a text.

The piece of code is :

int index=dialogTextBox.TextLength;
dialogTextBox.AppendText(message+"\r\n");
dialogTextBox.Select(index, message.Length);
dialogTextBox.SelectionColor=myColor;

(NB : its append a new line using the 'myColor' color)

I tried to use the ScrollToCaret but it doesn't work.

Please help me !

jpeg

Re: Scrolling in a RichTexBox

Steven Behnke22-Jul-02 7:30

Steven Behnke

22-Jul-02 7:30

All you will need to do is...

int index=dialogTextBox.TextLength;
dialogTextBox.AppendText(message+"\r\n");

// Inserted here
dialogTextBox.Focus();

dialogTextBox.Select(index, message.Length);
dialogTextBox.SelectionColor=myColor;

// Focus your entry box back again here.

Or you can write an On Text Changed handler, like I had to that will focus the box, scroll to the caret, then focus back to the entry. You will have to do this if you are adding text to the box from a thread that you created to read from the socket like I did. Doh!

-Steven

Re: Scrolling in a RichTexBox

jpeg22-Jul-02 21:37

jpeg

22-Jul-02 21:37

Thanks for your help.

As you said in your answer, my updating functions were called from a thread (a thread which is waiting for messages from the server). So I added a handling method for my dialogTextBox's TextChange Event to use these updating functions instead of calling them in the thread and it works !

Therefore this problem is quite strange, don't you think ?
Why can you add a text to a textbox and can't scroll to the end ?

Re: Scrolling in a RichTexBox

Steven Behnke23-Jul-02 4:09

Steven Behnke

23-Jul-02 4:09

It is a little strange. I had even tried passing the parent object as a part of a setup function, and then calling a method on that object to focus the object, but still no go. For some reason it appears that .Focus() doesn't function inside of a subthread.

Help With DataSets

Li Mu Bai22-Jul-02 3:14

Li Mu Bai

22-Jul-02 3:14

Hello

[WebMethod Description="Returns true if User ID in Database")]
public bool isUserIdValid( int nUserID )
{
DataSet myData = new DataSet();

sqlDataAdapter1.SelectCommand.Parameters["@userID"].Value = nUserID;

sqlDataAdapter1.Fill( myData, "UserID");

myData.Tables[????

return true;
}

Lets say we have a web method such as the one above, it calls a stored procedure on an sql database and returns an int, 0 if user id invalid, or the value of the user id if valid.

So, Ive passed the @userid to the sqlDataAdapter and filled a dataset ie myData with the results.

How do I now get at the data in the DataSet myData ive just created?????

Please help with code required to get the value returned by the stored procedure
Regards

Li Mu Bai
Wudan Master (Deceased)

Re: Help With DataSets

Roger Stewart23-Jul-02 6:12

Roger Stewart

23-Jul-02 6:12

Li Mu Bai wrote:
How do I now get at the data in the DataSet myData ive just created?????

Have you tried to access the data like so:
myData.Tables["UserID"]

So your code could possibly look something like:

[WebMethod Description="Returns true if User ID in Database")]
public bool isUserIdValid( int nUserID )
{
   DataSet myData = new DataSet();

   sqlDataAdapter1.SelectCommand.Parameters["@userID"].Value = nUserID;

   // Check to make sure the stored proc returned rows,
   // otherwise accessing the ds could throw an exception.
   //
   if ( sqlDataAdapter1.Fill( myData, "UserID") > 0 )
   {
      // Validate the returned ID. If the value is not 0
      // then the user is valid.
      //
      if ( myData.Tables["UserID"] != 0 )
      {
         return true;
      }
   }
<br><br>
   return false;
}

Roger Stewart
"I Owe, I Owe, it's off to work I go..."

DataSet

Li Mu Bai22-Jul-02 1:38

Li Mu Bai

22-Jul-02 1:38

Hi guys,

I just want to read a field in a column in a dataset.
I dont want to fill a grid, i just want to check one filed for a value???

Regards

Re: DataSet

James T. Johnson22-Jul-02 1:55

James T. Johnson

22-Jul-02 1:55

And your question is what?

I'm going to assume it is how you read a field in a dataset.

First, get the proper DataTable out of the Tables property of the DataSet; then find the appropriate Row in the Rows property of the DataTable, finally read the appropriate column out of that.

James
"Java is free - and worth every penny." - Christian Graus

Installing CollectionGen - How I did it

James T. Johnson22-Jul-02 0:44

James T. Johnson

22-Jul-02 0:44

If you don't have Visual C# (ie you purchased VB.NET standard) then you're out of luck with this tool since it was created with C#. It is also a tool created for use with VS.NET, so you are also out of luck if you aren't using VS.NET.

When I did a reinstall of CollectionGen a few minutes ago I took a look at the readme file and found that it was missing a few steps.

First off download it from the link above, then unzip it to the directory of your choice (this will be the final resting place for it so place it where you want it).

Now open the CollectionGen solution file (CollectionGen.sln) you will probably get some errors about not being able to find the Visual Source Safe server; just tell it ok to get through the warnings.

Now if you don't don't have VB.NET, remove the vbtestcli project from the solution [right click on it and choose remove, tell it to overwrite the solution file if it complains about being read-only].

This is where the readme is missing some steps.

Right click on the CollectionGen project, and choose "Add Reference..." click the Browse button and browse to the Microsoft Visual Studio .NET\Common7\IDE directory select the "Microsoft.VSDesigner.dll" file. 'Ok' back to the main IDE. Now right click on the testcli project and choose "Add Reference...", click Browse, and browse back to that directory again. Select the "Microsoft.VSDesigner.dll" file, then click Browse again; this time selecing the "microsoft.visualstudio.designer.interfaces.dll" file. Again, click OK back to the main IDE.

Now that that is done, change the combobox at the top of the IDE to say Release instead of Debug and build the solution.

Using the Command Prompt provided by VS.NET (look in VS.NET's Tools program group in the start menu) run the setup.bat file located in the CollectionGen\redist.

That should be all you have to do Smile | :)

To test it right click on one of the XML files in the testcli project and choose "Run Custom Tool". If all goes well you'll see VS.NET work for a bit then nothing will happen. That is good!

Now to use it in your own program simply create an XML file of the same format as listed in the readme file. Add that file to your project, then change the "Custom Tool" property to "SBCollectionGenerator".

Thats it Smile | :)

James
"Java is free - and worth every penny." - Christian Graus

Re: Installing CollectionGen - How I did it

Nish Nishant22-Jul-02 3:46

Nish Nishant

22-Jul-02 3:46

Ummmmmm, maybe I am trying to win the stupidity contest of the month, but uh, what is this collectiongen thingie?

Nish

p.s. Am at work. means my b/w is way way too limited for me to actually download it and try it out Sleepy | :zzz:

Author of the romantic comedy

Summer Love and Some more Cricket [New Win]

Review by Shog⁹
Click here for review[NW]

Re: Installing CollectionGen - How I did it

James T. Johnson22-Jul-02 6:44

James T. Johnson

22-Jul-02 6:44

Nishant S wrote:
what is this collectiongen thingie

Strongly typed collection generator for VS.NET.

Essentially you have an XML file that specifies the types and what kind of collection to generate and it does so. If you want to support a new type of collection its as simple as creating a new XSLT file and adding it to the project and recompiling CollectionGen.

James
"Java is free - and worth every penny." - Christian Graus

Video Capture Hardware?

Steven Behnke21-Jul-02 21:08

Steven Behnke

21-Jul-02 21:08

Does anyone know how to generate an enum of the video capture hardware, or how you would get other kind of information about hardware installed on a computer in C#?

Thanks,
Steven

Statusbar with 3 sliders???

Daniel Strigl21-Jul-02 21:07

Daniel Strigl

21-Jul-02 21:07

How can I create a statusbar with 3 panels with 3 sliders (in every panel 1 slider)?

Just like this:

Text... |---[Slider]---| |---[Slider]---| |---[Slider]---|

Re: Statusbar with 3 sliders???

SHaroz22-Jul-02 5:49

SHaroz

22-Jul-02 5:49

You should probably just make your own control, and make it look like a statusbar. When you add it to your form, just dock it to the bottom.

C# - language design by committee ???

Christian Graus21-Jul-02 12:55

Christian Graus

21-Jul-02 12:55

I mean, who decided that I could not do this ?

const int n = x+5;

And why can't I create a static method and use it from a class instance OR overload a method so that both the static and non-static versions exist ?

Who wrote this rubbish ?

Christian

come on all you MS suckups, defend your sugar-daddy now. - Chris Losinger - 11/07/2002

Re: C# - language design by committee ???

Rama Krishna Vavilala21-Jul-02 15:16

Rama Krishna Vavilala

21-Jul-02 15:16

Christian Graus wrote:
const int n = x+5;

I don't see any problem here.

Step back, rub your eyes, take a deep breath, stretch a bit, and reflect on the relative importance of CP, CG, the age / travel time sustained by supposedly 'fresh' cheese curds, and Life in General. - Shog⁹

Re: C# - language design by committee ???

Christian Graus21-Jul-02 15:28

Christian Graus

21-Jul-02 15:28

Nor do I, but the compiler will only accept

const int n = 5;

Christian

come on all you MS suckups, defend your sugar-daddy now. - Chris Losinger - 11/07/2002

Re: C# - language design by committee ???

Rama Krishna Vavilala21-Jul-02 15:38

Rama Krishna Vavilala

21-Jul-02 15:38

I meant to say that I don't see any problems with compiler not accepting it. You need to get over C+ mentality. there ain't no const variables only const constants.

Step back, rub your eyes, take a deep breath, stretch a bit, and reflect on the relative importance of CP, CG, the age / travel time sustained by supposedly 'fresh' cheese curds, and Life in General. - Shog⁹

Re: C# - language design by committee ???

Christian Graus21-Jul-02 15:40

Christian Graus

21-Jul-02 15:40

Rama Krishna wrote:
I meant to say that I don't see any problems with compiler not accepting it.

Thats cool. So why does my compiler not accept it ?

Rama Krishna wrote:
need to get over C+ mentality. there ain't no const variables only const constants.

That's really deep, but I have no idea what the hell it means. :P

Christian

come on all you MS suckups, defend your sugar-daddy now. - Chris Losinger - 11/07/2002

Re: C# - language design by committee ???

jparsons22-Jul-02 5:25

jparsons

22-Jul-02 5:25

A const in C# and the .NET framework is just that. A constant. When you create a constant in .NET it is not stored as a variable. Anywhere that it is used the value is copied directly into your code. So it makes sense that they will not allow you to use a variable in teh declaration of a constant.

Jared
jparsons@jparsons.org
www.prism.gatech.edu/~gte477n

Re: C# - language design by committee ???

Christian Graus22-Jul-02 12:17

Christian Graus

22-Jul-02 12:17

I'm not interested in the under the hood semantics ( I was actually reading up on them in the Richter book this morning ), I just want to know how to pass a variable into a function and then from that variable define another that is const for the life of the function call. const is an incredibly important part of programming in C++ because it allows me to specify that I want to be able to trust that a value has not changed. Does C# provide another mechanism for this in regard to function parameters, etc. ?

Christian

come on all you MS suckups, defend your sugar-daddy now. - Chris Losinger - 11/07/2002

Re: C# - language design by committee ???

Rama Krishna Vavilala22-Jul-02 5:37

Rama Krishna Vavilala

22-Jul-02 5:37

Christian Graus wrote:
That's really deep,

I was watching a movie when I wrote that.

Anyway,
const in C# is not same as const in C++.

These are valid bothe C# and C++

const int x = 200;
const int y = 200 + x;

But this is not

void func()
{
int x;
const int y = x + 10;
}

For the simple reason that compiler cannot calculate the value of y at compile time.

Step back, rub your eyes, take a deep breath, stretch a bit, and reflect on the relative importance of CP, CG, the age / travel time sustained by supposedly 'fresh' cheese curds, and Life in General. - Shog⁹

Re: C# - language design by committee ???

Christian Graus22-Jul-02 12:18

Christian Graus

22-Jul-02 12:18

OK then, how do I do what I want ? If the answer is I cannot then C# just plain sucks as far as this is concerned. I should be able to define a value from a variable passed into a function and mark it so that no code further down can modify the value.

Christian

come on all you MS suckups, defend your sugar-daddy now. - Chris Losinger - 11/07/2002

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