SQL Server :: Retrieving Info From 2 Databases With One Statement?
Nov 29, 2010
at present our site has a search function which then populates a grid with results from our catalogue database... I'm trying to implement product availability into the grid, but the stock information is stored in a completely different database in a different location. Both the main search results and the stock levels have to be referenced in the same datasource to get them both in the same grid; does anyone have any thoughts on how to do this? I'm not hugely experienced with SQL, but could I create a view containing aspects of both db's or are these limited to a single db?
View 3 Replies
Similar Messages:
Jan 16, 2011
I have the following select statement :
string Statement = "SELECT * FROM Car WHERE brand = Bmw;
how is it possble to display the result from the statement, because when i display the result exp: LblInfo.Text = Statement;
The result is : SELECT * FROM Car WHERE Brand = Bmw
View 5 Replies
May 13, 2010
I'm creating a site that will offer several different services (blogs, videos, images..), all under the same site.
Each service will use a separate database and all services must use the same membeship info. Users will only need one login to access all these services.
For the membership database i will use the default aspnetdb database.
There are two ways i can think of:
1) Use a join-query between two databases, each time i want to show some service records per user.
2) Create a custom membership-info table in each service's database, and keep it in sync with the master membership table in aspnetdb database.
The custom membership table will be like this:
Id - int, primary, identity
UserId - uniqueidentifier (of aspnetdb database)
What is the best way to do this in the long run, when i will have six or seven or more services ?
View 2 Replies
Sep 29, 2010
I have created a table in my Oracle database and am trying to add / edit / delete/ query the records. This table already has 4000000 records. Now when I try to query the database, it takes close to 3 minuetes to return records. I have tried creating indexes, but was not successfull so far.
Following is the structure:
User : varchar(20)
Fac : varchar(10)
Prm: varchar(100)
I am using the following code in VS2005:
[Code]....
View 4 Replies
Aug 3, 2010
I have an application called barcode available on a server on the web. The application is used to generate barcodes. The user is able to save her progress directly on her desktop, however though whenever the user try to load the saved progress. It is doesnt remotely connect to the server, instead, it defaults only the saved copy on her desktop. so for example
we have the following aspx created
barcoded.aspx. The barcoded.aspx is available on the server. the page has the following information
Name: PRT321-1 Code: 456789-1000
Label: 678900-001-001
Now, this information is saved as webpage.html. however though, when the user goes to the saved location and clicks on the saved copy, it automatically load the copy as a webpage and allow the user continue with the modification online but that is not the case. Does anyone know how to fix this problem.
View 1 Replies
May 10, 2010
I have a select statement where I want to get some data. The problem is that I am not geting the right answer. This is what I am trying to do:
SELECT * FROM se_cs_test WHERE
Status = 1
OR Status = 2
AND NumberOfContacts = 1[code]...
View 2 Replies
Jun 10, 2010
"SELECT a.fibunr, " & _
View 14 Replies
May 27, 2010
I'm having problem getting the syntax right for an SQL statement for a Progress database. I have the column "Resource" which is a reserved word and according to the Openedge SQL Reference I can only use reserved words if I delimit them with double quotation marks.
So how do I write this line...
Dim comm As New OdbcCommand("SELECT Resource FROM PUB.ActOper WHERE CreDate > TO_DATE ('05/24/2010')", conn)
...with double quotes around Resource? I've tried a bunch of different combinations but I get "Expression expected" or "valid continuation expected" or something similar.
View 4 Replies
Dec 15, 2010
actuly my site is working fine but suddenly site is giving "ORA-24338: statement handle not executed" this error i'm try to resolve this error but i could not get proper solution
my prblm is tht when i access my site on my PC using "www.xyz.in" at tht time i access my site with report properly but whn i access my site on out of company or any cyber cafe or other internet pc thn i could nt access my site properly tht site is give me error.......
ORA-24338: statement handle not executed
i'm use oracle10g & database connection in "system.data.oracleclient" & most imp thing i;m using site number of years
View 1 Replies
Jun 21, 2010
how to get the sql statement query or table name if oledbexception occurs - table or view does not exists.
get the DB details from the oledb exception.
View 1 Replies
Sep 7, 2010
I'm trying to read Excel file header column name. Then I can query data from excel using SELECT statement. For instance. column name is name,
department and email. Then I want this three header name being detected using code and put in select statement. User no need to care about the
header name and we can use code to read the header name instead of hardcode header name inside SELECT statement.
View 1 Replies
Jul 22, 2010
I'm building an ASP.NET MVC 2 site where I'm currently implementing an OpenID sign-up form. Unfortunately, I'm foreseeing a possible security bug/vulnerability inside my architecture.
Here's how I want OpenID login to work:
User requests /Account/Login, Controller sends back OpenIDLogin View. User enters their OpenID into the View, then OpenID authorization takes place, and finally the OpenID is returned to the Controller.The Controller checks whether the OpenID is currently in use by a user in the system or not. If it is, the user is logged in to that account. If not, the registration process begins.
And now, the OpenID registration process:
The OpenID identifier, as well as any other information provided by the OpenID provider (such as email address or name), is put into my custom ViewModel and sent to my OpenIDRegistrationForm View.The RegistrationForm View stores the OpenID in a hidden field to make sure that it gets sent back to the Controller.The user fills in the RegistrationForm View and sends it back to the Controller.The Controller creates the user account and puts the OpenID into the database.
The bug that I see within my architecture is that a user could modify the hidden value in the RegistrationForm View. Thus, they could spoof their OpenID! I will make sure to add another round of checking to the final Registration Controller Action to make sure that the OpenID that is provided doesn't exist yet, but there is still a possibility for spoofing. Can my architecture be improved somehow? I don't want this to end badly...
One solution I'm considering is encrypting the OpenID before I send it to the View and then decrypting it when it reaches the Controller. Should I try this?
View 1 Replies
Sep 25, 2010
have a very important issue,i have three Stored Procedures Sp1,Sp2 and Sp3 .the first one (Sp1) will execute the second one (Sp2) and save returned data into @tempTB1 and the Second one will execute the third one (Sp3) and save data into @tempTB2.if I execute the Sp2 it will works and it will returned me all my data from the Sp3 ,but the problem is in the Sp1, when i execute it it will display this Error:INSERT EXEC statement cannot be nested I tried to change the place of execute Sp2 and it display me another error:Cannot use the ROLLBACK statement within an INSERT-EXEC statement.
View 4 Replies
Dec 18, 2010
I am trying to pass a textbox integer to a sql statement in my code behind using the "where" statement to filter what I get from the mysql database but for some reason, it diplays nothing. If I change the variable in the "where" statement to an actual digit between 1 and 12, it works.
Here's my code:
Default.aspx:
[Code]....
Default.apsx.cs:
[Code]....
View 4 Replies
Feb 10, 2011
Can you read the servers hardware info via a web app in c#?
View 5 Replies
Nov 24, 2010
I have one website running on one server and another web application running on another server. My web application asks for username/password to login into the system. I need to put a username/password field on my website so that user can directly login from website. how to transfer these username/password values to the web application running on another server?
View 3 Replies
Feb 16, 2010
I have defined an ODBC Command and ODBCdatareader as follows
OdbcConnection myConnection = new OdbcConnection(connectionString);
OdbcCommand myCommand = new OdbcCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "select UOPGM from GREG.TUSROPTF";
OdbcDataReader myReader;
myConnection.Open();
myReader = myCommand.ExecuteReader();
When I try to retreive from the reader as follows:
while (myReader.Read())
{
string someString = myReader["UOPGM"];
lstNames.Items.Add(someString);
}
I get the following error
Error reading the database. Unable to cast object of type 'System.Byte[]' to type 'System.String'."
I have also tried string someString = (string)myReader["UOPGM"]; to no avail
View 4 Replies
Feb 1, 2011
i am working on a project which needs to send mails. it is still under development.
can any one guide me how to setup smtp server (IIS 5) to send mails and code to send mails as well. this is all for testing only.
View 9 Replies
Dec 15, 2010
I have a site where users can save images together with a couple of info fields about the image. The images are stored as binary data in the same table as the rest of the image info. So far pretty standard.
Now, the users should be able to upload a document, describing the image in more detail, along with the rest of the image and its' info.
Size ~2MB per document.
My question is: Should I store this document (binary data) in the same table as the rest of the images or should I create a new table holding only the documents. There would of course be an id reference in the image table to the document in the document table.
I have a search function joining a couple of tables, including the image table, when searching for images. I need to know if there's a difference in efficiency between these two solutions.
I always fetch the document data separately but if I don't win anything in having the documents in a separate table I'll just put it with the rest of the image info.
I'm asking this since I don't really know how SQL Server handle tables when joing and searching in them.
I have about 10´000 users with a maximum of 10 images per user. (ASP.NET - SQL Server)
(I'm not asking if I should store documents in the database, but how ;)
Example:
columns in imageTable - id, title, dateAdded, image (binary data), document (binary data)
Searching for items from a specific user I would join the userTable and the imageTable and select title where image id equals user id.
So, will there be any difference in the performance if the document is in the imageTable or in an own table?
View 4 Replies
Feb 27, 2011
The following stored procedure updates the value in LeaveTransaction table.
[code].,...
My Question here:
I have written the above trigger,which would update the value for the corresponding records in another table ie) LeaveCumulative table. The trigger is not updating the value in the designated rows in the leavecumulative table. Whereas when I excute the same update command separately in the Query Editor window the trigger is working fine.
View 1 Replies
Sep 18, 2010
I have the following code in a stored procedure to retrieve all posts:
[Code]....
However, I am having trouble selecting posts by their tag..
View 9 Replies
Jan 15, 2010
I am designing an prototyping an app the needs to store images, similar to facebook. This will be a public facing site and I am not sure how many users I will end up with but what I am looking for is a way to efficiently retrieve them.
So far I am thinking of storing them in SQL Server varbinary columns. I have the upload code and the storage code for that. My concern is retrieving them. I can retireve and build the image tag on the fly but I am worried about having to hit the database for each one.
I have been thinking about getting all images for a user and caching them in the asp.net cache for 10 to 30 seconds. I have never had to do something like this so I would be interested in hearing a few different approaches. Obviously the images can vary in size and I was thinking about defining a size limit, but I haven't gotten that far yet.
View 3 Replies
Sep 9, 2010
i saved files into database. when i'm displaying i wrote code like this
Dim mySqlDataReader As System.Data.SqlClient.SqlDataReader
Dim mySqlCommand As New System.Data.SqlClient.SqlCommand("pl_Resumes", mySqlConnection)
mySqlCommand.CommandType = CommandType.StoredProcedure
[code]...
View 13 Replies
Dec 16, 2010
I know how to retrieve sql server instance name from network,but i want to know is there any way to make sure that while retrieving which should not retrieve the sql server with express edition.
View 19 Replies
Aug 25, 2010
how to display image in image control on web page and also in gridview.In sql server image data type is "image".
View 3 Replies
