Hi I am new to C# and I tried to create this simple upload, file program. My code works okay on development, but when i tried Build Solution it does not work it showing me error.
it is showing
The name 'FileUpload1' does not exist in the current context.
The name 'GridView1' does not exist in the current context.
The name 'SqlDataSource1' does not exist in the current context.
below is my code.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>SRSR Uploader</title>
<style type="text/css">
.auto-style2 {
color: #0066CC;
}
</style>
<link href="Styles.css" rel="stylesheet" />
<%--<link href="Styles.css" rel="stylesheet" />--%>
</head>
<body>
<h2 class="auto-style2">Please Upload SRSR File(.xls)</h2>
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
<br />
<asp:RequiredFieldValidator ErrorMessage="Required" ControlToValidate="FileUpload1"
runat="server" Display="Dynamic" ForeColor="Red" />
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" ValidationExpression="([a-zA-Z0-9\s_\\.\-:])+(.xls|.xlsx)$"
ControlToValidate="FileUpload1" runat="server" ForeColor="Red" ErrorMessage="Please select a valid excel file."
Display="Dynamic"/>
<br />
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Upload" />
<br />
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SQL2000 %>" ProviderName="<%$ ConnectionStrings:SQL2000.ProviderName %>" SelectCommand="SELECT * FROM [INSYNCH_GL_TEST]" OnSelecting="SqlDataSource1_Selecting"></asp:SqlDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" CssClass="mydatagrid" PagerStyle-CssClass="pager"
HeaderStyle-CssClass="header" RowStyle-CssClass="rows" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="1191px" AllowPaging="True" Height="344px" AllowSorting="True" PageSize="20">
<Columns>
<asp:BoundField DataField="TRX_NO" HeaderText="TRX_NO" SortExpression="TRX_NO" />
<asp:BoundField DataField="ACCOUNT" HeaderText="ACCOUNT" SortExpression="ACCOUNT" />
<asp:BoundField DataField="STR_AMOUNT" HeaderText="STR_AMOUNT" SortExpression="STR_AMOUNT" DataFormatString="{0:0.00}" HtmlEncode="False" />
<asp:BoundField DataField="AMOUNT" HeaderText="AMOUNT" SortExpression="AMOUNT" DataFormatString="{0:0.00}" HtmlEncode="False" />
<asp:BoundField DataField="DEBIT" HeaderText="DEBIT" SortExpression="DEBIT" DataFormatString="{0:0.00}" HtmlEncode="False" />
<asp:BoundField DataField="CREDIT" HeaderText="CREDIT" SortExpression="CREDIT" DataFormatString="{0:0.00}" HtmlEncode="False" />
<asp:BoundField DataField="DESCRIPTION" HeaderText="DESCRIPTION" SortExpression="DESCRIPTION" />
<asp:BoundField DataField="LOCATION" HeaderText="LOCATION" SortExpression="LOCATION" />
<asp:BoundField DataField="STATUS" HeaderText="STATUS" SortExpression="STATUS" />
</Columns>
<HeaderStyle CssClass="header" />
<PagerStyle CssClass="pager" />
<RowStyle CssClass="rows" />
</asp:GridView>
<br />
</form>
</body>
</html>
using System;
using System.Linq;
using System.IO;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (FileUpload1.HasFile) {
GridView1.DataBind();
}
}
protected void Upload(object sender, EventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
}
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
FileUpload FileUpload1 = (FileUpload)GridView1.Rows[e.RowIndex].FindControl("FileUpload1");
if (FileUpload1.HasFile)
{
}
GridView1.EditIndex = -1;
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string excelPath = Path.GetFullPath(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(excelPath);
string conString = string.Empty;
string extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
switch (extension)
{
case ".xls": //Excel 97-03
conString = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
break;
case ".xlsx": //Excel 07 or higher
conString = ConfigurationManager.ConnectionStrings["Excel07+ConString"].ConnectionString;
break;
}
conString = string.Format(conString, excelPath);
using (OleDbConnection excel_con = new OleDbConnection(conString))
{
excel_con.Open();
string sheet1 = excel_con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Rows[0]["TABLE_NAME"].ToString();
DataTable dtExcelData = new DataTable();
//[OPTIONAL]: It is recommended as otherwise the data will be considered as String by default.
dtExcelData.Columns.AddRange(new DataColumn[8] { new DataColumn("TRX_NO", typeof(string)),
new DataColumn("ACCOUNT", typeof(string)),
new DataColumn("STR_AMOUNT",typeof(float)),
new DataColumn("AMOUNT",typeof(float)),
new DataColumn("DEBIT",typeof(float)),
new DataColumn("CREDIT",typeof(float)),
new DataColumn("DESCRIPTION",typeof(string)),
new DataColumn("LOCATION",typeof(string))
});
using (OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM [" + sheet1 + "]", excel_con))
{
oda.Fill(dtExcelData);
}
excel_con.Close();
string consString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
//Set the database table name
sqlBulkCopy.DestinationTableName = "dbo.INSYNCH_GL_TEST";
//[OPTIONAL]: Map the Excel columns with that of the database table
sqlBulkCopy.ColumnMappings.Add("TRX_NO", "TRX_NO");
sqlBulkCopy.ColumnMappings.Add("ACCOUNT", "ACCOUNT");
sqlBulkCopy.ColumnMappings.Add("STR_AMOUNT", "STR_AMOUNT");
sqlBulkCopy.ColumnMappings.Add("AMOUNT", "AMOUNT");
sqlBulkCopy.ColumnMappings.Add("DEBIT", "DEBIT");
sqlBulkCopy.ColumnMappings.Add("CREDIT", "CREDIT");
sqlBulkCopy.ColumnMappings.Add("DESCRIPTION", "DESCRIPTION");
sqlBulkCopy.ColumnMappings.Add("LOCATION", "LOCATION");
con.Open();
sqlBulkCopy.WriteToServer(dtExcelData);
con.Close();
SqlDataSource1.DataBind();
GridView1.DataBind();
//if (GridView1.Rows.Count > 0)
//{
// Button1.Visible = true;
//}
//else
//{
// Button1.Visible = false;
//}
FileUpload1.SaveAs(excelPath);
//ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "File has been Saved" + "');", true);
}
}
}
}
// ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "File has been Saved" + "');", true);
}
}