BrijeshSolutions

GET random Unique OTP(One Time Password) in C#.NET

noreply@blogger.com (Brijesh Kumar Singh) — Sat, 10 May 2014 11:16:00 +0000

Use this Code for random Unique OTP(One Time Password) generation:

private string generatePassword()
{
int lenthofpass = 6;
string allowedChars = "";
allowedChars = "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,";
allowedChars += "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,";
allowedChars += "1,2,3,4,5,6,7,8,9,0,!,@,#,$,%,&,?";
char[] sep = { ',' };
string[] arr = allowedChars.Split(sep);
string passwordString = "";
string temp = "";
Random rand = new Random();
for (int i = 0; i < lenthofpass; i++)
{
temp = arr[rand.Next(0, arr.Length)];
passwordString += temp;
}
return passwordString;
}

Send Mail with Attachment in asp.net

noreply@blogger.com (Brijesh Kumar Singh) — Tue, 29 Apr 2014 13:19:00 +0000

MailAddress SendFrom = new MailAddress("brijesh.singh879@gmail.com", "Brijesh");
MailAddress SendTo = new MailAddress("brijesh.singh879@gmail.com");
System.Net.Mail.MailMessage MyMessage = new System.Net.Mail.MailMessage(SendFrom, SendTo);
MyMessage.IsBodyHtml = true;
MyMessage.Subject = "Send Mail with attachment ";
MyMessage.Body = "Body";
if (fupResume.HasFile)
{
string FileName = Path.GetFileName(fupResume.PostedFile.FileName);
MyMessage.Attachments.Add(new Attachment(fupResume.PostedFile.InputStream, FileName));
}
System.Net.NetworkCredential authentication = new System.Net.NetworkCredential("brijesh.singh879@gmail.com", "password");
SmtpClient client = new SmtpClient("smtp.gmail.com", 25);//587
client.EnableSsl = true;
client.UseDefaultCredentials = true;
client.Credentials = authentication;
client.Send(MyMessage);

Directly Bind Byte[] Type Image data to Image control asp.net

noreply@blogger.com (Brijesh Kumar Singh) — Tue, 08 Apr 2014 07:12:00 +0000

Use this code for display image on both asp Image control and html img tag

<asp:Image ImageUrl='<%# "data:image/jpg;base64," + Convert.ToBase64String((byte[])Eval("IMG_DATA")) %>' />

Re-sized Image of byte[] array type in asp.net

noreply@blogger.com (Brijesh Kumar Singh) — Fri, 04 Apr 2014 12:07:00 +0000

I found the solutions of image re-sizing at run-time in asp.net

use this code to obtain re-sized image:

SqlCommand cmd = new SqlCommand("select ProductPicture from ProductDetails where Id=" + pdctid + "", con);

byte[] product = (byte[])cmd.ExecuteScalar();

MemoryStream stream = new MemoryStream(product);

Response.BinaryWrite(ResizeUploadedImage(stream));

private byte[] ResizeUploadedImage(Stream streamToResize)

