Create and save excel file using StringBuilder in server folder using asp.net c#

public void Save_stringBuilder()

    {

        StringBuilder sb = new StringBuilder();

        sb.Append("<table border='1' width='800' align='center' style='text-align:center'><tr><td colspan='3' style=' background-color:#000; height:100; color:#fff; font-size:x-large'>Header</td></tr><tr><td height='100' align='center'><img src='C:\\Users\\Krishna\\Desktop\\SaveGridViewAsExcelOnDisk\\a.gif' width='70' height='80'>&nbsp;</td><td>&nbsp;</td><td><img src='C:\\Users\\Krishna\\Desktop\\SaveGridViewAsExcelOnDisk\\b.gif' width='70' height='80'></td></tr><tr><td>&asldkfj;laksjdk fj;k as askdjflajksdf;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>&nbsp;</td><td>&asdkf;ajsdlkfj asdjfljasd faskldjflkas;</td><td>&nbsp;</td></tr><tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>&asdkjfflkasjd aksdjfl;jalsd skjdflkkjasd fas;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>&nbsp;</td><td  height='100' align='center'><img src='C:\\Users\\Krishna\\Desktop\\SaveGridViewAsExcelOnDisk\\b.gif' width='70' height='80' /> </td><td>&nbsp;</td></tr></table>");

        string path = Server.MapPath("~/Files/");

        if (!Directory.Exists(path))  // create folder if not exist

        {

            Directory.CreateDirectory(path);

        }

        using (StringWriter sw = new StringWriter(sb))

        {

            using (HtmlTextWriter hw = new HtmlTextWriter(sw))

            {

                StreamWriter writer = File.AppendText(path + "SavestringBuilder.xls");

                hw.BeginRender();             

                string html = sb.ToString();

                writer.WriteLine(html);// write file on server folder

                writer.Close();

            }

        }

    }

Check Upload Image size and height width using asp.net c#

protected void Btn_Upload(object sender, EventArgs e)

    {

        System.Drawing.Image img = System.Drawing.Image.FromStream(Upload_img.PostedFile.InputStream);

        int height = img.Height;

        int width = img.Width;

        decimal size = Math.Round(((decimal)Upload_img.PostedFile.ContentLength / (decimal)1024), 2);

        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "alert", "alert('Size: " + size + "KB\\nHeight: " + height + "\\nWidth: " + width + "');", true);

      

    }

Gett all column names of table Target_Table with comma separated (,) by commas

DECLARE @SQL    nvarchar(4000) = ''

SELECT @SQL += '['+COLUMN_NAME+']' + ', ' FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Employee'

select SUBSTRING(@SQL,0,len(@SQL))

result-

[EmployeeID], [OldID], [Contract_Type], [EmployeeCode]

How to set radiobuttonlist selected value and clear on check box changed event using jquery in asp.net

// HTML

<asp:CheckBox ID="CheckBox1" runat="server" Font-Bold="True" Text="Select" onchange="return SetRadios();"></asp:CheckBox>

<asp:RadioButtonList ID="rdBtnSHG" runat="server" Width="378px" RepeatDirection="Horizontal">

             <asp:ListItem Value="1">Add new</asp:ListItem>

              <asp:ListItem Value="2">Add+Update</asp:ListItem>

  </asp:RadioButtonList>

// JS

function SetRadios() {

      

            if ($('#<%=cbSHG.ClientID%>').is(":checked")) {

                $('[id*=rdBtnSHG]  :radio[value="1"] ').prop('checked', true);

            }

            else {

                $("#<%= rdBtnSHG.ClientID %> input[type=radio]").prop('checked', false);

            }           

             return false;

    }

Export to excel from using stringbuilder in asp.net c#

// HTML

<div>

        <div id="dvInfo" runat="server">

            <br />

            <center>

                <b>Student Informations</b>

             </center>

            <br />

            <table align='center' border='1' bordercolor='#00aeef' width='50%' class='reporttable1'

                cellspacing='0' cellpadding='0' style='font-size: 10;'>

                <tr align='center'>

                    <td style='width: 10%'>

                        <b>RollNo</b>

                    </td>

                    <td>

                        <b>Name</b>

                    </td>

                    <td>

                        <b>City</b>

                    </td>

                </tr>

                <tr>

                    <td>

                        A1001

                    </td>

                    <td>

                        Raja

                    </td>

                    <td>

                        IIT Kanpur

                    </td>

                </tr>

                <tr>

                    <td>

                        A1002

                    </td>

                    <td>

                        Mohit

                    </td>

                    <td>

                        ITI Gonda

                    </td>

                </tr>

            </table>

            <br />

            <br />

        </div>

        <center>

            <asp:Button ID="Button2" runat="server" Style="height: 30px;" OnClick="Button2_Click"

                Text="Export HTML to Excel" />

        </center>

    </div>

// ASPX.cs

protected void Button2_Click(object sender, EventArgs e)

    {

        try

        {

        StrExport.Append(@"<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:w='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'><head><title>Report</title>");

        StrExport.Append(@"<body lang=EN-US style='mso-element:header' id=h1><span style='mso--code:DATE'></span><div class=Section1>");

        StrExport.Append("<DIV  style='font-size:12px;'>");

        StrExport.Append(dvInfo.InnerHtml);

        StrExport.Append("</div></body></html>");

        string strFile = "Reporst.xls";

        string strcontentType = "application/excel";

        Response.ClearContent();

        Response.ClearHeaders();

        Response.BufferOutput = true;

        Response.ContentType = strcontentType;

        Response.AddHeader("Content-Disposition", "attachment; filename=" + strFile);

        Response.Write(StrExport.ToString());

        Response.Flush();

        Response.Close();

        Response.End();

        }

        catch (Exception ex)

        {

        }

    }

genrate dinamic slider using aps.net C# with css and JS (wowslider)

// get css from wowslider
// get JS from wowslider

protected void generate_slider()

    {

        string paths = Server.MapPath("FolderName");

        DirectoryInfo d = new DirectoryInfo(paths);

        FileInfo[] Files = d.GetFiles("*");

        HtmlImage img;

        HtmlGenericControl li;

        foreach (FileInfo file in Files)

        {

            string filename = file.Name;// file name find

            string[] str = filename.Split('_');// split with your condtion

            if (str[0] == "check id condition here")

            {

                li = new HtmlGenericControl("li");

                img = new HtmlImage();

                img.Src = "Photo Gallery/" + filename;

                img.Style.Add("min-height:50px; max-height:250px; min-width", "20%");

                img.Alt = "";

                img.ID = str[0] + "" + str[1];

                li.Controls.Add(img);

                sliderid.Controls.Add(li); 

//add htmlgenericcontrol with server control here 'sliderid= server control id'

            }

        }

// reference

http://wowslider.com/image-slider-jquery-epsilon-collage-demo.html

Get all files from directory folder using asp.net c#

// Add namespace

using System.IO;

// listed files

       // 1. for all files of directory folder

       public void getfiles()

    {

        string targetDirectory = Server.MapPath("slider/images");

        DirectoryInfo d = new DirectoryInfo(targetDirectory);//get directory folder

        FileInfo[] Files = d.GetFiles("*"); //get all files from Folder

        string str = "";

        foreach (FileInfo file in Files)

        {

            str = str + "" + file.Name + ", ";

        }

    } 

 // 2. for selected extension files only of directory folder

    public void getfiles()

    {

        string targetDirectory = Server.MapPath("slider/images");

        DirectoryInfo d = new DirectoryInfo(targetDirectory);//get directory folder

        FileInfo[] Files = d.GetFiles("*.jpg");//get all files from Folder

        string str = "";

        foreach (FileInfo file in Files)

        {

            str = str + "" + file.Name + ", ";

        } 

    }

JavaScript : Restrict multiple time entry of and char or number or decimal using javascript on keydown

// HTML

<input type="text" class="decimal" value="" />

            

 or

<asp:TextBox ID="txt_actID" runat="server">

///////  JS

$('input').on('keydown', function (event) {

                return isNumber(event, this);

            });

            function isNumber(evt, element) {

                var charCode = (evt.which) ? evt.which : evt.keyCode;

                if ((charCode != 190 || $(element).val().indexOf('.') != -1) && (charCode != 110 || $(element).val().indexOf('.') != -1)

                && ((charCode < 48 && charCode != 8) || (charCode > 57 && charCode < 96) || charCode > 105))

                    return false;

                return true;

            }

/////////////////or

<asp:TextBox ID="TextBox1" runat="server"   onkeydown="return isNumber(event, this);">

/// js

 function isNumber(evt, element) {

                var charCode = (evt.which) ? evt.which : evt.keyCode;

                if ((charCode != 190 || $(element).val().indexOf('.') != -1) && (charCode != 110 || $(element).val().indexOf('.') != -1)

                && ((charCode < 48 && charCode != 8) || (charCode > 57 && charCode < 96) || charCode > 105))

                    return false;

                return true;

            }

JavaScript : Restrict multiple time entry of and char or number or decimal using javascript on keypress

// HTML

<asp:TextBox ID="TextBox1" runat="server"   onkeypress="return isNumber(this, event);">

// JS

<script type="text/javascript">

function Is_Double_Exits(obj, event) {

            debugger;

            var charCode = (event.which) ? event.which : event.keyCode;

            if (charCode == 46) {   // keycode of decimal

                if (obj.value.indexOf('.') === -1) {

                    return true;

                }

                else {

                    return false;

                }

            }

            else {

                if (charCode > 31 && (charCode < 48 || charCode > 57)) {

                    return false;

                }

                else {

                    return true;

                }

            }

return true;

        }

</script>

Split first-name middle-name and last-name from full name using sql query

// using SUBSTRING

declare @name varchar(50)='krishna-chaturvedi'

SELECT top 2 SUBSTRING(@name, CHARINDEX('-', @name)+1, 8000)+'/' +SUBSTRING(@name, CHARINDEX('-', @name) + 1, 8000)

FROM mstuser

// using PARSENAME

declare @name varchar(100)= 'krishna-kumar-chaturvedi'

Select PARSENAME (Replace(@name,'-','.'),1)[LastName],

            PARSENAME (Replace(@name,'-','.'),2) [MiddleName],

            PARSENAME (Replace(@name,'-','.'),3)[FristName]

Encrypt password using sql server query with SHA and HASHBYTES

DECLARE @HashThis nvarchar(4000);

SELECT @HashThis = CONVERT(nvarchar(4000),'abc');

SELECT HASHBYTES('SHA1', @HashThis);

Encrypt and Decrypt password using sql server query

//1.   with query and parameter

declare @encrypt varbinary(200)

select @encrypt = EncryptByPassPhrase('key', 'abc' )

select @encrypt

select convert(varchar(100),DecryptByPassPhrase('key',@encrypt))

//2.   with query and direct value

declare @encrypt varbinary(200)

select @encrypt = EncryptByPassPhrase('key', 'abc' )

select @encrypt

select convert(varchar(100),DecryptByPassPhrase('key',0x01000000B97F1BA787918D419080AA009A4AC2B04628AFEAC1C1FBFD))

Rotate text inside gridview in asp.net using css for (IE,Mozial,Chrome etc.)

.verticaltext
{
/*I method
filter: flipH() flipV();
writing-mode: tb-rl;
height:128px;
-webkit-transform: rotate(-90deg);
-moz-transform: rotate(-90deg);
-o-transform: rotate(-90deg);
width:50px;
*/
/*II method*/
position: relative;
 -moz-transform: rotate(270deg);  /* FF3.5+ */      
 -o-transform: rotate(270deg);  /* Opera 10.5 */  
 -webkit-transform: rotate(270deg);  /* Saf3.1+, Chrome */            
  filter:  progid:DXImageTransform.Microsoft.BasicImage(rotation=3);  /* IE6,IE7 */        
  -ms-filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=3); /* IE8 */
  height:150px;

}

Show browser file or input type=file show only button in asp.net or HTML

//CSS

input[type=file] {

position: absolute;

border: solid transparent;

border-width: 0 0 0px 0px;

opacity: 0.0;

filter: alpha(opacity = 0);

}

.filebutton {

position: relative;

cursor: pointer;

text-align: center;

}

.filebutton span {

text-align: center;

padding: 2px 6px 3px;

background: #eac380 -moz-linear-gradient(center top , #eac380 5%, #fae4bd 100%) repeat scroll 0 0;

display: inline-block;

}

// HTML Controls

<label class=" filebutton">

   <span>Add Files</span>

   <input type="file" id="files" name="file"></input>

</label>

// Asp.net Controls

                               <label class="filebutton">

                                  <span>Browse...</span>

                                  <asp:FileUpload ID="FileUpload1" runat="server"/>

                              </label>