Get Excel sheet data to Dataset

using System.Data;
using System.Data.OleDb;

OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties=Excel 8.0");
OleDbDataAdapter da = new OleDbDataAdapter("select * from MyObject", con);
DataTable dt = new DataTable();
da.Fill(dt);



string connstr ="Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\aaa.xls;Extended Properties=Excel 8.0"/>
OleDbConnection conn = new OleDbConnection(connstr);
string strSQL = "SELECT * FROM [Sheet$]";
OleDbCommand cmd = new OleDbCommand(strSQL, conn);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds);


Data binding technique

• Bind data with text

NavigateUrl= <%# Eval("ShortTeamName","http://www.theredzone.org/archives/showteam.asp?Team={0}" ) %>

Position of {0} bind value of   ShortTeamName

• Bind data with unary operator

<%# (Eval("ClientReturnFromIFAP","{0:dd-MM-yyyy}")=="01-01-1900")?"":Eval("ClientReturnFromIFAP","{0:dd-MM-yyyy}")   %>

• Data bind with string

asp:HyperLink ID="show_story" Runat="server" NavigateUrl='%# "~/view_story.aspx?refurl=

default.aspx&story=" + DataBinder.Eval(Container.DataItem, "Story_ID")%>'>Click Here/asp:HyperLink>