ASP.NET

Sun Rays13-Nov-07 0:42

Sun Rays

13-Nov-07 0:42

matjame wrote:
Microsoft Access doesnt seem to support "LIKE", and by the way, the date in my database is saved in this format (yyyy/mm/dd).

Im getting errors running this.It doesnt seem to understand LIKE.

Hi,
I have checked in MsAccess itself.
its working fine. as yr format is (yyyy/mm/dd).
Then you have to change the query.

SELECT * FROM testbl<br />
where myDate like '*/9/12'<br />

Thanks,
Sun Rays

matjame13-Nov-07 0:59

13-Nov-07 0:59

Syntax error (missing operator) in query expression 'BirthDate LIKE '*/09/20' 2007/11/13'.

comx = New OleDbCommand("Select * from Bithdays where BirthDate LIKE '*/09/20' " & Date.Today, conx)
comx.Connection = conx 'enure that the command follows the rite connection
If conx.State = ConnectionState.Open Then
conx.Close()
End If
conx.Open()
Dim datar As OleDbDataReader = comx.ExecuteReader
Error appears on the above statement

kagiso

Sun Rays13-Nov-07 1:13

Sun Rays

13-Nov-07 1:13

matjame wrote:
Syntax error (missing operator) in query expression 'BirthDate LIKE '*/09/20' 2007/11/13'.

comx = New OleDbCommand("Select * from Bithdays where BirthDate LIKE '*/09/20' " & Date.Today, conx)
comx.Connection = conx 'enure that the command follows the rite connection
If conx.State = ConnectionState.Open Then
conx.Close()
End If
conx.Open()
Dim datar As OleDbDataReader = comx.ExecuteReader
Error appears on the above statement

Hi,
What are you doing here ????????

write query as below...

Select * from Bithdays where BirthDate LIKE '*/" + DateTime.Now.Day.ToString() + "/" +  DateTime.Now.Month.ToString() "'"

Thanks,
Sun Rays

matjame13-Nov-07 1:40

13-Nov-07 1:40

Syntax error in string in query expression 'BirthDate LIKE '*/13/11'.
error points here
GridView1.DataSource = cm.ExecuteReader(CommandBehavior.CloseConnection)

Dim con As New OleDbConnection
Dim str1 As String = "Provider = Microsoft.Jet.oledb.4.0; Data source =C:\Documents and Settings\kagisho.mashiloane\My Documents\Visual Studio 2005\Projects\Search AL\TelephoneList.mdb"
Dim cm As OleDbCommand
Dim str2 As String

con = New OleDbConnection(str1)
con.Open()
str2 = "Select * from Bithdays where BirthDate LIKE '*/" & DateTime.Now.Day.ToString() & "/" & DateTime.Now.Month.ToString()
cm = New OleDbCommand(str2, con)

GridView1.DataSource = cm.ExecuteReader(CommandBehavior.CloseConnection)
GridView1.DataBind()

kagiso

matjame14-Nov-07 0:01

14-Nov-07 0:01

Howzit Sun Rays.
Here is how the problem was solved.
str2 = "select * from Bithdays WHERE (DATEPART('m', BDate)) = '" & Date.Today.Month & "' And (DATEPART('d', BDate)) = '" & Date.Today.Day & "'"
cm = New OleDbCommand(str2, con)
GridView1.DataSource = cm.ExecuteReader(CommandBehavior.CloseConnection)
GridView1.DataBind()

Thanx a million for your assistance

kagiso

Jintal Patel13-Nov-07 2:17

13-Nov-07 2:17

hi
try with this query..

if i m not wrong then BirthDate is your table column name ..

select * from Tablename WHERE (DATEPART(month, BirthDate) = @mt) AND (DATEPART(day, BirthDate) = @dt)

set value of this both variable as u want

Jintal Patel

matjame13-Nov-07 2:26

13-Nov-07 2:26

Ok, I tried and loved it but the problem is that the values I have to give it are system generated(i.e the day and month I get from the database are compared to the day and month from my machine) so I cant use that method.

But I tried to do this

str2 = "Select * from Bithdays where WHERE (DATEPART(month, BirthDate)) = " & Date.Today.Day & AND "(DATEPART(day, BirthDate) = " & date.Today.Month

But Im getting an error on "AND"

kagiso

Jintal Patel13-Nov-07 2:40

13-Nov-07 2:40

your syntax is wrong near '" & Date.Today.Day ' for concat so correct syntax

Jintal Patel

matjame13-Nov-07 2:47

13-Nov-07 2:47

Let me try it and i will reply just nw

kagiso

matjame13-Nov-07 2:50

13-Nov-07 2:50

Conversion from string "Select * from Bithdays WHERE (DA" to type 'Long' is not valid.