{

byte[] resizedImage;

using (System.Drawing.Image orginalImage = System.Drawing.Image.FromStream(streamToResize))

{

ImageFormat orginalImageFormat = orginalImage.RawFormat;

int orginalImageWidth = orginalImage.Width;

int orginalImageHeight = orginalImage.Height;

int resizedImageWidth = 150; // Type here the width you want

int resizedImageHeight = 90; // Type here the hight you want

using (Bitmap bitmapResized = new Bitmap(orginalImage, resizedImageWidth, resizedImageHeight))

{

using (MemoryStream streamResized = new MemoryStream())

{

bitmapResized.Save(streamResized, orginalImageFormat);

resizedImage = streamResized.ToArray();

}

return resizedImage;

}

Export GridView Data with Image in C#.net

noreply@blogger.com (Brijesh Kumar Singh) — Tue, 01 Apr 2014 10:54:00 +0000

Write this code on .aspx page

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">

<asp:BoundField DataField="Name" HeaderText="Name" />

<asp:BoundField DataField="Job" HeaderText="Job" />

<asp:BoundField DataField="Location" HeaderText="Location" />

<asp:ImageField DataImageUrlField="Image" HeaderText="Image">

</asp:ImageField>

</Columns>

</asp:GridView>

<asp:Button ID="Button1" runat="server" Text="Export" onclick="Button1_Click" />

</div>

</form>

</body>

</html>

copy & paste this code on .cs page....

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

FillGridview();

}

private void FillGridview()

{

DataTable table = new DataTable();

table.Columns.Add("Name", typeof(string));

table.Columns.Add("Job", typeof(string));

table.Columns.Add("Location", typeof(string));

table.Columns.Add("Image");

table.Rows.Add("JP", "XXX", "QQQQ", "http://localhost:10735/WebSite2/image/sub-menu-corner.png");

table.Rows.Add("HP", "TTT", "AAAA", "http://localhost:10735/WebSite2/image/sub-menu-corner-2.png");

table.Rows.Add("SQ", "YYY", "HHHH", "http://localhost:10735/WebSite2/image/section1-bg.jpg");

table.Rows.Add("XS", "EEE", "UUUU", "http://localhost:10735/WebSite2/image/form-bg.png");

GridView1.DataSource = table;

ViewState["dt"] = table;

GridView1.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

DataTable dt = (DataTable)ViewState["dt"];

GridView1.DataSource = dt;

GridView1.DataBind();

for (int i = 0; i < GridView1.Rows.Count; i++)

{

GridViewRow row = GridView1.Rows[i];

//Apply text style to each Row

row.Attributes.Add("class", "textmode");

}

GridView1.RenderControl(hw);

//style to format numbers to string

string style = @"<style> .textmode { mso-number-format:\@; } </style>";

Response.Write(style);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

}

public override void VerifyRenderingInServerForm(Control control)

{

}

Result:

PRevent Re-submission of Data on Browser reload in C#.NET

noreply@blogger.com (Brijesh Kumar Singh) — Thu, 13 Feb 2014 10:38:00 +0000

On .aspx page write take a hidden field:

<asp:HiddenField id="hdncheckreload" runat="server" />

On .cs page write a function to check whether it's first time call event or reloaded......

public bool notIsRefresh()
{
bool retVal = false;
if (Session["match"] == null || Session["match"].ToString() == hdncheckreload.Value)
retVal = true;
Session["match"] = DateTime.Now.Ticks;
hdncheckreload.Value = Session["match"].ToString();
return retVal;
}

call this method on event which is reloaded such as button click event, form submission etc...

HOw to implement LINQ in C#.NET to Perform Aggregate Function as in SQL Server

noreply@blogger.com (Brijesh Kumar Singh) — Wed, 22 Jan 2014 10:54:00 +0000

First Add the namespace - System.Collections.Generic and System.Linq

Now we get data into datatable :

DataTable dtt = new DataTable();
string _cquery = "Select * from table1";
dtt = du.getdatatable(_cquery);

Now apply group by clause on datatable dtt using LINQ :

var query = from row in dtt.AsEnumerable()
group row by row.Field<string>("col1") into grp
select new { AfterDistinct = grp.Key};
DataTable ddldt = new DataTable();
ddldt.Columns.Add("col1");
foreach (var row in query)
{
int i = 0;
DataRow dr = ddldt.NewRow();
dr["col1"] = row.AfterDistinct.ToString();
ddldt.Rows.Add(dr);
i++;
}
ddl1.Items.Clear();
  ddl1.DataSource = ddldt;
  ddl1.DataTextField = "col1";
  ddl1.DataValueField = "col1";
  ddl1.DataBind();
  ddl1.Items.Insert(0, new ListItem("--Select--", "0"));

in this example we get data with group by clause from DataTable and bind this data to DropdownList ddl1.

HOw to Set ListView DataPager Page Index Property to specific Page Number in asp.net

noreply@blogger.com (Brijesh Kumar Singh) — Wed, 08 Jan 2014 05:14:00 +0000

Copy & Paste this on .aspx file :

<asp:ListView ID="ListView1" runat="server" GroupItemCount="1" GroupPlaceholderID="groupPlaceHolder1"

ItemPlaceholderID="itemPlaceHolder1" OnPagePropertiesChanging="ListView1_PagePropertiesChanging"

OnItemDataBound="ListView1_ItemDataBound">

<table>

<asp:PlaceHolder runat="server" ID="groupPlaceHolder1"></asp:PlaceHolder>

</table>

</LayoutTemplate>

<tr>

<asp:PlaceHolder runat="server" ID="itemPlaceHolder1"></asp:PlaceHolder>

</tr>

</GroupTemplate>

<tr>

<asp:Image ID="imgtick" runat="server" ImageUrl="~/Image/tick.png" Height="35px"

Width="35px" ImageAlign="AbsMiddle" /><asp:Label ID="lblid" runat="server" Text='<%# Bind("ID") %>'

Visible="false"></asp:Label>

</td>

<tr>

<td width="110px" height="60px" align="left" valign="middle" style="border-right-style: solid;

border-right-width: 1px; border-right-color: #CCCCCC">

<asp:Image ID="Image2" runat="server" Height="50px" Width="100px" ImageUrl='<%#Eval("AdImage","../{0}")%>' />

</td>

<td width="224px" height="60px" align="left" valign="top" style="padding-left: 5px;

padding-right: 5px; word-wrap: break-word; border-right-style: solid; border-right-width: 1px;

border-right-color: #CCCCCC; font-family: Arial; font-size: 9pt;">

<span style="font-weight: bold">Title :</span>

style="text-decoration: none; color: #023E7C"><%# Eval("Title")%><br />

<span style="font-weight: bold">About : </span>

style="text-decoration: none; color: Gray">

<%# Eval("Description").ToString().Substring(0,70)%>

</td>

<asp:Label ID="lblstatus" runat="server" Font-Bold="true" />

</td>

<%# Eval("ActivationDate").ToString().Substring(0,9)%>

</td>

<td width="80px" align="center" valign="middle" style="border-right-style: solid;

border-right-width: 1px; border-right-color: #CCCCCC">

<%# Eval("ExpiryDate").ToString().Substring(0,9)%>

</td>

<asp:Label ID="lblreward" runat="server" Text='<%# Bind("Reward")%>'></asp:Label>

</td>

</tr>

</table>

</td>

</td>

</tr>

</table>

</td>

</ItemTemplate>

</asp:ListView>

<br />

<%-- DataPager---%>

<asp:DataPager runat="server" ID="DataPager1" PageSize="8" PagedControlID="ListView1">

<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="true" ShowPreviousPageButton="false"

ShowLastPageButton="false" />

<asp:NumericPagerField ButtonType="Button" />

<asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True" ShowNextPageButton="False"

ShowPreviousPageButton="False" />

</Fields>

</asp:DataPager>

Write this code on pageload event with isPostBack property false:

protected void Page_Load(object sender, EventArgs e)

{

try

{

if (!IsPostBack)

{

_cMasterPageName = Page.MasterPageFile;

if (Session["pageno"] != null) /// set datapager to page 2

DataPager1.SetPageProperties(Convert.ToInt32(Session["pageno"]), 8, false);

fillListView();

getusertype();

}

catch (Exception)

{

////throw;

}

protected void fillListView() /// fill listview

{

con.Open();

SqlDataAdapter da= new SqlCommand("Select * from UserTable",con)

DataTable dt = new DataTable();

da.Fill(dt);

ListView1.DataSource = dt;

ListView1.DataBind();

}

protected void ListView1_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)

{

try

{

DataPager1.SetPageProperties(e.StartRowIndex, e.MaximumRows, false);

Session["pageno"] = e.MaximumRows; // save page size

fillListView();

}

catch (Exception)

{

////throw;

}

GridView Insert,Update,Edit and Delete in C#.net

noreply@blogger.com (Brijesh Kumar Singh) — Mon, 30 Dec 2013 05:28:00 +0000

On .aspx Page:

<asp:GridView ID="gvDetails" runat="server"
AutoGenerateColumns="false" CssClass="Gridview" HeaderStyle-BackColor="#61A6F8"
ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White"
onrowcancelingedit="gvDetails_RowCancelingEdit"
onrowdeleting="gvDetails_RowDeleting" onrowediting="gvDetails_RowEditing"
onrowupdating="gvDetails_RowUpdating"
onrowcommand="gvDetails_RowCommand">
<Columns>
<asp:TemplateField>
<EditItemTemplate>
<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server"ImageUrl="~/Images/update.png" ToolTip="Update" Height="20px" Width="20px" />
<asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel"ImageUrl="~/Images/Cancel.png" ToolTip="Cancel" Height="20px" Width="20px" />
</EditItemTemplate>
<ItemTemplate>
<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Edit.png"ToolTip="Edit" Height="20px" Width="20px" />
<asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server"ImageUrl="~/Images/delete.png" ToolTip="Delete" Height="20px" Width="20px" />
</ItemTemplate>
<FooterTemplate>
<asp:ImageButton ID="imgbtnAdd" runat="server" ImageUrl="~/Images/AddNewitem.jpg"CommandName="AddNew" Width="30px" Height="30px" ToolTip="Add new User"ValidationGroup="validaiton" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="UserName">
<EditItemTemplate>
<asp:Label ID="lbleditusr" runat="server" Text='<%#Eval("Username") %>'/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblitemUsr" runat="server" Text='<%#Eval("UserName") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtftrusrname" runat="server"/>
<asp:RequiredFieldValidator ID="rfvusername" runat="server" ControlToValidate="txtftrusrname" Text="*"ValidationGroup="validaiton"/>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="City">
<EditItemTemplate>
<asp:TextBox ID="txtcity" runat="server" Text='<%#Eval("City") %>'/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblcity" runat="server" Text='<%#Eval("City") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtftrcity" runat="server"/>
<asp:RequiredFieldValidator ID="rfvcity" runat="server" ControlToValidate="txtftrcity" Text="*"ValidationGroup="validaiton"/>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Designation">
<EditItemTemplate>
<asp:TextBox ID="txtDesg" runat="server" Text='<%#Eval("Designation") %>'/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblDesg" runat="server" Text='<%#Eval("Designation") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtftrDesignation" runat="server"/>
<asp:RequiredFieldValidator ID="rfvdesignation" runat="server" ControlToValidate="txtftrDesignation"Text="*" ValidationGroup="validaiton"/>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
<div>
<asp:Label ID="lblresult" runat="server"></asp:Label>

After that on .cs File:

SqlConnection con = new SqlConnection("Data Source=BRIJESH-PC;Integrated Security=true;Initial Catalog=TEST");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindEmployeeDetails();
}
}
protected void BindEmployeeDetails()
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from Employee_Details", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
gvDetails.DataSource = ds;
gvDetails.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvDetails.DataSource = ds;
gvDetails.DataBind();
int columncount = gvDetails.Rows[0].Cells.Count;
gvDetails.Rows[0].Cells.Clear();
gvDetails.Rows[0].Cells.Add(new TableCell());
gvDetails.Rows[0].Cells[0].ColumnSpan = columncount;
gvDetails.Rows[0].Cells[0].Text = "No Records Found";
}
}
protected void gvDetails_RowEditing(object sender, GridViewEditEventArgs e)
{
gvDetails.EditIndex = e.NewEditIndex;
BindEmployeeDetails();
}
protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());
string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();
TextBox txtcity = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtcity");
TextBox txtDesignation = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtDesg");
con.Open();
SqlCommand cmd = new SqlCommand("update Employee_Details set City='" + txtcity.Text + "',Designation='" + txtDesignation.Text + "' where UserId=" + userid, con);
cmd.ExecuteNonQuery();
con.Close();
lblresult.ForeColor = Color.Green;
lblresult.Text = username + " Details Updated successfully";
gvDetails.EditIndex = -1;
BindEmployeeDetails();
}
protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvDetails.EditIndex = -1;
BindEmployeeDetails();
}
protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values["UserId"].ToString());
string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();
con.Open();
SqlCommand cmd = new SqlCommand("delete from Employee_Details where UserId=" + userid, con);
int result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
BindEmployeeDetails();
lblresult.ForeColor = Color.Red;
lblresult.Text = username + " details deleted successfully";
}
}
protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName.Equals("AddNew"))
{
TextBox txtUsrname = (TextBox)gvDetails.FooterRow.FindControl("txtftrusrname");
TextBox txtCity = (TextBox)gvDetails.FooterRow.FindControl("txtftrcity");
TextBox txtDesgnation = (TextBox) gvDetails.FooterRow.FindControl("txtftrDesignation");
con.Open();
SqlCommand cmd =
new SqlCommand(
"insert into Employee_Details(UserName,City,Designation) values('" + txtUsrname.Text + "','" +
txtCity.Text + "','" + txtDesgnation.Text + "')", con);
int result= cmd.ExecuteNonQuery();
con.Close();
if(result==1)
{
BindEmployeeDetails();
lblresult.ForeColor = Color.Green;
lblresult.Text = txtUsrname.Text + " Details inserted successfully";
}
else
{
lblresult.ForeColor = Color.Red;
lblresult.Text = txtUsrname.Text + " Details not inserted";
}
}
}

