|
Hi,
I want to read an xls file and import data in dataset. This xls file is a system generated tab delimited file. Using below code I am getting "External table is not in the expected format" exception.
If I open the same file in excel and save it in correct excel format this piece of code works fine.
public static void ReadExcelFileData()
{
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Test.xls;Extended
Properties='Excel 8.0;HDR=Yes;IMEX=1;FMT=TabDelimiter'";
// Establish Connection
_connExcel = new OleDbConnection(connectionString);
_cmdExcel = new OleDbCommand();
_cmdExcel.Connection = _connExcel;
try
{
//Accessing Excel Sheet
_connExcel.Open();
//Code to read excel file
}
catch (Exception ex)
{
throw ex;
}
}
}
}
}
I tried to modify the connectionstring as given below,But it also gave me "c:\Test.xls is not a valid path" error
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Test.xls;Extended
Properties='text;HDR=Yes;IMEX=1;FMT=TabDelimiter'";
If anybody had faced such problem earlier, Please let me know the solution implemented by you.
Thanks & Regards,
Deepak
|
|
|
|
|
There is no such thing as a "tab delimitted XLS" file. A true XLS file is a binary format only natively readable by Excel, which your code will not work on. But, since you've said that you can open the file in Excel and export the data as a tab delimitted CSV file and your code suddenly work on that, leads me to believe that your initial file is not what you think it is.
|
|
|
|
|
As the previous poster stated, it looks like you're trying to import an excel file, rather than a tab delimited file (Excel workbooks have an '.xls' suffix whereas tab delimited are '.txt' by default). You can still open the workbook in the way you've started but you need to change the connection string. Have a look here[^] for details of what value to use.
HTH
ETA: you might need this one[^] instead depending on what version of Excel you're using.
It definitely isn't definatley
|
|
|
|
|
Hi
I am trying to transfer a data securely over HTTP and my page that I am recieving the secure data from is written in PHP.
I need a secure encryption method to encrypt the data that I am sending. It better needs a key to encrypt and decrypt and it should be secure (Rijandel would be nice  )
Thanks.
|
|
|
|
|
HTTPS would be the best way.
However, Google suggests that PHP does support various crypto fucntions so pick one that is also available in .NET.
|
|
|
|
|
Thank you for your answer.
I have searched a little about it on Google and I have read some articles that I've came across.
But none of them give me enough information about how secure is that encryption method is and wheather it exists both on C# and PHP.
I need an encryption method which decryptable only with a secret key and exists on both C# and PHP.
|
|
|
|
|
|
If you don't have a solid enough foundation in encryption to know the answer you should not be writing code that does encryption, from a security standpoint. It is very easy to make mistakes that can compromise the data. If it is truly important information hire a specialist to come in for one day to do it for you or your company. If the data is not that important just do whatever is simplest and don't worry about it.
As for checking whether is exists in both languages. The documentation for both languages provide that answer.
|
|
|
|
|
Thank you for all your answers.
As you can see I don't have a solid foundation in encryption, the data I am trying to encrypt is not so vital and sensitive. But it should be encrypted. I can even use Base64 but it would be a little bit too easy I guess.
|
|
|
|
|
Base64 is not encryption at all. It is an encoding to make sure 8-bit data can safely traverse a 7-bit path.
|
|
|
|
|
|
|
Thank you, but what about PHP?
|
|
|
|
|
|
I am trying to get a ToolStripPanel to have the same drawing style as the embedded ToolStrips, so that it looks like one continuous bar. I have the ToolStrips using the ToolStripProfessionalRenderer so that they are styled the same as the Windows Task Bar.
I have gotten close by creating a new Renderer derived from ToolStripProfessionalRenderer:
class CustomRenderer : ToolStripProfessionalRenderer
{
protected override void OnRenderToolStripPanelBackground(ToolStripPanelRenderEventArgs e)
{
base.OnRenderToolStripPanelBackground(e);
LinearGradientBrush lgb = new LinearGradientBrush(e.ToolStripPanel.ClientRectangle, this.ColorTable.ToolStripGradientBegin, this.ColorTable.ToolStripGradientEnd, LinearGradientMode.Vertical);
e.Graphics.FillPath(lgb, e.ToolStripPanel.ClientRectangle);
}
}
This creates the gradient look with the correct colors, but they do not match up quite right. It seems as if the gradient has a higher number of colors, so the spread is drawn out longer.
I have accounted for the border of the ToolStrips (which is not shown in this code), yet they still don't match up quite right.
Anyone know how to make this happen?
|
|
|
|
|
hi everybody
i had a problem with gridview.
my grid view having 10 rows of data.
if i change one value in one row then the remaining rows will be updated.
how can i solve this. im explaining briefly here
name | credit | debit | balance
aaa | 1000 | 0 | 1000
aaa | 0 | 500 | 500
if i change 1000 value to 2000 then the balance vl be 1500
i m inserting those values from different forms by using triggers concept.
hope u help me in this
thnx in advance
kumar
|
|
|
|
|
I would use excel with macros to do something like this.
|
|
|
|
|
At any value change in the datagrid field, you may raise events and invoke the function to update affected datagrid fields.
|
|
|
|
|
Hi, ive been using the Digital Persona SDK for past projects but for the scale of an upcoming project I am looking for a better SDK.
Has anyone had experience with different ones and which one would you recommend?
It doesnt need to be free.
Thanks
|
|
|
|
|
That all depends on what you intend to do with it?
Whats this upcoming project about more or less?
Harvey Saayman - South Africa
Software Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
It just needs to reliably check fingerprints against a database of about 1000 or so. Only needs to run on windows, and must come with both authentication and enrollment functionality.
|
|
|
|
|
The SDK's I've used for "large scale production environments" (MUCH greater than 1,000 users) all came with their scanners and will not work with other scanners.
|
|
|
|
|
I suggest you ask this in the Lounge forum. It's not programming specific and it'll get a lot more attention.
|
|
|
|
|
I have a series of strongly typed datasets in my .NET v2 project. When I shift the project to .NET v3.5 the system runs the first connection but refuses any further connections giving me a Named Pipes error...
I thought that there were no code changes required to migrate from v2 to v3.5, well obviously there should have been because it no longer works, but what should I be looking for?
Any ideas?
Thanks
|
|
|
|
|
Make sure your connections are properly released. Also, make sure that your application accesses the database in a linear manner. Then make sure that SQL server is properly configured, etc. Your error, unfortunately, has many potential causes. The current project I am working can be built in 2.0 or 3.5 and access the database without an error so it can happen seamlessly depending on your code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
