|
i want to display the name starting with any letter(A-Z,a-z) in textbox from sqldatabase through datagrid using vb.net windows application.
for example,
values are in datagrid like
companyid companyname contactperson city
1 IBM rajesh Bangalore
2 Wipro kannan Chennai
here companyid, companyname, contactperson,city are field name.
companyid is primarykey.
in my form there are 4 label and 4 textbox.
1st label name as Findlabel
2nd label name as companynamelabel
3rd label name as contactpersonlabel
4th label name as citylabel
1st textbox name as findtextbox
2nd textbox name as companytextbox
3rd textbox name as contactpersontextbox
4th textbox name as citytextbox
i want to display company name starting with any letter.if i type wipro in findtextbox,then i click findbutton means the values will automatically diplay in other 3 textbox(ie..wipro in companytextbox,Kannan in contactpersontextbox,chennai in citytextbox).
if i type IBM in findtextbox,then i click findbutton means the values will automatically diplay in other 3 textbox(ie..IBM in companytextbox, rajesh in contactpersontextbox,Bangalore in citytextbox).
so i want to display starting with any letter.i am doing these project in windows application using vb.net.plz help me.
|
|
|
|
|
In the keypress event of findtextbox, search though the dataset using the following SQL command:
"SELECT * FROM yourtable WHERE companyname LIKE '" & findtextbox.text & "%'"
Then check if the found results count is one, you do simply set other textboxes to the fields from the queried row.
This is even more easy-to-use than what you wanted, since the data about IBM would be shown just by typing the letter 'I' and the other just by typing 'W'.
Here this code makes your program case-sensitive; you may change it with a simple 'OR' command.
|
|
|
|
|
In VB6, I have a main form (frmMain) with three subsidary forms. The latter set various properties on frmMain, e.g. frmMain.NoCopies = x
I have a number of procedures that I want to put this in, so I need to pass the name of the form as a variable - otherwise I will end up with three subsidiary forms for each procedure.
Is it possible?
(I am trying to pass the info as public variables, but it seems to be a long way round)
Regards
pitters
|
|
|
|
|
You should pass the form itself rather than just the name of it!
This is how to do it:
<br />
Sub SomeFunction(frm As Form)<br />
<br />
End Sub<br />
.<br />
.<br />
.<br />
Call SomeFunc(frmMain)<br />
|
|
|
|
|
Then wouldn't I have to use the Call SomeFunc(frmMain) in my original form?
I actually need to access the properties in the subsidiary form like so:
e.g. instead of using the code frmMain.NoCopies = 2
I want to be able to use (varaible).NoCopies = 2
|
|
|
|
|
You may call the function anywhere (if it is public).
If I were you, I would declare SomeFunc in a public module and call it anywhere that is needed.
I guess that it will satisfy what you want.
|
|
|
|
|
Hi,
I am binding my DataGrid control to an arrayList that contains strings as
datagrid1.datasource = str
where str is the ArrayList.
On executing the code, the datagrid displays the length of the strings instead of the strings themseleves.
How do i make the datagrid display the strings contained in the arraylist and not the length.
Thanks!
|
|
|
|
|
This is actually by design that this happens. An array doesn't implement the databinding interfaces, so the DGV looks at the only property that it can find on each element, Length.
You'd have to expose the array in a wrapper class that exposes the text of the string as a property. You cannot bind to the string text without it being exposed by a property.
|
|
|
|
|
Thanks a lot! It works now.
|
|
|
|
|
Hi,
In VB.net how do I uplaod files to server path (http://<servername>/Uploadedfiles/<filename>).
I have an desktop application in VB.net, I need some files to be needed for online. So that I need those files to by uploaded to server using http upload method.
Any luck.
Rams.
Be simple and Be sample.
|
|
|
|
|
The easiest way to do this is to write a web service and host it on your service/consume it from your app.
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 am not much familiar with web service, could you provide me any link or code snippet to do this.
Thanks in advance.
Be simple and Be sample.
|
|
|
|
|
Try this[^]
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 all...
I have to develop a project for hospital management in Vb .Net.Can anyone prescribe the sites that offer free project downloads...?
Regards,
Balaguru
|
|
|
|
|
balaji agar aap ko koi link mila to please mujhe Zaror bejhna.
|
|
|
|
|
Dear Nilesh..
I cannot understand hindi..Can u reply in english...?
Balaguru
|
|
|
|
|
So how did u get to know this is Hindi Language
|
|
|
|
|
Velaya Paara venru....
Balaguru
|
|
|
|
|
If you find it, let me know. I wouldn't mind quoting on jobs, downloading some code, and getting paid. Although, it scares me that a hospital doesn't have better ways of checking who works on their systems
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 )
|
|
|
|
|
Christian Graus wrote: I wouldn't mind quoting on jobs, downloading some code, and getting paid.
I wouldn't mind that either. Code reuse?
"too much daily WTF for someone..." - Anton Afanasyev
|
|
|
|
|
have you done any requirements gathering or consult with the hospital about what they need in the project? I'd start with these tips first rather than going the lazy way and looking for something that has already been done...
"too much daily WTF for someone..." - Anton Afanasyev
|
|
|
|
|
hey all, hope you're all well
i need help with creating a dvd player
well mainly just getting the dvd to play
in visual basic 2005 express
i have these two:
MSWEBDVDlib
MSVidCtlLib
its supposedly better to use MSVidCtlLib for DVD on XP according to the MSDN
but i just cant get it to play anywhere
(its for a school project)
thanks
|
|
|
|
|
To play a DVD, you need to do two things:
1 - use the windows media player control and
2 - make sure you have the MPEG/DVD codecs installed.
There are free DVD decoders on the web, I am pretty sure. Without one, it's just not going to work.
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 )
|
|
|
|
|
no i didnt want to use the windows media player control
|
|
|
|
|
OK - well, even if you find some harder way of doing things, it's still not going to work without the DVD codecs installed.
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 )
|
|
|
|