Add Radion Button in a GridView Control

July 19, 2010 Leave a comment

GridView Code for aspx page

<asp:GridView ID=”gvAvailableDuration” runat=”server”
AutoGenerateColumns=”False”  SkinID=”CJGrid”
onrowcommand=”gvAvailableDuration_RowCommand”
onrowcreated=”gvAvailableDuration_RowCreated”>
<Columns>
<asp:BoundField DataField=”AdId” HeaderText=”AdId” Visible=”false” />
<asp:TemplateField HeaderText=”Select”>
<ItemTemplate>
<asp:Literal ID=”rdoRowSelector” runat=”server”></asp:Literal>

</ItemTemplate>
</asp:TemplateField>

<asp:BoundField DataField=”startDate” HeaderText=”Start Date”  />
<asp:BoundField DataField=”EndDate” HeaderText=”End Date”  />

</Columns>
</asp:GridView>

Add  This Code into your CS page

protected void gvAvailableDuration_RowCreated(object sender, GridViewRowEventArgs e)
{

string sStartDate = “”;
string sEndDate = “”;
if (e.Row.RowType == DataControlRowType.DataRow)
{
Literal output = (Literal)e.Row.FindControl(“rdoRowSelector”);
DataRowView rowV = (DataRowView)e.Row.DataItem;
if (rowV != null)
{
sStartDate = rowV.Row.ItemArray[1].ToString();
sEndDate = rowV.Row.ItemArray[2].ToString();
output.Text = string.Format(“<input type=’radio’ name=’DateGroup’ id=’” + e.Row.RowIndex + “‘ value=’” + sStartDate + “$” + sEndDate + “‘ onclick=’SetDate(” + e.Row.RowIndex + “)’ />”, e.Row.RowIndex);
}
}

}

Categories: Asp.Net

