I have a simple asp.net web forms page that does an insert to my sql server db. My server was running slow at the time and I pressed Insert button several times because I didn't think it took but it did all 3 times.So I have duplicates from that one interaction. How would I prevent this?
This is the exact same question as this unanswered one from May.
(edit) Note: this unanswered post exactly describes the behavior - extra scripts being added in the <head> by ScriptManager.RegisterClientScriptBlock in a usercontrol, in an UpdatePanel, is causing duplicates. C# .NET 4.0. The page is structured like this:
MasterPage Page UserControl1 (ascx) - loaded in code by Page UpdatePanel UserControl2 (ascx) - loaded in code by UserControl1
The first time the script is added as expected, in the body. The code, simply, in the UserControl2 OnInit:
I've also tried referencing "this" instead of page, which doesn't really make sense since I don't want the same script keys duplicated on the page if the usercontrol is loaded multiple times on a page, but it didn't work anyway.
After a partial postback, the script is added again - but curiously in the <head> of the page, not the body, and interestingly, lacking the normal //<![CDATA[...//]]> wrapper that asp.net usually adds.
Another script which is added by UserControl1 is duplicated exactly the same way after a partial postback.
I am importing images names from a file into a database by using the code below. When I import the image names, I aslo want to add a date of "June 12, 2009" in the DATE column. Finally, I do not want to import any duplicates. Is there something I can change in this code to make that happen?
declare @cmd varchar(1000) set @cmd = 'dir "D:imagesREVIVE" /b' if (object_id('ImageTable..tblimages') is not null) begin insert into tblimages (imgname) execute xp_cmdshell @cmd delete e from tblimages e where ISNULL(e.imgname, '') = '' select * from tblimages end else create table tblimages ([id] int identity(1,1), imgname varchar(1000)) insert into tblimages (imgname) execute xp_cmdshell @cmd delete e from tblimages e where ISNULL(e.imgname, '') = '' select * from tblimages
My SQL query joins on multiple tables, and because of this it is displaying multiple results. I know about SELECT DISTINCT, but one of the fields ('Account.Name') is occasionally different, so it treats this record as a new row. Here is my SQL:
I have a table named dups. There are 4 columns in the table.
id, name, path, hash
I want to return only the name, path, hash of each row where the hash field is the same. Example there are 100 rows but only two qualify the return would be.
file1 c: 10909 file4 d: 10909
For some reason this seems to be a more difficult task than I though it would be.
I've got a simple user control in my ASP.NET Webforms project which inherits from the LinkButton. It's got a property to change the size, which just adds some predefined CSS classes to the control.
Protected Overrides Sub CreateChildControls() Dim SizeClass As String = String.Empty If Size = SizeEnum.Large Then SizeClass = "large"
[Code]....
So when it renders the class property is something like class="button small".
When this control is placed inside an update panel along with some other things, when the update panel updates the class property for every one of these controls becomes class=" button small button small button small button small button small button small button small button small button small button small button small button small button small"
Most of the examples of removing duplicates I saw have a list of one item only but in my case I have 3 items per record and I need to loop through each record, find the duplicate years, remove them and then return the distinct list of years along with the other data.
I have several LINQ-auto-created data classes which are created using dragging and dropping database tables into the Visual Studio LINQ design pane. Also, in my project I have to manually create WCF data-contract classes. Each WCF contract class is for one LINQ-auto-created data classes; one to one. Is there some better way to reduce the efforts to this problem? e.g. inheritance or something else to create WCF datacontract class from existing LINQ-data class.
Using ASP.NET, I'm building an admin tool that requires a function to import a list of email addresses. Upon uploading the file, I want to check for existing records for any of the email addresses supplied. For non-existing email addresses, I would create them using my DAO.
Basically I want to:
Receive list of emails Retrieve data for existing emails Create data for new emails in db Return full data for all emails in list.
Since I want to know which of the emails exist up front, my first thought was to query the table for all records WHERE Email IN ('Email001FromFile', 'Email002FromFile', 'etc...') but the list could potentially contain thousands of email addresses, and I'm not certain supplying that many email addresses to the IN operator would be a good idea.
I also thought about looping through the list and checking for a record for each email, but that would potentially generate far too many queries.
My next thought was to generate a temp table to hold the list and modify the IN clause to use the temp table, rather than an explicit list of items, but that would require I execute SQL or a stored procedure directly, which I'm not inclined to do since I'm using NHibernate to access my DB.
i used the following technique to Select multiple items from DropDownList into TextBox with No duplicates, however i dont think it is the most proper way, any ideas. pressing again with same value selected choose another value from DDL and press button
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click If TextBox2.Text.Contains(DropDownList1.SelectedItem.Text) Then Dim m As New Label m.Text = "duplicate !" Me.form1.Controls.Add(m) Exit Sub End If If TextBox2.Text = "" Then TextBox2.Text = DropDownList1.SelectedItem.Text Else TextBox2.Text = TextBox2.Text + " , " + DropDownList1.SelectedItem.Text End If End Sub
I have location #s, date, time, the sales amount, and tax in a excel file. The system pulls sales numbers throughout the day from each store location and places the total sales and tax numbers along with the polling date into a file.
So the most current date/time has the most upto date sales numbers at the time for that location number, but it also lists the older entries so mgmt can see how sales went during the day, and this is where my issue is, I don't need to see the old numbers from this generated file (atleast at this part of the program).
What I would like to do is write a query that only selects the most recent sales numbers for each location. I will output this to a table in ASP.NET. The query I tried using the TOP 1 clause only gave me the very first row listed below.
I am fairly new to C# programming and I am stuck on my little ASP.NET project.
My website currently examines Twitter statuses for URLs and then adds those URLs to an array, all via a regular expression pattern matching procedure. Clearly more than one person will update a with a specific URL so I do not want to list duplicates, and I want to count the number of times a particular URL is mentioned in, say, 100 tweets.
Now I have a List<String> which I can sort so that all duplicate URLs are next to each other. I was under the impression that I could compare list[i] with list[i+1] and if they match, for a counter to be added to (count++), and if they don't match, then for the URL and the count value to be added to a new array, assuming that this is the end of the duplicates.
This would remove duplicates and give me a count of the number of occurrences for each URL. At the moment, what I have is not working, and I do not know why (like I say, I am not very experienced with it all).
With the code below, assume that a JSON feed has been searched for using a keyword into srchResponse.results. The results with URLs in them get added to sList, a string List type, which contains only the URLs, not the message as a whole.
I want to put one of each URL (no duplicates), a count integer (to string) for the number of occurrences of a URL, and the username, message, and user image URL all into my jagged array called 'urls[100][]'. I have made the array 100 rows long to make sure everything can fit but generally, this is too big. Each 'row' will have 5 elements in them.
The debugger gets stuck on the line: if (sList[i] == sList[i + 1]) which is the crux of my idea, so clearly the logic is not working.
Here is sample code:
var sList = new ArrayList(); string[][] urls = new string[100][]; int ctr = 0; int j = 1; foreach (Result res in srchResponse.results) { string content = res.text; string pattern = @"((https?|ftp|gopher|telnet|file|notes|ms-help):((//)|(\\))+[wd:#@%/;$()~_?+-=\.&]*)"; MatchCollection matches = Regex.Matches(content, pattern); foreach (Match match in matches) { GroupCollection groups = match.Groups; sList.Add(groups[0].Value.ToString()); } } sList.Sort(); foreach (Result res in srchResponse.results) { for (int i = 0; i < 100; i++) { if (sList[i] == sList[i + 1]) { j++; } else { urls[ctr][0] = sList[i].ToString(); urls[ctr][1] = j.ToString(); urls[ctr][2] = res.text; urls[ctr][3] = res.from_user; urls[ctr][4] = res.profile_image_url; ctr++; j = 1; } } }
The code then goes on to add each result into a StringBuilder method with the HTML.Is now edite