ASP.NET

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

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

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

To clear textboxes in the content page

Sun Rays13-Nov-07 0:13

Sun Rays

13-Nov-07 0:13

Hi,
after running your application page,see page source. In that you will see that your control named textbox1 is chaged to "ctl00_contextplaceholderName_textbox1". so see that new ID and then get from javascript.

Thanks,
Sun Rays

SunithaNallana12-Nov-07 23:00

SunithaNallana

12-Nov-07 23:00

hi...
i am having a contentpage which has many textboxes.Pls let me know the code(in c#)to clear textboxes at a button click.

SunithaNallana

N a v a n e e t h12-Nov-07 23:09

12-Nov-07 23:09

SunithaNallana wrote:
to clear textboxes at a button click.

Clearing textbox value ?

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

My Website | Ask smart questions

SunithaNallana12-Nov-07 23:17

SunithaNallana

12-Nov-07 23:17

yes to clear textboxes values

SunithaNallana

N a v a n e e t h12-Nov-07 23:45

12-Nov-07 23:45

Content place holder will have Control collection property. Iterate through each item and check if it is TextBox. If yes clear the text.

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

My Website | Ask smart questions

SunithaNallana13-Nov-07 0:46

SunithaNallana

13-Nov-07 0:46

thank u all Rose | [Rose]

i cleared my doubt.
i have done it this way...
1.in the master page i put a property block in which i wrote
public ContentPlaceHolder CPH
{
get{return ContentPlaceHolderid;}
}
2.i made the content page strongly typed ie..
<mastertype virtualpath="masterpagefile path">
3.in button click function
foreach(control c in Master.CPH.Controls)
{
if(c.getType().Name == "TextBox")
{
(c as TextBox).Text ="";
}
}

SunithaNallana