Save and retrieve values in Cookie (C#)

July 13, 2010 Leave a comment


<%@ Page Language="c#" %>
<script Language="c#" runat="server">
void Page_Load(object source, EventArgs e)
{
if (!(IsPostBack))
{
MyButton.Text = "Save Cookie";
MyDropDownList.Items.Add("Blue");
MyDropDownList.Items.Add("Red");
MyDropDownList.Items.Add("Gray");
}
}
public void Click(object sender, EventArgs e)
{
HttpCookie MyCookie = new HttpCookie("Background");
MyCookie.Value = MyDropDownList.SelectedItem.Text;
Response.Cookies.Add(MyCookie);
}

</script>

<html>
<body>
<form id=“CookieForm” method=“post” runat=“server”>
<asp:DropDownList id=MyDropDownList runat=“server”/>
<asp:button id=MyButton runat=“server” OnClick=“Click”/>
</form>
</body>
</html>

///////////////////////////////////////////////////

<%@ Page Language=“c#” %>
<script Language=“c#” runat=“server”>
void Page_Load(object source, EventArgs e)
{
Response.Cache.SetExpires(DateTime.Now);
}
string GetBackground()
{
return Request.Cookies["Background"].Value;
}
</script>
<html>
<body bgcolor=“<% Response.Write(GetBackground()); %>”>
<asp:label id=“message” runat=“server” />
</body>
</html>
Categories: Cookies

String Format for DateTime [C#]

July 12, 2010 Leave a comment

This example shows how to format DateTime using String.Format method. All formatting can be done also using DateTime.ToString method.

Custom DateTime Formatting

There are following custom format specifiers y (year), M (month), d (day), h (hour 12), H (hour 24), m (minute), s (second), f (second fraction), F (second fraction, trailing zeroes are trimmed), t (P.M or A.M) and z (time zone).

Following examples demonstrate how are the format specifiers rewritten to the output.

[C#]

// create date time 2008-03-09 16:05:07.123
DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);

String.Format("{0:y yy yyy yyyy}", dt);  // "8 08 008 2008"   year
String.Format("{0:M MM MMM MMMM}", dt);  // "3 03 Mar March"  month
String.Format("{0:d dd ddd dddd}", dt);  // "9 09 Sun Sunday" day
String.Format("{0:h hh H HH}",     dt);  // "4 04 16 16"      hour 12/24
String.Format("{0:m mm}",          dt);  // "5 05"            minute
String.Format("{0:s ss}",          dt);  // "7 07"            second
String.Format("{0:f ff fff ffff}", dt);  // "1 12 123 1230"   sec.fraction
String.Format("{0:F FF FFF FFFF}", dt);  // "1 12 123 123"    without zeroes
String.Format("{0:t tt}",          dt);  // "P PM"            A.M. or P.M.
String.Format("{0:z zz zzz}",      dt);  // "-6 -06 -06:00"   time zone

You can use also date separator / (slash) and time sepatator : (colon). These characters will be rewritten to characters defined in the current DateTimeForma­tInfo.DateSepa­rator and DateTimeForma­tInfo.TimeSepa­rator.

[C#]

// date separator in german culture is "." (so "/" changes to ".")
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9/3/2008 16:05:07" - english (en-US)
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9.3.2008 16:05:07" - german (de-DE)

Here are some examples of custom date and time formatting:

[C#]

// month/day numbers without/with leading zeroes
String.Format("{0:M/d/yyyy}", dt);            // "3/9/2008"
String.Format("{0:MM/dd/yyyy}", dt);          // "03/09/2008"

// day/month names
String.Format("{0:ddd, MMM d, yyyy}", dt);    // "Sun, Mar 9, 2008"
String.Format("{0:dddd, MMMM d, yyyy}", dt);  // "Sunday, March 9, 2008"

// two/four digit year
String.Format("{0:MM/dd/yy}", dt);            // "03/09/08"
String.Format("{0:MM/dd/yyyy}", dt);          // "03/09/2008"

Standard DateTime Formatting

In DateTimeForma­tInfo there are defined standard patterns for the current culture. For example property ShortTimePattern is string that contains value h:mm tt for en-US culture and value HH:mm for de-DE culture.

Following table shows patterns defined in DateTimeForma­tInfo and their values for en-US culture. First column contains format specifiers for the String.Format method.

Specifier DateTimeFormatInfo property Pattern value (for en-US culture)
t ShortTimePattern h:mm tt
d ShortDatePattern M/d/yyyy
T LongTimePattern h:mm:ss tt
D LongDatePattern dddd, MMMM dd, yyyy
f (combination of D and t) dddd, MMMM dd, yyyy h:mm tt
F FullDateTimePattern dddd, MMMM dd, yyyy h:mm:ss tt
g (combination of d and t) M/d/yyyy h:mm tt
G (combination of d and T) M/d/yyyy h:mm:ss tt
m, M MonthDayPattern MMMM dd
y, Y YearMonthPattern MMMM, yyyy
r, R RFC1123Pattern ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (*)
s SortableDateTi­mePattern yyyy'-'MM'-'dd'T'HH':'mm':'ss (*)
u UniversalSorta­bleDateTimePat­tern yyyy'-'MM'-'dd HH':'mm':'ss'Z' (*)
(*) = culture independent

Following examples show usage of standard format specifiers in String.Format method and the resulting output.

[C#]

String.Format("{0:t}", dt);  // "4:05 PM"                         ShortTime
String.Format("{0:d}", dt);  // "3/9/2008"                        ShortDate
String.Format("{0:T}", dt);  // "4:05:07 PM"                      LongTime
String.Format("{0:D}", dt);  // "Sunday, March 09, 2008"          LongDate
String.Format("{0:f}", dt);  // "Sunday, March 09, 2008 4:05 PM"  LongDate+ShortTime
String.Format("{0:F}", dt);  // "Sunday, March 09, 2008 4:05:07 PM" FullDateTime
String.Format("{0:g}", dt);  // "3/9/2008 4:05 PM"                ShortDate+ShortTime
String.Format("{0:G}", dt);  // "3/9/2008 4:05:07 PM"             ShortDate+LongTime
String.Format("{0:m}", dt);  // "March 09"                        MonthDay
String.Format("{0:y}", dt);  // "March, 2008"                     YearMonth
String.Format("{0:r}", dt);  // "Sun, 09 Mar 2008 16:05:07 GMT"   RFC1123
String.Format("{0:s}", dt);  // "2008-03-09T16:05:07"             SortableDateTime
String.Format("{0:u}", dt);  // "2008-03-09 16:05:07Z"            UniversalSortableDateTime
Categories: Asp.Net

The visual studio language support for style has not been installed. code-editing Intellisense will not be available. Markup Intellisense for server controls may not work.”

July 12, 2010 Leave a comment

Resolution is simpler actually , close visual studio go to your windows run box

and type

Devenv /ResetSkipPkgs


this has fixed my problem
Categories: Installation

Listener

June 14, 2010 Leave a comment

Single-Tier Architecture

The single-tier architecture dates back to the days of monolithic mainframes connected  by dumb terminals. The entire application comprising layers such as user interfaces,business rules, and data was collocated on the same physical host. The users interacted with these systems using terminals or consoles, which had very limited text-based processing capabilities.

Figure: Single-Tier Architecture

Two-Tier Architecture

2-tier architecture is used to describe client/server systems where the client requests resources and the server responds directly to the request, using its own resources. This means that the server does not call on another application in order to provide part of the service.

Figure: Two-Tier Architecture

Categories: Oracle

Redo Log File

June 14, 2010 Leave a comment


Redo Log File:
Redo Log file contains any changes made to the data in database buffer cache. Every
database should have at least two redolog files groups.
Check Redo Log file Status:
SQL> select group#,status from v$log;
GROUP# STATUS
———- —————-
1 CURRENT
2 INACTIVE
3 INACTIVE
The log files have the following status values:
Name Meaning
USED Indicates either that a log has just been added but never used.
CURRENT Indicates a valid log that is in use.
ACTIVE Indicates a valid log file that is not currently in use.
CLEARING Indicates a log is being re-created as an empty log due to DBA
action.
CLEARING
CURRENT
Means that a current log is being cleared of a closed thread. If a log
stays in this status, it could indicate there is some failure in the log
switch.
INACTIVE Means that the log is no longer needed for instance recovery but
may be needed for media recovery.
The v$logfile table has a status indicator that gives these additional codes:
Name Meaning
INVALID File is inaccessible.
STALE File contents are incomplete (such as when an instance is shut down
with SHUTDOWN ABORT or due to a system crash).
DELETED File is no longer used.
Null File in use.
Redo Log Buffer
LGWR
Online Redo Log file

2
Adding Redo Log Groups:

SQL> ALTER DATABASE ADD LOGFILE GROUP 4
‘C:\oracle\product\10.2.0\oradata\dba12\REDO04.LOG’
SIZE 10M;
Adding Redo Log Members:
SQL> ALTER DATABASE ADD LOGFILE MEMBER
‘C:\oracle\product\10.2.0\oradata\dba12\REDO04b.LOG’ TO GROUP 4;
Check the file Location of redo log files:
SQL> select group#,member from v$logfile;
GROUP# MEMBER
————————————————————-
3 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA12\REDO03.LOG
2 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA12\REDO02.LOG
1 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA12\REDO01.LOG
4 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA12\REDO04.LOG
4 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA12\REDO04B.LOG
Dropping Online Redo Log Member:
SQL> ALTER DATABASE DROP LOGFILE MEMBER
‘C:\oracle\product\10.2.0\oradata\dba12\REDO04B.LOG’;
Dropping Online Redo Log Groups:
SQL> ALTER DATABASE DROP LOGFILE GROUP 4;
Move Redo Log File Destinations
1. SQL>SHUTDOWN;
2. Copy the redo log file in new location.
3. SQL> STARTUP MOUNT;
4. SQL> ALTER DATABASE RENAME
FILE ‘C:\oracle\product\10.2.0\oradata\dba12\REDO01.LOG’
TO ‘C:\oracle\product\10.2.0\oradata\dba12\redologfile\REDO01.LOG’;
5. SQL> alter database open;
Forcing Log Switch:
SQL> ALTER SYSTEM SWITCH LOGFILE;
Forcing Checkpoint:
SQL> ALTER SYSTEM CHECKPOINT;

Categories: Oracle

PFile and SPFile

June 14, 2010 Leave a comment

PFILE:
PFILE is a text file which can be modified by text editor. Oracle server required PFILE to
start an oracle Instance.
SPFILE:
SPFILE is a binary file which can not be modified by text editor. It is created from
PFILE.
How the Oracle Instance is initialized
When the Oracle instance start, first it looks to the $ORACLE_HOME/dbs
(UNIX, Linux) or ORACLE_HOME/database (Windows) directory for the
following files (in this order):
1. spfileSID.ora (SPFILE)
2. Default SPFILE (SPFILE)
3. initSID.ora (PFILE)
4. Default PFILE (PFILE)
SPFILE advantages
1. No need to restart the database in order to have a parameter changed and
the new value stored in the initialization file
2. Reduce human errors: Parameters are checked before changes are
accepted
3. An SPFILE can be backed-up with RMAN (RMAN cannot backup
PFILEs)
How could I switch from SPFILE to PFILE and vice-versa?
Switch from SPFILE to PFILE:
1) CREATE PFILE FROM SPFILE;
2) Backup and delete SPFILE
3) Restart the instance
Switch from PFILE to SPFILE:
1) CREATE SPFILE FROM PFILE=’Location of the PFILE’;
2) Restart the instance (the PFILE will be in the same directory but will not be
used. SPFILE will be used instead)
Converting SPFILE to PFILE and vice-versa
This could be done in order to have a backup in the other format or to
change the initialization file for the database instance.
CREATE PFILE FROM SPFILE;
CREATE SPFILE FROM PFILE=’/oradata/initORCL.ora’;
CREATE SPFILE = ‘/oradata/spfileORCL.ora’ FROM PFILE = ‘/oradata/initORCL.ora’ ;

Categories: Oracle
Follow

Get every new post delivered to your Inbox.