How to retrieve data from two different database with single query

Please give me actual query for following action I want data from two different database to single table (as same field name) ex. database1.table1 as field database2.table2 as field result into database1.table3 as field how to write query thanking you abglorie

How to use MS-Word Eqution Editor in asp.net textbox control? Is it possible are not? If possible how to implement? Thanking you abglorie

Now typing in msword document using equation editor and type matrix (i.e. 3 row 4 columns). 1 0 1 1 1 1 0 1 0 1 1 0

I want help from you. How to typing mathematical equvation in textbox? Is it possible are not? If possible how to implement? Thanking you abglorie

Please help me. Now I want to store the (text and image) combined to store in one field as binary format. In later we want to retrieving the binary data from the database and display a IE page. How it is possible? Can you give a solution in VB.net Thanking you, abglorie

Please help me. I want employee photo store into SQL database. And retriev the photo from database and display a photo in IE. Please give me exact coding in VB. Thanking You, abglorie

Sorry for the distrubing. Please give your answer. Now, I want store a picture in database. Later retrieve the picture from database and show in a page. 1. Which type of datatype to create in SQL? and 2. How to retrieve from (picture) data and display on IE. Please give exact coding. Thanking you, abglorie

already enabled anonymous access checkbox my website description is XYZ IP address is (all unassigned) TCP port is 150

Now I am developing a website in asp.net with visual basic my databases in MS SQL-Server 2005 my server is WINDOW S2003 R2 my web.confg file setting in authorization is my website open in client system ask the username and password (server password) supply the username as "administrator" and password="xyz" then the site is open now we want is.. the site open without asking for username and password in the client system please give me a solution for above problem is rectified thanking you in advance abglorie

I am working in SQL Server/asp.net Database How to using val() in sql? mycode datatype is string values as "MS12", "MW10", ... My query is "Select * from FILE1 where val(substring(mycode,3,2))=10" Sql say error as val is not recognised function name Kindly tell your suggesions. Thanking you abglorie

sql2000 database is using

How to using val() in sql? mycode datatype is string values as "MS12", "MW10", ... My query is "Select * from FILE1 where val(substring(mycode,3,2))=10" Sql say error as val is not recognised function name Kindly tell your suggesions. Thanking you abglorie

First thank you for your helping mind. I need some idea from you. I am designed one form in asp.net. (using coding in Visual Basic) Using more than one textbox control in a form. Each control fixed tabindex starting from 1 in sequential order. Now run this program, I give a value and press enter key the control passing to next control. this process is ok for more than one textbox control is using. But I restrict the textboxes in run time of displaying a form. This time only one textbox is display the form and one command button. In this case, I give some value in textbox press enterkey but the controll not to go to next control, the next control is command button (OK). In this time using only tab key is used. But I want to press enter key the control move to next control of command button is activate and form is refresh to next input. How to solve the above problem? thanking you abglorie

I am developing 5 pages under one master page. Now I want to prepare report using table tag. The report show in next page. The report page open in same window. But I want to open report page in new window. How to open in new window? Please give your suggessions. Thanking you. abglorie

Please give me an example.

The exception is Incorrect syntax near 'S'. Unclosed quotation mark before the character string ''.

I want some idea from your briliant mind. My dout as how to insert or update a string value using sql quries. the string value as Women's Studies Now use this Dim mystring as string = "Women's Studies" MySql = "INSERT into tblName (Dept) values ('" & mystring & "')" or MySql = "UPDATE tblName SET Dept='" & mystring & "' where dept='Womens Studies'" in above quries not working. How to possible it? Please give an example. Thanking you in advance. abglorie

I am new entry in asp.net programming with VB. I did work in VB past two years. Now I want some help from your knowledge. I am creating form with three text box using address typing textbox1 as name textbox2 as address line 1 textbox3 as address line 2 I type name then press enter key. The cursor go to next textbox2. How to made it in this action? In VB do this action using KeyPress event, but how to made in asp.net Please give your suggestions with sample coding. Thanking you, abglorie

Please can you help me, for the following problem solving I want update the string value. The string value is "Women's Studies" Now I am using UPDATE command like Dim MyText as TextBox MyBox = "Women's Studies" MySql = "UPDATE MyTable SET Title='" & MyText & "' Where Title='Womens Studies'" The programme running time display the error message as Incorrect syntax near 'S'. Unclosed quotation mark before the character string How to rectify in above problem? Now I am using Asp.net with VB, and SQL Server Please Help me Thanking you in advance abglorie abglorie