Assigning value to a cookie...?

Smitch · 08-26-2006, 09: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">
????: NamePros.com http://www.namepros.com/programming/231882-assigning-value-to-a-cookie.html
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, 10:06 PM

Code:

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

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

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

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

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, 10: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, 11: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..
????: NamePros.com http://www.namepros.com/showthread.php?t=231882

Good luck!

- Steve

08-26-2006, 10:06 PM	#2 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Code: Response.Cookies("ckusername").Value = <?php echo $username_from_database; ?> __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

08-26-2006, 11:15 PM	#6 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,272	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.. ????: NamePros.com http://www.namepros.com/showthread.php?t=231882 Good luck! - Steve __________________ I feel old. Last edited by iNod; 08-26-2006 at 11:32 PM.

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

08-26-2006, 10:49 PM	THREAD STARTER #5 (permalink)
Smitch New Member Join Date: Aug 2006 Posts: 3	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)