|
Dear All,
I have Table(MS SQL Sever 2000) name "Item" It has two colomn "ItemNo, IName") and it has relevant sample data also. Actually I can bind one colomn data to combo box(Using data set). But I need bind this two colomn("ItemNo", "IName") data in one combo box.
Pls, tell me or send sample code for that.
I'll think after binding two colomn like this.
00001 - Mother Board
00002 - Mouse
00003 - Key Board.
Thanks & Regrds
Kusal
|
|
|
|
|
You'll need to build a collection of strings that combines the values and bind to that.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Dear Christian ,
Many Thanks
Best Regards
Kusal
|
|
|
|
|
before doing collection of string tell me schould u want to make both in display
othervice set data member as one field and value member as other field so it will consider the the value member if u selected the data member i think i am saying in reverse any how it will give u a good result
with regards
Balagurunathan.B
|
|
|
|
|
Personally I would combine them in your query alone with the original 2 kept separate. So you would so something like the following.
SELECT (ItemNo + ' - ' + IName) AS CombinedColumns That way it is taken care of and you dont have to do any extra work in your code.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
I would suggest that you construct SQL statement that concatenates the two column some thing like the following
Select (Col1 + ' - ' + Col2) as Col1, Col3 from Table
Once you do this you can always bind the col1 to dataText and col3 to datavalue
Hope that sounds good to you.
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
|
|
|
|
|
I want the user to be able to point to a directory on their hard drive and the Images that are in there are then used to skin the form.
What I need to know is how to pre-load images when the form loads.
So that they are only loaded once.
Cheers
|
|
|
|
|
Just make them lazy initialised properties. That is, do this:
private Bitmap _mySkin;
private Bitmap MySkin
{
get
{
if (_mySkin == null)
{
_mySkin = LoadFromResources("mySkin");
}
return _mySkin;
}
}
Where LoadFromResources is a method you provide.
Then, you just reference MySkin, not _mySkin. Or, you can just load the bitmaps in your constructor or Load event.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I want to use VB2005 (VSTO) to create an add in for Outlook. I have read a lot, and tried a lot. I know how to create the add in, and how to show a dialog box when Outlook fires and when it's being closed. Those events are in the code that is created by VB. Now how can I add a button to the toolbar that, let's say, scans the messages of last week for a keyword entered by the user?
Any help would be greatly appericiated.
Thanks in advance,
Mark
|
|
|
|
|
How can I change VS 2005 shortcuts so CTRL + DOWN ARROW does the Edit.ScrollLineDown (Scrolls text down one line) command.
Thank you,
|
|
|
|
|
Tools -> Options -> Environment -> Keyboard -> Select command and apply new keyboard key combo
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Thanks for the help – that's what I needed to know.
|
|
|
|
|
I need to develop a Windows Form application that has a sophisticated multipane or "paneled" User Interface.
I don't mean MDI, but various different panels that the user can move, resize, close, etc. to his/her own liking. Something like the Visual Studio UI.
Before re-inventing the wheel, I am wondering if there are any useful classes, examples, walkthroughs, articles or tips about this.
Thanks,
Jim
(I already found the articles:
"Using Paneled Forms in Windows Applications", and
"A guide to using Paneled Forms, Multi-Splash Screens, SQL Express, and many more in Windows Application Development"
on this website but they don't really discuss what I need)
|
|
|
|
|
I have added a combocolumn in a datagridview and added some items in it.
What i want is to autocomplete the combobox when i press a key?
How can i do so?
X
|
|
|
|
|
How can I make the function below to be performed from antoher sub?
Private Sub gain_Scroll(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ScrollEventArgs) Handles gain.Scroll
You know there is a function PerformClick for Pushdown buttons. Appriciated for your help and support. Thanks.
B.B.
|
|
|
|
|
Raise Event Gain.Scroll(sender, e)
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
or if you just want the content executed:
gain_Scroll(nothing, nothing) 'when you don't care who's the sender or what's in e
|
|
|
|
|
Thanks I will test those code lines and I will post the result..;)
|
|
|
|
|
Thanks for the reply. It works now. Thank you both.
B.B.
|
|
|
|
|
hiya, ive created an application in VB 6 where i have connected a database to the vb. i use recordset to update, delete, add records, but i want to create an invoice, ive created the data report without a problem, but i want to search through the records.
i thought i could do this by having a text box (name txtsearch) a command button (CmdSearch)
this is my code on the text button.
Private Sub CmdSearch_Click()
Dim name As String
name = txtsearch
name = UCase(customer)
Select Case customer
Case "'name'"
Case Else
MsgBox "no records found"
End Select
End Sub
i just cant get it to work, not used Vb in a few years properly, any help would be great thanks
|
|
|
|
|
1) what's customer?
2) you populated the variable name with the content of txtsearch then in the next statement you replaced the variable name with the content of customer
3) you uppercased customer and then asked if it equals a lower case 'name'
4) unless 'name' is actually stored that way you'll never get a hit
|
|
|
|
|
Hi!
In my project some strings use international char values such as "ŞİĞÇÜÖ". When I use Instr function to check existence of a specific character in runtime, it doesn't detect these characters. How can I solve the problem? Thanks.
Dim MyWord as String = "ABŞG"
Dim CharPos as Int32 = Instr (MyWord, "Ş", compareMethod.Text)
msgbox(CharPos.ToString) 'returns zero
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Is this VB6 ? If not, you should not use msgbox or Instr, you should use the .NET methods provided, such as string.Contains and MessageBox.show.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
I know what I am asking is simple and u all probably did it before, but I have a delivery time within 2 hours and I am so confused from the varies things I tried to do so Please help:
I have a web service that returns a Dataset with Values, I access this DataSet successfully in a VB Application, all I need is to pass these Values to Crystal report ( that's All!!)
Guys, Please send me a very detailed solution as I am confused and under stress.
Thanks a lot
Nena
|
|
|
|
|
Hi,
I know what I am asking is simple and u all probably did it before, but I have a delivery time within 2 hours and I am so confused from the varies things I tried to do so Please help:
I have a web service that returns a Dataset with Values, I access this DataSet successfully in a VB Application, all I need is to pass these Values to Crystal report ( that's All!!)
Guys, Please send me a very detailed solution as I am confused and under stress.
Thanks a lot
Nena
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
