MSDE Installation & Configuration

Populate DropDownList

Using SqlDataAdapter ( No AutoPostback)

protected void geturl()
{
string conninfo = ConfigurationSettings.AppSettings["StudentConn"];
SqlConnection conn = new SqlConnection(conninfo);

SqlCommand objcmd = new SqlCommand("GetUrlDesc", conn);
objcmd.CommandType = CommandType.StoredProcedure;

conn.Open();
SqlDataReader objrdr= objcmd.ExecuteReader();

ddlurl.DataSource = objrdr;
ddlurl.DataTextField = "Description";
ddlurl.DataValueField = "Description";
ddlurl.DataBind();

}

Using DataSet and SqlDataAdapter (AutoPostBack)

rotected void Page_Load(object sender, EventArgs e)
{
ArrayList ar = new ArrayList();
DataSet ds= Geturldesc();
DataTable dt=ds.Tables[0]; //or ds.Tables["webdescription"];

foreach( DataRow row in dt.Rows)
ar.Add(row["Description"]);

ddlurl.DataSource=ar;
ddlurl.DataBind();

}

protected DataSet Geturldesc()
{
string conninfo = ConfigurationSettings.AppSettings["StudentConn"];
SqlConnection conn = new SqlConnection(conninfo);

SqlCommand objcmd = new SqlCommand("GetUrlDesc", conn);
objcmd.CommandType = CommandType.StoredProcedure;

DataSet objds = new DataSet();
SqlDataAdapter objda = new SqlDataAdapter();
objda.SelectCommand = objcmd; //associate sel command with sqldataadapter

conn.Open();
objda.Fill(objds, "webdescription");

return objds;

}

Grab Control Values from Previous page

1 . Button in page1 need to have PostBackUrl="~/P2.aspx"

2. Page 2 , following code to grab value of control from Page1

TextBox tbname=new TextBox();
TextBox tbpass = new TextBox();
Calendar c = new Calendar();
tbname= (TextBox)PreviousPage.FindControl("Textbox1");
tbpass = (TextBox)PreviousPage.FindControl("Textbox2");
c = ((Calendar)PreviousPage.FindControl("Calendar1"));
Label1.Text = string.Format("hello {0} with password {1}, you click on {2}", tbname.Text , tbpass.Text,c.SelectedDate.ToShortDateString() );

Create/Check Cookie

void Page_Load (Object s , EventArgs e){

HttpCookie ck=Request.Cookies.Get("WEB1");
if (ck!=null)
Response.Redirect("page1.aspx");

}

void Create_Cookie(String userid)
{
HttpCookie cookie = new HttpCookie("WEB1");

cookie.Value=userid;

Request.UserHostAddress.ToString()
Convert.ToString(Request.ServerVariables["REMOTE_HOST"]);

DateTime dtNow = DateTime.Now;
TimeSpan tsMinute = new TimeSpan(0, 0, 10, 0);
cookie.Expires = dtNow + tsMinute;

Response.Cookies.Clear();
Response.Cookies.Add(cookie);

Response.Write("Cookie value " +cookie.Value.ToString()+ " has been written. <br><hr>");
}