ASP.NET

21-Oct-09 21:57

can we insert only date (mm/dd/yyyy) using smalldatetime(mm/dd/yyyy 00:00:00) as datatype.. into sql table
as i used this to select..

select (CONVERT(CHAR(10), date, 101)) as date

Christian Graus21-Oct-09 22:01

21-Oct-09 22:01

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.

m@dhu21-Oct-09 22:59

21-Oct-09 22:59

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

Christian Graus22-Oct-09 0:51

22-Oct-09 0:51

A datetime has a time component. IF you want to work only with dates, just ignore the time part, and set it to 0 Blush | :O

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.

Nisha Agrawal22-Oct-09 0:34

Nisha Agrawal

22-Oct-09 0:34

If you are using sql server 2008 then there is a data type date for this purpose. you can use that.

m@dhu22-Oct-09 1:11

22-Oct-09 1:11

im using sql server 2005...

Richard MacCutchan22-Oct-09 1:30

Richard MacCutchan

22-Oct-09 1:30

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.

m@dhu22-Oct-09 3:26

22-Oct-09 3:26

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;
// i got mm/dd/yyyy

 DropDownList5.SelectedItem.Text = dt.Day.ToString();
Object reference not set to an instance of an object.

what im i doing wrong????

error in my projects please need help its urgent

Richard MacCutchan22-Oct-09 4:20

Richard MacCutchan

22-Oct-09 4:20

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();

AjitMourya21-Oct-09 21:40

AjitMourya

21-Oct-09 21:40

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.

Re: error in my projects please need help its urgent

nagendrathecoder21-Oct-09 21:53

nagendrathecoder

21-Oct-09 21:53

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.

Re: error in my projects please need help its urgent

Christian Graus21-Oct-09 21:59

Is there any other difference between AND & OR

21-Oct-09 21:59

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.

meeram39521-Oct-09 20:45

meeram395

21-Oct-09 20:45

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.

Re: Is there any other difference between AND & OR

Nuri Ismail21-Oct-09 20:55

Nuri Ismail

21-Oct-09 20:55

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. Smile | :)

Regards

Nuri Ismail

Re: Is there any other difference between AND & OR

meeram39521-Oct-09 21:49

meeram395

21-Oct-09 21:49

Thanks very much

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Is there any other difference between AND & OR

Christian Graus21-Oct-09 21:39

Built Setup of ASP.net application

21-Oct-09 21:39

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.

S.Aijaz21-Oct-09 20:20

S.Aijaz

21-Oct-09 20:20

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

Christian Graus21-Oct-09 20:21

21-Oct-09 20:21

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.

S.Aijaz21-Oct-09 20:39

S.Aijaz

21-Oct-09 20:39

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

Christian Graus21-Oct-09 22:01

21-Oct-09 22:01

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.

S.Aijaz22-Oct-09 0:07

S.Aijaz

22-Oct-09 0:07

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.

Browser close issue

yrishi21-Oct-09 19:29

yrishi

21-Oct-09 19:29

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

Re: Browser close issue

Christian Graus21-Oct-09 20:24