|
I checked in my hosting server,I used the correct aspnet version in hosting server.
|
|
|
|
|
I am telling my special thanks to Abjit jana,Paddy boyd and ma Tju.
i solved my problem with your suggestions.
Problem with complilation in my visual studio.I tried it from some other system its working.
I am very thankful to codeproject.
|
|
|
|
|
Hi all,
i am getting following error when reading data from excel file.
"External table is not in the expected format".
The application is hosted on server. The applicatin takes input as one excel file and save it on server folder. And then open that excel file and read whole data to datatable.
This is working fine if excel file contains 50,000 records.
I tested the same thing with 1 lakh records, it getting the below error
"External table is not in the expected format".
I tested with 70000 records, it showing the below error
"No error message available, result code: E_FAIL(0x80004005)."
What i have to do to avoid this? why it showing different errors if excel file containing more and more records
G. Satish
modified on Thursday, November 27, 2008 7:36 AM
|
|
|
|
|
Is there any mismatch of data?
cheers,
Abhijit
|
|
|
|
|
NO mismatch of data..
If there is any mismatch means, it wont work for first 50,000 records.
The same records has been duplicated as next 50,000 records.
G. Satish
|
|
|
|
|
|
It may be totally irrelevant, but I thought Excel could only hold 65,535(ish) records.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ashfield wrote: I thought Excel could only hold 65,535(ish) records.
I never thought about that !!! You are correct , it can hold 65,535 records ( Rows) in a sheet.
Great !!!
cheers,
Abhijit
|
|
|
|
|
yes...if the excel file is 97-2003 it has only 65000 limit
But i am using excel 2007. It is taking records so on. I dont know how much limit it has. i have checked with 5 lakh records. Still it is taking
G. Satish
|
|
|
|
|
yes...if the excel file is 97-2003 it has only 65000 limit
But i am using excel 2007. It is taking records so on. I dont know how much limit it has. i have checked with 5 lakh records. Still it is taking
My excel file extension is .xlsx
G. Satish
|
|
|
|
|
I completed the web design now my problem is alignment.
When i run the program in Internet Exporter it work perfectly with good alignment.
But same thing i run in Mozilla Firefox the complete format is changed.
What can I do...
Thanks guys.
|
|
|
|
|
Yes !!! You have to use proper css for that !!
cheers,
Abhijit
|
|
|
|
|
Hi all,
i have a gridview in my project.
i need to pass the backcolor of a row to a javascript function and assign that backcolor to some other row in the javascript.
actually the requirement is,
i have to highlight(say yellow) a row on mouseover
that highlight to be removed(i.e., back to its original color) on mouseout
a row is highlighted with some other color(say green) on click.
here is the code im using for it.
<pre>
var previousRow;
var mouseOverBgColor;
var clickBgColor;
function ChangeRowColor(row)
{
//If last clicked row and the current clicked row are same
if (previousRow == row)
return;//do nothing
//If there is row clicked earlier
else if (previousRow != null)
//change the color of the previous row back to white
document.getElementById(previousRow).style.backgroundColor = clickBgColor;
//change the color of the current row to light yellow
document.getElementById(row).style.backgroundColor = "#80FF80";
//assign the current row id to the previous row id
//for next row to be clicked
previousRow = row;
clickBgColor = mouseOverBgColor;
}
function mouseOver(row, backColor)
{
if(previousRow == row)
return;
else
{
mouseOverBgColor = backColor;
document.getElementById(row).style.backgroundColor = "#EEFF00";
}
}
function mouseOut(row)
{
if(previousRow == row)
return;
else
document.getElementById(row).style.backgroundColor = mouseOverBgColor;
}
</pre>
and here is the code behind..
<pre>
protected void gdvToolSize_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onclick", "javascript:ChangeRowColor('" + e.Row.ClientID + "')");
e.Row.Attributes.Add("onmouseover", "javascript:mouseOver('" + e.Row.ClientID + "','" + e.Row.BackColor + "')");
e.Row.Attributes.Add("onmouseout", "javascript:mouseOut('" + e.Row.ClientID + "')");
}
}
</pre>
any help appreciated..
|
|
|
|
|
Can I fill a dropDownList Like treeView
thanks
ahmed eldeghedy
|
|
|
|
|
To make it look like a tree, with nodes, you'd need a custom control. I'm sure they exist, commercially. The easy way is to have a tree, and then show/hide it in a div when an arrow button is pressed.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Then Why Dropdown List.
use Tree inside Div which can be expandable !!!
cheers,
Abhijit
|
|
|
|
|
I m fresher to asp.net now i m working on menu & Treeview can u send more information and sample code on it. and I m using vb code as background
Thanks
Ananda.
|
|
|
|
|
I would suggest that you start with something simpler. Why do you need to be working on menus and treeviews if you're new to ASP.NET ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
I done rest of all other control that website pending in only Treeview...
|
|
|
|
|
|
Hi...
I have a browse button on client side webpage, now i need to select a application file on the server Machine by using the browse button...
Please help…
Thanks in advance
skvs
|
|
|
|
|
You plainly can't do that directly. ?You'll need to build UI to read the file system on the server and show it to the client.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hello Guys...
I m created a asp.net web page and control also. now when i open the page it take's too time. I load Image like 2053*3420 size. now what i do for fast loading without removing images and size also....
Plz Help Me...
Thanks
Ananda.
|
|
|
|
|
The page will load before the images load. But the first time you run an ASP.NET page, it's compiling, which could be what makes it slow.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Reducing the actual size of the image would help, just create a version the size you want to display.
Bob
Ashfield Consultants Ltd
|
|
|
|