In my project's earlier version I used Stored Procedures (SPs) & directly used them inside presentation layer. SP contains multiple Insert & Update queries for multiple tables.
Now I have decided to use a DAL(Typed DataSets & TableAdapters)
How can i use the same SPs with TableAdapters or If not possible how to wrap Multiple TableAdapters inside Transactions.
1 more thing in my earlier version i was using Transaction in SPs & Presentation Layer.
i've created a dataset, and created inside it a datatable and its table adapter.
when i try to reference the table adapter in a .cs class i get an error message that i'm missing some namespace:
Compiler Error Message: CS0246: The type or namespace name 'DataSet1TableAdapters' could not be found (are you missing a using directive or an assembly reference?)
environment: W7ULT64, VS2008, SQL Express.I'm changing from an OLD (MSAccess, VS 2003) environment to SQL exp / VS2008! Now I'm stuck with adding 'DataRows' using the 'DataSet.xsd'.
PS: the very last peace of code is just to test that I'm able to read the DB! I.e. I assume it's NOT a SQL issue!
Problem: (Vs2008)With below code I'm able to fill 'newRow' with the correct values! But because I do NOT have an 'add' mechanism the '.update(newRow)' doesn't do anything (also no error!)
Problem: somehow I'm NOT able to find a way (intellisense!) to create the appropriate/correct statements to .add(newRow).
Code in VS2008: Dim TherapieAdapter As New DataSetTherapieTableAdapters.therapieTableAdapter Dim values As New DataSetTherapie.therapieDataTable Dim newRow As DataSetTherapie.therapieRow = values.NewtherapieRow()[code]....
I have created the tables and the stored procedures in SQL 2008.
In VS 2008, I created DataSet1.xsd in App_Code and created the connectionString in web.config file.
Then when I go into the DataSet1.xsd and try to add a TableAdapter, strange things happened.
First I chose the data connection, then selected "Use existing stored procedure", then there was nothing listed in the dropdownlists (in Select, Insert, Update, or Delete).
I'm sure the connectionString is correct because if I choose "Use SQL statement" and type in a "select * from mytable1", the TableAdapter can be created without any problem.
I have two databound controls on one page. GridView, DropDownList. My page is crashing with a SQL Transaction deadlock victim error. I would like to capture this error, and attempt to re-databind the controls. My first thought was to handle an event on the controls that allow me to do this, but I don't see which event to handle. I couldn't search any answers. Where should I begin?
Are there any transactions around multiple webservice calls.Let me start with a commonly used example -- the travel agency. A customer intends to create a travel plan through an online travel agency. To do this, the online travel application calls the following three Web services:
These three services are available from three separate vendors. If any one of these three services fails, the customer does not wish to proceed with the transaction (again, either all three services must succeed or none at all).My language programming is Asp.net c#.
One is adding Userdetails(Fn Name : AddUserDtls) and another one adding address details(Fn name : AddAddresDtls) based on UserName which will get added after execution of first method ie AddUserDtls.
Problem I am facing is :
I have a single transaction and in that I have all the methods.
After the execution of first method,with out commiting i will go to second method.
and if any error occurs in second method.
I will rollback everything including the changes made by first method also.
Here one issue is there.
Since I am not committing the changes made by first method,
While I am executing the second method I am getting error that 'No user Name exists'
I understood that if we commit the transaction before the second method starts ,it will solve the issue.
But then it creates another problem.If some problem araise in the second method,then I cannot rollback the changes made by first method since it aleready commited.
I am trying to delete three related objects on one submit. Delete fails on one of the child objects, because of foreign key contraint with another table, It deletes one (the parent) but not the two child objects. All in one SubmitChanges(). I even used the TransactionScope, still same thing. So here is the scenario:
I have an object called Page which has a collection of objects called Webinars. There is another object Called Product which is one to one with Webinar.
I am looking for an accepted pattern for using MVC 2 and EF. Especially I am interested on how to implement updates. Where should the ObjectContext be created, where should the queries be, how to pass a model object from the controller and have it persisted with minimum robust code. I also want to be able to use transactions when updating multiple objects.
I used Linq in an asp.net application (code behind model). With EF I was hearing it was much more n-tier friendly, but I don't find it any different, rather than people talking about POCO which to me, all it means is satisfying the desire of those that want to have control of every piece of code being created.
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
Would it be better to have a sp return multiple result sets and use NextResult() or have subsequent call to dr.execute.... () and hadle one result at a time?
To me using nextResult() on a multiresult datareader would be cleaner and easier - but it does not seem to be very "atomized". I guess I am wondering can the cost of executing multiple commands be neglected? Seems like executing multiple commands and receiving a single result set would also be easier to read/test/understand.
I have a page that is essentially a group of controls on top, a button in the middle and a DataGrid at the bottom.
I wanted some asynchronous code to get ran; so I wrapped the bottom DataGrid in an UpdatePanel and made the button in the middle as the async trigger. This is working great. However, the button also needs to clear out the values of the controls up top after it adds to the bottom DataGrid.
The code to clear these controls out gets ran, but nothing changes on screen. I assume this is because the top controls need to be wrapped in an UpdatePanel as well. I did this, but I'm having a problem.
One of the controls up top is an asp:ImageButton. Clicking on this button executes a handler for the click event in the VB code behind. This VB constructs a Javascript snippet that opens a new window with a different page (don't ask me why it is done this way). That VB code gets executed, but nothing happens.
I have a gridview and a css file that is giving it a style,colors, font style etcThe gridview is showing blog comments in it.If someone posts hyperlink in the blog comments, the gridview width gets increasedOnly in mozilla the hyperlink is getting wrapped and works fine but in I.E, opera, safari, chrome and all other browsers the wdith of the gridview is going out of the page.In my css. style sheet also i have defined width:.grid
I have a gridView that returns 12 columns / Fields. I want to only allow 6 columns per row and on the 7th have the 7th column move below the first 6. Example: ...
I have a gridView that I want to only show 5 columns per "Row". To explain, lets say I have a gridView that has a total of 20 columns. Normally this would mean that the grid would show all 20 columns in a single row side by side:col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 ... etcI want it to instead show the columns underneath each other like so:
of course the prespective data associated with the columns would show below each column header.I have read some posts and they are pointing me to a repeator but I am not sure how I would impliment a method like that. Any suggestions / examples of ways you have done so or read about?
I'm trying to create a few custom web controls wrapping some existing controls. One of them, for instance, is a wrap for a textbox (because I need additional behaviors such as corresponding validators). The problem is, I'm not sure how to get the data of that control to be sent in the postback.
I have a Crystal report with a datasource of tables from two different typed datasets. Two of the tables come from one typed ds, and one the other ds. They logically share a common key.
In the webform backend of the crystal report, I populate datatables using the methods of the respective tableadapters. Every time I run the report, it is prompting me for username and password info, which it then doesn't accept. The code to populate the dataset in the backend is as follows:
I will explain the my current yet simple architecture of my application(s). At the moment I have my main web application as a separate project. I then reference the CoreBLLDAL (Business Logic and Data Access) Project so that several projects can have access to the BLL/DAL Project.
Within the CoreBLLDLL Project I use TableAdapters for my DAL.
I have just upgraded to VS2010 and I would like to make use of the Config Transforms, allowing me to have a separate web.config for test and production - however, TableAdapter get the connection string from the Settings.settings file.
How can I change the TableAdapters to get the connection string from the app/web.config file? I read that you can change this within the designer file for the TableAdapters by using ConfigurationManager, however, I tried this but I do not have access to the ConfigurationManager namespace. I presume this is because the project is a class library and not a web application - I am not too sure.
I have got requirement we are developing a on line holiday package booking system.
A package can have consist of multiple days like 5day - 6 night package or 10 day - 11 nights package.
Based on total no. of nights of package we are going define day wise itinerary along with itinerary images.
Now for define itinerary I want have grid view where I will define each day detail along with image. but before submitting to database to store itinerary I want to have a preview of itinerary image which will be browse from same machine or any machine attach to LAN...
