Recent content by russellmunday

yes that now works Thanks

I added the your line but the sdate was underlined when i hover over it the message says "value of type 'date' cannot be coverted to integer

I am still getting the following error when connecting System.Data.SqlClient.SqlException: Error converting data type nvarchar to datetime. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at...

I do not have the origional code i tested with so i have recreated it the first problem is the dr.item is underlined and when i hover the mouse over it it says " overload resolution failed because no accessible item accepts this number of arguments. Dim da As SqlClient.SqlDataAdapter...

thanks ill give it a go

had to move on to another project an your help was appreciated but when i came back to this project and tried the code it would not work.

how?

thanks but it does not work

I still am not sure of whats happening here but I have tried it and am getting the following results i am probably doing something wrong but i just can't seem to grasp it; System.InvalidOperationException: The SelectCommand property has not been initialized before calling 'Fill'. at...

I am trying to attach files to an email based on a selection that is stored in a sql table but when i try to loop through whats there i get various build errors. if anyone has done this or can see where i'm gpoing wrong please help 'connect to database and fill the daaset with the kitnumbers...

May be I'm getting this wrong but if the dataadapter does not have any idea of the parameter when it polls the database table all records will be returned and put into the dataset. and not the selected records I want.

If I use a stored proceedure how do I get the returned data into a dataset? because the datasets i have used so far have had a string passed to them see my example Dim sdate As Date sdate = Date.Today.AddMonths(1).ToString Dim ssql As String ssql = "select * from...

do you have any examples of using parameters?

can someone tell me where i'm going wrong with this Dim sdate As Date sdate = Date.Today.AddMonths(1).ToString Dim ssql As String ssql = "select * from information where expirydate <'" & sdate & "'" i want the records that are about to run out to be returned. Thanks

your a star thanks for your help