I'm trying to read a CSV file into a DataTable using OleDbConnection and OleDbDataAdapter. It works loading the DataTable, but only does 255 columns. The file has 362 columns.
Code is as follows -
[Code]....
I have a schema.ini too -
[Code]....
I'm able to upload and read any excel file to my server prior 2007, when I try an 07 Excel file, i'm getting the following error message:
'microsoft.ace.oledb.12.0' provider is not registered on the local machine'
do I need anything specail on the web server to allow for Excel 07 files? I'm running IIS6 and a Win 2003 server
iam Working on Asp.net Web apliation using c#.net, in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 Repliesiam Working on Asp.net Web apliation using c#.net. in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 Repliesi've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
I work on C# .My input file look likes :
d00 d04 WinMain
d00 d04 lpCmdLine: '/UNREGSERVER'
d00 d04 Run
d00 d04
lpCmdLine: '/UNREGSERVER'
d00 d04 nCmdShow: 10
d00 d04 leaving WinMain
[code]....
If i use the multi delimited than error shows.How to use the multi delimited.If i run the code to to load the text file given in above show the bellow error
Input array is longer than the number of columns in this table.
i have used a repeater in my website, and linked it to acccess data source, and thats the good bit...
i now have 26 items displalying on 1 page...
i was wondering if i could have help on how to limit the number of products displaying on my page.
my code:
[Code]....
is there is any methos so that only the some data rows displayed in detaisview.and rest of the data row item will appear by clicking more button or link.
View 1 RepliesI'm creating a login page. I want to limit the number of login attempts, say not more than 5, in case of wrong.I want to do it without using the asp:loghin controls and the membership.How can restrict it??
View 3 RepliesI have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 RepliesIs there any limit on number of classes that a namespace can have in .net ? Further what is the recommended number of classes that there should be in a namespace?
View 7 RepliesHow to limit the number of emails to send per tick cycle of the timer in ASP.NET Windows application?
View 2 RepliesAny limit to the number of nodes you can have in a treeview, I have been having some problems getting it to display with the panel I made. I have actually decided not to use the treeview, in fact may drop this part of the app altogether, but just wondering for future reference. I know if certain browsers have a limit for the the url, but can not seem to find anything, if there is anything, on a node limit. I am using asp.net 3.5 with VB and my browser is IE8, well the only one I tested on.
View 5 RepliesI'm sure it was discussed hundred of times, but maybe this time will elucidate some new points )
The question is: do I need to limit number of selected rows in data source for GridView?
When I use paging in GridView does limiting selected rows make GridView work faster?
Now I use ObjectDataSource with Linq in functions.
[Code]....
Does this make sense or I can just use LinqDataSource without thinking of selected rows?
On my products page I have a small thumbnail and a description that is pulled from the database, since there is space restraints, how do I allow a max amount of characters, and if the description is longer append ... to the end? I'm using a data repeater and data binding for the content inside it.
View 2 RepliesI have notice that the UpdatePanel post every field included on the form on every trigger.
But in most of my cases I use 2-3 UpdatePanels at the same page, and each one is independent.
When I click for update the one panel, then my page receive all the input data of the page (ok this is logical) but I won to read only this UpdatePanels data and act according, and not the other panels data.
So I see that a lot of traffic is happened this way.
So is there a way to say to one UpdatePanel - send only my input data, and not everything found on the page. ?
According below article i set limit characters for textbox [URL] ....
Now I want do it for CkEditor i wrote these code
<CKEditor:CKEditorControl ID="CKEditorControl1" runat="server"></CKEditor:CKEditorControl>
<asp:RegularExpressionValidator Display = "Dynamic" ControlToValidate = "CKEditorControl1" ID="RegularExpressionValidator3" ValidationExpression = "^[sS]{0,600}$" runat="server" ErrorMessage="please enter Maximum 600 Characters." CssClass="valid1"></asp:RegularExpressionValidator>
but it didn't work...
I have a dropdown list. This is a bound to a column in Table which has around 200 entires.Now when a user clicks on the drop down list I want him to see not more than 10 rows. The rest he should navigate by using scroll bars.
View 5 RepliesI have a html.dropdownlist on my webpage as follows: <%=Html.DropDownList("MyDropDown", Model.Data, new { @class = "dropdown"})%> I am populating the dropdown with ~80 items. The issue is that when I click the dropdown the list of items is rendered from the top of the screen to the bottom of the screen. How can I set up the dropdownlist so that it only displays a maximum of 20 items when the dropdown menu is clicked (i.e. user needs to scroll down to see items 21 - 80)?
I was anticipating (!) that there would be a html.dropdownlist property to control the number of displayed items that would allow something like the following e.g.: <% =Html.DropDownList("MyDropDown", Model.Data, new { @class = "dropdown", rows ="20"}) %> From research I have been doing on the msdn website it appears that there is no such property and that each browser has its own rules of how many items are displayed in a dropdownlist (?).
I have a report, which has two sections namely Labour and Spares.In labour section no of records per page must be limited to 5 records and the Spares section have to limit to 10 records per page.If either Labour or Parts exceed the max limit the records must be shown in the next page. Limiting one section by using formulas can be done easily ...but it is very difficult control two sections simultaneously.
View 4 RepliesI am trying to find a solution to control the number of logins on asp.net application. I need to install the application in the client server, and set the number of licences. e.g. only 10 users are allowed to access the app.
Every time someone tries to login I need to check how many user are logged in, compare with the total allowed then authorize that user to proceed.
I tried with Certificate, but I couldn't see where to match the number of logged in users with the max number of allowed user.
Also I would like to use the IP address as identifier, then if I open 3 browser windows, it count only one user logged.
Basically this web application will be sold by licences. We need to control the logins per computer, and not per user, and block logins if the limit of logins are reached.
I have text box in my page that users can enter Characters...
I want if user inter more than 100 Characters it show error that they can't enter more than 100 Characters...
I have 65 columns in the grid, if the columns are reduced to 20 then the speed when accessing from client is more or less similar to that accessing from web browser. Does it mean that all this performance issue is due to the data only ???
View 1 RepliesI am in process of developing a registration website for a convention for work. When people register they can choose an activity to do on the convention, however some activites have a maxmium number of people. In my activity table in the database i have the following fields;
RecordID, Name, Limit, Booked, Status
So the record ID is automatic, the name is the name of the activity, limit is the maximum number that activity can hold (20), booked will have the value of the number registered for the activity and status is either open or closed. If closed the activity does not show up for the people to register.
I am not sure how to have an UPDATE query running when the person registers it UPDATES the activity database with the value in BOOKED + 1 and once BOOKED EQUALS LIMIT the status changes to Closed.
any one know why are the following two give me different result? they should both give me no results as the value I give is not available. however, number 1 give me many results, and number 2 works as expected. I'd like the number 1 working as the same as number 2.
1. DECLARE
@SearchMCat nvarchar,
@SearchTitle nvarchar,
@SearchDesc nvarchar
SET @SearchMCat = 'fjiewo;jafoia'
SET @SearchTitle = 'fryere'
SET @SearchDesc = 'fdsfdsafae33'
SELECT ArticleCategory.CategoryDisplayName, Article.AudioPlaybackTargetTabID, Article.VideoPlaybackTargetTabID, Article.StartTime, Article.DateAdded, Article.Body, Article.Synopsis, Article.Title, Article.ArticleHasAudio, Article.ArticleHasVideo, Article.createdBy,
Article.RatingTotal, Article.RatingCount, Article.ArticleID, ArticleCategory.CategoryName
FROM ArticleCategory RIGHT OUTER JOIN Article ON ArticleCategory.ArticleCategoryID = Article.MasterCategory
WHERE (ArticleCategory.CategoryName LIKE '%' + @SearchMCat + '%') or (Article.Title LIKE '%' + @SearchTitle + '%') or (Article.Body LIKE '%' + @SearchDesc + '%')
2.
SELECT ArticleCategory.CategoryDisplayName, Article.AudioPlaybackTargetTabID, Article.VideoPlaybackTargetTabID, Article.StartTime, Article.DateAdded, Article.Body, Article.Synopsis, Article.Title, Article.ArticleHasAudio, Article.ArticleHasVideo, Article.createdBy, Article.RatingTotal, Article.RatingCount, Article.ArticleID, ArticleCategory.CategoryName
FROM ArticleCategory RIGHT OUTER JOIN Article ON ArticleCategory.ArticleCategoryID = Article.MasterCategory
WHERE (ArticleCategory.CategoryName LIKE '%' + 'fdsafdsafdsa' + '%') or (Article.Title LIKE '%' + 'fffaery' + '%') or (Article.Body LIKE '%' + 'fdas3r43ffdsa' + '%')