Search results for query: *

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

OK i have this so far but it may be completley off mark the loop through seems to work if i use the response.write as in the example but i am not sure where to go from here. Private Sub sndtorep() 'code here sends email to factory with attachments Dim wapp As...

Thanks thats great

I understand the sql query but do you have any examples on looping through the dataset? Thanks

I have a prgram that stores infromation in an sql table through the program until the final page where the collected data is then used to place an order. I want to be able to use the kit number values as part of the filename that i can then attach to an email. for example if i had the kitnumbers...

sorry one last question I am running windows 2000 sbe and when i try to add the www.russell.co.uk in the forward lookup zone it will not allow the "." am i in the wrong place?