ASP.NET

Tuesday, January 15, 2013

Cookies in JQuery

You can then do:

$.cookie("test", 1);

To delete:

$.removeCookie("test");

Additionally, to set a timeout of a certain number of days (10 here) on the cookie:

$.cookie("test", 1, { expires : 10 });

If the expires option is omitted, then the cookie becomes a session cookie, and is deleted when the browser exits.

To cover all the options:

$.cookie("test", 1, {
   expires : 10,           //expires in 10 days

   path    : '/',          //The value of the path attribute of the cookie 
                           //(default: path of page that created the cookie).

   domain  : 'jquery.com',  //The value of the domain attribute of the cookie
                           //(default: domain of page that created the cookie).

   secure  : true          //If set to true the secure attribute of the cookie
                           //will be set and the cookie transmission will
                           //require a secure protocol (defaults to false).
});


For complete detail see the following plugin.

https://github.com/carhartl/jquery-cookie

courtesy: https://github.com/carhartl/jquery-cookie

Saturday, April 28, 2012

Auto Refresh ASP.NET PAGE on Database Update

This is the aspx page source. The controls that you want to update must be inside the UpdatePanel.

<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div style="height: 804px; position: relative; top: 0px; left: 0px;"
align="center">
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>

<table style="width:100%; height: 100px;" width="50">

<tr>
<td align="center" valign="top">
<asp:Label ID="lblUpdateTime" runat="server" Text="Label"></asp:Label>
</td>
</tr>

<tr>
<td align="center" valign="top">
<asp:Timer ID="Timer1" runat="server" Interval="10000" ontick="Timer1_Tick">
</asp:Timer>
<asp:DataList ID="dlDataList" runat="server" CellPadding="2"
GridLines="Vertical" Height="106px" RepeatColumns="1" Width="230px"
BackColor="#0066CC">
<ItemTemplate>
<asp:Label ID="MyTableField" runat="server" Font-Size="12pt"
ForeColor="White" Text='<%# Eval("FieldBoundToList") %>' />
<br />
</ItemTemplate>
<SeparatorStyle BorderColor="White" BorderWidth="2" Font-Size="Medium" />
</asp:DataList>
</td>
</tr>

</table>

</ContentTemplate>

</asp:UpdatePanel>

</div>
</form>
</body>

And this is the code behind.

protected void Timer1_Tick(object sender, EventArgs e)
{

string ConnString = "Data Source=TEST\\SQLInstanceName;Initial Catalog=DatabaseName;Integrated Security=True";

try
{
lblUpdateTime.Text = "Last Update: " + DateTime.Now.ToString();

//I am using LINQ To SQL here
using (DataDataContext context = new DataDataContext(ConnString))
{
//Here I am using a stored procedure and binding the results to the datalist.
//dlDataList.DataSource = context.spGetSomething().Take(20);
//dlDataList.DataBind();

//Or you can do something like this.
var query = from p in context.TableName
select p;

dlDataList.DataSource = query;
dlDataList.DataBind();

}
}
catch (Exception)
{

//Do something here
}

}