dienadel wrote: If i = 0 Then ws.Range("csr_title").Value = mvarCsrDetails(CsrIndex.Title) <---- ERROR HERE drd = GetDataReader(db1, stored_func(i), mvarCsrDetails(CsrIndex.ID)) Should it probably be mvarCsrDetails(CsrIndex).Title and mvarCsrDetails(CsrIndex).ID ??

Thanks dave it is clear now that I need to use a dataadapter for this one. Thanks guys......

Dont have any idea how to do it. Do you know how?:confused:

dienadel wrote: its urgent That is not nice around here. It'll just piss people off. As far as the error is concerned, Exception from HRESULT: 0x800A03EC, those are notorious for not being very descriptive. Check that you don't have old processes running from previous debug sessions, and also make sure the parameters are called correctly. MSDN can be of more help... "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Thanks for the help guys. :)

Thanks man the code is correct. One more thing can i store this value to a properties for example: public properties you() get return textbox.text end get set (byval value as string) textbox.text = value end set

there are several ways to solve this: 1) make a property iIDNo (or something), make this property public and then in the 2nd form you can acces it like this: form1.iIDNo 2) make a contstructor with a parmeter (new(iidno as integer))on the 2nd form, when you click on the button you call the 2nd form with the parameter: dim frm as new form2(txtidno.text) in the contructor you then initialize a local variable wich you can use in the sql string 3) same as 2) but in stead of giving a string or integer with the constructor you just give you're form1 with it (new (ffrm as form)) on the click: dim frm as new form2(me)) in the constructor you then initialize a local variable (private frm as form) and 'fill' it frm=ffrm then you can access you're textbox by: ffrm.txtidno.text hope this helps

When you create your columns for the DataGridView, you simply specify the format string for the DefaultCellStyle: DataGridView1.Columns("MyColumnName").DefaultCellStyle.Format = "M/d/yyyy" or, using the culture-specific short date format for the current thread: DataGridView1.Columns("MyColumnName").DefaultCellStyle.Format = "d" All you have to do is Google for "datagridview format date[^]". There's lots of examples out there. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007