|
|
|
Hi,
See my code for importing data from excel sheet.I have problem with importing data which contains in one column all record in digit except one is in charecters. The row containing charecters in that perticular column is not imported.
<br />
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pathName + @"\" + fileName + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1;\"";<br />
OleDbConnection ExcelConnection = new OleDbConnection(excelConnectionString);<br />
OleDbCommand ExcelCommand = new OleDbCommand();<br />
ExcelCommand.Connection = ExcelConnection;<br />
OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand);<br />
<br />
ExcelConnection.Open();<br />
<br />
DataTable ExcelSheets = ExcelConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,null);<br />
<br />
<br />
string SpreadSheetName = "[" + ExcelSheets.Rows[workSheetNumber]["TABLE_NAME"].ToString() + "]";<br />
<br />
ExcelCommand.CommandText = @"SELECT * FROM " + SpreadSheetName;<br />
ExcelAdapter.Fill(ExcelDataSet);<br />
In my "Password" colomn all record contains digits but one record contains charecters.
At a time of debuging, i have found record contains NULL value. I have done lots of googling for this problem but still face this problem.
My registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
key ImportMixedTypes=Text.!- F - R - I - E - N - D - S -!
|
|
|
|
|
The excel driver makes an assumption about the data type of each column based on the data in the first 8 rows. If you mix data types in the same column you need to format your excel sheet properly to get the data type set correctly.
Related MS KB article[^]
|
|
|
|
|
Actually my client is upload excel sheet. I can't format cells in every sheet. is it any way to format excel sheet column? or any other Extended Property is there? !- F - R - I - E - N - D - S -!
|
|
|
|
|
|
Hi...
I am using asp with c#. I am doing an application for upload image files via ftp. how to i do this?
Any help will be appriciated...
thanks...G.Paulraj
|
|
|
|
|
|
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm6.aspx.vb" Inherits="MyData.WebForm6"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>WebForm6</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<ASP:panel id="FileUploadForm" visible="true" runat="server">
<FORM id="Form2" method="post" encType="multipart/from-data" runat="server">
<P><INPUT id="loFile" type="file" name="loFile" runat="server"></P>
<P>
<asp:TextBox id="dir" runat="server"></asp:TextBox><BR
<asp:Button id="Button1" runat="server" Text="Button"></asp:Button><BR>
</P>
</FORM>
</ASP:panel>
<ASP:panel id="AnswerMsg" visible="false" runat="server">
<ASP:label id="FileName" runat="server"></ASP:label>
<BR>
<ASP:label id="FileLength" runat="server"></ASP:label>
<BR>
<ASP:label id="FileType" runat="server"></ASP:label>
<BR>
</ASP:panel>
</body>
</HTML>
.vb
Imports System.IO
Imports System.Data
Public Class WebForm6
Inherits System.Web.UI.Page
#Region "
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Protected WithEvents FileUploadForm As System.Web.UI.WebControls.Panel
Protected WithEvents FileName As System.Web.UI.WebControls.Label
Protected WithEvents FileLength As System.Web.UI.WebControls.Label
Protected WithEvents FileType As System.Web.UI.WebControls.Label
Protected WithEvents AnswerMsg As System.Web.UI.WebControls.Panel
Protected WithEvents loFile As System.Web.UI.HtmlControls.HtmlInputFile
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Protected WithEvents dir As System.Web.UI.WebControls.TextBox
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim lstrFileName As String
Dim lstrFileNamePath As String
Dim lstrFileFolder As String
If dir.Text <> "" Then
lstrFileFolder = dir.Text
Else
lstrFileFolder = "c:\"
End If
Dim files As System.Web.HttpFileCollection = System.Web.HttpContext.Current.Request.Files
Dim postedFile As System.Web.HttpPostedFile = files(0)
lstrFileName = System.IO.Path.GetFileName(postedFile.FileName)
lstrFileName = Path.GetFileName(lstrFileName)
If (Not Directory.Exists(lstrFileFolder)) Then
Directory.CreateDirectory(lstrFileFolder)
End If
lstrFileNamePath = lstrFileFolder & lstrFileName
loFile.PostedFile.SaveAs(lstrFileNamePath)
FileName.Text = lstrFileName
FileType.Text = loFile.PostedFile.ContentType
FileLength.Text = CStr(loFile.PostedFile.ContentLength)
FileUploadForm.Visible = False
AnswerMsg.Visible = True
End Sub
End Class
April
Comm100 - Leading Live Chat Software Provider
|
|
|
|
|
Hi...
Thanks for your reply.
I am using c#. so can you please send the code snipt in c#?
thanks...G.Paulraj
|
|
|
|
|
I have an asp.net application hosted in localhost with backend as sql express. An sql server 2008 database with same structure is hosted in a remote server. I have to synchronize these two databases. What is the best way to do this? Can I do it with sync framework? Please suggest me a solution for this.
|
|
|
|
|
How about Backup the remote server and Restore it to the local? Or you could export the data from the remote server and import it back in locally - there are a number of ways to accomplish that. There are a number of other ways that also come to mind but those are probably the easiest and quickest (depending n the size and disposition of the databases).Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
The process should work in every 1 or 2 hours. The synchronization process should be done automatically. The backup and restore will be difficult in this situation and it will take more time. Is there any other solution apart from back up and restore.
|
|
|
|
|
Well it was good that you mentioned everything in the first post otherwise I might have posted an innapropriate answer.
How about scheduling a Sql job that will do the work for you? Sql Server Jobs[^]Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
Actually I do not know much about sql job. I will try it. Thank you so much for giving the details. If you have any other ideas please give that one too. I'm going to check with jobs. Once again thank you.
|
|
|
|
|
Hello,
Here are the steps I have taken to set and retrieve a session value:
1)
In the page load event of the login page, I have placed:
Session.Remove("DB");
2)
Then when there is a successful login, in the page load event of the first page that appears i.e. the default.aspx I have placed:
Session["DB"] = strDB; //where strDB is a text
3)
Then I need to retrieve this session value from within a class file and this is how I am retrieving it in the constructor of the class
string strName = (string)System.Web.HttpContext.Current.Session["DB"];
Question:
Most of the times there is no problem but sometimes I get an error on step 3) above and it says object reference not set to an instance of an object.
Do you see anything wrong please?
Thanks
|
|
|
|
|
arkiboys wrote: reference not set to an instance of an object
are you writing you page load code in,
if (!Page.IsPostBack)
{
//your code here
}
|
|
|
|
|
Can't see anything wrong with the code itself, but this is probably not the best way to be doing this kind of thing.
IMO As long as a user is logged in, the Session value should be there, and you should only remove it when they have logged out.
- rather than doing Session["DB"] = strDB; on PageLoad of Default.aspx, do it on the login page, when the user has entered their credentials and clicked the login button
- rather than doing Session.Remove("DB") in PageLoad of the login page I think you should do Session.Abandon() when the users click on the logout link.
|
|
|
|
|
|
The solution to this task is simple.
protected void loginButton_Click(object sender, EventArgs e)
{
// your code for authentication goes here
if (myUser.IsAuthenticated())
{
Session["username"] = usernameTextBox.Text.Trim();
Response.Redirect("~//Default.aspx");
}
else
messageLabel.Text = "Authentication failed: Invalid username or password";
}
protected void logoutButton_Click(object sender, EventArgs e)
{
Session.Abandon(); // or Session.Remove("username");
Response.Redirect("~//Logout.aspx");
}Tunsten
|
|
|
|
|
arkiboys wrote: Most of the times there is no problem but sometimes I get an error on step 3) above and it says object reference not set to an instance of an object.
This is because your session is expired and the object no longer exists. so everytime when you read a session variable you need to check wether its there or not.
string strName;
if(System.Web.HttpContext.Current.Session["DB"] != null)
strName = (string)System.Web.HttpContext.Current.Session["DB"];
else
Response.Redirect("Your login page");
if you open the page and wait until your session expires you will get that error every time (default time of session is 20 min).
take a look at the article which 'Brij' has suggested.
|
|
|
|
|
Hi All,
I have hosted my asp.net 2.0 project in a general webserver where we have found a lot of problem like session expiry, view state, machine key etc. To execute my project on such server I had to do configuration which is required for asp.net project running on web farm. so I thought my server could be web farm.
But the server guy has confirmed that they have not done any cofiguration for web farm and they say its a simple web server.
I am totally confused if my server is not web farm then why its need configuration like web farm. why my code is not running there.
Any body can suggest me whats wrong I am doing.
Any help would be highly appriciable.
Thanks
Rohit
|
|
|
|
|
You just need a Windows Hosting with ASP.Net 2.0 nothing special, Do you know wether you have windows hosting with ASP.Net 2.0 ? because if its just simple HTML hosting or Linux hosting, you cannot run ASP.Net application on it.
What kind of problems you are facing ? List out the exact error messages here.
|
|
|
|
|
we have a dedicated server windows 2003 and all required software for asp.net project is installed.
we have used .net 2008 provided Ajax which doesnot work there gives the javascript error "sys is undefined" but when I specified the machine key on web.config then its works.
We got the error about the view state we had to made the enableledViewStateMAC to false in web.config.
We got the session expire problem in "InProc" case which was solved when i used StateServer
I just dont understand what wrong i did there.
|
|
|
|
|
Ask you about the heroes of a web development technical issues, how to use Flash technology to achieve dynamic image switching, that is, multiple pictures into a cylindrical rotating display, each user is always seen in front, a picture, the effect like the following website show: http://www.monex.co.jp/
|
|
|
|