|
Well, Access knows how to count and compare dates, so it's plain what is going wrong. As someone else said, if you always pass dates using date types instead of strings, you will solve the problem.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks you for ur kind atention chistian , problem is solved.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
You may check your regional settings.
But this is not an ultimate solution because you'll never know how it is defined in the user computer. So try this:
Dim d as date = "2\1\2006"
query = "select date1 from emptimepolicies where date1>" & CDate((CLng(d))
I hope it will help.
Shay Noy
|
|
|
|
|
can i convert the value of type long to date?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Yes,
In fact date is a long formatted number.
If you will try to write the fololowing code:
Dim d as date ="31/12/1899"
msgbox(Clng(d))
You will get 1
"31/12/1899" is the first date from it we start to count.
To answer to your question, try this:
'This is in VB6, if you need it in VB.NET, tell me
Dim d As Date
d = "31/12/1899"
Label1.Caption = CDate(CLng(d))
Label1.caption result will be "31/12/1899".
I hope it helps you.
Shay Noy
|
|
|
|
|
try this in your query
"SELECT date1 FROM emptimepolicies where month(date1)>2 and day(date1)>1 and year(date1)>2006"
i try that in my query analyzer and its works fine
Regards,
Tomi
|
|
|
|
|
Woh .it is working very fine.
Thanks a lot
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Anytime Sonia..
Glad can solve u'r problem
Kind Regards,
Tomi
|
|
|
|
|
I have 2 asp.net files: default.aspx.cs and test.aspx.cs
How can I call methods from test.aspx.cs from default.aspx.cs?
I can't seem to call methods from a different file unless it's in my appcode folder.
/\ |_ E X E GG
|
|
|
|
|
i think function calling is posible if class is placed in appcode folder.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Try this code
Use this line where u want to call Function
In .aspx page
<%@ PreviousPageType VirtualPath="~/index.aspx" %>
in .aspx.cs
this.PreviousPage.Login();
//Make sure your method is public
Best Regard
Pathan
-- modified at 0:54 Wednesday 1st August, 2007
---------------------------------------------------
|
|
|
|
|
imran i tried ur code
i got the following exceptions
Object reference not set to an instance of an object.
at the following line
this.PreviousPage.Login();
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Now try this
take two page test1.aspx and test2.aspx
Take LinkButton in test1.aspx
<asp:LinkButton ID="LinkButton1" runat="server" PostBackUrl="~/test2.aspx">LinkButton</asp:LinkButton>
and write public method
i.e
public string Login()
{
return "Welcome";
}
Now In test2.aspx
<%@ PreviousPageType VirtualPath="~/test1.aspx" %>
Call Method in page load event
Response.Write(this.PreviousPage.Login());
Run test1.aspx and click on LinkButton
Best Regard
Pathan
---------------------------------------------------
|
|
|
|
|
imran, have u tested the code u r providing.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Yes
---------------------------------------------------
|
|
|
|
|
well i have tested this code it really works great
|
|
|
|
|
The appcode folder is global to the whole application, then I loose isolation between debug and release code in my app.
/\ |_ E X E GG
|
|
|
|
|
Someone else was asking this the other day. You can't. You just can't. test.aspx.cs does NOT exist when default.aspx.cs is running. The class instances are created as the pages are served. If you have stuff you want to be able to call from many pages, give them a common base class.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Ok, then that clears it up. So I guess my next solution would be to put the common code I need, into an app_code folder.
/\ |_ E X E GG
|
|
|
|
|
Hi, if I don't want to use a DataGrid and don't want to use Stored Procedures for Paging purposes, what other options do I have? Would you please point me to tutorials on them if they exist, thank you in advance for your help.
|
|
|
|
|
Hi,
Usually I use Stored Procedure for paging. If U want paging without datagrid is okay, but if U dont want to use stored procedure then U should create a class for paging. It means for easy maintenance.
Regard,
Edwin
|
|
|
|
|
ASPnoob wrote: don't want to use Stored Procedures for Paging purposes
What is the role of stored procedure in paging. If know to implement manual paging with help of stored procedures, copy the same query to your page and append to string variable and pass to DB.
Do you have any specific reason for avoiding stored procedure ?
|
|
|
|
|
Hi,
I have a regular select statement, but it doesn't shows any data, may be I don't see sth, could anybody help me?
Here is the code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PapersDBConnectionString %>"
SelectCommand = "SELECT name, lastname, organization, addressline1, addressline2, city, state, country, zipcode, phone, newuser, moderator, date FROM Users WHERE (username = @current_user)">
<SelectParameters>
<asp:SessionParameter Name="current_user" SessionField="CURRENT_USER" />
</SelectParameters>
</asp:SqlDataSource>
thanx
|
|
|
|
|
I used following code and i get result
u can try it
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:RelationshipPortalConnectionString %>"
="" selectcommand="SELECT * FROM [User_Registration] WHERE ([UserName] = @UserName)">
<selectparameters>
<asp:sessionparameter name="UserName" sessionfield="UserName" type="String">
-- modified at 6:47 Wednesday 1st August, 2007
Nand Kumar das
|
|
|
|
|
Hi,
My Provider is System.Data.OracleClient. I need to use the OracleTransaction with Enterprise Library Data Access Application Blocks. With out DAAB we can write Like this:
OracleConnection con=”…”
OracleTransaction tr=Con.BeginTransaction(..);
With DAAB we have to write like this:
Database db=DatabaseFactory.createdatabase();
OreacleTransaction tr=?
Here How to initialize the Transaction.
Can any one provide me the link to how to execute Oracle Transactions with DAAB
Thanks
|
|
|
|