Showing results 1 to 12 of 12
Search took 0.00 seconds.
Search: Posts Made By: brown
Forum: .NET Database and Reporting 02-06-2013, 09:01 AM
Replies: 21
Views: 1,144
Posted By brown
Thanks for that. This is what lack of sleep...

Thanks for that.

This is what lack of sleep does. i forgot to link the database across through the Searchcon *FacePalm*
Forum: .NET Database and Reporting 02-06-2013, 06:38 AM
Replies: 21
Views: 1,144
Posted By brown
This is what happens when you don't sleep... you...

This is what happens when you don't sleep... you forget to actually assign the Connection to a database *FacePalm*

Now I should be able to stick a NOT in there and it will show the bookings that...
Forum: .NET Database and Reporting 02-06-2013, 06:30 AM
Replies: 21
Views: 1,144
Posted By brown
I just have Dim searchcon As...

I just have

Dim searchcon As OleDbConnection

in the public class then

Dim SearchCommand As OleDbCommand = Nothing

in the search sub
Forum: .NET Database and Reporting 02-06-2013, 06:16 AM
Replies: 21
Views: 1,144
Posted By brown
Ok didn't think about that, I assumed the...

Ok didn't think about that, I assumed the parameters would be needing to set up first.

I changed that and now I get a different error :(

Error in processing SQL
Fill: Selectcommand.connection...
Forum: .NET Database and Reporting 02-06-2013, 06:03 AM
Replies: 21
Views: 1,144
Posted By brown
when I click the search, it causes an error. ...

when I click the search, it causes an error.

NullReferanceException was unhandled
Object reference not set to an instance of an object.

That is on the line that makes the parameter for the...
Forum: .NET Database and Reporting 02-06-2013, 05:54 AM
Replies: 21
Views: 1,144
Posted By brown
ok so in which case if I do ...

ok so in which case if I do

SearchCommand.Parameters.Add("@dateIn", OleDb.OleDbType.Date).Value = searchbydatein.Value
SearchCommand.Parameters.Add("@dateOut",...
Forum: .NET Database and Reporting 02-06-2013, 05:20 AM
Replies: 21
Views: 1,144
Posted By brown
ok so lets try parameters as that's not working...

ok so lets try parameters as that's not working with the strings.

So my code would look something like.....

SearchCommand.Parameters.Add("@dateIn", OleDb.OleDbType.Date).Value =...
Forum: .NET Database and Reporting 02-06-2013, 05:16 AM
Replies: 21
Views: 1,144
Posted By brown
how does that stand with the date in the datebase...

how does that stand with the date in the datebase as that takes the format of a short date.... "dd,mm,yyyy"
Forum: .NET Database and Reporting 02-06-2013, 05:05 AM
Replies: 21
Views: 1,144
Posted By brown
I really don't understand parameters im afraid :(...

I really don't understand parameters im afraid :(

Ill give that a go, one sec lol.

I really do appreciate your help, thank you, lets see how this one goes. :)
Forum: .NET Database and Reporting 02-06-2013, 04:47 AM
Replies: 21
Views: 1,144
Posted By brown
Im slightly lost here to be honest so are...

Im slightly lost here to be honest

so are you saying this should be ok? I don't need time to work, if anything I want to avoid time

("SELECT * FROM Booking WHERE DateIn OR Dateout BETWEEN '" &...
Forum: .NET Database and Reporting 02-06-2013, 04:10 AM
Replies: 21
Views: 1,144
Posted By brown
So essentially. I should convert the datepicker...

So essentially. I should convert the datepicker format into custom. then make it "YYYY/MM/DD"

Then I need to say that variable1 = datepicker.value

then use the variable1 inplace of the...
Forum: .NET Database and Reporting 02-06-2013, 01:48 AM
Replies: 21
Views: 1,144
Posted By brown
SQL Help needed, Desperatly

Hi there

I need some help with 2 SQL statements that don't seem to be working for me :(

im really stuck on this one, and REALLY need to get this sorted ASAP, im not the most advance VB user, so...
Showing results 1 to 12 of 12

 
Forum Jump
Advertisement:



Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe