|
Hi, I am now working on a data compare and copy for datagrid. Below i have the codes the open up this csv file and attached it to the datagrid1.
I am now finding a way to
1. Type in "123123" into the textbox
2. Click a button
3. Compare it with the datagrid1(which has the opened csv file) or compare directly with csv file
4. Copy the whole row on which the "123123" is found and paste into another field or datagrid for display
Public Function Import()<br />
<br />
Dim myPath As String = "c:\testing.csv"<br />
<br />
Try<br />
<br />
Dim objDataSet As System.Data.DataSet<br />
Dim objAdapter As System.Data.OleDb.OleDbDataAdapter<br />
<br />
strConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & myPath & " '; " & "Extended Properties=Excel 8.0;")<br />
objAdapter = New System.Data.OleDb.OleDbDataAdapter("select * from [sheet1$]", strConnection)<br />
objDataSet = New System.Data.DataSet<br />
objAdapter.Fill(objDataSet)<br />
DataGrid1.DataSource = objDataSet.Tables(0).DefaultView<br />
strConnection.Close()<br />
<br />
Catch ex As Exception<br />
<br />
Dim er As String<br />
<br />
strConnection.Close()<br />
<br />
End Try
thanks
|
|
|
|
|
Use the objDataSet.Tables(0).Select("ColumnName = "& YourTextBox.Text")
This will return DataRow Collection that you can manage the way you wish
Best Regards
3ala2
|
|
|
|
|
hy everyone!
i do have problems debugging my webservice. it compiles propperly but when i choose "debug > start new instance" in the solution explorer then i get the message "Auto-attach to process '[2704] aspnet_wp.exe' on machine 'devVS2003' failed. Error code 0x8013134b".
When I manually attach the process to aspnet_wp.exe and start it in debug mode (common language runtime checked) i get a dialog "unable to attach to the process" but no message why.
does anyone of you have an idea how to solve this?
when i googled for it i just found similar postings but no solution to these problems which could help me.
thanks for any advice.
stephan.
|
|
|
|
|
Hi Friends
I am developing small project using Biometric device. its process is create the user(capture finger print) and when the user login it verify the user.
i dont have any idea about. if any body knows kindly help me.
i am using the device NITGEN (FINGKEY HAMSTER).
Thanking You
Regards
K. Rajesh Kumar
i am a fresher in software development i have so many doubts in .net so i need to ca
|
|
|
|
|
There's an API[^] for it.
|
|
|
|
|
Is there s way by using vb.net to know the current memory of my portable harddisk?? Where should i point to as there is no URL for harddisk...
|
|
|
|
|
|
Hi all,
I m working with Proxy Server Project.but i have got many error Like Listning Clients URL.
Please help
Thanks
|
|
|
|
|
Member 4542257 wrote: i have got many error
Well, that sure doesn't help anyone help you.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi all,
I want to write a service, which takes 2 arguments.
How can i do in VB6?
Thanx
Webbee™ the Œ
|
|
|
|
|
This[^] is the best place to look for what you need to do.
|
|
|
|
|
im suppose to write a 4 page document on "How does Open source cater for what Microsoft’s ADO.Net provide"
then i have to come up with example aswell.
any help will be appeciated
|
|
|
|
|
Ask yourself these questions:
In what context? Are you talking about open source targetting the .NET platform only?
Is it asking what open source frameworks replace ADO.NET? (None that I know of. There are some that are a wrapper around ADO.NET, but ADO.NET is still being used to access the underlying database)
What does ADO.NET do? What open source equivalents are there? How do each of these technologies work? Can you show the exact same task being performed in ADO.NET versus an open source equivalent?
|
|
|
|
|
Hi Friends...
I have application like kiosk... i have to supress keyboard's input...n allow only scanned input
i have only 1 textbox for input..it will allow only barcode scanner's input...n keyboard input restricted
so friends if u have any idea, please write me...
thankz in advance..!!
|
|
|
|
|
Make the textbox Readonly... or
you can write e.handled=true in Keypress event of that textbox.
Abhishek Sur
Web Developer
|
|
|
|
|
Virani wrote: I have application like kiosk... i have to supress keyboard's input...n allow only scanned input
i have only 1 textbox for input..it will allow only barcode scanner's input...n keyboard input restricted
so friends if u have any idea, please write me...
thankz in advance..!!
AFAIK, a scanner is a keyboard wedge - it just outputs the characters read into the text box that has control at that point. If you make the textbox read-only or handle the keypress and throw the key away, you might not get any data into your text box at all.
|
|
|
|
|
Like the other person said, most barcode scanners are keyboard wedges. This means that they are, in fact, a keyboard. There is no way to tell the difference between the user hitting keys on the keyboard and the key data comming from the scanner. To Windows, and your app, they are exactly the same. So, to answer your question, no there isn't a way to do what you want using the scanner you have.
There are, on the other hand, barcode scanners out there that work on Ethernet that may do what you want, but they cost considerably more money to buy.
|
|
|
|
|
Hi,
for most barcode readers, you can set a prefix and postfix string that they emit around
the text scanned; read the reader's doc.
have your TextBox reject everything that does not have the prefix+postfix,
and remove those once you consume the data.
Or just remove the keyboard!
|
|
|
|
|
|
Yes, but ini files are no longer used by most people.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Is there anyone out there knows how to read a .ini file using vb.net2005? Is there any particular formal need in an ini file?
|
|
|
|
|
Use app.config instead and it is fully supported. Ini files are no longer in fashion.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
How to set the Row Selector and scroll bar to left side of the Infragistics Grid ..
Pls any one help
|
|
|
|
|
Why aren't you asking Infragistics this question?? After all, they wrote the contorls you're using and you've paid them for the support, haven't you?
|
|
|
|
|