Export Selected GridViewRow to Excel on button click in C#.NET

noreply@blogger.com (Brijesh Kumar Singh) — Sat, 07 Dec 2013 08:42:00 +0000

Copy & Paste this on .aspx file:

<asp:GridView ID="gvDetails" runat="server" AutoGenerateColumns="False" CellPadding="4"
BackColor="#5DA63A" ForeColor="White" Width="100%" AllowPaging="false" Style="border-radius: 10px;
border: Solid 3px #5DA63A; text-align: left; word-wrap: break-word; word-break: break-all">
<AlternatingRowStyle BackColor="#F1FCCA"></AlternatingRowStyle>
<RowStyle BackColor="#DEDFDE" ForeColor="Black" CssClass="grid_font" />
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#8EBE12" Font-Bold="False" ForeColor="#E7E7FF" />
<Columns>
<asp:TemplateField ItemStyle-Width="20px">
<HeaderTemplate>
<asp:CheckBox ID="chkAll" runat="server" AutoPostBack="True"
oncheckedchanged="chkAll_CheckedChanged" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" AutoPostBack="True"
oncheckedchanged="chkSelect_CheckedChanged" />
</ItemTemplate>
<ItemStyle Width="20px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="EIEUID" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblid" runat="server" Text='<%#Eval("EIEUid")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<ItemStyle Width="60px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Name" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblname" runat="server" Text='<%#Eval("Name")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<ItemStyle Width="150px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Details" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblemail" runat="server" Text='<%#Eval("Email")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<ItemStyle Width="160px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Mobile" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblmobile" runat="server" Text='<%#Eval("Mobile")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<ItemStyle Width="120px" />
</asp:TemplateField>
</Columns>
</asp:GridView>

Copy & Paste this on .cs Code File:

dataUtility du = new dataUtility();

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
BindGridData();
}

/// This Method is used to bind gridview
private void BindGridData()
{
try
{
DataTable dtnew = new DataTable();
DataTable dt = new DataTable();
dt = du.executeStoteProc("SP_CLIENT 5,'" + Session["Name"] + "','',''");

if (dt.Rows.Count > 0)
{
gvDetails.DataSource = dt;
gvDetails.DataBind();

}
else
{
dt.Rows.Add(dt.NewRow());
gvDetails.DataSource = dt;
gvDetails.DataBind();
int columncount = gvDetails.Rows[0].Cells.Count;
gvDetails.Rows[0].Cells.Clear();
gvDetails.Rows[0].Cells.Add(new TableCell());
gvDetails.Rows[0].Cells[0].ColumnSpan = columncount;
gvDetails.Rows[0].Cells[0].Text = "No Records Found";
}
}

}
catch (Exception ex)
{

}
}

/// enable gridview control to be rendered
public override void VerifyRenderingInServerForm(Control control)
{
/*Verifies that the control is rendered */
}

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ExportToExcell();
}

/// export gridview to excel
private void ExportToExcell()
{
DataTable dt = new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Details");
dt.Columns.Add("Mobile");
foreach (GridViewRow row in gvDetails.Rows)
{
CheckBox chkCalls = (CheckBox)row.FindControl("chkSelect");
if (chkCalls.Checked == true)
{
int i = row.RowIndex;
Label lblname = (Label)gvDetails.Rows[i].FindControl("lblname");
Label lblemail = (Label)gvDetails.Rows[i].FindControl("lblemail");
Label lblmobile = (Label)gvDetails.Rows[i].FindControl("lblmobile");

DataRow dr = dt.NewRow();
dr["Name"] = Convert.ToString(lblname.Text);
dr["Details"] = Convert.ToString(lblemail.Text);
dr["Mobile"] = Convert.ToString(lblmobile.Text);
dt.Rows.Add(dr);
}
}
GridView gdvExportxls = new GridView();
gdvExportxls.DataSource = dt;
gdvExportxls.DataBind();
gdvExportxls.HeaderStyle.Font.Bold = true;
gdvExportxls.HeaderStyle.ForeColor = Color.White;
gdvExportxls.HeaderStyle.BackColor = Color.Green;
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/ms-excel";
Response.AddHeader("content-disposition", string.Format("attachment;filename=ReferrerDetails.xls", "selectedrows"));
Response.Charset = "";
StringWriter stringwriter = new StringWriter();
HtmlTextWriter htmlwriter = new HtmlTextWriter(stringwriter);
gdvExportxls.RenderControl(htmlwriter);
Response.Write(stringwriter.ToString().Replace("<div>", " ").Replace("</div>", " "));
Response.End();

}

