|
You need to data the data from the SqlDataReader and put it into a collection that implements either the IList or IListSource interface such as Dataset or Datatable.
|
|
|
|
|
use these instead of data reader
SqlDataAdapter da = new SqlDataAdapter(cm_combo);
DataTable dt = new DataTable("Table");
da.Fill(dt);
comboBox1.DataSource = dt;
comboBox1.DisplayMember = "au_lname";
comboBox1.ValueMember = "au_id";
|
|
|
|
|
better still, just after you execute your data reader, insert a do while loop to iterate all rows read (i.e:
if(dr_combo.HasRows())
{
do
{
comempnam.Add(dr_combo["Cust_Name"]);
// or if you choose to display the Cust_ID then:
//comempnam.Add(dr_combo["Cust_ID"]);
}
while (dr_combo.Read());
}
cn.close();
hopefully, this should work.
'Tilewa
-- modified at 12:38 Sunday 24th September, 2006
|
|
|
|
|
hi all,
i want to ask my question with this illustration:
i have a pen object. then color property (typeOf(String)) of this pen can be "white", "red"... and it possibly can change. and i don't want to save it into the database but it needs to be managed at runtime.i.e a combo box will pick its items from it and an admin can (using a UI)change thye available colors. can i save this enum in the config file? how do i save at design time and how do i modify at runtime?
Thanks for any suggestion
|
|
|
|
|
You can serialise any item, so long as it's marked as serialisable, and can be rendered to and from a string. An enum will be fine in this regard.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks. But i think you are getting my question wrongly.
A pecil object has a Color property, TypeOfEraser property, Thickness(H,HB,B..) property..
Each of these properties are enumerable: Color.White, Color.Green...; TypeOfEraser.Big,TypeOfEraser.Red...; Thickness.H,Thickness.HB...; and these enumerations can be altered by an administrator of the app. rather than pull/push these values into an SQL db, i ask if it is better to save them in a config file. Now this means i'll have to be able to read the config file at runtime and persist changes too.
please how do i go aboout this?
thanks
'Tilewa.
|
|
|
|
|
As Christian said, you can serialize your object (Pencil in your case) to a file and read it back without writing any custom code.
Just mark your class with the [Serializable] attribute and you're ready to go. You need to make sure that types of member variables (and their members, essentially the whole object graph) is marked as [Serializable]. <code>Enum</code>s are serializable , so you won't have any problems there.
|
|
|
|
|
Hi!
How can i work with the Windows Media player control on my form i mean not in Asynchronously mode, how can i load it playlist or one sonf, and how can i play it?
Thanks 
|
|
|
|
|
add mediaplayer into your toolbox.after that use of its property and events .
set axWindowsMediaPlayer1.URL= "Address of your mp3 or audio file" to run the mediaplayer.<br />
<br />
for stop :<br />
axWindowsMediaPlayer1.Ctlcontrols.stop()<br />
<br />
and other properties and events
|
|
|
|
|
i need these dll but i couldnt find them !!! how could i use them?
DLL:<br />
<br />
Microsoft.DirectX<br />
Microsoft.DirectX.AudioVideoPlayback<br />
Microsoft.DirectX.Diagnostic<br />
Microsoft.DirectX.DirectSound
|
|
|
|
|
They are part of the DirectX SDK. You'll need to download and install it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Nafiseh Salmani wrote: is that what you say?!!
Gee, does it LOOK like what I said ?
I recommend in future if people give you advice, you take the terminology they use and google it. You still need to download the DirectX SDK. .NET framework and DirectX are two different things, that's why they are spelled differently.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
  .
|
|
|
|
|
Thanks , i install it and find those Dll .;)
|
|
|
|
|
What method in C# to View Text File ?
Thanks !!
|
|
|
|
|
View a text file? You mean launch a .txt file with the program currently associated with .txt files? That would be System.Diagnostics.Process.Start. Or do you mean show the contents of a text file inside your own Windows Form? For that, you just need to read the text of the file in using System.IO.File.ReadAllText, then put that text into a textbox on your form.
|
|
|
|
|
Thanks !!
Can U give me any example?
|
|
|
|
|
Can you first tell me what you're trying to do? Are you trying to launch a .txt file or show its contents in your own form?
|
|
|
|
|
I want to lauch a .txt, .doc, .xls File in my form
thanks for help !!
|
|
|
|
|
System.Diagnostics.Process.Start("c:\thefile.doc");
|
|
|
|
|
sottos wrote: in my form
Does that mean that your form launches a new form that shows the file, or do you want to view Word and Excel files within your app ( that is, within your program window ) ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
within my program window .. Great!!!
Thannks !!!
|
|
|
|
|
OK - I thought so. This will become possible with the new XML formats for Office 2007, in the meantime, the best you can do is to use COM or ( for the newer versions ) .NET to embed/control Excel/Word within your app. It can't be done so that it works for PCs without office installed.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hey guys,
My question is simple. How do I delete repeating characters? Say I have the string "Hello World" and after deleting ALL repeating characters (not just adjacent ones) the new string would be HeloWrd. I'm thinking of using a nested 'for' loop to compare each character to the one after it, but it's not working. Here's what I have so far... I appreciate your help!
for(i=0;i
|
|
|
|
|
Use the "Ignore HTML" option when you post code that contains <. Now half of your loop statements are missing.
-- modified at 18:19 Saturday 23rd September, 2006
And another thing: Why should the space be removed? It's not a repeated character.
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
