ASP.NET

SqlCommand dataCommand = new SqlCommand(sql, dataConnection);

SqlCommand dataCommand = new SqlCommand(sql, con);

when you are binding the values from any source, create another alias in your selection query.

ex: select fullname,left(fullname,20) as shortname from tablename

the 20 mentioned can be of your need.and then bind the shortname to literal.it works.

<ItemTemplate>
 <asp:CheckBox ID="chkItemSelect" runat="server" />
 <asp:Label ID="lblname" Text='<%#Bind("name")%>' runat="server" />              
<asp:Button ID="btnFindx" runat="server" CommandName="Findx" Text="Do Some thing" CommandArgument='<%#Eval("ID")%>'></asp:Button>
                                        </ItemTemplate>

Protected Sub GridView_RowCommand(sender As [Object], e As GridViewCommandEventArgs)
	Select Case e.CommandName
		Case "Findx"
			MethodFindControlValue()
			Exit Select
	End Select
End Sub

Private Sub MethodFindControlValue()
	For Each row As GridViewRow In ApprovalGrid.Rows
		Dim chkItemSelect As CheckBox = CType(row.FindControl("chkItemSelect"), CheckBox)
		Dim chkItemSelect As Label = CType(row.FindControl("lblname"), CheckBox)

		Dim id As String = Convert.ToString(NameGridView.DataKeys(row.RowIndex).Value.ToString())
	Next
End Sub

mydomain.com/signin

mydomain.com/myprofile/comment/post-guid-string

mydomain.com/signin/www.mydomain.com/myprofile/comment/post-guid-string

<input type="button" value="Export to Excel" onclick="ExportToExcel()"/>

<script type="text/javascript">
      function ExportToExcel()
      {
          var txt = window.open("pageListForExportExcel.aspx");
      }
</script>

<%@ Page Language="C#" AutoEventWireup="true" EnableSessionState="ReadOnly" EnableViewState="false" CodeBehind="BukuInduk_exportToExcel.aspx.cs" Inherits="LimSys.Web.Laporan.BukuInduk_exportToExcel" %>
		<asp:Repeater ID="rep1" runat="server">
			<HeaderTemplate>
				<table border=1>
					<tr>
						<td>NAME</td>
						<td>ADDRESS</td>
						<td>TELP</td>
						<td>GENDER</td>
					</tr>
			</HeaderTemplate>
			<ItemTemplate>
					<tr>
						<td><%# Eval("name")%></td>
						<td><%# Eval("address")%></td>
						<td><%# Eval("telp")%></td>
						<td><%# Eval("gender")%></td>
					</tr>
			</ItemTemplate>
			<FooterTemplate>
				</table>
			</FooterTemplate>
		</asp:Repeater>

 protected void Page_Load(object sender, EventArgs e)
{
    Response.Clear();// this for clear any response
    Response.Buffer = true; // and then set to Buffer is true
    Response.ContentType = "application/vnd.ms-excel";// and this is for call type what you want to set File extention for save....you can export to pdf ,if you change value Response.ContentType

    var process = new DataLayersCollections();//set here by name your BusinesLogic
    var list = process.GetListFromDataTable(); //set here by name your functions
    rep1.DataSource = list;
    rep1.DataBind();
}