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
Thanks in Advance
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?
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 webpageHope you guys can helpThanks in advance!
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.......
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?
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
protected void Authorise(object sender, EventArgs e)
foreach (GridViewRow rowItem in GridView1.Rows)
// gets the Debit Reference number for each row checked
string type = GridView1.DataKeys[rowItem.RowIndex].Values.ToString();
// gets the Debit Error Type Number number for each row checked
string DDIREF = GridView1.DataKeys[rowItem.RowIndex].Values.ToString();
chk = (CheckBox)(rowItem.Cells.FindControl("RowChecker"));
// chk.checked will access the checkbox state on button click event
if (type == "1")
// Message_ltr.Text = type + DDIREF;
// string a = "false";
DataTable dt = this.ExcelToDatatable_dt;
posList = positionList;
foreach (DataRow row in dt.Rows)
string error = "No Error Message";
row["DDIREF"].ToString() // String DDIREF_P
, row["Sortcode"].ToString() // String Sortcode_P