Search results for query: *

Hi, in my application i'm transferring data from MS Access into pre-made Excel templates using datasets. I'm using the following code to start the excel application objExcel = New Excel.Application objExcel.Workbooks.Open(path) objWorkSheet1 = objExcel.Worksheets(sheet)...

Hi, I'm tryin to export a dataset to excel but I keep getting: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred Additional information: Exception from HRESULT: 0x800A03EC. On the Interet i've read that I should have something to do with my "culture info"...

Hi, This might be an easy problem but I just don't know how to solve it. I'll give you an example I have a form (ex: theForm) with a button (Btn) and a statusbar (pBar1). On pressing Btn, the class DoTheMath is called and has to process about 10000 lines . After each 100 lines processed...

Hi, I have a dataset filled with doubles(9,344 ; 0,543; ...) When I trie to write it to an access database; It only stores them like integers (9; 0;...) I did have set the property of the field in the database to double, but it stil doesn't work. And even when i set the amount of numbers...

Hi, I know that when you fill a dataset with data from a database you can use the names of the columns of the tabel in the database to sort on.. ex: Dim oConn As OleDbConnection Dim OCmdItem As OleDbCommand Dim dsItem As DataSet Dim daItem As OleDbDataAdapter Dim strSQL As "select ... from...

Hi, I know how the Topmost property works (keeps a form on the foreground), but is it possible to make a form topmost, only within the program itself.. It should disappear when opening an other application, but now it always stays on top, even when opening an other app... Anyons knows how to...

Hi, I have to fill up a combobox with a list of clients from a database. I have managed to do this by directly creating a oledbconnection, dataAdapter,dataset...and then accessing the dataset from the combobox But I would like to do it with a method like "FillClients", where FillClients then...

Hi, is there any way that I can count the number of elements in an array? methods Length & Get Upperbounds return the length of the array (=how many elements could I place in the array), not how many places are allready taken.... Niko

Hi, before I write my dataset to the database, I would like to sort it on a certain column. I've found some examples on the Internet, but they all used a 'dataview' to sort a DATAGRID. => but I'm not using a datagrid:S.. What would be te easiest way to sort a dataset? Can I use a dataview on...

Hi, I'm able of splitting a string lik "Hallo, my name is.." with the "split method" But what to do if there are more than one space between the words???? split(string, " ") only works if there's exactly one space between them... I've been searching for a couple of houres now :( Anyone who...

Hi, I have to read the text from a txtfile into a database. I know how to manage all the connections, but the only problem is: How do you split a line by his whitespace? ex (these are all phonecalls): 1/12/04_09:23:45___myName ___calledNumber if I have tried spacePostion = theString.IndexOf("...

Hi, I have filled da dataset (ds7) from a database with a dataAdapter. Each row presents a phone call (with "date", "time", "duration",..." I have (just for practice) tried to manually change the date from the first record: ds7.Tables("Call").Rows(0)("date") = "3/03/2003" (it was 12/12/2005)...

Hi, in the next couple of weeks I have to developpe a vb.net application witch uses MS Access a lot. I have been able to fill up comboboxes with data from database. But I just don't manage to place some silly names into the database with the insert command and executeNonQuery.. I know it must a...