I've developed an application using strong-typed dataset with .net framework 3.5.is there a way to change the source table for a tableadapter programmatically?
View 1 RepliesIm trying to make a template for a dropdownlist.
In my Model i have:
[Code]....
The PageTemplate, is a class, but I what my view to render a DropDownList, that can set the key.
I have in my shared/EditorTemplates/String.ascs - witch is render as that template
But my /shared/DropDownList.ascs, does not render at all. why?
// dennis
In a sence im trying to recreate this article:[URL]
[Code]....
for List<AnswerInfo>,
[Code]....
now, what i want to do is to place few textboxes on a view that allow users to input the Answer Text. after click the submit button. i want List<AnswerInfo> which contains the Text information pass to the controller. can anyone tell me how to do it?
i need to prepare a report as a table. but my table needs to contain data from two schemas. so my doubt is, is it possible to set two dataset names for a table in its property?
View 3 Replieshow can i get a single row from strongly typed dataset table data adapter in c#?
View 2 RepliesTill now I used to design RDLC file before and assigned typed dataset table columns.Report processing mode is local. But now my stored procedure returns different columns based on condition i.e columns are not fixed every time. Now I need to add that columns to typed dataset and dataset is assigned to RDLC file. So dataset and RDLC files are create dynamically based on stored procedure result set columns.
View 1 RepliesToday I am facing the problem with Typed DataSet using DataSet.XSd file, And How to fetch, Delete and Update the Database through Dataset.xsd file.
View 9 RepliesI am learning .net and building a table from code behind and attempting to change alternate row colors.I have it working but at he moment only using Drawing.Color when I would like to use a hexidecimal value, is there a way of doing this?Here is the code thats doing it at the moment:
If j Mod 2 = 1 Then
r.BackColor = Drawing.Color.Aquamarine
'Table1.Rows(j).Cells(i).CssClass = "odd"
[code]...
I have been working with this database for some time. Here is the situation...
I inherited a MS SQL database that has hundreds of tables with similar data. For instance:
FordTampa_customer is a table,
ChevyAtlanta_customer is a table, etc....
All of the columns are the same...just different tables with their own ID field. All I have done...Inside of another database id is created a table called 'Customer' and added an 'Dealer ID' column along with the rest of the other columns in the other tables...
So the combination of the 'Dealer ID' and the 'ID' field are unique.....I know...its not the best way to do things...but I cannot change the old data structure because I cannot have access to it. I am give back-ups on a weekly basis, so this is all I have to work with.
All right, on to the real point of my post...
Currently, I have an application that I use to select all of the data from the 'Ford_customers','Chevy_customers',etc... and inserts them into my new main 'Customer' table. I do this by selecting the table names, bind it to an arraylist, loop through the list and execute an insert statement.
I do this in VB.NET, but I would prefer to do it in a Stored procedure of some kind....I just am not sure how to accomplish it. I use this syntax to get my list of tables:
[Code]....
I am not sure how to take those names from the table and do another select based on that list of names.
I use a function which contains object type parameter. I want to get name of this unknown typed object's properties. How can I do this?
View 3 RepliesHow to refresh the xsd Typed DataSet when I change an id field from normal to autoincrement? I'd the INSERT statement to remove the 'id' field in its statement from files *.Designer.cs and *.xsd.
View 2 RepliesIt must just not be my week to learn LINQ. I have a Typed DataSet that I am trying to write a LINQ query over and take advantage of the strong typing. The problem is that in visual studio, I can't use intellisense to take advantage of the strong typing. I don't know if it matters, but I am doing this in a class file project, not in a website type project. Anyone run into this or think of something I should check???
View 2 Replieshow can i add multiple columns in typed dataset.
I have a typed dataset (ProjectDemandDAL.xsd) with two methods in it. Now i just wnt to add few more columns of diff table. How can i add it.
How can i add designer.cs to this file?
I have a Strongly typed Dataset TableAdapter in C#, how do I get a single row from it?
View 4 Repliesis it possible to do a batch update in a strongly typed data set? UpdateBatchSize does not seem to be an option once you create a strongly typed dataset.
View 1 RepliesI'm currently working on a 3-tier ASP.NET application (UI, BLL & DAL). The DAL uses a strongly typed dataset that I've created with the VS Dataset Wizard. My question is, what is the best way to handle exceptions originating from the BLL and DAL classes. I googled a bit and it seems that the most commonly used practice is to create DALException and BLLException classes and throw your own message. Is this the way forward? how this can be done for an automatically generated DAL? What are the best practices?
View 1 RepliesI have an asp.net nTier application. The data access layer is a strongly typed DataSet consisting of multiple DataTables with DataAdapters. When the user logs in, they choose which database to connect to (from a table in the membership database). I need to pass the selected connection string into the DataSet object which will remain the same for that users until they log in again. I'm thinking that the answer might be to create a partial class of the DataSet object where I can pass the connection string into the constructor. Im not sure how to go about this though.
View 2 Repliesi create typed dataset and i create my report using this dataset in another page i create report viewer when i set the report source for the report viewer using wizard automatically the reportviewer generate 3 ReportDataSource one for each table it is working correctly but when i try to set the report using code the report dislplayed successfully but it is empty? here is my code to bind to dataset
[code]....
i have a winform application with huge strongly-typed dataSet. Now, i've decided to create a web edition of my application and i want to use strongly-typed typed dataSet which exists in my winform application. also it's tableAdapters create with the connection string settings which stored in my winforms app.config. My problem is that how to use strongly-typed dataset of my winform app with new connection string which exists in my web app?
View 2 RepliesI'm trying to set up a simple content management system for two different sites, which are both stored on the same server (my own, not hosting, if it matters:)).
Both sites are basically the same, built upon a similar (but seperate) xsd (Typed DataSet) file, and read data from different databases using the tableadapters in the xsds.
Obviously, i have the same xsd setup in my management system application that need to hook up to the relevant database (after user authentication) and use the tableadapters to access the data and allow the forms in the management system to modify the data.
When i had a single site, the connection string was stored in the web.config file and after logging in to the management system, all forms could access the database.
Now i have two site and i need to setup the connection string in the xsd dynamically after user validation based on the relevant site to edit.
My question is, how do i set the xsd's connection string dynamically (after user logs in, the function returns the specific connectionstring and stores it in a Session variable)
i have been developing an asp.net application with typed dataset.suddenly after adding a method to one of my tabel adapters and compiling the project this error occurs in compiling dataset: Failed to generate code.object reference not set to an instance of an object.
View 4 RepliesI have a date field in a typed dataset that created from database.
I get an NULL Value exception when I try to enter some null value. I am not able to set the Nullvalue property of the DateTime field in XSD to other value other than Throw Exception.
I am getting Resultset from SQL server2005.It contains 4 tables.
Dataset ds=new Dataset();
ds=BLogiclayer1.TestMethod1(a,b,c,d);. This normal Dataset ds contains Resultset. ( I am working with RDLC reports. I added a Typed dataset to my project. I am using Typed Dataset as report dataset.) I want to add normal Dataset all the table values to Typed Dataset table as rows i. e. only one table in Typed dataset.I am trying like below.
//Typed Dataset name that I have added is salesdata.
salesdata sd=new salesdata();
for(int i=0;i<ds.Tables.Count ; i++)[code]....
I fill a GridView from a ObjectDataSource that points to a Typed DataSet.
I need to read a couple of row columns from the object data source that IS NOT part of the Gridview.
So far, I have found out that ObjectDataSource.ObjectDataSource_Selected is the right event to do this.
Examples on the internet refers to e.OutputParameters, but that appears to be empy even though rows are returned.
e.ReturnValue seem to contain a type related to the row type, but I cannot interpret this either.
how to convert the dataset columnnames to UPPER case letters. I have a code like :
[Code]....
But returned dataset result is not showing the uppercase column names.