i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 RepliesI am using mysql as my database.From one of my web pages I want to insert data to 4 tables.All the data should be inserted to these different tables on a single button click from the web page.How can I achieve this?Which is most reliable way to insert data to multiple tables on a single click event?
Will the sql operation with 4 'insert' statements separated by semicolon work for me?
i want to find data from excel sheet using c# my excel sheet like this
Sr. No.
Store Code
Store Name
City
State
1
3062
C.G.Road.
Ahmedabad
Gujarat
2
3103
Iscon Mega Mall 2
Rajkot
Gujarat
3
3113
New Gandhi Nagar
Ghaziabad
Delhi
4........................
I need to insert/update data to 3 or more tables on a single button click.What is best method for achieving this?I am using mysql as my DB.
View 2 RepliesI am building a web site following the tutorials on asp.net. I am using dataset as data access lay, and writing classes to access the dataset. But the example is just basic ideas, how do I retrieve individual table column value in the business layer?For example, if I have a table called Product, I only want to find out what is the product name by product id. I did this in my ProductBLL:
public ProductBLL
{
public int GetProductName(string productId)
{
ProductDataSet.ProductDataTable prodData = Adapter.GetProductById(productId);
[code]...
Is there a better way, or am I doing this correctly? Can anybody give me a reference to a more complicated business logic model?
I have two databases (DB1 & DB2) from which i wish to build a single table/gridview output, ideally i want to be able to sort the table by using any data.
However i cannot seem to figure out how to have more than one datasource per Gridview, and if i have more than one Gridviews then i can't sort all the data by any of the columns.
This is a oneway street, i do not want to update the databases from the webfront end.
Here is a Trimmed Down Version of what i have
[code]....
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:
[Code]....
here i have in 3-tier architecture , how to pass the data between DAL and BAL. i am using grid view to edit the data,when ever i click on the edit button all the corresponding fields should come to textboxes. i tried for delete ,it works fine bt not working to EDIT.
View 7 Repliesrecommend a data access class / helper class for Access databases, similar to the sqlhelper class found in the (Data Access Application Block)?
View 6 RepliesI have to update multiple row and two column of each row.
I have try to Update with case statement but after I perform that statement it blank out every other column that doesn't fall into the criteria of the update statement.
My table structure is like this;
table1
col1
row1 11
row2 22
I want to update row1 and row2 of their col1 in one single sql , how do i do that?
i am looking for a source code which will do following operation
1 it will ask user to select txt/csv file only when user click on browse
2 after this when user click on upload it should load all records into existing database table.
I read a lot of tutorials to learn what was the way to manage accessdata on a MySQL database from my ASP.NET, but there still something to whichremains unclear is the formatting of data and the ideal time to do so.For example, if I have a sentence like the following:"Je voudrais t'aider à résoudre ton problème"
When I pass the variable that contains this sentence, I wonder who the quotea problem because the SQL query in this setting look like this:"'I want to help you solve your problem'The quote of "t'aider" comes as the end of ther string in the query string. So I have to the format the string to double the quote to be able to pass it in the database..Maybe I missed the good tutorials, so if you have any links
I have a web site which uses one SQL database but the hosting company is very slow sometimes and I got database timeout, login and similar errors. Can I implement my code to use two databases simultaneously? I have stored procedures and the data is updated periodically.
EDIT:
Simply: When dbDefault is down and inaccessible I need to use dbSecondary so the web app keeps running. Ant these two databases must be always same.
EDIT:
Some errors:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
In my web application, I have 2 totally different databases - one that's being used mostly by a CMS from which we'd like to get page information on non CMS pages on the same website, & one that contains totally different data. Is it possible to use Spring.NET's Open Session In View module with multiple session factories for both of those databases, so in this case I have 2 objects defined in spring.config of type Spring.Data.NHibernate.LocalSessionFactoryObject?
View 1 RepliesI have an application which connect to oracle db.
I have two database hitting functions.
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.
In following code I am binding two parameter by name. Program compile successfully but output isn't coming.
cmd = new OracleCommand("select * from books where book_id=:bid and title=:rat", conn);
OracleParameter op = new OracleParameter();
"SELECT a.fibunr, " & _
View 14 RepliesI want to update multiple column of a table using subquery ...My sample code is shown below
[Code]....
its throwing syntax error...I dont know where i commiting mistake.
if we are trying to add the several columns in select statement and only one condition in group by.
how can we do that ?
Example:
[code].....
Is it better for a collection of ASP.NET web apps to share the same session database, or should each one have its own? If there is no significant difference, having a single database would be preferable due to easier maintenance. Background My team has an assortment of ASP.NET web apps, all written in either Monorail 1.1 or ASP.NET MVC 1.0. Each app currently uses a dedicated session state database. I'm working on adding a new site to that list, and am debating whether I should create another new session database, or just share an existing one with another app.
View 1 RepliesI am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
i want to know how to connect to multiple databases in sql from our asp.net code??
View 4 RepliesI have a doubt. For examples, Multiple users trying to update the same record usign asp.net application.
Can any one explain me indatil the situation how db process the request.?
What do i need to do in order to be able to query across multiple databases which are in the same db engine?
I have added the .edmx file of 1 database, but i only need 1 view from another db.
I have a quick question about best practices and especially expected performance for the following scenario:
If I want to query data from multiple servers that contain schematically identital sql databases, would having each server provide a web method that a single client application can consume be an appropriate (and relatively fast) solution?
The data just needs to be consolidated on the client end, where several web methods would have to be consumed serially (or in parallel?) to provide the data to the client. Each server would also be implementing Entity Framework as an ORM.
Performance is my main concern here, would it turn out excessively slow as we start to scale up to more and more servers?