In my code i have 3 tables,i have to insert 3 tables data using single insert

In my code i have 3 tables,i have to insert 3 tables data
using single insert query so that i wrote transations in a
sp.but what my problem is,in those 3 tables i have to
include my empId from another table.when i'm passing values
im getting error at this EmpId.
how can i solve this error to execute insert query?
plesae tell me the solution...

Question Posted / anusha

1 Answers
2915 Views
I also Faced
E-Mail Answers

In my code i have 3 tables,i have to insert 3 tables data using single insert query so that i wrot..

Answer / koundinya

before execute the sp you have to get the empID from other
table then you have to call the sp

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ASP.NET Interview Questions

What is different between webconfig.xml & Machineconfig.xml ?

1 Answers

can i use two web.config files of ConnectionString in One Default.aspx page

6 Answers Satyam, Verinon Technology Solutions, Wipro,

How can you handle unmanaged code exceptions in asp.net?

0 Answers

In what languages in ASP written?

4 Answers Microsoft,

For Web services where you can browse on the Internet?

1 Answers Siebel,

Difference between Dataset and DataReader ?

4 Answers Accenture, BirlaSoft, Infosys, Microsoft, Techseol,

What is the mvc model?

0 Answers

What I need to create and run an asp.net application?

0 Answers

What does the .webpart file do?

0 Answers

You are creating a Web site for Your company. You receive product lists in the form of XML documents. You are creating a procedure to extract information from these XML documents according to criteria that your users will select. When a user makes a request, you want the results of these requests to be returned as quickly as possible. What should you do? A . Create an XmlDataDocument object and load it with the XML dat Use the DataSet property of the object to create a DataSet object. Use a SQL SELECT statement to extract the requested dat B . Create an XmlDataDocument object and load it with the XML data. Use the SelectNodes method of the object to extract the requested data. C . Create an XPathDocument object and load it with the XML data. Call the CreateNavigator method to create an XPathNavigator object. Call the Select method of the XPathNavigator object to run an XPath query that extracts the requested data. D . Create an XmlReader object. Use the Read method of the object to stream through the XML data and to apply an XPath expression to extract the requested data.

1 Answers Syntax Softtech,

What are the different method of navigation in asp.net?

0 Answers

What's the difference between viewstate and sessionstate?

0 Answers

For more ASP.NET Interview Questions Click Here