Search results for query: *

Thanks alot mate fixed my problem!

Why was this moved?

Hi all, when i hold the arrow up, arrow down, page up, page down key in the datagrid view, the selected row jumps and doesn't select the next row one by one it jumps a couple depending on how long you hold it down for. Is there anyway to stop this so it selects one row at a time when holding...

didn't want to do it this way, i thought there would be an easier way, but ended up doing it anyway and works great thanks for your help guys.

Hi all, im trying to implement code that allows me to scroll up/down on the data grid view control even though i dont have focus, any help will be much appreciated, thanks for your time.

i need to filter out all the records that are blank so myBindingSource.Filter = "ParentID <> '' "?

yep, im using a select query through code, and then putting it into a datatable and then bind it to a data grid.

hi all im trying to make the datagridview only show the rows that have data in a certain column, for example i want to only show the rows that have data in the column "OurPartNo", if the "OurPartNo" column doesnt have data then not to display the row.I hope that makes sense, thanks.

Thanks Alot guys for your input.

hi all im just about to release my first application using clickonce and was wondering where to store the updated versions of my app so the client can download updates when needed. the application will be running on a company's server for all employees to use, should i store it be stored on the...

Hi all Im trying to make a custom filtering system that the user can run a select query based on what they have highlighted in the datagridview cell like access's filters the table can also be searched without any filters using a text box, the filters will need to be able to have wild cards...

thanks all for your input, i managed to get a satisfactory performance speed but selecting the top 100 rows in the select query which seems to be working great, thanks again!

I am running a select query ("Select * From Table Where [Feild1] Like 'txtsearch.text %'" for example) each time the user types in a search box (Key down event) that retrieves data from a very large table (~121,000 records), its probably not the best way to do it on the key down event but this...

i want to be able to select the records i want without the massive delay. the select queries are just simple statements like "Select * From Table Where [Feild1]Like 'ten%'".

hi all, I'm having trouble with the performance of my select queries. The database has around 121,000 records and data retrial is very slow is there way around this? maybe if i store the whole table in RAM(Data set)? would that be more efficient? and if so any pro's or con's? thanks for your time.

So the data Retrieval code goes in the for loop? Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, _ ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork Dim worker As System.ComponentModel.BackgroundWorker =...

thanks for the reply mate, how would i get the data access on another thread as i have never worked with threads before? thanks in advanced.

Does any one know how to implement a Progress bar with a select query, Maybe using a Back ground worker? the only thing i dont understand is how to increment the progress bar when running the query(In a loop). any help would be much appreciated!

Problem solved everyone! Dim DAPT As New OleDbDataAdapter("SELECT * FROM CatalistT WHERE [" & Feild & "] = '" & txtsearch.Text & "*'", DCON) need to be Dim DAPT As New OleDbDataAdapter("SELECT * FROM CatalistT WHERE [" & Feild & "] LIKE '" & txtsearch.Text & "%'", DCON) silly me

Hi i am trying to run a like query to an access database from vb.net the problem is it doesn't return any data i have tryed using both '*' and '%' as the wild cards the '*' works in access query but not when ran from vb.net through an OLEDB connection Dim DAPT As New OleDbDataAdapter("SELECT *...