Introduction : In this article i will show you how to bind a DropDownList to avoid page refresh via a webmethod .It is very useful and many time we require to use Jquery ajax . I have here provided html and c# code behind code to understand Jquery Ajax in asp.net .
C# Code for binding Dropdownlist using Jquery Ajax
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.Services;
using System.Data.SqlClient;
public partial class AjaxInJquery : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static List GetCityData()
{
List CityCollection = new List();
try
{
DataSet Ds = GetDataSet("Select * from Countrytable");
CityCollection = Ds.Tables[0].AsEnumerable().Select(data => new City() { CityId = (int)data["CountryID"], Cityname = (string)data["CountryName"] }).ToList();
}
catch (Exception) { }
return CityCollection;
}
public static DataSet GetDataSet(string Query)
{
DataSet Ds = new DataSet();
try
{
string strCon = @"Data Source=ServerName;Initial Catalog=Test;Integrated Security=True";
SqlConnection Con = new SqlConnection(strCon);
SqlDataAdapter Da = new SqlDataAdapter(Query, Con);
Da.Fill(Ds);
}
catch (Exception) { }
return Ds;
}
}
public class City
{
public int CityId { get; set; }
public string Cityname { get; set; }
}
Order by Ascending and Descending class List<> in C# :
Introduction : In this article i will explain you how to sort class collection ( List<> of class ) in linq c# . I done the easy code to understand how to uses Order by Ascending and Descending of class list in linq c#.
Class example for sorting class List<> In c#: Following is the user class example with constructor in c#.
public class User
{
public int UserId { get; set; }
public string Firstname { get; set; }
public User(int userId, string firstname)
{
UserId = userId;
Firstname = firstname;
}
}
Ascending and Descending Sorting class list in linq C#:
List<User> UserList = new List<User>();
UserList.Add(new User(1, "bimal"));
UserList.Add(new User(2, "punit"));
UserList.Add(new User(3, "amit"));
UserList = UserList.OrderBy(x => x.Firstname).ToList(); //Ascending Sorted the class list using linq.
UserList = UserList.OrderByDescending(x => x.Firstname).ToList(); // Descending Sorted the class list using linq.
Add,Update,Delete,paging with DetailsView in asp.net c#
Introduction: In this article i will show you how to bind DetailsView in asp.net c# . I have implemented all operation like paging ,add ,edit and delete in DetailsView in asp.net c# .
In following i have written the Css class to format the DetaildView.
Html Code for DetailsView in asp.net :
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 :
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));
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.
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 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 .
Introduction : In this article i will show you how to bind Radiobuttonlist in asp.net c# .Radiobuttonlist control is group of Radiobutton.Many time we require to bind the data in RadioButtonList using database sql server in asp.net . I have here provided complete Html code and Code behind code for binding RadioButtonList In Asp.net c# .Following are my simple code .
Many time we require to bind the data in checkboxlist using database sql server in asp.net . I have here provided complete Html code and Code behind code for binding CheckBoxList In Asp.net c# .Following are my simple code .
In this article i will show how to fill dataset from database sql server using c# language .For this i have created common methodh in which you have just pass the query and it automatically return the filled dataset .GetDataSet function contains the easy code to fill the dataset .
Calling the method :
DataSet Ds = GetDataSet("Select * from Tablename");
Method to bind dataset :
private DataSet GetDataSet(string Query)
{
DataSet Ds = new DataSet();
try
{
string strCon =""; // set connetion string here ..
SqlConnection Con = new SqlConnection(strCon);
SqlDataAdapter Da = new SqlDataAdapter(Query, Con);
Da.Fill(Ds);
}
catch (Exception)
{
}
return Ds;
}