/// select/unselect all row using header checkbox
protected void chkAll_CheckedChanged(object sender, EventArgs e)
{
try
{
CheckBox chkH = (CheckBox)gvDetails.HeaderRow.FindControl("chkAll");
if (chkH.Checked == true)
{
foreach (GridViewRow gv in gvDetails.Rows)
{
CheckBox chk = (CheckBox)gv.FindControl("chkSelect");
chk.Checked = true;
}
}
else
{
foreach (GridViewRow gv in gvDetails.Rows)
{
CheckBox chk = (CheckBox)gv.FindControl("chkSelect");
chk.Checked = false;
}

}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

/// select/unselect single row using row checkbox
protected void chkSelect_CheckedChanged(object sender, EventArgs e)
{
bool isFound = false;
CheckBox cbxall = (CheckBox)gvDetails.HeaderRow.FindControl("chkAll");
foreach (GridViewRow gvr in gvDetails.Rows)
{
CheckBox chkSelect = gvr.FindControl("chkSelect") as CheckBox;
if (chkSelect.Checked == false)
{
isFound = true;
break;
}

}

if (isFound)
cbxall.Checked = false;
else
cbxall.Checked = true;

}

SOLVED: Session Lost problem after Response.Redirect when redirect from Iframe

noreply@blogger.com (Brijesh Kumar Singh) — Thu, 05 Dec 2013 11:55:00 +0000

Copy & Paste this to head tag:

<script type="text/javascript" language="javascript">

//for Redirect Iframe
function Redirect()
{
top.location = "Checkout.aspx";
return false;
}

</script>

Copy & Paste this code on .cs file:

ScriptManager.RegisterStartupScript(Page, typeof(System.Web.UI.Page),
"blur", @"<script type='text/javascript'>Redirect();</script>", false);

Note: bool value set true if you don't use UpdatePanel......

How To Style A Checkbox With CSS

noreply@blogger.com (Brijesh Kumar Singh) — Thu, 05 Dec 2013 06:41:00 +0000

Method 1:

/* in style tag */

.onoffswitch {
position: relative; width: 65px;
-webkit-user-select:none; -moz-user-select:none; -ms-user-select: none;
}
.onoffswitch-checkbox {
display: none;
}
.onoffswitch-label {
display: block; overflow: hidden; cursor: pointer;
border: 2px solid #999999; border-radius: 20px;
}
.onoffswitch-inner {
width: 200%; margin-left: -100%;
-moz-transition: margin 0.3s ease-in 0s; -webkit-transition: margin 0.3s ease-in 0s;
-o-transition: margin 0.3s ease-in 0s; transition: margin 0.3s ease-in 0s;
}
.onoffswitch-inner:before, .onoffswitch-inner:after {
float: left; width: 50%; height: 25px; padding: 0; line-height: 25px;
font-size: 14px; color: white; font-family: Trebuchet, Arial, sans-serif; font-weight: bold;
-moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box;
}
.onoffswitch-inner:before {
content: "ON";
padding-left: 10px;
background-color: #FFC42F; color: #FFFFFF;
}
.onoffswitch-inner:after {
content: "OFF";
padding-right: 10px;
background-color: #EEEEEE; color: #999999;
text-align: right;
}
.onoffswitch-switch {
width: 15px; margin: 5px;
background: #FFFFFF;
border: 2px solid #999999; border-radius: 20px;
position: absolute; top: 0; bottom: 0; right: 36px;
-moz-transition: all 0.3s ease-in 0s; -webkit-transition: all 0.3s ease-in 0s;
-o-transition: all 0.3s ease-in 0s; transition: all 0.3s ease-in 0s;
}
.onoffswitch-checkbox:checked + .onoffswitch-label .onoffswitch-inner {
margin-left: 0;
}
.onoffswitch-checkbox:checked + .onoffswitch-label .onoffswitch-switch {
right: 0px;
}

/* html tag */

<div class="onoffswitch">
<input type="checkbox" name="onoffswitch" class="onoffswitch-checkbox" id="myonoffswitch">
<label class="onoffswitch-label" for="myonoffswitch">
<div class="onoffswitch-inner"></div>
<div class="onoffswitch-switch"></div>
</label>
</div>

Method 2:

/* in style tag */

.slideThree {
width: 80px;
height: 26px;
background: #333;
margin: 20px auto;

-webkit-border-radius: 50px;
-moz-border-radius: 50px;
border-radius: 50px;
position: relative;

-webkit-box-shadow: inset 0px 1px 1px rgba(0,0,0,0.5), 0px 1px 0px rgba(255,255,255,0.2);
-moz-box-shadow: inset 0px 1px 1px rgba(0,0,0,0.5), 0px 1px 0px rgba(255,255,255,0.2);
box-shadow: inset 0px 1px 1px rgba(0,0,0,0.5), 0px 1px 0px rgba(255,255,255,0.2);
}

.slideThree:after {
content: 'OFF';
font: 12px/26px Arial, sans-serif;
color: #000;
position: absolute;
right: 10px;
z-index: 0;
font-weight: bold;
text-shadow: 1px 1px 0px rgba(255,255,255,.15);
}

.slideThree:before {
content: 'ON';
font: 12px/26px Arial, sans-serif;
color: #00bf00;
position: absolute;
left: 10px;
z-index: 0;
font-weight: bold;
}

.slideThree label {
display: block;
width: 34px;
height: 20px;

-webkit-border-radius: 50px;
-moz-border-radius: 50px;
border-radius: 50px;

-webkit-transition: all .4s ease;
-moz-transition: all .4s ease;
-o-transition: all .4s ease;
-ms-transition: all .4s ease;
transition: all .4s ease;
cursor: pointer;
position: absolute;
top: 3px;
left: 3px;
z-index: 1;

-webkit-box-shadow: 0px 2px 5px 0px rgba(0,0,0,0.3);
-moz-box-shadow: 0px 2px 5px 0px rgba(0,0,0,0.3);
box-shadow: 0px 2px 5px 0px rgba(0,0,0,0.3);
background: #fcfff4;

background: -webkit-linear-gradient(top, #fcfff4 0%, #dfe5d7 40%, #b3bead 100%);
background: -moz-linear-gradient(top, #fcfff4 0%, #dfe5d7 40%, #b3bead 100%);
background: -o-linear-gradient(top, #fcfff4 0%, #dfe5d7 40%, #b3bead 100%);
background: -ms-linear-gradient(top, #fcfff4 0%, #dfe5d7 40%, #b3bead 100%);
background: linear-gradient(top, #fcfff4 0%, #dfe5d7 40%, #b3bead 100%);
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#fcfff4', endColorstr='#b3bead',GradientType=0 );
}

.slideThree input[type=checkbox]:checked + label {
left: 43px;
}

/* html tag */

<div class="slideThree">
<input type="checkbox" value="None" id="slideThree" name="check" />
<label for="slideThree"></label>
</div>

HOw to Add break-point when Debug Window Service in C#.net

noreply@blogger.com (Brijesh Kumar Singh) — Mon, 02 Dec 2013 13:15:00 +0000

Service1.cs file code:

Timer timer;
public Service1()
{
InitializeComponent();
}

public void OnDebug()
{
OnStart(null);
}

protected override void OnStart(string[] args)
{
// get today's date at 00:01 AM
DateTime time = DateTime.Today.AddMinutes(1);

// if 00:01 AM has passed, get tomorrow at 00:01 AM
if (DateTime.Now > time)
time = time.AddDays(1);

// calculate milliseconds until the next 00:01 AM.
int timeToFirstExecution = (int)time.Subtract(DateTime.Now).TotalMilliseconds;

// calculate the number of milliseconds in 24 hours.
int timeBetweenCalls = (int)new TimeSpan(24, 0, 0).TotalMilliseconds;

// set the method to execute when the timer executes.
TimerCallback methodToExecute = Brijeshmethod;

// start the timer. The timer will execute "Brijeshmethod" when the number of seconds between now and
// the next 00:01 AM elapse. After that, it will execute every 24 hours.
timer = new System.Threading.Timer(methodToExecute, null, timeToFirstExecution, timeBetweenCalls);

}

private void Brijeshmethod(object source)
{
//write your code here
}

protected override void OnStop()
{
Thread.Sleep(Timeout.Infinite);

}

Program file:

/// <summary>
/// The main entry point for the application.
/// </summary>
static void Main()
{
#if DEBUG
Service1 myService = new Service1();
myService.OnDebug();
System.Threading.Thread.Sleep(System.Threading.Timeout.Infinite);
#else
ServiceBase[] ServicesToRun;
ServicesToRun = new ServiceBase[]
{
new Service1()
};
ServiceBase.Run(ServicesToRun);
#endif

}

HOw to Clear Cache,Cookies and History of All Browser in C#.net on Button Click

noreply@blogger.com (Brijesh Kumar Singh) — Fri, 29 Nov 2013 07:22:00 +0000

Use this code on your button click event:

protected void LinkButton1_Click(object sender, EventArgs e)
{
Session.Abandon();
Session["AEmail"] = null;
Session.Clear();
ClearCache();
clearchachelocalall();
Response.Redirect("../Default.aspx");

}
public static void ClearCache()
{
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Cache.SetExpires(DateTime.Now);
HttpContext.Current.Response.Cache.SetNoServerCaching();
HttpContext.Current.Response.Cache.SetNoStore();
HttpContext.Current.Response.Cookies.Clear();
HttpContext.Current.Request.Cookies.Clear();
}

private void clearchachelocalall()
{
string GooglePath = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Google\Chrome\User Data\Default\";
string MozilaPath = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Mozilla\Firefox\";
string Opera1 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Opera\Opera";
string Opera2 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Opera\Opera";
string Safari1 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Apple Computer\Safari";
string Safari2 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Apple Computer\Safari";
string IE1 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Microsoft\Intern~1";
string IE2 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Microsoft\Windows\History";
string IE3 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Local\Microsoft\Windows\Tempor~1";
string IE4 = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Microsoft\Windows\Cookies";
string Flash = Environment.GetEnvironmentVariable("USERPROFILE") + @"\AppData\Roaming\Macromedia\Flashp~1";

//Call This Method ClearAllSettings and Pass String Array Param
ClearAllSettings(new string[] { GooglePath, MozilaPath, Opera1, Opera2, Safari1, Safari2, IE1, IE2, IE3, IE4, Flash });

}

public void ClearAllSettings(string[] ClearPath)
{
foreach (string HistoryPath in ClearPath)
{
if (Directory.Exists(HistoryPath))
{
DoDelete(new DirectoryInfo(HistoryPath));
}

}
}

void DoDelete(DirectoryInfo folder)
{
try
{

foreach (FileInfo file in folder.GetFiles())
{
try
{
file.Delete();
}
catch
{ }

}
foreach (DirectoryInfo subfolder in folder.GetDirectories())
{
DoDelete(subfolder);
}
}
catch
{
}
}

HOw To Call URL API for SMS sending using function in C#.NET

noreply@blogger.com (Brijesh Kumar Singh) — Thu, 21 Nov 2013 11:11:00 +0000

Copy & Paste this code and call this function anywhere you use to use API:

public void SendSMS()
{
//HTTP connection
HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create("your url API");
//Get response from Ozeki NG SMS Gateway Server and read the answer
HttpWebResponse myResp = (HttpWebResponse)myReq.GetResponse();
System.IO.StreamReader respStreamReader = new System.IO.StreamReader(myResp.GetResponseStream());
string responseString = respStreamReader.ReadToEnd();
respStreamReader.Close();
myResp.Close();

}

Play All type of Video files in GridView with Literal Control using C#

noreply@blogger.com (Brijesh Kumar Singh) — Fri, 15 Nov 2013 05:51:00 +0000

Follow the instructions:

1.) First Select asp Literal Control from Toolbox.

<asp:GridView ID="GridView1" runat="server" GridLines="None" ShowHeader="False" Width="100%"
AutoGenerateColumns="False" AllowPaging="true" PageSize="3" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table style="width: 100%" cellpadding="5px">
<tr>
<td valign="top">
<h2 style="text-align: left; color: #771212">
<%#Eval("Title")%></h2>
<hr />
<div style="font-size: 13px; color: Gray; text-align: right">
Posted on <%#Eval("PostingDate")%></div>
<p style="font-size: 15px; color: Black">
<div style="width: 280px; height: 220px; float: left; text-align:left">
<asp:Label ID="lblvideo" runat="server" Visible="false"><%#Eval("VedioFile")%>.<%#Eval("OriginalFileExtn") %></asp:Label>

<asp:Literal ID="Literal1" runat="server"></asp:Literal>
</div>
<%#Eval("Description")%></p>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings Mode="NextPreviousFirstLast" FirstPageText="First" PreviousPageText="Previous"
NextPageText="Next" LastPageText="Last" />
</asp:GridView>

2.) Copy and paste this code to your code file on GridView Binding

DataTable dt = App.GetDataTable("Select * from Blog order by PostingDate DESC");
GridView1.DataSource = dt;
GridView1.DataBind();
foreach (GridViewRow gvrow in GridView1.Rows)
{
Label vurl = (Label)gvrow.FindControl("lblvideo");
Literal Literal1 = (Literal)gvrow.FindControl("Literal1");
string myobj = "";
if (vurl.Text != "" && vurl.Text != null)
{
myobj += "<video width='250' height='200' controls='controls' data-setup='{}'>";
myobj += "<source src='File/BlogFile/" + vurl.Text + "' type='video/ogg' />";
myobj += "Your browser does not support video";
myobj += "</object>";
myobj += "</video>";
}
else
{
myobj = "<img src='File/BlogFile/blogging.jpg' width='250' height='200'/>";
}
Literal1.Text = myobj;

}

Social Sites Share Button for website Floating Left using javascript

noreply@blogger.com (Brijesh Kumar Singh) — Tue, 29 Oct 2013 10:37:00 +0000

Copy & Paste this code to your website:



<div class="addthis_toolbox addthis_floating_style addthis_counter_style" style="left:50px;top:180px;">
<a class="addthis_button_facebook_like" <%="fb:like:layout"%>="box_count" width="70px"></a>
<a class="addthis_button_tweet" tw:count="vertical"></a>
<a class="addthis_button_google_plusone" g:plusone:size="tall"></a>
<a class="addthis_counter"></a>
</div>
<script type="text/javascript">var addthis_config = {"data_track_addressbar":true};</script>
<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-526f51334345dc15"></script>

Change Div/Panel Border width and color on dropdownlist selectedchanged Event using Javascript

noreply@blogger.com (Brijesh Kumar Singh) — Sat, 26 Oct 2013 07:20:00 +0000

Use this code to implement this function:

<asp:DropDownList ID="ddlchnageborderwidth" runat="server">
<asp:ListItem Value="1px">1px</asp:ListItem>
<asp:ListItem Value="2px">2px</asp:ListItem>
<asp:ListItem Value="3px">3px</asp:ListItem>
<asp:ListItem Value="4px">4px</asp:ListItem>
</asp:DropDownList>

<asp:DropDownList ID="ddlchnagebordercolor" runat="server">
<asp:ListItem Value="#000000">Black</asp:ListItem>
<asp:ListItem Value="#0000FF">Blue</asp:ListItem>
<asp:ListItem Value="#A52A2A">Brown</asp:ListItem>
<asp:ListItem Value="#FF7F50">Coral</asp:ListItem>
<asp:ListItem Value="#A9A9A9">DarkGray</asp:ListItem>
<asp:ListItem Value="#8B0000">DarkRed</asp:ListItem>
</asp:DropDownList>

Color change javascript code:
<script type="text/javascript">
$("#ddlchnageborderwidth").change(function() {
$("#someDiv").css("border-width", $(this).val());
}).change();
</script>

Color change javascript code:
<script type="text/javascript">
$("#ddlchnagebordercolor").change(function() {
$("#someDiv").css("border-color", $(this).val());
}).change();
</script>

Add Facebook Like and Share Button API to Website

noreply@blogger.com (Brijesh Kumar Singh) — Sat, 26 Oct 2013 07:00:00 +0000

Copy & Paste this code for Facebook like button with count:

{

var js, fjs = d.getElementsByTagName(s)[0];

if (d.getElementById(id)) return;

js = d.createElement(s); js.id = id;

js.src = "//connect.facebook.net/en_US/all.js#xfbml=1";

fjs.parentNode.insertBefore(js, fjs);

}

(document, 'script', 'facebook-jssdk'));</script>

Copy & Paste this code for Facebook Share button with count:

<div style='float:center;padding:0px 0px 0px 25px'>
<a share_url='http://brijeshsolutions.blogspot.com' href='http://www.facebook.com/sharer.php' name='fb_share' type='button_count' target="_blank">Share Brijesh Solutions< /a><script src='http://static.ak.fbcdn.net/connect.php/js/FB.Share' type='text/javascript'></script>

</div>

How to Use a Windows Installer Disc to Back Up Your Files When Your Computer Won’t Boot

noreply@blogger.com (Brijesh Kumar Singh) — Thu, 24 Oct 2013 06:33:00 +0000

If Windows won’t boot, recovering your files can be a headache. You do n0t have to pull the hard drive or use a Linux live CD – you can use a Windows installer disc to quickly back up your files.

We have included steps for both Windows 8 and Windows 7 here – the process is basically the same on each. You can use a Windows 7 disc to back up files from a Windows 8 system or vice versa.

Boot From a Windows Installer Disc

First, insert a Windows installer disc (or a USB drive with the Windows installer on it) into your computer and restart your computer. If everything is working properly, you will see a “Press any key to boot from CD or DVD” message. Press a key to enter the installer. If you do not see this screen, you may need to change the boot settings in your computer’s BIOS.

Click the Next option and select Repair Your Computer. You will see this option at the bottom-left corner of the window, whether you are using a Windows 7 or Windows 8 installer disc.

If you are using a Windows 8 installer disc, select Troubleshoot > Advanced Options > Command Prompt.

If you are using a Windows 7 installer disc, select the Restore your computer using a system image you created earlier option, click Next, click Cancel, and click Cancel again.

You will see the System Recovery Options window – click Command Prompt to launch a Command Prompt window.

When you see a Command Prompt, type notepad and press Enter to launch a Notepad window. Click File and select Open in the Notepad window.

Ensure you select the All Files option at the bottom of the window, and then click the Computer option.

You can use this Open dialog as if it were a Windows Explorer window – select files and you’ll be able to copy and paste them elsewhere. If you connect a USB drive or removable hard drive to your computer, you will be able to copy-paste files onto it.

Do not double-click any files or Notepad will try to open them, possibly freezing. If Notepad freezes on you, go back to the Command Prompt window and type taskmgr to launch the Task Manager. You can end the frozen Notepad task and re-launch Notepad.

Once you are done copying your files off your hard drive, you can close the windows and shut down your computer. Or, if you plan on reinstalling Windows anyway, you can now begin performing a clean installation with your files safely backed up.

Open New Window as Popup with defined size on Button Click using C#

noreply@blogger.com (Brijesh Kumar Singh) — Wed, 23 Oct 2013 12:21:00 +0000

Use this Code on button click event:

ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "var Mleft = (screen.width/2)-(760/2);var Mtop = (screen.height/2)-(700/2);window.open( 'popup.aspx', null, 'height=500,width=560,status=yes,toolbar=no,scrollbars=yes,menubar=no,location=no,top=\'+Mtop+\', left=\'+Mleft+\'' );", true);

ASP.NET - Export Gridview data to excel and directly send a mail with exported excel file

noreply@blogger.com (Brijesh Kumar Singh) — Tue, 08 Oct 2013 11:53:00 +0000

On Control Event use this code in C#:

GridView gdvExportxls = new GridView();
gdvExportxls.DataSource = dtnew;
gdvExportxls.DataBind();
MemoryStream ms = new MemoryStream();
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
gdvExportxls.RenderControl(htmlWriter);
byte[] excelFile = System.Text.Encoding.ASCII.GetBytes(stringWriter.ToString());
ms.Write(excelFile, 0, excelFile.Length);
ms.Position = 0;

Attachment attachment = new Attachment(ms, "Test.xls", "application/vnd.xls");
SendMail(attachment);

private void SendMail(Attachment excel)
{
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress("brijesh.singh879@gmail.com")
mail.Subject = "Export GridView to Excel";
mail.Body = "mail with attachment";

//System.Net.Mail.Attachment attachment;
//attachment = excel;
mail.Attachments.Add(excel);

SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential("brijesh.singh879@gmail.com", "*******");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);

}

GridView Select all row using Header Checkbox or select one row using checkbox in C#.NET

noreply@blogger.com (Brijesh Kumar Singh) — Sat, 05 Oct 2013 05:32:00 +0000

Copy and Paste this code to .aspx Page :

<asp:GridView ID="GridView1" runat="server" Width="100%" BackColor="White" BorderColor="White"
BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" GridLines="None"
AutoGenerateColumns="False" Style="font-size: 10pt">
<RowStyle BackColor="#DEDFDE" ForeColor="Black" />
<PagerStyle BackColor="#669900" ForeColor="White" Font-Bold="true" />
<HeaderStyle BackColor="#669900" Font-Bold="True" ForeColor="#E7E7FF" />
<Columns>
<asp:TemplateField HeaderText="Course" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="id" runat="server" Text='<%#Eval("Row_Id")%>' Visible="false"></asp:Label>
<asp:Label ID="lblgrade" runat="server" Text='<%#Eval("Quali1")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle Width="35px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Grade" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblsubgrade" runat="server" Text='<%#Eval("Quali2")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle Width="45px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Roll No" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblroll" runat="server" Text='<%#Eval("RollNo")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle Width="80px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Name" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblName" runat="server" Text='<%#Eval("Name")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle Width="180px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Father's Name" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lblfname" runat="server" Text='<%#Eval("FName")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle Width="180px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Date" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label ID="lbldate" runat="server" Text=""></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle Width="70px" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="cbxap" runat="server" AutoPostBack="true" OnCheckedChanged="cbxap_CheckedChanged" />
</ItemTemplate>
<HeaderTemplate>
A/P<asp:CheckBox ID="cbxapall" runat="server" AutoPostBack="true" OnCheckedChanged="cbxapall_CheckedChanged" />
</HeaderTemplate>
<ItemStyle Width="50px" />
</asp:TemplateField>
</Columns>

</asp:GridView>

and .cs Page Code is given:

Bind GridView:
private void bindgridview()
{
try
{
DataTable dt = app.GetDataTable("select * from tb_Regstd_mst where Center='" + ddlcenter.SelectedItem.Text + "' and Quali1='" + ddlgrade.SelectedItem.Text + "' and Quali2='" + ddlsubgrade.SelectedItem.Text + "' order by RollNo Asc");
GridView1.DataSource = dt;
GridView1.DataBind();
foreach (GridViewRow gv in GridView1.Rows)
{
Label date = (Label)gv.FindControl("lbldate");
date.Text = DateTime.Now.ToShortDateString();
}
if (GridView1.Rows.Count <= 0)
{
btnattd.Visible = false;
lblmsg.Text = "No Student Records Found in this Category.";
}
else
{
lblmsg.Text = "";
btnattd.Visible = true;
}
}
catch (Exception)
{

}

}

On Header Checkbox checkchanged Event :
protected void cbxapall_CheckedChanged(object sender, EventArgs e)
{
try
{
CheckBox chkH = (CheckBox)GridView1.HeaderRow.FindControl("cbxapall");
if (chkH.Checked == true)
{
foreach (GridViewRow gv in GridView1.Rows)
{
CheckBox chk = (CheckBox)gv.FindControl("cbxap");
chk.Checked = true;
}
}
else
{
foreach (GridViewRow gv in GridView1.Rows)
{
CheckBox chk = (CheckBox)gv.FindControl("cbxap");
chk.Checked = false;
}

}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}

}

Checkchanged event of each row :
protected void cbxap_CheckedChanged(object sender, EventArgs e)
{
bool isFound = false;
CheckBox cbxall = (CheckBox)GridView1.HeaderRow.FindControl("cbxapall");
foreach (GridViewRow gvr in GridView1.Rows)
{
CheckBox chkSelect = gvr.FindControl("cbxap") as CheckBox;
if (chkSelect.Checked == false)
{
isFound = true;
break;
}

}

if (isFound)
cbxall.Checked = false;
else
cbxall.Checked = true;

}

Play Youtube video with URL in C#.NET

noreply@blogger.com (Brijesh Kumar Singh) — Fri, 04 Oct 2013 13:03:00 +0000

Copy and paste this code on C# code file

string youtubeUrl = "http://www.youtube.com/watch?v=6rpZnBfG6YE";

string vCode = youtubeUrl.Substring(youtubeUrl.LastIndexOf("v=") + 2);
if (vCode.Contains("&"))
vCode = vCode.Substring(0, vCode.LastIndexOf("&"));

string sHtml = @"<object width='{0}' height='{0}' data='http://www.youtube.com/v/{2}&autoplay=0' codetype='application/x-shockwave-flash'>
&ltparam name='movie' value='http://www.youtube.com/v/{2}&autoplay=0'></param></object>";
//define frame size
string sWidth = "200px";
string sHeight = "100px";

video.GroupingText = String.Format(sHtml, sWidth, sHeight, vCode);

where video is the Id of Div/Panel

Common Table Expression (CTE) in SQL Server 2008 R2 and get Column value split on comma as row

noreply@blogger.com (Brijesh Kumar Singh) — Tue, 03 Sep 2013 05:39:00 +0000

Introduced in SQL Server 2005, the common table expression (CTE) is a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. You can also use a CTE in a CREATE VIEW statement, as part of the view’s SELECT query. In addition, as of SQL Server 2008, you can add a CTE to the new MERGE statement.

SQL Server supports two types of CTEs—recursive and non-recursive. In this article, I explain how to create both types. The examples I provide are based on a local instance of SQL Server 2008.

State Table

CREATE TABLE [dbo].[tb_State](

[SID] [nchar](40) NOT NULL,

[Statename] [nvarchar](200) NULL

) ON [PRIMARY]

City Table

CREATE TABLE [dbo].[tb_City](

[CID] [nchar](40) NOT NULL,

[Statename] [nvarchar](200) NULL,

[Cityname] [nvarchar](500) NULL

) ON [PRIMARY]

Working with Common Table Expressions

You define CTEs by adding a WITH clause directly before your SELECT, INSERT, UPDATE, DELETE, or MERGE statement. The WITH clause can include one or more CTEs, as shown in the following syntax:

[WITH <common_table_expression> [,...]]

<common_table_expression>::=

cte_name [(column_name [,...])]

AS (cte_query)

Example of Common Table Expressions:

WITH cte_BRIJESH AS

(

SELECT a.CID,a.Statename,b.SID,SUBSTRING(',' + a.Cityname + ',', Number + 1,

CHARINDEX(',', ',' + a.Cityname + ',', Number + 1) - Number -1)AS CityName

FROM master..spt_values

cross join dbo.tb_City a

JOIN tb_State b ON a.Statename = b.Statename

where type = 'P'

and Number <= LEN(',' + a.Cityname + ',') - 1

AND SUBSTRING(',' + a.Cityname + ',', Number, 1) = ','

)

SELECT * FROM cte_BRIJESH

Result: