I have a dataset dsvalue that has columns Id and views. An other dataset has quite a number of columns including Id. So for each id in dataset ds, i should add a new column "Views" and merge it with views from dsvalue.
View 1 RepliesI have two datasets called ds and ds1 that I want to merge into a grid. I get data from the first dataset to display in the grid but the second dataset where I want to display a count I don't get any data from it. I am trying a ds.Merge(ds1). here is the code i have for the sub. What am I doing incorrectly?
Code:
[code]....
How to link multiple DataSets (why SSRS call it a DataSet even there is only one bunch of data fields in it) using keys, then put data fields from multiple DataSets into one Data Region? The reason I have to do this is: There will be 6 major DataSets to be used together few times in same report, it is not make sense to build a huge Matrix for all of them together. (in some data region I use data from dataset A and B, some times I use data from dataset A and C, D ...)
View 2 RepliesI have a solution I'm working on in VS2010 Professional, using ASP.NET 4.0 with the AJAX Toolkit.This has been working fine, but when I started it up today, I got the runtime exception shown above. This exception occurs on any page with a control from the toolkit.Sometimes when I load a page, I get an exception "Could not load file or assembly 'System.Windows, Version=2.0.5.0, Culture=neutral, ublicKeyToken=7cec85d7bea7798e' or one of its dependencies. The system cannot find the file specified." If I then reload the page (without making any changes), I then get the exception shown in the subject line.I tried dragging an AJAX Toolkit control from the toolbox onto a page, and then deleting it, and that worked - once. The next time I tried the page (or any other), I got the exception again. Dragging a control out didn't help this time.
View 5 RepliesI have just started learning asp.net with c# and want to know how to write datasets to XML using asp.net.
Can anyone provide me any example or reference so that I can move ahead.
I have two datasets, each of containing single column. I want to compare each row of first dataset with each row of second dataset and check if any match in the data.How can i implement such a login in VB.NET with minimum iterations.
View 2 RepliesI am building a web page that will be presenting users two dataset results from two stored procedures in sql but the data is not similar. Is it possible to present both datasets to users in one datagridview? I am unable to do a union of the data in SQL due to the fact that the results aren't similar and wanted to see if I could work around this issue with .net.
View 3 RepliesI created an ASP.NET site in Visual Web devloper 2010 & then published it to our webserver. Due to the nature of the site, there are several users updating the content on the site (e.g. news pages). Is there a simple way to merge these changes back into my project? Can I just copy the published site back over my project folder which should overwrite the aspx pages but leave the code behinds untouched?
View 4 RepliesI have these two methods on a service:
public Offer GetOffer(int id, string languageCode = Website.LanguageSettings.DefaultLanguageCode)
{
Entities.Offer offerEntity = _db.Offers.FirstOrDefault(offer => offer.Id == id);
if (languageCode.ToLower(CultureInfo.InvariantCulture) != Website.LanguageSettings.DefaultLanguageCode)
{
using (IDocumentSession session = store.OpenSession())
{
Translation.Offer translatedOffer = session.LuceneQuery<Translation.Offer>(Website.RavenDbSettings.Indexes.Offers)
.Where(string.Format("ObjectId:{0} AND LanguageCode:{1}", id, languageCode))
.OrderByDescending(offer => offer.Id)
.FirstOrDefault();
var offerPOCO = Mapper.DynamicMap<Translation.Offer, Offer>(translatedOffer);
offerPOCO.Id = offerEntity.Id;
return offerPOCO;
}
}
return Mapper.Map<Entities.Offer, Offer>(offerEntity);........................................
Is it possible to merge several JavaScript files being used on a site into one? I'm looking to do this to minimize server loads by forcing only one download. This way I can keep my JavaScript organized into separate files and still have efficiency.
View 2 RepliesI want to access to the ViewBag from javascript, so I can access to this variable in the future from javascript.Im trying to do this:
var array = new Array();
@for (int i = 0; i < 5; i++)
{
array[i] = @ViewBag.FriendsId[i]);
}
I found an interesting discussion here:
[URL]
Quote:
DataSets are sub-par amateur solutions to code your Data layer...Stop Using Them and learn to CODE! :)
What is your opinion of DataSets vs. just stubbing out custom classes and working with those? What are other alternatives?
I have a good bit of data that is generally static. I want to load it into my application so I can access the items from picklists without having to make redundant calls to the database. I have found a few articles discussing how I can approach this, but, I am specifically looking for a way to create a collection of DataSets with constraints at Application_Start. Also, when you do this kind of thing, do you normally create one dataset or a separate dataset per table? I know there are ways to add multiple tables to a single dataset, but, I don't know how to do this from the DataSet Designer.
View 2 RepliesI have imports.aspx with an ASP:FileUpload function.In my code-behind I have this:
SEPTA_DSTableAdapters.ServiceTBLTableAdapter sta = new SEPTA_DSTableAdapters.ServiceTBLTableAdapter();
SEPTA_DSTableAdapters.RoutesTBLTableAdapter rta = new SEPTA_DSTableAdapters.RoutesTBLTableAdapter();
protected void Page_Load(object sender, EventArgs e)
[code]...
Now I know Datasets support disconnected operations. but does EF do the same thing?
View 3 RepliesI am using Visual Studio 2010 now. I do not have network access to my database because of some connectivity issues. Are there any good articles on how to manually wireup Entity Framework objects manually? Or, is this just unrealistic?
View 3 RepliesI have three tables. I need to merge these three tables into one table. There is an ID column in all these three tables. The ID's can be same in all three tables or they can be different. If the IDs are same then I need to merge based on those ID's so if the ID 1 exists in Table A, table B and Table C then one row will be created in the resulting master tables, but if the Id's are different then one individual row will be created in each table.
Also, some of the columns are same in all three tables, but some are different, but if the ID is same then I just want to append that column in the existing table.
I need to access, merge and parse my log files using my asp.net application programmatically. I use shared hosting and as I can see log files are out of the root directory of my website? Is there anyway to access those files from my application?
View 1 RepliesWhat would it be the simplest way to merge a result like this from a sql query to be displayed in an asp.net gridview?
NULL Tarde Fer W. Lunes
Mañana NULL Fer W. Lunes
I need the result to look like this
Mañana Tarde Fer W. Lunes
i lunched an asp.net web-site. the main idea in the site is that:the site shows the same page, but on each next button the user clicks, the pictures in the site change randomly. im working with postback and sessions.
i noticed that when a few users try to log into my site - their sessions are merging. meaning, the first picture presented is diffrent but the second picture is the same for all the users, and so on... (moreover, pictures that appears in the begining appearing again even thow i don't allw it in my code)when i tried to debug the site locally, the random function works perfectly and there were no such problems. it haapens only when 2 users and more log into my site.
I'm very new to jQuery, and have little experience using JavaScript,I've found what to me looks like a fantastic crop tool using jQuery ( http://deepliquid.com/content/Jcrop.html ).What I need is to merge example 2 and 3 together, as I'd like both the preview panel AND I need the coordinates. The two bits of JS are:
<script language="Javascript">
// Remember to invoke within jQuery(window).load(...)
// If you don't, Jcrop may not initialize properly[code]....
Before I can upload my web site I need to merge my 6 small databases into one otherwise I am going to pay unreasonable hosting fees.Is there any easy way to do this?
View 4 RepliesI want to serialize an object to json, so I'm using [Code]....
[Code]....
This is fine, but I want to return different json datasets depending on the circumstances. Lets say I have this object (a simplified example):
[DataContract]
class foo
{
[DataMember] int productId
[DataMember] string productName
double price; //not used in json.. yet
}
Which will serialize to a json object containing the product name & Id, but what if I also need to be able to return a different json object (say, productId and price but not name)? Can this be done somehow in the same object using WCF/DataContracts and DataMembers? This will be sent in an ajax query containing a collection of objects and needs to fast, so just including every member in every type of json request whether it's needed or not isn't a good solution.
I was just thinking if there was a way to programmatically open and close connections to the database via the dataset classes we've added into the project.
I am trying to avoid one specific problem. Assume there is an EmployeeTableAdapter. It has two methods IsValid(string EmployeeID) and HasDepartmentAccess(string EmployeeID, string DeptID). Afaik each of these methods, open a connection, does data retrieval, and then closes it.
The opening and closing of the connection is done internally. I kind of want to override this, and close the connection upon a page unload event which (I'd manually register it with the datadapter class somehow).
I've a user table, and contact table linked to it, and appointments where contact are linked to it with users in this in it. need a report which show ...by user number of contact created by this user and number of appointment createdo i guess i need two datasets but how can I pass parameters between them to know what is the current user id ..?
View 1 Replies