save the data temporatily in a Session variable ~ go to confirm page ~ In confirm page to add , retrieve data from session and save it into database ~ to delete , just remove the session variable using Session.Remove

The ASP.NET forum is the right place for this. momoo wrote: I using .ascx file to design it. That's a control, which needs embedding on a page to be displayed. momoo wrote: This is ascx (under html view). I can't see how writing the text is going to help you - you need to add some sort of control that is databound ( can tell which object it's working on ) and that redirects you to another page. Christian Graus - Microsoft MVP - C++

That all depends on what your using to handle logins. There is no one way of authenticating, tracking, and giving roles to users of your site. How you do the logout depends ENTIRELY on how you designed your authentication package, how your tracking your user sessions, what you need to do when the user logs out, or the session times out. Without a LOT more detail about your security system, it's impossible for anyone to tell you how to code your logout. That is, other than dropping a button on a form and handling it's click event. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

There are navigator bars out there that have been developed for ASP .NET 1.1. They generally use a JavaScript implementation to display fly-out menus. http://aspalliance.com/652#Page7 Take a look at category 6. However, with ASP .NET 2.0, Microsoft has introduced a fully featured menu control which should meet your needs - if you're able to upgrade.

A simple lookup on MSDN will help you. I suggest you do that in future before asking because * you learn better that way * somebody is not always going to be around to help you Please don't think I'm being harsh or condescending. :) This is what you're supposed to do, if you want the date as a string in the DD/MM/YYYY format: DateTime dt = DateTime.Now; string todaysDate = dt.ToString("dd/MM/yyyy"); Now you can do whatever you want with this string. Retrieving the time is very similar, just change the format string in the call to ToString(). HTH. :) Cheers, Vikram. "When I read in books about a "base class", I figured this was the class that was at the bottom of the inheritence tree. It's the "base", right? Like the base of a pyramid." - Marc Clifton.

Hi,J4amieC.. Below is my code which i have changed.. But somehow when i run the program, the database does not show out when i click on the date. Is there's anything wrong or i still missing on some part?? DateTime selectedDateTime = CAL1.SelectedDate; SqlConnection conn=new SqlConnection("my connection string"); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM Particulars WHERE DateField = @Date"; cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = CAL1.SelectedDate; Thanks for your help!!:) Regards

I've done a site wide navigation control before using a User Control. A User Control is just like any other control on your page (ei, button, textbox, checkbox, etc.) but it is one that you write yourself. Once it is written you can include it in any page on your site. Cehck out this page for a simple User Control tutorial: http://www.asp101.com/lessons/usercontrols.asp[^] "Half this game is ninety percent mental." - Yogi Berra

Hello_mouse wrote: somehow it dosen't work at all!! You mean the css is not applying to the web page? And make sure that the value of the href attribute is correct? the relative path to ur css file is correct? << >>

First of all, never use string concatenation like that in SQL strings. All I have to do as an attacker is set the TBDate1.Text field (either in the page or via an HTTP GET or POST) to ' or 1=1; delete from Particulars; -- and your table is gone. With probing I could do worse, such as steal credit card information or other private information, etc. This is called a SQL injection attack and is one of the most overlooked vulnerabilities. Use parameterized queries using the SqlCommand.Parameters collection property. That's also the answer to the problem here. Dates are typically surrounded by "#" (depending on the database management system) but using parameters eliminates having to know that: SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM Particulars WHERE DateField = @Date"; cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = DateTime.Parse(TBDate1.Text); // ... Add some error-handling, though, since DateTime.Parse could fail if incorrectly formatted. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Customer Product-lifecycle Experience Microsoft [My Articles] [My Blog]

Hello_mouse wrote: My problem is that if i retrieve the database, how can i select, edit or delete the particulars from the database which i select? Using SQL. You don't retrieve a database, you retrieve a set of data which is a snapshot of the moment when you asked for it. You retrieve data, but you execute SQL to update or delete data seperately, although you may use the data you got back to build your query ( although it's better to use stored procs than to send SQL to the database ). Google is bursting with help on this. Christian Graus - Microsoft MVP - C++

Good morning Write a method like the below to populate the form // could be global private string strErrorMsg = "Database error: " + exp.Message; try { SqlConnection conn = new SqlConnection(put your connection string hear); strSQL = "SELECT * FROM theNameOftheTable"; SqlCommand cmd = new SqlCommand(strSQL, conn); cmd.CommandType = CommandType.Text; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); // a method to display the information, is this a grid or form with textboxes? conn.Close(); cmd.Dispose(); conn.Dispose(); } catch { //some message about the error strErrorMsg; }

You need to make your calendar control auto postback on selection, then set it in your codebehind. Christian Graus - Microsoft MVP - C++

Although I am not very familiar with ADO.NET, I think that if you intercept the calendar's event handler for a value changed then you will be able to know that the current selected date has chnged... I hope you understand...because is a rough world out there...

When You Open a New Window When you open a new window (Calendar) just pass your form name along with the textbox name. Inside The Your Code in NEWWINDOW.ASP When you click any control in NEWWINDOW.ASP you may call some function. In that function use the following code. if (opener !=null){ var updateTo=eval("opener.document." + hSourceCtrlName); updateTo.value=dateField; updateTo.focus(); } Where hSourceCtrlName=FORM NAME.TEXT BOX NAME(where you want to return focus) Where dateField =Your Date. N.Rajakumar B.E., Application Developer,

Yup.. So when i click on the date i slected it'll display on the grid.. Anyones know how to do it.. Thank... ;) Cheers!

Hi there, What you might need to do is to create an event handler for the SelectionChanged event of the Calendar[^] control. In the event handler, you can get the selected date from the SelectedDate property and execute an SQL command to query data. If you don't know about the ADO.NET, then the documentation[^] can get you started.

Okie.. i got it.. Thankz.. Cheese_kid =p

Hi.. Thankz.. I have put my design in the table.. But the problem i that when i resize the frame it is not centre align anymore.. So i'm asking if anyones know that how can i make the object centre no matter how i resize it anot.. Thankz... ;) Cheese_kid =p

Hi there, Your question is so generall :zzz:. You need to ask a scpecific question. Cheese_kid wrote: i need to retrieve user list where do u retrieve user list? (Database, or just normal file) if u decide which technology used as ur back-end, so then you should go ahead with some next steps << >>