.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Call SP from SQL server for selected Resultset

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :Sql Server
 

Anyone can help me out for the SP.

I have one SP which is having more then one result set as output.

I want only one 2nd or 3rd result set only as output...

Anybody know the syntax for the same...

 

Thanx in advance...

 

 




View Complete Post


More Related Resource Links

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Call Server Side Code from Javascript in VB.NET

  

Hi

Could anyone give me an example how to call Server Side Function from javascript and then I want to call that javascript function on Button OnClick () Event.


Thanks in Advance

Shabbir



HOW to call FTP Server and get files using DotNet.

  
I  find some information about to connect and get files using below code. http://www.codeguru.com/csharp/csharp/cs_internet/desktopapplications/article.php/c13163 But i would need to call cd(/) directory using SSIS. can anyone help how to resolve this issue.N.Srikanth Reddy

WCF - First call to Callback instance from Server takes considerable time to make it to the client.

  
Hello. There's a performance problem we are facing that we are unable to fix using DuplexChannels. The first call made by the client to the server reaches the server instantly. The first call made by the server to the first client using a Callback proxy will take several seconds to reach the client. All subsequent calls to the client (as well as other clients) will reach and execute instantly. The client connects to the Server using a proxy to IServiceProvision, supplies an instance to an implementation of IClientCallback and calls IServiceProvision.Start(). The server instantly processes the call and makes an asynchronous call to IClientCallback.DoWork(), which takes several seconds to enter the client's DoWork() implementation. The remainder of the execution then runs smoothly. Also, the server will experience such a slowdown only for the very first call of the first client that connects to it. Is it normal for the Callback interface to take so much time to warmup, only on the first call to the first client? Below is the full source code. Thanks for any information you may provide. Cheers Mike Shared Class Library using System.ServiceModel; namespace Test { [ServiceContract(Namespace = "http://test/IService", CallbackContract = typeof(IClientCallback))] public interface IServiceProvision { [OperationContract] void Start(); [OperationContract] void

WCF Basic Http Binding - Two server requests per method call

  
We have a service that uses BasicHttpBinding/Transport Security/Windows Authentication and is hosted in IIS. I have created a unit-test application in VSTS and whenever we test a WCF method, Fiddler records two calls. 1st call - No authorization token is sent. The WCF service returns a 401 error - Unauthorized: Access is denied. Http headers as sent in the request given below. POST http://localhost/AccountScreen.svc HTTP/1.1 Content-Type: text/xml; charset=utf-8 SOAPAction: "IAccountScreen/RetrieveAccountDetails" Host: localhost Content-Length: 243 Expect: 100-continue Connection: Keep-Alive 2nd call - Authorization token is sent and the WCF service returns the expected response. POST http://localhost/AccountScreen.svc HTTP/1.1 Content-Type: text/xml; charset=utf-8 SOAPAction: "IAccountScreen/RetrieveAccountDetails" Authorization: Negotiate Host: localhost Content-Length: 243 Expect: 100-continue I am not able to figure out why there are two calls made to the server in the first place and what is the significance of the first call. Any thoughts?

Issues in GetItemDataSources web service call in 2008 Report Server R2

  
Hi, I'm using Reporting Services web services endpoint ReportService2005.asmx with 2008 report server R2 and I'm facing some issues in getting the data source names for a report definition using the GetItemDataSources web service. The problem is that the data source names returned are different from the names of the actual data sources on the report server. The report has the following data sources: 0 1 _0 _A Data Source And the names returned by the GetItemDataSources for 2008 report server R2 is: AutoGen_0 AutoGen_1 AutoGen__0 AutoGen__A Data_Source When I make the same calls using a 2005 report server, the names returned are the same as that in the report definition. To summarize, only numeric data source names are changed to "Autogen_<number>"(eg. Autogen_0), data source names beginning with "_" are changed to "Autogen_<data source name>"(eg. AutoGen__A)  and spaces are replaced by an "_".   What is the problem for the data source names returned for 2008 report server R2? Or has there been any change in the way in which report server stores the data source names? Thanks, Kulbhushan Singhal.  

call a server side C# method from javascript

  
http://forums.asp.net/t/1591584.aspx Hi friends, can anyone provide me the C# code of the above post answer(pls go to the link)..i didnt understand the VB code... i dont know VB.. my problem also same.. i have a method in a class in App_Code folder... i want to call that method from javascript.. the method takes one parameter which is list box cotrol id... the list box control also available in the same page..   Please can anyone help me on this..

How to the web client credentials to call the server (hosted in IIS 7) database with Integrated Secu

  
I'm dealing with a problem trying to use Windows authentication with IIS 7 in Windows Server 2008. Also i'm using WCF. I have a client application and the server application. The server application manage the user accounts using Active Directory. Everything starts when the client sends its user and password to the server application, which is hosted in the IIS(7), and this application must use the same credentials to authenticate the user in the Active Directory. Also after the user is logged in the application, every request sent to the database must use Windows Integrated Security. I already installed Windows Authentication in the IIS 7, and also I enabled it, (and disabled Anonymous Authentication), also I added authentication mode="Windows" in the server app Web.config. I would like to know: - How can I know which user is running the server application (In other words, which user is doing requests to the database). I forgot to say I can't use the SQL Server Profiler cause I don't have permissions. - If I'm missing something, cause I don't want to have security problems in the application. By the way this website says something about this topic but using another IIS version. http://imar.spaanjaars.com/287/how-do-i-determine-the-security-account-that-iis-uses-to-run-my-web-site

Using SIP make a connection and call in Asterisk Server using c#

  
Hi all,

       I am new to Telecommunication but now my situation is want to use the SIP(Session Initiation Protocol) with Asterisk Server. So some one pls help me that is how i connect with Asterisk server and make a call using the SIP and c#.
Aelvakumar.a

Why call web serivce so slow on windows2003 sp2(or windows server 2008) iis6?

  

my web service reference a ATL COM dll(provide many interface to access MS Sql server).

i create a ATL Activex Control call the web service.

when i test IIS server, the problem appears:

1 when i use win2003 (no server packs). the activex call the web serivce fast, less than 1s.

2 when i use win2003 (sp1).   the activex call the web serivce fast less than 1s.

3 when i use win2003 (sp2).   the activex call the web serivce slow, test the same function will cost more than 3s.

4 when i use win2008. got the result same as 3.

Why ? Can anyone help me?

 

thank u all!
Chinese fairy tale

Call server control from HTML string

  

Hi you guys, is there any way to create a server control from html string, i mean in code behind i have a string like this:

string html = "<asp:CheckBox ID=\"CheckBox1\" runat=\"server\" />";

So how to insert it into aspx page and when the page is rendering, it convert my string as i write it own in the webpage
Hope you guys can help
Thanks in advance!

Make a C# WinForm Call a JS code in a Data server??!!

  
Hi... 
I have a situation as follows:
My company has its Customers Data stored in a server, and we as employees use Internet Explorer to find the data needed through a page that contains some textboxes to supply info to the server and some other textboxes that shows Data retrieved from server. So fro example I put the customerID in a textbox, press the search button near this textbox, and I get the customerName and customerAge and so on in another textboxes in the same webpage. I konw this is done via JavaScripts.

I hope the scene is clear, Now when I need to print a report about certain customer I have to copy/paste every single textbox content to Word individually.

So I know how to export from C# to Word or at least to Excel .., But is it possible to make a C# WinForms App that can read the contents of these textboxes OR call the JS function that is executed when I press the (Search) button shown in the IE WebPage.

I dont know if my question is clear enough but I hope you can help me. Any help would be appreciated.
Thanks in advance

How to call the server method After the Cascading dropdown populated

  

i'm using the Ajax cascading dropdown list it works fine. But how to call the server side after the dropdown list populated....

i don't want to call those method in drop down list index changed because it may cause postback.......


A call to SQL Server Reconciler failed?

  

When I  try to synchronize from the emulator I get the error

Message: "A call to SQL Server Reconciler failed."


Any ideas what has happened?



Setting server UserPrincipleName in a client call SqlClr

  

I'm calling a WCF service from a SQL CLR stored procedure. As a result I cannot use the configuration file generated by svcutil.exe for my SOAP web service. If I run the WCF service under the default .NET account in IIS I'm able to complete the call without difficulty. When I run the WebService under a ServiceAccount I get the following error when I attempt to call the web service from the Sql Clr client:

System.ServiceModel.Security.SecurityNegotiationException: SOAP security negotiation with 'http://sdczeapwdcde09/TestClrService/Service1.svc' for target 'http://sdczeapwdcde09/TestClrService/Service1.svc' failed. See inner exception for more details. ---> System.ComponentModel.Win32Exception: Security Support Provider Interface (SSPI) authentication failed. The server may not be running in an account with identity 'host/sdczeapwdcde09'. If the server is running in a service account (Network Service for example), specify the account's ServicePrincipalName as the identity in the EndpointAddress for the server. If the server is running in a user account, specify the account's UserPrincipalName as the identity in the EndpointAddress for the server.

The config file provides the UserPrincipleName that I need to&n

Inserting Selected Row onto SQL Server Database from GridView

  




protected void Authorise(object sender, EventArgs e)
        {
            CheckBox chk;

            foreach (GridViewRow rowItem in GridView1.Rows)
            {
               // gets the Debit Reference number for each row checked
                string type = GridView1.DataKeys[rowItem.RowIndex].Values[0].ToString();
				// gets the Debit Error Type Number number for each row checked
                string DDIREF = GridView1.DataKeys[rowItem.RowIndex].Values[1].ToString();
 
                chk = (CheckBox)(rowItem.Cells[0].FindControl("RowChecker"));
   
                // chk.checked will access the checkbox state on button click event
                if (chk.Checked)
                {
                  
					 if (type == "1")
					 {
						// Message_ltr.Text = type + DDIREF;
						 string[] posList;
						 //   string a = "false";
						 DataTable dt = this.ExcelToDatatable_dt;

						 posList = positionList;
						 foreach (DataRow row in dt.Rows)
						 {
								 string error = "No Error Message";
								 fn.InsertNewDDIsTemporary_Proc(
										  row["DDIREF"].ToString()                    //  String DDIREF_P
										, row["Sortcode"].ToString()                  //  String Sortcode_P
										, row["AccountNo"].ToString(
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend