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...



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

Which method do you use to kill explicitly a users session?

0 Answers   MindCracker,


What are the versions of garbage collection?

0 Answers   Proteans,


what is page life cycle state management postback cross page postback types of feilds in gridview gridview events their life cycle cte in sql diff truncate and delete paging concepts in gridview diff bet gridview datalist and repeater what new operations in sql 2005 compared to earlier you get

1 Answers   e4e,


What are runtime hosts?

4 Answers   Microsoft,


Clearly Explain the ispostback

6 Answers   TCS,


Differentiate between authentication and authorization.

0 Answers  


What methods are fired during the page load?

2 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 clr?cts?cls?

4 Answers   e4e, HCL, Microsoft, Tata Communications,


What is loop in asp.net?

0 Answers  


What is web.config and machine.config ?

3 Answers   Collabor, NDPL, TCS,


What is the difference between Postback and Ispostback Property?

7 Answers   Atrocity Apps Technologies, DC Infotech, HCL, Maples, Visual Soft,


Categories