Error appears here
str2 = "Select * from Bithdays WHERE (DATEPART(month, BirthDate)) = " & Date.Today.Day And "(DATEPART(day, BirthDate) = " & Date.Today.Month

kagiso

Jintal Patel13-Nov-07 17:59

13-Nov-07 17:59

hii

sorry for let reply..

try this...

str2 = " Select * from Bithdays WHERE (DATEPART(month, BirthDate)) ='" & Date.Today.Day &"' And (DATEPART(day, BirthDate) = '" & Date.Today.Month & "'"

Jintal Patel

matjame13-Nov-07 19:44

13-Nov-07 19:44

Your solution has been morethan helpful.Now I can see the light, but the little problem I now encounter is that "No value given for one or more required parameters.".It was showing month as 14 which is today's day and 11 as the day which is the month.But after sorting the missing ")".

I get this message on the

GridView1.DataSource = cm.ExecuteReader(CommandBehavior.CloseConnection)
GridView1.DataBind().

I checked the values how they correspond with the string, its fine and the date formate(yyyy/mm/dd) is fine.What cud be the problem now.

kagiso

Jintal Patel13-Nov-07 19:53

13-Nov-07 19:53

please send me the total code or that function so i can understand your problem perfactly...

Jintal Patel

matjame13-Nov-07 20:06

13-Nov-07 20:06

Imports System.Data
Imports System.Web.UI.Control
Imports System.Web.UI.WebControls.WebControl
Imports System.Web.UI.WebControls.LinkButton
Imports System.Data.oledb
Imports Microsoft.VisualBasic.ApplicationServices
Imports Microsoft.VisualBasic.OpenShare
Partial Class Birthdays
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim comx As New OleDbCommand
Dim conx As New OleDbConnection
Dim con As New OleDbConnection

Dim str1 As String = "Provider = Microsoft.Jet.oledb.4.0; Data source =C:\Documents and Settings\kagisho.mashiloane\My Documents\Visual Studio 2005\Projects\Search AL\TelephoneList.mdb"
Dim cm As OleDbCommand
Dim str2 As String

con = New OleDbConnection(str1)
con.Open()
str2 = " Select * from Bithdays WHERE (DATEPART(Month, BirthDate)) ='" & Date.Today.Month & "' And (DATEPART(Day, BirthDate)) = '" & Date.Today.Day & "'"
cm = New OleDbCommand(str2, con)

GridView1.DataSource = cm.ExecuteReader(CommandBehavior.CloseConnection)
GridView1.DataBind()

If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
End Sub

Again, thank you very much for ur time and effort

kagiso

Jintal Patel13-Nov-07 23:48

13-Nov-07 23:48

hiii

this will definately work just change ur str2 to belove

str2 = "select * from Birthday WHERE (DATEPART('m', BDate)) = '" & Date.Today.Month & "' And (DATEPART('d', BDate)) = '" & Date.Today.Day & "'"

cm = New OleDbCommand(str2, con)

GridView1.DataSource = cm.ExecuteReader(CommandBehavior.CloseConnection)

GridView1.DataBind()

Jintal Patel

matjame14-Nov-07 0:00

14-Nov-07 0:00

You have no idea how much this means to me.It works like a charm.
I wud buy you lunch, but ur there.Thanx a million.

Damn, thank you very much.

kagiso

Jintal Patel14-Nov-07 0:37

14-Nov-07 0:37

welcome

Jintal Patel

call javascript from ContentPlaceHolder

Guffa13-Nov-07 6:14

Guffa

13-Nov-07 6:14

matjame wrote:
the problem is that the values I have to give it are system generated(i.e the day and month I get from the database are compared to the day and month from my machine) so I cant use that method.

Yes, you can. The @mt and @dt values are parameters. Add two parameter objects to the command object, with the values for the month and day.

Experience is the sum of all the mistakes you have done.

yesu prakash12-Nov-07 23:47

yesu prakash

12-Nov-07 23:47

How can i call a javascript function from a Contentplaceholder?
can we get document object from here?

Thanks and Regards
Yesuprakash

N a v a n e e t h13-Nov-07 0:01

N a v a n e e t h

13-Nov-07 0:01

ypki wrote:
Contentplaceholder?
can we get document object from here?

Javascript don't understand Master pages/Content pages. All these will be rendered together to produce page. So you can write it anywhere.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

yesu prakash13-Nov-07 0:05

yesu prakash

13-Nov-07 0:05

but i cant get the control in content.
I try document.formname.textbox1 and document.getelementbyid("textbox1")
both showing unidentify in javascript
I am trying to use calenser control

N a v a n e e t h13-Nov-07 0:28

N a v a n e e t h

13-Nov-07 0:28

ypki wrote:
I try document.formname.textbox1 and document.getelementbyid("textbox1")

document.getElementById(<% textbox1.ClientId > )

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions