Introduction : In this article i will show you how to export GridView to excel file. Many times we require to export the GridView to excel sheet file.I have here written following code in asp.net c# to export the gridview control to excel sheet file. Html code for gridview export to excel sheet :
Introduction : In this article i will show how to detect browser in Jquery . Many times we require to detect browser and need to do code accordingly as per browser. By using following code you can detect Internet Explorer Browser ,Mozila Browser ,Safari Browser In Jquery
Jquery Code to Detect Browser :
<script src="Scripts/jquery-1.4.1-vsdoc.js" type="text/javascript"></script>
<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
if ($.browser.msie) { alert('Internet Explorer and Version is ' + $.browser.version) }
if ($.browser.safari) { alert('Safari Browser .') }
if ($.browser.mozilla) { alert('Mozila Browser and Version is ' + $.browser.version) }
});
</script>
Sorting, Paging, Add, Update, Delete in GridView asp.net c#
Introduction : In this article i will show full functional Gridview with Sorting, Paging , Add ,Update ,delete operation .The GridView control is used to display the values of a data source in a table. It is very useful asp.net control .Here I have written the code for Sorting , Paging , Update , Delete , Add with footer row .
The Code for All operations in GridVeiw that i have written is very easy understand and easy to implement in you application .
Html Code For Gridview with Sorting, Paging , Add ,Update ,delete operation In Asp.net:
Introduction : In this article i will show you how to pass the arguments to String.Format method in c# .
You need to pass comma separated list of arguments to the string.Format method .There must be argument for each of the place holders .
Following is the example of String.Format in c# :
string Name ="Seta Hamid ";
string Country ="India";
Response.Write( String.Format("My Name is {0}. I am from {1}.", Name, Country));
Get Recursive all childs by parentid in sql server
Introduction : In this article i will show you how to get all recursive childs by parentid in sql server .To get all childs i have used recursive query using with CTE ( Common Table Expressions ) . It is very simple to with parentid and childId relationship table.I have written query for getting recursive child records in sql server is as follow .
Table design for Relationship :
Query for get all childs by parentid in sql server :
declare @ParentId as int;
set @ParentId = 1;
WITH RecursiveTable (ProductId, ParentId,ProductName, Level)
AS
(
SELECT MaintTab.ProductId,
MaintTab.ParentId,
MaintTab.ProductName ,
0 AS Level
FROM ProductTable AS MaintTab
WHERE ParentId = @ParentId
UNION ALL
SELECT MaintTab.ProductId,
MaintTab.ParentId,
MaintTab.ProductName ,
LEVEL + 1
FROM ProductTable AS MaintTab
INNER JOIN RecursiveTable Rtab ON
MaintTab.ParentId = Rtab.ProductId
)
SELECT * FROM RecursiveTable
Introduction : In this article i will show you how to add Chart control in asp.net 4.0 and how to bind chart control in asp.net with Dataset .You just need to drag the chart control in aspx page so following assembly will be register in your web page and corresponding httpHandlers will be added in web config too .
Code For Bind Chart Control In asp.net :
I have following complete html and code behind code for binding Chart control in c# asp.net. I have here created Bar chart control in asp.net.
Set hidden field's value on button's click in Jquery
Introduction : In this i will show you how to set value of hidden field's value on button click usinng Jquery . It is very easy to set value of hidden field's value using Jquery .I have written two way to set value of hidden field using Jquery . In first way you can write code in $(document).ready() function and second you can directly assign to on click of button .
HTML Code for Set hidden field's value on button's click in Jquery :
Check / Uncheck all checkbox in treeview using jquery in asp.net
Introduction : In this article i will show you how check all checkboxes in treeview using Jquery in asp.net .It is very easy just you need add code and replace id as per treeview control .
For the binding the Treeview control in asp.net you can visits my previous post bind treeview in-asp.net .
Jquery for check / uncheck all checkboxes in treeview in c# :
Following is jquery code for check or uncheck all checkboxes in treeview control and HTML code in asp.net .
Introduction : In this article i will show you how to bind treeview in c# using dataset . I have created complete code to bind the treeview and also table structure in image which require for the treeview control to bind in asp.net c# using dataset .
Introduction : This article show you how to merge or combine two more doc files in Asp.net using C# .
I have created one function to merge multiple word file in c# .it is very easy to use .You just need to pass word file path arrays and save file path . Then i will save merged word document file .
Introduction : This article show you how to add validation using Jquery in Asp.net . Validation is easy in jquery just need add my following complete html code for Jquery validation in asp.net .
you can apply required validation by adding class to textbox like : CssClass="required". ..etc .so on you can Url validation ,date validation , digits validation ..etc using jquery .
Complete Html Code for Jquery validation in asp.net page :
Introduction : This article describe how you can convert the DOC file to RTF format in asp.net using c# language .
Code For Doc to RTF: I have created one function to convert DOC file to RTF format in c# . You need to pass just doc file path to it and it save the .RTF format file .
First you need to add reference of Microsoft.Office.Interop.Word.dll dll in project .
Microsoft.Office.Interop.Word.dll
Function For Conversion Doc To RTF :
public void ConvertDocToRTF(string DocPath)
{
//Creare object of documnet .
Document document = new Document();
try
{
//Load doc file from given path
document.LoadFromFile(DocPath);
//Save doc file. It will convert to .Rtf format .
document.SaveToFile("Tesfile.rtf", FileFormat.Rtf);
}
catch (Exception) { throw; }
}
Introduction : In this article i will show you how to send mail
in asp.net using gmail account.It is very simple just you need to pass
your gmail account email address and password in
System.Net.NetworkCredential() . And also you need to set host= smtp.gmail.com ,port =587 .I
have following code to send mail using gmail account in asp.net c# .
Introduction : In this article i will show how to redirect one website to another website . Many times we require that some one visit www.xyz.com then he should be redirect to another site for that you need add peace of java-script code and it automatically redirect to another site .
