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.
I am developing web application using Csharp on Visual studio 2008.How can I avoid duplicates on a data grid? I am using one form with datagrid. When I run it while it is in one of the folders AB it is running without any problems and data grid is displaying correct records. However, when I get the same and put it on a different Folder AB1 on the same machine and web server (IIS) it is displaying duplicated records?
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 have a gridview that I loop through to get the x and y values of the chart control, and upon the first execution of this code, it looks great. But when the page posts back and it "refreshes" data, the original points on the chart control are still there, as well as the new values.
Is there any way to "delete" all data in the chart control to ensure this doesn't happen?
I have query that returns a line that looks like this belowA NEWYORK PROGRAM AA NEWYORK PROGRAM Bnow, the NEWYORK is inputted into a dropdownlist and the program A and program B is inputted into a dropdownlist as wellI am using utility.ControlTools.SetListControl for my dropdownlist. I would like a situation where my dropdownlist only contains one NEWYORK instead of two and my dropdownlist for programs to contain Program A and program B. Can this be done.
Using SQL server and C# to build my web site. I need to do a bulk upload Employee data from Excel to SQL.
I use the following code to perform this. The code works fine.
[Code]....
In the Employee table there is a field called ID which is of type int and auto incrememntral . This is the primary key.
There cannot be duplicates in the combination of EmployeeName and Location. If the user tries to upload ( through the Excel file) the combination of EmployeeName and Location which is there in the database, I need to flag it.
How can I identify the duplicates in an easy way rather than going through all the records again and again? Any functaion in SQL I can use to identify the duplicates?
I am writing code to insert values from an xml file. I check for a duplicate before inserting and delete if there is a match. Is there a more effecient way to prevent duplicates before insert a record? my code: private void LoadFData() { SqlConnection oConn = new SqlConnection(ConnectionString); SqlCommand oCommand = new SqlCommand(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.Text; oConn.Open(); // Load committee master files string[] strFiles = System.IO.Directory.GetFiles("fff", "ffff.dta", System.IO.SearchOption.AllDirectories); for (int i=0; i
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 a repeater which does quite expensive processing when it is populated. It gets the info from a web service which is itself a federated search service and will take 15 to 20 seconds to return results.
In each repeater item/alternatingitem, i have 3 imagebuttons doing some actions (saving in session some ID's, updating some custom collections...) , the problem is when clicking on one of the buttons, the repeater will trigger the command and then databind again, which takes quite some time to process again..
I am using datalist and used custom paging for that but on page index changed there is full postback..because i am sending the values through querystring just have a look to this link
I am using linkbutton in my gridview to avoid the use of querystrings. The gridview is filled from a dataset.
I almost have it working but the text the linkbutton is displaying does not vary as a function of what row it is in. I need a way to associate the text of the linkbutton with the row it is in.
I am having a problem with the gridview and formview. I have a gridview setup to show products and have a select button to clock on to give you the details of the product in a formview. I have the gridview setup for paging at 5 rows. In the page.aspx.vb I have on the SelectedIndexChanged event
FormView1.PageIndex = GridViewMain.SelectedIndex
This all works great until I go to the next page in the gridview and try to select a product on that page and the form view does not sync up. I really need a soultion for this. I could use the 2 page soultion for the master/details view however I would like to avoid it if possible...
Here change_scheduleDate function is executing every time for every row but i need to execute this function only when value change in txtdate textbox or same case i need if i create textboxchange event at serverside here i am updating txtdate value in database when text box value changed
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:
