C# Discussion Boards - CodeProject

Thanks Christian but I tried doing what you said let me just copy paste my code

DataSet ComboboxLicencegrpID;

ComboboxLicencegrpID = CombolicencegrpID();
this.LicensegrpIDBox.DataSource = ComboboxLicencegrpID.Tables["comboLicenseGroupID"];

public DataSet CombolicencegrpID()
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();

cmd.CommandType = CommandType.Text;
cmd.CommandText = "select Name,LicenseGroupID from webqa_state.dbo.METADATA_LicenseGroups";
cmd.Connection = DBConnection.getConnection();
da.SelectCommand = cmd;
da.Fill(ds, "comboLicenseGroupID");
return ds;
}

Its giving me an outputlike this :-

In the Combobox all values are the same and its "System.Data.DataRowView"

What can be the problem ???

Sorry, I missed a step. There's a property you set to tell it what property to read out of each data item, such as a row name. Otherwise, it displays the ToString of the object. I think it's DataTextField or something.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

It worked I have to use this which i was missing Smile | :)

combobox.Displaymember = "Name";
combobox.Valuemember = "Name";

Thanks !

*grin* that's it. I think the property I told you was the one for web forms, sorry.

Value member does not need to be set, unless you want to set a value, usually an Id, not a string.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I am able to retrive the values but I have to display in the combo box like this "Name[UserID ]"

sam[1003]
dan[2003]

If I am writing as below, It will diplay any one of these ..

combobox.Displaymember = "Name";
combobox.Valuemember = "Name";

combobox.Displaymember = "userID";
combobox.Valuemember = "userID";

What should you think I should do to get the desired result ???

you need to add a new column which contains the data in the format you want to display it. You can't format a value directly from multiple fields.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I did not get it if possible can you provide me some code or little more detail. I tried this

while fetching the Data I Pass the Querry Like that

"Select ID,('['+ID+']'+EnpName) As FullDeatils form Emp"

Then while DataBinding, just Give like that

combobox.Displaymember = "FullDeatils ";
combobox.Valuemember = "ID";

now

Its giving an SqlException stating "Conversion failed when converting the varchar value '[' to data type int "

Frown | :(

Was able to solve actually had to cast it

select '['+CAST(ID As varchar(20))+'] '+Name As FullDetails from Emp

Resolved Smile | :)

iam declaring property in one class and using this property i want to
get a value from one page and set it to other page iwant an example code.

with regards
priya

priya

I suspect that your use of the word 'page' means you meant to ask this in the ASP.NET forum.

You can't get values from pages, only the page you're viewing exists on the server, and only just before the client sees it. you can pass values between URLs using the querystring

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

So, I have IE hosted in a windows app. This app adds functionality to a website ( long story ). So, the website has an area for typing reports. The people generating reports, use Dragon Naturally Speaking.

In IE, they can double click on a word and can type to replace it, or speak to replace it. In my program, they can double click on a word and it selects. They can press delete to delete the word. If they type ( or speak ) it doesn't work. If they scroll to highlight the word, then it works, but not if they double click.

Does anyone know what's happening here ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Are you sure it's not losing focus for some ungodly reason? It could explain why it's not working properly.

My current favourite word is: I'm starting to run out of fav. words!

-SK Genius

Game Programming articles start -here[^]-

I thought it may be a focus issue, and perhaps it ultimately is, but what weird focus state means you have highlighted a word, the delete key deletes it, but other keys don't work ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Right, yeah *scratches head*

I do know of one other situation where stuff doesn't work properely in IE, here at CP. When I post messages, occasionaly the shortcut Ctrl+V doesn't work and i have to right click - paste instead, also sometimes the backspace or delete key will not work, I forget which. So it could just be some crazy stuff with IE although lets hope not

My current favourite word is: I'm starting to run out of fav. words!

-SK Genius

Game Programming articles start -here[^]-

Well, the crazy thing is, it works fine in IE, until it's embedded in my app. That's the point at which it's assumed to be MY problem.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I think it's IE gets screwed up when it is hosted by another application. For example if you use this[^] to host IE, you won't be able to navigate to another website.

Giorgi Dalakishvili

#region signature
my articles
#endregion

Yeah, that seems to me to be the case. I am just hoping there's a way around it. Sadly, googling 'internet explorer host keyboard focus' gives me a lot of useless stuff.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi All!
I've been trying to port my apps from VS6 to 64 bit.

When I use serialization to write classes to fie - what should be a 27mb data file becomes 459mb!
And it runs S-L-O-W.

There are no methods (functions) in the classes. Just data.
The data file was created the (EASY) old way by writing structs to a binary file.
I also tried that "marshall" thing - what a joke!
So, my question is how in the world do you write structs or classes to a file without tons of overhead?
I know I can use C++ native code but surely there must be a better way.
If not, can native code be compiled to 64 bit?

thanx for any responses
bigchump

bigchump wrote:
I've been trying to port my apps from VS6 to 64 bit.

One has to ask if you're porting to C#, or if you're just lost ?

