I am using following code to serialize class object into dataset. Storing the dataset schema in a viewstate, when I try to read the schema from viewstate getting following error.System.Xml.XmlException: There are multiple root elements. Line 20, position 2.Please let me know how to resolve this error.
CustForm cList = new CustForm();
cList.CustID = 10;
cList.CustName = "Testing";
[code]...
I have a gridview with delete buttons for each record (I've used AccessDataSource). I have loaded the data in and have many duplicate records.
I just want to use the delete button delete each duplicate record while remains many duplicate records. For example:
I used the following query to load in duplicate records:
SELECT * FROM TableA WHERE ([ControlA] IN (SELECT [ControlA] FROM TableA GROUP BY [ControlA] HAVING (COUNT [ControlA]) > 1)))
ID ControlA PIN# FaceValue Date
delete 76637 128232 1234 5 6/4/2006
delete 72722 128232 1234 5 6/4/2006
delete 76638 234567 2345 10 7/3/2006
delete 72723 234567 2345 10 7/3/2006
What is the query to delete single duplicate record instead of deleting all duplicate records?
I've got an odd problem and can't figure out what's causing it. We've got 2 different DataSets in the same project and I'm seeing different generated code from the MSDataSetGenerator. Both projects are .NET Framework 4.
In one DataSet, I can open the .Designer.cs file and there's a line like:
[Code]....
This essentially exposes a Transaction property to any partial class I create so I can do with it what I want (by setting it to something).
In the other DataSet no matter what I try to do, this Transaction property never gets generated. I've right-clicked on both DataSets and chose "Run Custom Tool" to get them to regenerate (I've even tried deleting the .Designer.cs file before doing this) and they both get generated the same.
I tried to make sure all the properties of the DataSets were the same. Both are using .NET Framework 4.0 and VS2010.
The file that does not generate the Transaction was from a .NET 1.0 asp.net web site that has continually been upgraded through different .NET versions. Right now it's at 4.0 but I don't know if that would have anything to do with it.
I have a detailsview, template as follows:
[Code]....
Codebehind: creating dataset, getting data from sql with adaptor and filling into dataset object, then setting detailsview's datasource.
I add 2 button to above template to able to edit data at asp page, and added event handlers:buttons:
[Code]....
My question is, what to do inside the detailsview update event function to able to edit and update data. My method can be wrong too.
I ran into the following issue when trying to run a test website on IIS 7.5 (Windows Server 2008 R2 DatacenterEdition). The web-app is configured to run with framework version 3.5 in a .Net 2.0 app pool. Also the framework 4.0 beta 2 is installed on the server. The application named 'TestPfade' is located under the website's root named 'Default'. It is not only a virtual directory but defined as an application. The folder structure looks like this: The markup of the sole document reads as follows:
[Code]....
When viewed in a browser the image gets shown because the given relative path is correctly resolved to 'images/Lighthouse.jpg' but the paths to the ajax-framework resources also include the application's root folder and therefor aren't found: 'src="/TestPfade/WebResource.axd?d=1bX...' Here is the complete html-source generated:
[Code]....
I want to create a trafic controlling system and show data in a tabular format. as follows
----------------------------------------------------------------------------------------------------------------------
August
1 2
3 4
5 6
7 8
9 10 .......31
How to achive this using any of the data control gridview, datalist or repeater control ?the numbers 1,2,3....31 are the days in a month while "HomePage", "Maps" etc are the name of the pages and the entry below each date will show no of users visited the page. I want to show the same for every month
i have fetched required data and the output is as follows .
PageId VisitedDate VisitCounts PageName
I have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....
I have a grid control that is dynamically generated according to supplier. If I have 2 suppliers I have 2 grid controls.
I need to send email to client the product information along with how much grid is generated.
Th email body is hardcoded along with required parameters. Something like,
"<table style='border:1px #6C9EE1 solid;' width='100%' border='0' cellspacing='0' cellpadding='5'>"
+"<tr><td bgcolor='#6C9EE1'>" +"<span style='font-size: 14px; color: #FFFFFF;
font-family: verdana, arial, sans-serif; font-weight:bold;'>For your attention...</span>" +"</td></tr>" +"<tr><td>"
+"<span style= 'font-size: 11px; color: #666666; line-height: 15px; font-family: verdana, arial, sans-serif;'>Subject: </span> " +"<span
style='font-size: 11px; color: #2266AB; line-height: 15px; font-family: verdana, arial, sans-serif;'>" + Subject +
"</span><br/>" +"<span style= 'font-size: 11px; color: #666666; line-height: 15px; font-family:
verdana, arial, sans-serif;'>Date: </span> " +"<span style='font-size: 11px; color: #2266AB; line-height: 15px; font-family: verdana, arial, sans-serif;'>"
+ string.Format("{0:dd MMM yyyy}",
DateTime.Now) +
"</span><br/>" + and so on
How do I add dynamic controls to such code? Also I need to change mail body as per certain conditions.
I am displaying the output of a LINQ query in a Detailsview control. I have a Detailsview called DetailsCaAb and a DropDownList called DropDownList2, when the use makes a selection from DropDownList2 the Linq query fetches the data CatAbstract from the table CatagoryTables. e.g.
[code]....
Unfortunately I cannot seem to control what is displayed by the DetailsView, I only want to display CatAbstract, but the details view generates another column called Items. How do I ensure only the data I want is displayed? I need a way of controlling the columns generated programmatically.
I want to generate serial number in gridview but the serial number should be equal to the count of records for a particular column(in my case No. of Villages).
I know how to generate serial number but i am unable to generate number of rows equal to the number of records of my datatable column(Village_Name---say for example 45 rows--- any no. of rows)
I am writing a web form in C# using VS 2008. My form accesses an Access database that has a list of Cusomers. Each customer has a customerID. My goal is to allow the form to automatically generate a new customerID each time a user clicks on INSERT. I need it to take the highest customerID from the DetailsViewand add 1 to it in order for the customer ID's to be sequential. I am assuming I need a loop for this or maybe an Arraylist?
View 2 Replies'm getting duplicate client IDs in my gridview for some reason. ASP isn't putting a unique ID on them.My gridview is this:
[Code]....
When I view Source on the page, each imagebutton has a name of "lnkPDF". I would expect ctl100_lnkPDF, ctl101_lnkPDF, etc.
sample SQL data:
table1:
eid ename
1 vijay
2 shankar
table 2:
id eid sal
1 1 4000
2 1 3000
3 2 2000
i want to bind the below data format in repeater.
vijay
4000
3000
shankar
2000
Duplicate Data in Gridview and Updating textbox in DetailsView
View 2 RepliesI am trying to simulate the file system like explorer using a treeview. I would like to have the application in the server but is the starting root limited to where the application is? Is it possible to have a certain directory in the server to be the starting node? I would like to be able to set a starting node in the config.
View 4 RepliesI'm getting duplicated rows of data showing up in my GridViews. I have two GridViews, each showing different data. I'm using SQL queries to retrieve the data from 2 database tables (1 query pulls from one table and the other query pulls from a second table, but references the first table in the WHERE clause). The GridViews were not duplicating data until after I added the Data Binding code to each GridView event handler and the button click event handler (outside of the GridView). I double checked my SQL queries by running them in TOAD and did not get any duplicated rows. So the issue is not with the SQL queries. It appears to be the GridViews causing it, or the Data Binding, or combination of those two, but I'm not sure what it is.Has anyone heard of or seen this? If needed, I can post my VB code and GridView code.
View 7 RepliesMy page has Grid View & ObjectDataSource to bind data. In page preRender event and not post back I updating the Panel to display data. Suprisingly, it displays duplicate data. I check my stored procedure and it returns Rows correctly.
[Code]....
I have a Gridview that I am using in a User Control. The grid loads great and my paging buttons that exist outside of the grid itself work properly. When I click my delete button inside the grid, I am getting an invalid postback message. How should I handle this? My control raises one event by the way.
View 22 RepliesThe user will enter values in the textbox of the gridview in item template. A button outside the grid, when it is pressed we have to highlight the duplicate values.
Is there is any way to use validation control.
I have a database table that stores a list of friends. The table can store many friends and there can be duplicates, for example - John is James' and davids' friend. John will be in the table twice but will be linked to the others via another data-member. What i dont want is james to be down as johns friend twice in the table. I'm doing a small social network and this is possible by james accepting john as his friend twice. Is there anything to check if there are 2 columns identical?
View 3 RepliesI Have one gridview which i show in admin panel and need to allow edit and delete the row.now my problem is when click on edit i need to check that duplicate record not allow to enter and my password is in encrypted formate and i need to show decrypted form in gridview so if admin want to edit password then he can edit it
And at a time of edit gridview can i give option of dropdow to selection instead of text box?
In my Admin page, I have a drop down list containing all current user tables in the database. The user chooses one.
My DetailsView below uses that parameter to populate itself with data from that table. The stored procedure used to select the data passes a string to sp_executesql. The string is concatenated from a select statement and the tablename parameter. Can I do something similar for Update/Delete statements? I'm not sure of the best approach, given that I won't know which/how many fields will be in the DetailsView at runtime, and which of these are keys - the choice of table depends on the user. I think Insert will be straightforward - am I right? I would like to streamline things as far as possible. Is it possible to dynamically pass in the values in, say, a string, and get my stored procedure to understand them? And what's the best method of grabbing the values from the DetailsView in this situation?
Using vb.net/asp.net 2005 and sql server mgmt studio 2005.
I am querying sql server db and returning unique records, no duplicates when I return the records in sql server mgmt studio.
However when I bind the dataTable that I return it is showing multiple duplicates, meaning I see each record appear 8 times in the gridview, has anyone seen this or know what I'm doing wrong?
My code below:
[Code]....
On inserting record, I want to check that for example if a user enters a telephone number for any record is already in the database then it should validate that the number already exists in table and you cannot enter a duplicate value.
Then if user will provide some other telephone number then he allows to insert record.
For insertion of record I used ObjectdataSource.
User will enter telephone number in a simple textbox.
I may want to inform that I am working in asp.net2.0 and also not allowed to use any third party control or ajaxtoolkit.
I am using iis 5.1 in which we have only only one default website, I have two projects v2 and v3 my website points to v2 projects and have some folders images, styles etc now i have a virtual directory under this website that is hosting project v3 and having the same folder hierarchy as v2 in the home page of the both projects i have img src="imagesedlogo.gif" alt="logo"/> but this shows the same image that is in the v2 directory, How can i show different images for both projects. using "" get the root of the web site but how can i get the root of virtual directory under that website
View 2 Replies