I've got a sql table, that just keeps getting more and more columns added. I optimize the db as much as possible, but am curious about how many fields a table can have, and if there is a way to check if I'm getting too much data per row?
View 2 RepliesI am trying to add row in DataTable CartDT using row[], which is a string array.
DataTable CartDT = new DataTable();
public void DataTableColumn()
{
CartDT.Columns.Add("Product_Name", typeof(string));
CartDT.Columns.Add("Product_ID", typeof(string));
CartDT.Columns.Add("ItemQTY", typeof(string));
CartDT.Columns.Add("Price", typeof(string));
CartDT.Columns.Add("TotalPrice", typeof(string));
[CODE]..
Now when I execute it, it gives the error that "Input array is longer than the number of columns in this table" The array row[] has exactly 5 elements in it & also DataTable CartDT has also 5 columns. Now i am not able to find exactly where i am wrong.
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've created a dropdownlist that pulls from a SQL table with 241 rows. For some reason, the list only shows 168 rows? What am I doing wrong?
View 4 Replieswhat is the maximum number of characters that can be put into textarea?
View 2 RepliesMy ASP.NET MVC 2.0 web application does not maintain any session state and My production machine has n (>1) core, .NET 4.0, IIS 7.5 Integrated mode.For increased performance, I am curious if I should increase the max concurrent threads in thread pool to 12*n or should I keep the max concurrent threads as 12 but assign n worker process (w3wp.exe) to my application pool. What are the pros and cons of one over another?
View 1 RepliesI have an ambitious requirement for an asp.net 2.0 web page that contains a table (gridview), and each row in the grid contains 6 select (dropdown) controls for data entry. The number of rows that will be displayed is dependent upon the user's search parameters, which are specified in another area of the page. Unfortunately, with the default (and even basic) search parameters specified, the grid could contain several hundred rows. I've noticed that the browser, in this case IE8, starts behaving rather erratically once I reach a large number of rows -- no documented evidence for the number of rows where this begins to be a problem. For example, trying to view the source of the page results in a message from IE stating that there was a problem with the page that forced the browser to reload it, and I never get the source. Obviously the page loads and renders rather slowly also.
I know that my solution is probably going to involve paging the gridview such that it only displays 20 or so rows per page, and I'll have to write code to handle the saving of changes in the dropdown values when the user changes pages. I can probably turn off viewstate on the gridview also. However, the question I really want to pose is this -- has anyone seen a documented rule indicating the maximum number of input controls that an HTML browser form is supposed to be able to contain? I could not find anything on the Internet after doing a search, and I suspect the answer may be whatever the browser can handle based on the machine configuration it is running on. Any rules of thumb you use?
one of our programmers is having an issue with a asp.net app. i had him rebuild and recompile the app to the network share on the staging server and received the same error. i even deleted the files in this folder
(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files). to make sure that the server was not the issue i installed it on another server and received the same error. i found a article on msdn that states that its a source code issue. Compiler Error Message: BC30041: Maximum number of errors has been exceeded. Source Error:
[Code]....
[No relevant source lines]
Source File: vbc : Line: 0
it's a multiline TextBox the MaxLength property does not work. At the moment I only see the option to use a CustomValidator with checking TextBox1.Text.Length on server side and perhaps in addition some Javascript client side validation.But isn't there a simpler way to do this, using the standard ASP.NET validators (RegularExpressionValidator, RangeValidator, CompareValidator, etc.)
View 1 RepliesI have a gridview, in which i placed checkbox as Itemtemplate. My need is to restrict the user from selecting more than 'N' number of selections.
Eg: Gridview contains 50 records, that means 50 check boxes.
Max permitted selections: 10.
After the 10th checkbox selection, user should be prompted that..
"No more selections.. blah blah... "
Should i go for looping through records.. or is there any better way..
I have a PDF document with a number of text fields, several of which have a maximum length - namely, a maximum number of allowable characters. Is there a way using iTextSharp to determine this setting? Here's the code I have so far:
Dim reader As New iTextSharp.text.pdf.PdfReader("Foobar.pdf")
Dim inputFields As IDictionary(Of String, iTextSharp.text.pdf.AcroFields.Item) = reader.AcroFields.Fields
For Each key As String In inputFields.Keys
Dim PDFFieldName As String = key
Dim MaxFieldLength As Integer = ???
...
Next
I need to set MaxFieldLength to the number of allowable characters for the current form field being iterated over.
Today my client asked to implement SMS Counter and restriction to 150 characters in SMSalert.aspx form,I have done only Validation Control. I am working with SMS for the first time.
View 1 Repliesi have a table & i have to find out second mamimum or third maximum.Which is the best approach to do this?
View 5 RepliesI want to create a page on which the website's sponsors are displayed. The information about the sponsors is coming from the database via an ObjectDataSource, and I'm retrieving an Image (company logo), the name of the company, and a url to the company's website. Each Image (logo) is of the same height, but of varying width. I want each Item to be formatted so that the Image is on top, and underneath is a centered hyperlink with the name of the company.
This all seems pretty straightforward ... now for my problem: I want to display as many of these on the page as possible. Essentially, start off horizontally and fit as many as possible on each row. A DataList or Repeater with RepeatDirection=Horizontal doesn't quite do what I want as I don't want to have a fixed number of columns.
Is there an easy way to achieve this, or do I have to manually add up the width of each item on an ItemDataBound event, and then somehow move to the next row when the maximum width is reached? In addition I have to deal with the fact that the width of my Item is the maximum of the Image width and the text underneath.
I get the following error from a 550 line sql statement with multiple temp tables:
"The maximum number of tables in a query (260) was exceeded."
Are there any tricks for getting rid of this error? The long query is required for this program. Will I need to build a new table before the query runs?
I developed a web site using Sybase PowerBuilder V12.0 Classic and the output is deployed and converted to ASP.Net (ASPX) web pages.The Database connection is configured and used properly as the data is displayed in the web application using DataWindow Objects and is a direct connection with sybase Database Server using Dsedit Tool and No ODBC is used.I edited The Sybase Databse configurations related to remote servers and connections to be more than the default value which was 25 although the real number of users will not exceed that in the same time.Recently I received an error message when some users connected to the web site and after making valid logins:-The Error Message is:-Maximum number of connections already opened ct_connect(): user api layer: external error: The maximum number of connections have already been opened.
I am confused about the causes of that error as I think I had made all configurations needed and I checked evey option and setting related to the Number of Connections in The Sybase Database server, The Application Deployment Settings in Sybase PowerBuilder V12.0 Classic, and The IIS Settings.I use Windows Server 2003 and the IIS version is 6.0 in the Web Server.
I'm creating a table in an asp.net code behind dynamically, and I want to have a footer row that only has 2 cells. The first should span all the columns in the table-1. Is there some way other then keeping track of the # of columns in the table manually for me to set the colspan to be # of all the columns in the table-1? Preferably a HTML or CSS solution?
View 2 RepliesI've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
Dim current as Double = 0
If Double.TryParse(xyz123.Tables(0).Rows(0)(x).ToString(), current) AndAlso current <> 0 Then
count += 1
totalNumber += current
End If
Next
Dim averageRating as Double = totalNumber / count
I have a gridview where I display (from left to right) plant id, product no and month/year and there after a column with qty for every day on the month.
The gridview is located inside a panel that has a horizontal scrollable property set that lets user scroll from left to the right. This works fine.
Now, they are asking if it is possible somehow to freeze plant id and product no? Currently when they scroll past day 10 then plant id and product no is not longer visible and making it hard to see what line you are on.
i have a table that has some columns and rows i want this table to have borders that are visible inside it i want every column an row to be closed in borders how can i do that?
View 1 RepliesI'm developing a CMS of sorts, and I want to give my users the possibility of customizing the display. More precisely, I want to give them the ability to choose to display or hide the left column, the right column and/or the top div. The middle column cannot be hidden since this is where the actual content will show, whereas the other columns are for navigation or side menus.
I've been looking for a way to make this as smart and flexible as possible. For now I'm using a MasterPage, but that seems to be too constraining. For instance, with MasterPage you need to add a ContentPlaceHolder control in every of your ASPX pages.
What are the best practices in this area? I guess a simpler way of saying this would be "I want to create a template system over which I have complete control".
What would you all suggest a database with less number of tables and more number of columns or more number of tables with less number of columns. I am developing a web application using Visual stuio 2005 and Sql Server 2005
View 2 RepliesI want to count the number of days from selected days.I am having 2 calendar control on the form.I am selecting a dates from each calendar and passing values to textbox1 and textbox2.Suppose i am selecting 13/01/2010 from calendar1 and 18/01/2010 from calendar2. I want to count the number of days and display as 6.
View 5 RepliesI have a page within our site that allows admin users the ability to upload configuration settings into the system instead of submitting 1 at a time.
While testing yesterday, i found that one of the upload pages allowed me to upload a excel file that had alot more columns than expected and when i checked the database, the first few columns that were expected took the values from the file, and everything else was ignored, but wanted to see if there is any way to check the number of columns in the file to make sure it matches the upload logic before accepting it.
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 Replies