Re: Enter Valued in Combobox from database - C# Discussion Boards

Yeah, it came to me while I was typing Smile | :)

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'm becoming crazy for this problem...then I must rename a file on a FTP, I've tried with the .NET framework integrated classes but I didn't resolve the problem.
Can you help me?...THX

Bye

You don't really rename files, you Move them with a different name, like:
File.Move("\\myfile.txt", "\\myNewFile.txt");

Does that help you out?

Not sure exactly what you'd do with FTP, but it should be the same kinda thing.

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

-SK Genius

Game Programming articles start -here[^]-

Here you are:
FTPWebRequest[^]

WebRequestMethods.Ftp.Rename[^]

Giorgi Dalakishvili

#region signature
my articles
#endregion

THX, but i've already tried this solution...else?? THX

Bye

Can you please provide me a code snippet or link where I can find out how to retrive values from datbase into combo box ?
Thanks

You get the values from the database, then make the data set you get back the data source for the combo box.

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 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