|
It sounds like this is an issue with the Excel driver attempting to guess the data type for the column. The driver has probably made the decision, based on sampling an initial number of rows (default is 8) that the column should contain text values. Values that look like they belong to another data type will be disregarded and show up as NULL. If you add the element 'IMEX=1' to your connection string this tells the driver to treat intermixed data in a column as text (see here[^])
If you need to increase the number of rows that the driver uses to guess the data type for a column, you need to make a registry change. See this article[^] for more information.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks a lot for your help. IMEX=1 did the trick.
|
|
|
|
|
Has anyone here played with this? I'm considering doing so, but I don't want to mess with it if it is vaporware or doesn't work outside of simple examples. What's the general impression of it? Has anyone run into any deal breakers with it that make you not want to use it?
Also, has anyone seen a situation where dynamic data handles hierarchical data (like groups that can contain other groups)?
Thanks,
Will
|
|
|
|
|
Can we dispose a datatable after use to free up the memory because it is huge in size
|
|
|
|
|
table = null;
mark it null so that when garbage collector runs it will free the memory
|
|
|
|
|
If it has a Dispose method, this should be called first. If not, then perhaps it shouldn't be a member variable, so it just gets disposed.
Hell, the page lifecycle means it will get removed unless it's stored in the session ( which would be stupid )
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
How to use group by in datatable in c#?
|
|
|
|
|
Hi,
I have placed a Telerik progress bar on my login page, this produces Javascript which makes calls to the Telerik.Web.UI.dll that is stored in the bin folder. However Forms Authentication is preventing access to this and producing JavaScript errors that 'telerik' is undefined. If I log into the site and go back to the login page it works fine.
Currently we have forms authentication set with the option path="/" meaning everything from the root down. Would it be better to have a new folder named "secure" and then any pages that need to have authetication sit under that folder, and change the forms authentication option to Path="/secure"?
Or is there a better solution?
Kind regards
Paul Custance
|
|
|
|
|
Hi,
I want to bind radio button with the database (MS Access). I have written some code.there are two radio buttons male and female. and one gender coloun in table yes/no (bool) type.
private void rbd()
{
try
{
database = new OleDbConnection(connectionString);
database.Open();
}
catch (OleDbException ex)
{
MessageBox.Show("Error in connection ..." + ex.Message);
}
string sqlStr = "SELECT * FROM city;";
dAdapter = new OleDbDataAdapter(sqlStr, connectionString);
dset = new DataSet();
dAdapter.Fill(dset,"city");
bindingSource = new BindingSource(dset, "gender");
radioButton1.DataBindings.Add("Checked", bindingSource, "gender");
radioButton2.DataBindings.Add("Checked", bindingSource, "gender");
during selection of radio button, i want to show data in grid based on selection??? any suggestions.
}
|
|
|
|
|
Are you binding city or gender? 
Apurva Kaushal
|
|
|
|
|
sorry, its gender. please ignore that syntex error
|
|
|
|
|
Oh ok.
Are you getting any error in this?
One more thing, the last parameter for the databindings is the navigation path (in dataset) i.e TableName.ColumnName. Is it the same in your case?
Apurva Kaushal
|
|
|
|
|
My web application displays perfectly fine in IE but in firefox it's completely messed up. How can I make it display the same in firefox??
|
|
|
|
|
By fixing it. FF and IE render the same HTML differently so you need to work out alternative ways to do the things you're doing in IE ( probably non standard ) and that are being rendered differently ( but probably correctly ) in FF
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
It is also worth noting that for the next IE release (IE8) Microsoft have worked some way further towards becoming much more standards compliant, which Firefox is already. So time spent fixing your site for Firefox will not be wasted 
If you are using Stylesheets, take a look at this site, it gives examples on how to load seperate stylesheets according to the browser the user is accessing the site with:
http://www.mimoymima.com/resources/071115_stylesheets.php
Regards
Paul
|
|
|
|
|
Start by checking that the html that your app is rendering is valid. This is easy to do with Firefox if you download the HTML Validator plugin.
http://users.skynet.be/mgueury/mozilla/[^]
Words fade as the meanings change, but somehow, it don't bother me.
|
|
|
|
|
well, the problem is that the project is huge and I can't go through everyline of code to fix it in firefox. so I was wondering if there's anything in asp.net that can render html in firefox exactly like IE.
Maybe something in the web.config file or anything??
|
|
|
|
|
You shouldn't have to alter your code throught out the whole project, just the stylesheet.....presuming stylesheets are used and that the styling mark-up is not done in-line?
As was suggested in the previous post you can use the HTML validators available as a plugin in Firefox or take a look at http://validator.w3.org/
This will at least pint you to markup that does not comply to the W3C standards. Unfortunately it will be a painful and time consuming process.....all because Microsoft couldn't be bothered to adhere to standards when developing their browser, however they are making marked improvements in IE8.
Regards
Paul
|
|
|
|
|
I'm afraid there is no quick fix like that.
I know its too late for you at this stage of the project, but in future I would advise using Firefox as your default browser when developing, and then fixing css for the bugs in various versions of IE.
Words fade as the meanings change, but somehow, it don't bother me.
|
|
|
|
|
Nada Adel wrote: I was wondering if there's anything in asp.net that can render html in firefox exactly like IE.
No, there is no such thing.
The page looks like it does in Firefox because the html code is wrong. It's Firefox that is rendering the page according to the standard, and Internet Explorer that renders it incorrecty. It only looks like you expect it in IE because the code uses the errors in IE to make the page look like it does. There is no way to make any other browser (Firefox, Opera, Netscape, Safari, Chrome et.c...) render the page incorrectly the same way as IE does.
This is a common problem for people who only test pages in IE during development.
The solution is to make the page work in Firefox first, then it will most likely also work without any problem in all other browsers except IE. After that you fix any problems that IE may have with it.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi,
On my form , i have a iframe. In Iframe I open a external webpage which gets the posted data using
request.form(..)
SO now my requirement is to post my form and in iframe i should be able to get the form data using request.form.
Thing is I can not change the request method in my external webpage.
But so far I have not able to do that. In my Iframe webpage I always get request.servervaraibles("request_method") as GET , not POST
my form is
some hidden controls
where CrmMap is iframe id and action is the page to be opened in iframe.
What am I doing wrong here?
regards
Vijay
|
|
|
|
|
Dear Friend,
my code : objDTItemMasterColl = ((DTItemMasterColl)(Session[Resources.ItemMaster.SessionName]));
where objDTItemMasterColl is the datatable collection object
It is giving the error cannot convert system.string object to objDTItemMasterColl ...
Awaiting for ur reply.
Regards,
Santi
|
|
|
|
|
Sasmi_Office wrote: objDTItemMasterColl = ((DTItemMasterColl)(Session[Resources.ItemMaster.SessionName]));
How did you insert data in session object ?
|
|
|
|
|
Sasmi_Office wrote: It is giving the error cannot convert system.string object to objDTItemMasterColl
I'm sure it is actually saying: Cannot convert type 'System.String' to 'DTItemMasterColl'
You have a string, a string cannot be cast to DTItemMasterColl. Either you have stored the wrong thing in the session, or what is in the session isn't what you thought it was.
|
|
|
|
|
I'd like to add a backgorund image to a table on my web page, but the size is not fixed since it sometimes contains more or less data.
Any ideas how to display this background image?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
