Assigning value to a cookie...?

Smitch · 08-26-2006, 08:57 PM

Hey,

I was wondering if anyone could help me out with the following problem. I have created a user authentication system using dreamweaver. It all work fine except I want to make a few changes.

Here is the code I want to change;

Quote:

1 <Script runat="server">
2 Sub button_click(s as object, e as eventargs)
3 If ds_checkuserinfo.RecordCount = 1 Then
4 Response.Cookies("ckusername").Value = Request.Form("txtusername")
5 Response.Cookies("ckusername").Expires = DateTime.Now.AddDays(1)
6 Response.Redirect("index.aspx")
7 End if
8 End Sub
9 </script>

How do I assign the fist cookie, 'ckusername' (line 4) to a value from a MSSQL database instead of a form variable?

Thanks in advance
-Smitch

Barrucadu · 08-26-2006, 09:06 PM

Code:

Response.Cookies("ckusername").Value = <?php echo $username_from_database; ?>

Smitch · 08-26-2006, 09:46 PM

sorry i should have said....needs to be asp.net. Sorry

Barrucadu · 08-26-2006, 09:46 PM

Quote:

Originally Posted by Smitch

sorry i should have said....needs to be asp.net. Sorry

I should really learn asp.net sometime..... lol

Smitch · 08-26-2006, 09:49 PM

any asp.net coders around? Im not sure how to actually get the value from that database and assign it to the cookie.

Thanks

iNod · 08-26-2006, 10:15 PM

Hello,

-- Changed since I noticed you want .NET

Code:

SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comm = new SqlCommand("SELECT fields FROM table_name", conn);
comm.Connection.Open();
SqlDataReader r = comm.ExecuteReader(CommandBehavior.CloseConnection);
Response.Cookies["TestCookie"].Value = r.GetString(0)
r.Close();
conn.Close();

I just did it off the top of my head.. So you can get an example. Though I am not a great ASP.Net coder..

Good luck!

- Steve

08-26-2006, 09:06 PM	#2 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	Code: Response.Cookies("ckusername").Value = <?php echo $username_from_database; ?> __________________ Website \| Blog \| Uzbl (my branch) 9thSeptember2009.com

08-26-2006, 10:15 PM	#6 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,289 126.05 NP$ (Donate)	Hello, -- Changed since I noticed you want .NET Code: SqlConnection conn = new SqlConnection(connectionString); SqlCommand comm = new SqlCommand("SELECT fields FROM table_name", conn); comm.Connection.Open(); SqlDataReader r = comm.ExecuteReader(CommandBehavior.CloseConnection); Response.Cookies["TestCookie"].Value = r.GetString(0) r.Close(); conn.Close(); I just did it off the top of my head.. So you can get an example. Though I am not a great ASP.Net coder.. Good luck! - Steve __________________ I feel old. Last edited by iNod; 08-26-2006 at 10:32 PM.

08-26-2006, 09:46 PM	#3 (permalink)
Smitch New Member Join Date: Aug 2006 Posts: 3 0.00 NP$ (Donate)	sorry i should have said....needs to be asp.net. Sorry

08-26-2006, 09:49 PM	#5 (permalink)
Smitch New Member Join Date: Aug 2006 Posts: 3 0.00 NP$ (Donate)	any asp.net coders around? Im not sure how to actually get the value from that database and assign it to the cookie. Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)