ASP.NET

R.Palanivel15-Feb-07 4:14

R.Palanivel

15-Feb-07 4:14

HI
you just use this code

insertCmd.Parameters.Add("@DateVale", SqlDbType.DateTime,10);

insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")

r_palanivel83 10:01 4 Jan '06

Colin Angus Mackay15-Feb-07 4:41

Colin Angus Mackay

15-Feb-07 4:41

r_palanivel83 wrote:
insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")

Why on Earth would you convert the date to a string?! Just pass it the DateTime object.

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

Kunal P15-Feb-07 5:00

15-Feb-07 5:00

i am now able to add the date to the database.. bu there is on problem.. when i retrive the date when the employee was added.. it will also the time along the date..

i dont want the time to at all get into the database... is it possible.

Kunal Piyush

badgrs15-Feb-07 5:34

badgrs

15-Feb-07 5:34

A date field also includes the time - I see no reason why you wouldn't want this information available even if you don't want to display it. Use DateTime.ToString(format) to format the output without time.

Kunal P17-Feb-07 3:18

17-Feb-07 3:18

a lil bit of problem..
the date would be retrieved from the database... now how shud i fomat it without the time.. and in DD/MM/YYYY format..

to retrieve i m using this line of code

Label1.Text = "" + dread["dt"].ToString();

where dt is the datetime field in the database.

Kunal Piyush

badgrs18-Feb-07 0:37

badgrs

18-Feb-07 0:37

Kunal P wrote:
Label1.Text = "" + dread["dt"].ToString();

If you look in the documentation you'll see the ToString method is overloaded (has several different methods with different parameters). You can feed is a string format like this: (and you don't need the initial blank string - that just creates another object to be cleaned up by the GC)

Label1.Text = dread["dt"].ToString("dd/MM/yyyy");

You'll probably find you need to cast it to a DateTime object first:

Label1.Text = ((DateTime)dread["dt"]).ToString("dd/MM/yyyy");

This documents the possible formating strings:
Custom DateTime Format Strings

Kunal P19-Feb-07 1:35

web based data analysis tool for stocks

19-Feb-07 1:35

hi
thanks a lot for all the help.. and i am sorry if i am asking way too basic questions.. just started programming..;P

Kunal Piyush

Extending MasterPage

Taurian11015-Feb-07 3:03

Taurian110

15-Feb-07 3:03

I am trying to create a base MasterPage class that all the other MasterPages will inherit from. This base class will have some controls so the inheriting MasterPages get those controls automatically.

My problem is that whenever I add controls to my base class it doesnt get added withing the "FORM" tag and I get errors like "Calendar control must be within FORM tag". What am I doing wrong?

this is how I am doing it:

protected override void OnPreRender(EventArgs e)
{
            base.OnPreRender(e);
            string Header = "<div>some text</div>";
            this.Controls.Add(new LiteralControl(Header));
}

but when I look at the page it is something like this:

...
<form>
...
...
...
</form>
<div>some text</div>

Any help would be appreicated. Thanks.

Re: Extending MasterPage

Not Active15-Feb-07 4:25

Not Active

15-Feb-07 4:25

Find the form tag on the master page and add the controls to its collection, not to the master pages' controls collection

only two letters away from being an asset

Re: Extending MasterPage

Taurian11015-Feb-07 7:49

Taurian110

15-Feb-07 7:49

Thanks a lot Smile | :)

tota123415-Feb-07 2:55

tota1234

15-Feb-07 2:55

our application would need:

1.import data(stock prices) from websites into a database(excel sheets)
2.interfacing excel sheets with the asp application
3.performing manipulations on the data and draw corresponding graphs(line,bar,..)
4.make the application accessible on a network

are asp.net and C# apt for the application?
can someone please help us with relevant code?

regards

ps:please reply asap

besides our email add are:

funwithsiddartha@gmail.com
lovelyritesh_in@yahoo.com
shobhit.samaria@gmail.com
abhinavsharma0507@gmail.com

Lost input values in formview when cancel insert command.

JimFeng15-Feb-07 2:54

JimFeng

15-Feb-07 2:54

I have a formview. When I cancel insert command with e.cancel in OnItemInserting envent, all inputted values in the fromview are gone. Any help is appreciated.

retreiving data in dropbox

Kunal P15-Feb-07 2:48

15-Feb-07 2:48

hi
i am devloping a c# web based appl. i wanted to ask as to how to retreieve data to drop down boxes.

i wanted to update details of employees.. for eg. their state of residence.
though the addition was done by way of drop down box. but now how shud i retrieve the field so that the drop down box shows the state of the employee.

to retrieve to textfields i m using this

fname.Text = "" + dread["FirstName"].ToString();

Kunal Piyush

Not Active15-Feb-07 4:22

Not Active

15-Feb-07 4:22

fname.Text = dropdownlist.SelectedValue

Not difficult if you read the documentation

only two letters away from being an asset

Kunal P17-Feb-07 3:06

17-Feb-07 3:06

i guess this piece of code wud assign the text box the value of the selecte item in the drop down box..

my problem was a bit different, i wanted the value from the database to be reflected in the drop down box..

sorry if i was not able to clarify myself..

Kunal

Not Active17-Feb-07 5:54

Not Active

17-Feb-07 5:54

http://msdn2.microsoft.com/en-us/library/31723w77(vs.80).aspx[^]

Again, not very difficult to find if you look for the information

only two letters away from being an asset

Kunal P17-Feb-07 21:48