I ve a contacts database... i need to find duplicate entries in it.. i have to pick one record and then take for example "Company Name" and then search all the other records matching same Company Name .. i ve to show all the duplicates and then have to merge them...
i m unable to show sets of duplicates ...plz tell me how to manipulate rows using dataset or datareader?
I like asp:FormView because it gives me a flexibility to display a single record with an image, link and Paging on the bottom. And its very easy to databind to sql db table. But my question: is there any way to make FormView to change RECORDS automatically lets say every 5 sec. - Slideshow style?
View 6 RepliesI have an xml file with this structure:
[Code]....
I need to make a dataset and put into a grid or repeater with the records that have <show>1</show>. Can anyone point me in the right direction?
I have a data grid in which I have to display around 12,000 records. Even if I do paging it is difficult to display all the records. Is there any other control or something else so that I can display all these records. Even if I make these as alphabetical also, some times I have to load 1000 records in a page which is difficult.
View 2 RepliesI am working on a site in which as user logs in (first database request) the stored procedure varify password and user id and then returns user record that I put in session to use next.
After this I do a second db request. it returns addresses of user which I put in cache.
I can get both sets of data (user record and his address from 2nd table) in one database requests.
I have set up an SQL 2005 DB with a TimeDate column. I put a date in (UK - dd/mm/yyyy) and to shows "18/04/2010 00:00:00" Fine not a problem here. When I come to format the Data in my gridView it sets the Month to "00" all the time!
[Code]....
I have a form where the user enters their first name, last name, email address etc.. and then they also have the ability to enter 'cottages' that they are interested in viewing (ie. The cottage name, cottage address). The user then needs to be able to 'save' this somewhere and enter another cottage into the same form.
Finally the user will submit the form, and all the user details, and cottage details will be emailed to admin.
I am working on a large project where I have to present efficient way for a user to enter data into a form.
Three of the fields of that form require a value from a subset of a common data source (SQL Table). I used JQuery and JQuery UI to build an autocomplete, which posts to a generic HttpHandler.
Internally the handler uses Linq-to-sql to grab the data required from that specific table. The table has about 10 different columns, and the linq expression uses the SqlMethods.Like() to match the single search term on each of those 10 fields.
The problem is that that table contains some 20K rows. The autocomplete works flawlessly, accept the sheer volume of data introduces deleays, in the vicinity of 6 seconds or so (when debugging on my local machine) before it shows up.
The JqueryUI autocomplete has 0 delay, queries on the 3 key, and the result of the post is made in a Facebook style multi-row selectable options. (I almost had to rewrite the autocomplete plugin...).
So the problem is data vs. speed. Any thoughts on how to speed this up? The only two thoughts I had were to cache the data (How/Where?); or use straight up sql data reader for data access?
Imagine you have this HTML layout:
<div id="msg"></div><br />
<div id="submitButton">
<input type="submit" value="OK" style="width:50px" onclick="$('div.subtleMsg').hide(); return false;" />
</div>
I know how to manipulate the contents of <div id="msg"> any way I wish but I'm wondering if it's possible, IN THE SAME LINE OF JQUERY CODE, to also manipulate <div id="submitButton">.
Everything has to be combined into one long jQuery string because I'm passing it from the server-side code as a script.
I have a table that contains a date column along with others. I need to extract two sets of data from this table for two different time periods. Call them Current and Previous, so that I can compare them line for line. There are exactly the same number of days in both time periods.
The problem is that I need to return the data like this:
CurrentDate, Count(CurrentItems), Sum(Amt), Count(PreviousItems), Sum(PrevAmt)
JOIN puts the data into the result vertically, so that doesn't work. So far, I have not found a method that will arrange the data correctly.
Say I need to populate 4 or 5 dropdowns w/ items from a database. Each drop down will have < 15 items in it. These items almost never change.
Now I could query the DB each time the page is accessed or I could grab the values from a custom class that would check to see if they already exist in ASP.Net's cache and only if they don't query the DB to update the cache.
It's trivial for me to write but I'm unsure if the performace would be better or not. I think it would be (although not likely anything huge).
I am trying to design a website in asp.net (just learning) and am having trouble positioning div's on the .aspx page.
I normally design in dreamweaver where you can move the div around freely and it sets the x and y coordinates for you but I am having trouble positioning an image.
Do you have to type the x and y coordinates in yourself in the code behind or in the css or is there an easier way where you can freely move the image around and it sets the coordinates.
I'm working with a third party product and my boss wants to be able to link directly to a specific screen in this product from our company intranet. When I drilled all of the way down to the screen in this product, I see that it is an ASP.Net application and the particular screen is reached via a link that triggers a javascript function. I can see the anchor tags for this link and a link to a different screen and I can see the javascript function. Both screens as well as the initial screen are all part of the same content form. It is pretty clear that this screen is modified based on which link is clicked but it isn't using query string values so it must be using button click events to modify what shows on the screen. My question is; with what I can see of the 2 links and the javascript function, is there a way to send a postback with that specific click event from a different site to that specific ASP.Net form so it would pull up the correct screen? Here are the javascript function and anchor tags:
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
<a id="ctl00_popular1_pnlLeftPopular_dlsPopular_ctl00_lnkActivity" href="javascript:__doPostBack('ctl00$popular1$pnlLeftPopular$dlsPopular$ctl00$lnkActivity','')">IT Request for Change (RFC)</a>
<a id="ctl00_popular1_pnlLeftPopular_dlsPopular_ctl01_lnkActivity" href="javascript:__doPostBack('ctl00$popular1$pnlLeftPopular$dlsPopular$ctl01$lnkActivity','')">VOSA</a>
I have a C# website developed with Visual Studio 2008 with a SQL backend. I have a top Navigation menu that has seven different tabs. I have a specific right bar content for each of the seven tabs. The content for the right bar is stored in a sql database and will be accessed using data sets. I believe that I have two ways to display the information with the data set...
1. User control - Create a User Control for each data set and then drop that on to the respective pages.
2. Master Pages - Create a Master Page for each of my seven sections, adding the data set to the respective Master Page.
Is there a preffered approach to achieve my goal? I am thinking Master Pages would be the most efficient but not certain. Is there another method I should consider?
I have webform with 4 textboxes in a panel and next to that panel a panel with an accordion with 4 panes in it.
Without a refresh on every click, I would like to set the index of the accordion on the click in a textbox.
so if the user puts the cursor in the first textbox, the first pane is expanded, if he clicks in the 2nd, the second pane is expanded, etc..
I tried it with:
txtRequestorName.Attributes.Add("onclick",
"javascript:$find('InfoRequestorAccordion').set_selectedindex(1); ")
but that is not working. Is there another way or is it just not possible?
rg,
Eric
On an ASP.NET page, I am using the same form for login and registration. There are two login fields and seven registration fields. Something like this:
txtUsername | txtPassword
txtNewUsername | txtNewPassword | txtNewPasswordRepeat | txtFirstName | txtLastName | txtPhone | txtEmail
btnSubmit
In each case, all the fields are compulsory (ie username and password are compulsory for logging in, and the other seven fields are compulsory for a new registration). There is a single submit button. This layout of the form is imposed by the client and is not open to modification.Now, my question is, how to validate the form? Initially, I cooked up a customized server-side validation system, but the client insists on using the standard asp.net validation controls (including the custom validator if necessary).
To validate the form, first I have to determine if the client is doing login or validation, and only then can I decide whether to validate one set of fields or another. So the first operation is to see if the user has filled in username or newUsername and use that to determine whether a login or a new registration is taking place. Since there is a single submit button, I cannot use validation groups to distinguish between the two sets of controls.
I thought about using a custom validator for the whole thing, but it is connected to a single control, so that does not solve the problem. I also thought about creating a new validation control, but again the problem is the same - any class inheriting from WebControls.BaseValidator is connected to a single form control.
Just after some advice I have a stored procedure that returns several tables. I then need to loop through the tables and create dynamic gridviews using the data. At the moment this stored proc is called using
[Code]....
I have used an xsd file to populate everthing else, but due to this returning multiple tables i wasn't sure how this works should it just be in its own xsd? as all the oather i just get a datatable where as with this i need a dataset... how this makes sense...
The website I am working on has a section where users can search for content they have digitally subscribed to. way to cross-check both data sets, the first being content that matches the search criteria, the second being the content the user has subscribed to. What's making this is a mess is how the data is structured. Here is an example...
We store all of our content in a "Content" table in our database. A piece of content, a "journal", for example, and all of its child records (volumes, issues, and articles) are all stored as records in the "Content" table, each with a ParentId of its corresponding parent record. So, A journal can have n volumes. Each volume can have n issues. Each issue can have n articles. A user can have a subscription to any of these, which would implicitly give them access to all child records. For example, if a user was subscribed to a journal, they would have access to all of its volumes, issues, and articles. If the user was subscribed to an issue, they would have access to all of its articles, but not the parent volume or journal.
Some users own over 30,000 records, and we have over 100,000 content records in the database. The Content table has relationships with several other tables that are used for the search. This leaves me with an expensive query to find what the user has access to, and another expensive query to search through all of the records to find search criteria matches. Some of our searches take 20-30 seconds and I would like to speed it up to a max of 5sec per search.
I tried running a query to get the ContentIds of everything the user owned when they first visited the search page, and then caching it to eliminate further database hits, but when I passed the list of ints into the query via a linq .Contains statement, I hit the SQL parameter limit of 2100, since apparently .Contains() splits them all out.
I have a following scenario - A use selects criterias from a webform (C#) - a result is then returned from the sql. Say, to start, there are 2000 data returned from the sql and are stored in a dataset.
Now, the user wants to choose a number of drops (up to 6) - with the number of drops selected, they can enter their own quantity in each box. So, they can divide the 2000 records into 6 different drops. With each drop, there is campaigncode created based on the mail date and the job number they provide.
So, now i have the 2000 records in a dataset. What i want to do is loop through the gridview where the user fill out the quantity depending on the number of drops (for ex: if they say 3 drops, then there will be 3 rows in gridview with 3 quantity box to fill).
In the loop, I am getting the quantity, dropdate and the job number. The Campaigncode is created as well. Then, i am looping through the datarow in the dataset; updating the Campaign Code column with the CampaignCode for the number of records thats set in a loop. It works but the Campaign Code is not populated for the next set of records.
Here is the code:
[Code]....
I think its this line right here thats causing the problem. But i don't know how to tweak this so as to accomplish what i want to do.
if (Convert.IsDBNull(DSAEFile.Tables[0].Rows[i]["Campaign Code"]))
I had requirement that i need to display four charts in one report. The data for the report is given through stored procedure. In this stored procedure each chart have its own result set. ie., the Stored Procedure is returning four result sets.
View 2 RepliesMy development groups uses shelf sets for doing code reviews. When a shelf set has a new-to-source-control file, I need to view it. I had configured Notepad as my viewer application for several file suffixes but now I would like to change that to another application. Problem is that I cannot find anywhere how to change that association--it is *not* the Windows-wide app/file-type asociation kept in the Windows registry.
how to reset the default application assignments used in shelf set reviews?
I have a datalist and now i want to give custome paging to that datalist using multiple active result set. I mean i want to show paging as
first,previous,1 2 3. . . next, last.In this I want to get only 3 pages at a time. and once i got the page, I want to put it in caching and again if user click on that page number then i dont want to get the data from cache instead of hitting the database
I'm seeking an algorithm to split a list of items of varying sizes into "N" number of similarly-sized groups.
Specifically, I'm working on an ASP.NET site in C# where I have a (database-retrieved) list of strings. The strings are of varying lengths. I have a set of columns which need to display the strings. I need an algorithm that will find the most balanced sets (item order is irrelevant) to allow the final columns to be as balanced as possible.
Abstracted Example:
Creating 3 columns.
Items to distribute:
- Item A - height 5
- Item B - height 3
- Item C - height 7
- Item D - height 2
- Item E - height 3
Desired output:
Column 1: Item A, Item D
Column 2: Item C
Column 3: Item B, Item E
I'm fairly new to MVC and admittedly don't fully understand how data is passed between Views and Controllers. That said, here is my issue.
I am working with C#. I have a page which has a list of items. Each item has a radio button set of three associated with it and there are 15 of these sets on the page. Thus I have radio1, radio2....radio15, etc. Each of these has value 0, 1, or 2 upon submit. I can't seem to understand how to get the information out of these radio button sets from the controller without passing 15 different variables to the post method in the controller which is associated with the view; ie passing Int32 radio1, Int32
radio2,.., Int32 radio15, etc.
I tried using ViewData["radio"+i] in a loop to access the value of each radio button set, but this, apparently can only be used to pass data to the View from the Controller and not the other way around.
I am using a sql stored procedure which returns multiple result sets. By default Sql Datasource is binding the first result set to gridview. I want the second result set to be binded. I browsed all the properties in Sql datasource but could not find one to set this.
View 4 Replies