I am having 2 databases namely ach and cart and i am having tables namelt Register and Invoice i would like to add a field in to those 2 tables . Like if i enter a value like some ccyyxxyxyxa this should be saved in the 2 tables...
View 3 RepliesI have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
View 1 RepliesI have a C# problem I need to synchronize two MS Access tables from two different databases(two databases over a network) which is quite similar, I thought of using two different OleDbConnections and two DataAdapters to fill a Single DataSet and then manipulate the data in the DataSet, I think the source table (database with the primary data) should be loaded first (into the DataSet) then the secondary table from the remote database should subtract the existing records in the DataSet to get the difference then the difference should be Appended to the remote table, but I don't know how to remove the same records from the DataSet and to send the remaining records to the secondary database.
Here is some code I already have, but I don't know how to get this to work:
[Code]....
i need to join two tables in different databases, how it can be done??? and if i want to use sqldatasource control to bind results to some data-bound control how can I configure my sqldatasource control???
View 3 RepliesI've a problem in MySql.I need to retrieve data from two tables,in which one field is common in both the tables and I need to retrieve distinct data.But all I'm getting is this :
Id Name Initial
1 abc A
1 abc A
1 abc A
2 def B
2 def B
2 def B
How can I make it like this :
Id Name Initial
1 abc A
2 def B
3 ghi C
I 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?
will bad SQL query or tables not indexed properly cause any problem when we execute it? or it may just take more time to execute??
View 3 RepliesI need to join two tables accross two different databases and return an ADO dataset.
ie: select * from database1.table1 a inner join database2.table2 b on
a.key=b.key where some_condition=true
My main problem is how to specify the SqlCommand parameters specifically the connection string for both databses. Is this possible?
I am having a hell of a time trying to figue out groupings on data tables with LINQ. I am using VB
I have two data tables. I'll define from Table Law = columns (ven_grp,comp_no,acct_unit,description,company)
Table Comps = columns(comp_parent,comp_struct1, comp_struct2, .... through comp_struct9 Now here is the SQL equivalent of what I need in LINQ
[Code]....
For reasons I won't get into I can't use SQL to do what I need to do. this is how far I got with LINQ
[Code]....
which works ok, but I can't for the life of me figure out how to group on the fields I need to and then dump the query results into datatable. I've looked at tons of examples on line and I just don't seem to get it or it does not work the way examples show. Both of my tables are defined as similar "Dim law = ds.tables(0).asenumerable()
We have some stored procedures in mysql which use temporary tables.For performace reasons we need to replace them and write alternate code.
View 1 RepliesI 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 have access to two seperate databases (mySQL) located on two servers. I need to get the data, link the tables on a key field and display the results in a datagrid. My challenge is that if the search criteria changes for the display it affects rows returned from on table and should thus automatically affect the linked table and resulting data returned.
what the best approach would be to achieving this? So far I have set up a dataset with a dataadapter and table for each connection and then linked the tables in the dataset. The problem that I'm having is getting the linked resultsets to work.
On my form I have the datagrid with two Objectdatasources one for each dataadapter and i believe that's where I'm going wrong...
We are doing migration from SQL Server to Oracle.
I have following sample trigger which uses SQL Server built in tables "deleted" and "inserted" tables. But Oracle we do not have equivalent. Oracle has only :OLD, :NEW, which represents only one row, but not table contains set of deleted/inserted rows. what would be the equivalent trigger in Oracle?
[Code]....
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
View 5 Repliesi 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 make use of SMO namaspace to get Table, Function, Procedure names from the DB.
Now I've intended to get the tables [Column] name and the relation (dependency) among the tables. Is this possible?
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'.
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]....
One of my classes currently is a C# class. I was given a small assignment for creating a bare-bones Facebook clone. I am now ready to list wall posts on user's pages.Having just been taught about DataLists (using tables), I thought I'd use one. However, I'm told "The messages list must be displayed without using table tags (<table>, .<td>, etc.)"
This is not really a coding question, just asking for a recommendation on how I should go about displaying posts without tables while still easy on the eyes (including name, the poster's picture, the message, and a date).
My SQL Server db was installed before I installed VS2008. What happens when I create the standard ASP.net security it does not create the tables and SPs that are needed.
Would it be possible for someone to create an empty database with the relavant tables and SP etc and save it here or send it to me.
i want to read the following xml file.
[Code]....
using ds.readxml.. .i am getting a column specialties_id in the specialties table. . i have spec_id as PK in tht table ..still it is creating extra column automatically.. i need the output like this.. doctors table is fine.. specialties table columns(spec_id,specialty)..drspecialties table columns(dr_id, specialty_id)
then i need to send three tables into database..sending to database i can do tht... let me know how to read this xml to get the tables as required.. pls solve my prob..
I need to link two tables have the same fields but in different DB using visual studio 2010 and ASP.NET application? I'm using a grid view to show the details of each table.
View 1 RepliesI can't get it to recognize LunchPanel and AttendPanel in the VB code behind this page.
Code:
<tr>
<asp:Repeater ID="StudentRepeater" runat="server">
<ItemTemplate>
<table border="1" rules="rows" frame="box">
<
[Code]....
When I move those panels from the table to outside the table they are seen in code - so I obviously can't put them in that spot.What is the preferred method to have optional columns in table/repeaters?
I recently read Scott Mitchell's article series "Examining ASP.NET's Membership, Roles, and Profile". In Part [URL], It says "to store additional, user-specific fields...If you are using the SqlMembershipProvider, this would mean creating an additional database table that had as a primary key the UserId value from the aspnet_Users table and columns for each of the additional user properties."I created a table named Thread to store some specific users information and comments they make. I set the ThreadId as the primary key and the UserId as the foreign key to the UserId in aspnet_Users table. But when I run the application and use a user's account to submit a comment, there is an error in my Comments.aspx.vb page "Cannot insert the value NULL into column 'UserId', table 'ASPNETDB.dbo.Thread'; column does not allow nulls. INSERT fails.The statement has been terminated."How can I make the logged-on user's UserId inserted into the Thread table when storing the user's other data information?
View 2 Repliesif you have two table inner join like SELECT* From A INNER JOIN B on A.ID = B.IDSay A and B tables both have Username values but A's username is Test, and B's username is Test2When I do Eval("Username") it always print out "Test", how can I configure it to print out "Test2"... meaning how to specify which table's value to put using eval.. is there something like Eval(B.("Username"))??
View 6 Replies