bigchump wrote:
If not, can native code be compiled to 64 bit?

Yes.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

<blockquote class="FQ"><div class="FQA">Christian Graus wrote:</div>One has to ask if you're porting to C#, or if you're just lost ?</blockquote>

I've ported everything to C# and am generally pleased.
My business requires me to write my own programs.
I've been doing it for over 20 years using C and assy.
But I'm not any kind of expert and need some answers in plain English.
The help screens in VS8pro are virtually worthless to me. I don't understand the jargon AT ALL.
Never liked C++ and don't want to use it *IF* I don't have to...
It's really annoying to have my 32 bit machine run circles around my 64 bit stuff.
So back to my question, is it possible to create a custom database with C# that is compact and runs fast?

thanx
bigchump

bigchump wrote:
So back to my question, is it possible to create a custom database with C# that is compact and runs fast?

Wow - I didn't get that this was your question at all.

Why would you use a custom database ? SQL Server Express is free, there's an edition that actually embeds the DB in your app, or you can still use an Access MDB database. They will all run fast enough for most applications.

you can set the compiler to build 64 bit, but in C#, the default setting is for both, b/c the framework itself builds your final exe, unless you need to write 64 bit specific code, that seems the best option to me. In fact, I have found the only reason to specify 32 or 64 is to specify 32 to force 32 bit compatibility mode if needed.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Thanks Christian!
My database is over 20 years old and grows by about 512K every day.
I don't know anything about SQL except that I run circles around people who do use it.
My compiler is set to "any CPU" on my 64 bit machine. I understand all that stuff.
What I don't understand AT ALL is the inability to read/write a struct/class directly to disk without a whole lot of overhead involved.
I only get paid if I am the first one with the answer, therefore speed is critical.
From my perspective, this whole DOT NET thing is a throwback to the old "interpeter" days with this JIT thing.
I don't understand why the JIT compiler "chokes" (only at 64 bit, not at 32) the first time a large function is called.
I can write a native console app to retrive the data and write a small temp file that a C# app can then read.
The problem with that is the original 32 bit app is still faster and there's every indication that the native app is running @ 32 bits.
It's also likely that I've got my head screwed on backwards and am missing something simple.

thanx
bigchump

bigchump wrote:
My database is over 20 years old and grows by about 512K every day.

Oh, a custom format ?

bigchump wrote:
I don't know anything about SQL except that I run circles around people who do use it.

Well, if you're not using SQL, you're using some specialised code written for your purpose, no surprise it may work faster than a more generalised approach ( but still impressive )

bigchump wrote:
What I don't understand AT ALL is the inability to read/write a struct/class directly to disk without a whole lot of overhead involved.

Well, did C++ just write a class for you ? You can store a class the same as you did in C++, by writing code to stream the component parts, if you like. Serialisation actually works mostly for free, if you're only using simple types that know how to serialise themselves.

bigchump wrote:
I don't understand why the JIT compiler "chokes" (only at 64 bit, not at 32) the first time a large function is called.

Because it's compiling it. Why is your function so large ? What do you mean by 'chokes' ?

bigchump wrote:
It's also likely that I've got my head screwed on backwards and am missing something simple.

I suspect that I'm not fully understanding you just yet

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi Christian!

Christian Graus wrote:
bigchump wrote:
My database is over 20 years old and grows by about 512K every day.

Oh, a custom format ?
Yes, a relatively small file on HD is indexed to database on tape drives to find records that match.

bigchump wrote:
I don't know anything about SQL except that I run circles around people who do use it.

Well, if you're not using SQL, you're using some specialised code written for your purpose, no surprise it may work faster than a more generalised approach ( but still impressive )

There's no comparison to SQL. I wrote all the code many years ago before SQL even existed.

bigchump wrote:
What I don't understand AT ALL is the inability to read/write a struct/class directly to disk without a whole lot of overhead involved.

Well, did C++ just write a class for you ? You can store a class the same as you did in C++, by writing code to stream the component parts, if you like. Serialisation actually works mostly for free, if you're only using simple types that know how to serialise themselves.

IF I UNDERSTAND YOU, COMPONENT PARTS MEANS WRITING ONE ITEM AT A TIME TO A BINARY FILE.
The problem with that is one of these classes has over 1500 different items.
That would mean writing 1500 lines of code to write and another 1500 to read????

bigchump wrote:
I don't understand why the JIT compiler "chokes" (only at 64 bit, not at 32) the first time a large function is called.

Because it's compiling it. Why is your function so large ? What do you mean by 'chokes' ?

I tried breaking it down into several smaller functions. It just ran slower. "Chokes" means serious delay.
Why does it choke at only 64 bits and not at 32??????

bigchump wrote:
It's also likely that I've got my head screwed on backwards and am missing something simple.

I suspect that I'm not fully understanding you just yet

That's because I'm not a programmer by profession. It took me a while to figure out what "component parts" meant.

yes, in C++ you would write your own code that uses a stream to store the different properties you need to restore a class, and you'd write code to read the values back out and assign them to properties in a new class instance.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )