|
You can if you want, but it looks to me like you're trying to store it as a string instead of a date. That would be stupid.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i tried this
insert into news(date) values (CONVERT(char(10), 2001-01-01, 101))
but still it is 2001-01-01 00:00:00
|
|
|
|
|
A datetime has a time component. IF you want to work only with dates, just ignore the time part, and set it to 0 for all values.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
If you are using sql server 2008 then there is a data type date for this purpose. you can use that.
|
|
|
|
|
im using sql server 2005...
|
|
|
|
|
madhukk wrote: im using sql server 2005...
It's just the same; like I told you yesterday, store your dates as date values not as strings. Then, when you want to display them or print them you can format them any way you like, in any order, with or without the time.
|
|
|
|
|
i stored in date itself but i want seperate into three dropdownlists
ddl1(mm) ddl2(dd) ddl3(yyyy)
string final = Session["startdate"].ToString();
DateTime dt;
dt = Convert.ToDateTime(final);
final = dt.Day + "/" + dt.Minute + "/" + dt.Year;
TextBox1.Text = final;
DropDownList5.SelectedItem.Text = dt.Day.ToString();
Object reference not set to an instance of an object.
what im i doing wrong????
|
|
|
|
|
madhukk wrote: what im i doing wrong????
Well your main problem suggests that either DropDownList5 or its SelectedItem property do not have a valid reference.
Also you have dt.Minute where you want the month.
Lastly, you still seem to be wasting processing on converting DateTime values to and from String values when it is not necessary. I would be tempted to rewrite the above (assuming Session["startdate"] returns a DateTime value) :
DateTime dt = Session["startdate"];
TextBox1.Text = dt.ToString("dd/MM/yy");
DropDownList5.SelectedItem.Text = dt.Day.ToString();
|
|
|
|
|
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
Source Error:
Line 29: <compilation debug="true">
Line 30: <assemblies>
Line 31: <add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 32: <add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 33: <add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Source File: E:\Projects\SCHOOL MGMT\DAISY CD\SchoolManagementSystem\web.config Line: 31
Assembly Load Trace: The following information can be helpful to determine why the assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' could not be loaded.
|
|
|
|
|
Here comes another one with that 'URGENT'.
The error is very well describing itself, it is unable to load some crystal report assembly.
Are you using crystal reports?
1. If Yes, then see why these are not loading.
2. If No, then remove that assembly section from Web.Config.
|
|
|
|
|
It's urgent', yet you can't read the error, think about what it may mean, google it, etc ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I have to use the logical and OR for one of my logic in my form. Just thinking of the following, want to confirm.
When I use 'select 0 & 1' it gives 0 and when I user 'select 0 | 1' it gives 1. From this, I think, the '&' gives the lowest value and '|' gives the highest value. Is this correct? Is there any other differences? please help.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
meeram395 wrote: When I use 'select 0 & 1' it gives 0 and when I user 'select 0 | 1' it gives 1. From this, I think, the '&' gives the lowest value and '|' gives the highest value. Is this correct? Is there any other differences? please help.
Have a look at these links:
1) Logical Conjunction (AND)[^]
2) Logical Disjunction (OR)[^]
The Truth tables and Ven diagrams from the above articles will help you understand these operators.
I hope this helps. 
Regards
Nuri Ismail
|
|
|
|
|
Thanks very much
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
This has nothing to do with ASP.NET, but you have NO idea what and and or do, you are totally lost. I think it's cool that you're experimenting, but you should read some resources instead of guessing, or you will just get in trouble.
They actually do what they say. 1 is true and 0 is false. Only one needs to be true in an OR, both need to be true in an AND.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i have to make setup of ASP.net 3.5 application. i create it successfully, even it is working fine. but the problem is it copies .cs files also when i install it on the machine. what i want is setup should not copy .cs files of the .aspx pages and work fine after installing it on a machine. please help im in a fix.
thanks
|
|
|
|
|
What makes you sure this is the case ? Does your application compile so there's a dll that contains those cs files ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i mean i make the setup and when i run the setup for test purpose what i see in wwwroot is the directory with project name and having all the .aspx.cs files installed. please help me. steps i follow to make setup are:
1. Add web setup project
2. right click on web application folder and select project output
3. it displays only content files dere in the dialog box "Add project output group". select it and click ok
4.Build
Pleeeeeeeeeeeeese Help
|
|
|
|
|
You typed a lot of stuff and yet you didn't answer my question ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
wt i want is i want to give user setup and when he run setup there, code files(.cs Files) of my pages shd not be copied. like if i have ABC.aspx it always has ABC.aspx.cs(this file shd not be coppied). please tell me how can i make setup of it.
|
|
|
|
|
can we stop window.open on page refresh event... because if i refresh then also this code is executing...
Sorry I am repeating my question..
Thanks in advance
Yrishi
|
|
|
|
|
yrishi wrote: Sorry I am repeating my question..
Yes, you are. And the answers are not going to change.
1 - window.open is not a solution
2 - an AJAX call is more reliable
3 - even that is not going to work 100% of the time
4 - therefore, most of the pages on the web find other ways to deal with this.
Asking the same question and expecting a different answer, is not really terribly bright.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanks for quick reply..
you mean to say that AJAX call is also not 100% sure solution(as your point no 2 and 3)
Please update me
|
|
|
|
|
Yes, I told you that last time. If someone closes the browser, rather than goes to another page, I'm not sure if the event fires. Either way, you can't be sure someone's computer didn't just crash, right ?
Like I said last time, your solution is to fix your code, not to look for something that does not reliably exist.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
