|
|
Hi, This is ASP.NET Forum. SQL Profiler has nothing to with ASP.NET. Better place to ask Database related question is General Database Forum.
BTW : You can check this, which I wrote few years back
SQL Server Profiler Step by Step[^]
and here is many more,
How to use SQL Server profilerCheers !
Abhijit
Codeproject MVP
|
|
|
|
|
i m sorry...i wanted to post in sql but dint notice i was still in asp.net forum...sorry for the inconvenience...and thanks for providing the links...
|
|
|
|
|
No Problem. Its happened sometimes. Please do it from next time. Let us know if you need any more help. Cheers !
Abhijit
Codeproject MVP
|
|
|
|
|
hi i need to make an entry in the session table once the user logs. need to use web service methods for everything. i ve written a stored prov for login and within that i ve called the session procedure. while running web service method i m getting an error "string or binary truncated. statement has been terminated".
as i couldnt spot the error i tried writing a separate method for session in webservice and tried calling it from login method. i m not getting any error but the entry is not made in the session table.
can anyone help me out?
|
|
|
|
|
|
may i know what was the problem??? i dint ask for the coding too...i just wanted to know where i had gone wrong...
|
|
|
|
|
Didn't read the link that I mentioned ."3.Keep the subject line brief, but descriptive.".Also somthing may be urgent for you not for others.. Cheers!!
Brij
|
|
|
|
|
So, you want to store session information in a table from Web Services ? or any thing else you are expecting ? Can you please rephrase your question. Cheers !
Abhijit
Codeproject MVP
|
|
|
|
|
ya i want to store session information in table from web service
|
|
|
|
|
< Updated Subject >
So, what you have written in your code? Can you please show us the code? Did you debugeed your code? Are you able to access session variable in Web service ? Cheers !
Abhijit
Codeproject MVP
|
|
|
|
|
The length of the value that you are going to put in the column is exceeding the size of the column. Just compare the lentgh of the value with the columns data size.
There is no foolish question, there is no final answer...
|
|
|
|
|
|
What is this ? Cheers !
Abhijit
Codeproject MVP
|
|
|
|
|
And the point of your posting is what? Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
|
%@ Control Language=”C#” ClassName=”RandomImage” %;
is this directive wrong?
wen am specifying this it is giving me a error.
|
|
|
|
|
sowjanya3 wrote: wen am specifying this it is giving me a error.
Please let us know which error are you getting ?Cheers !
Abhijit
Codeproject MVP
|
|
|
|
|
it says that attribute control is not valid attribute of element page
|
|
|
|
|
Hi,
I am creating a new setup page where I am trying to have a user add new setup values. These values have a unique identifier id (like HEAD01, HEAD02 and so forth - which happens to be the primary key in that record) which I have to generate using code.
Here I am trying to use a detailsview object with the New/Update/Delete option.
Here if the user Chooses to Add a new value, I need to determine the next unique identifier for this new value to be added (say HEAD16) by looking at the last generated number in that table and have this new value added in the database. The user should not be able to give this primary key value manually it should be autogenerated by code.
Can you help me on how to do this?
I am using SQLDataSource with Detailsview to add update values.
Rikhav
|
|
|
|
|
Hello -
do you guys know if there are some webservices out there which we can call for getting tracking info for shipped items?
Thx, Laziale
|
|
|
|
|
Nope,
Without limitation, you are not authorized to make the Information available on any web site or otherwise reproduce, distribute, copy, store, use or sell the Information for commercial gain without the express written consent of UPS.
They want you to use their products to do it. See the "Integrate Tracking Tools" section of their tracking page[^]
|
|
|
|
|
Thanks for your answer.
So in order to use the ups tracking code webservice I will need to contact UPS or...?
|
|
|
|
|
Hello,
I have a asp.net website and a C# web page and I am calling a stored procedure to return the email address of the user that is logged in.
I have debugged my code and am presented with the following error message.
Cannot implicitly convert type 'System.Data.SqlClient.SqlParameter' to 'string'
Any assistance you can provide would be much appreciated.
My code for the web page class and my code for the stored procedure are below.
Thank you,
Allison
EmailTo Class
<br />
public class EmailTo<br />
{<br />
public string getEmailTo() <br />
{<br />
<br />
using (System.Data.SqlClient.SqlConnection myConnection = new<br />
System.Data.SqlClient.SqlConnection(ConfigurationManager.<br />
ConnectionStrings["ConnectionString2"].ConnectionString))<br />
{<br />
System.Data.SqlClient.SqlCommand myCommand2 = new System.Data.SqlClient.SqlCommand();<br />
myCommand2.CommandText = "usp_get_email_to";<br />
myCommand2.CommandType = CommandType.StoredProcedure;<br />
myCommand2.Connection = myConnection;<br />
<br />
SqlParameter returnEmail = new SqlParameter("Email", SqlDbType.NVarChar);<br />
returnEmail.Direction = ParameterDirection.ReturnValue;<br />
myCommand2.Parameters.Add(returnEmail);<br />
<br />
<br />
myConnection.Open();<br />
myCommand2.ExecuteNonQuery();<br />
myConnection.Close();<br />
<br />
return returnEmail;<br />
<br />
<br />
}<br />
}<br />
}<br />
<br />
Stored Procedure
<br />
CREATE PROCEDURE dbo.usp_get_email_to<br />
<br />
@Email nvarchar(256),<br />
@UserId uniqueidentifier<br />
<br />
AS<br />
<br />
SET @Email = (SELECT Email FROM aspnet_Membership<br />
WHERE UserId=@UserId)<br />
<br />
<br />
RETURN @Email<br />
GO<br />
<br />
<br />
|
|
|
|
|
ahayw01 wrote: SqlParameter returnEmail = new SqlParameter("Email", SqlDbType.NVarChar);
returnEmail.Direction = ParameterDirection.ReturnValue;
myCommand2.Parameters.Add(returnEmail);
1. parameter should start with '@'
SqlParameter returnEmail = new SqlParameter("@Email", SqlDbType.NVarChar);
2. parameter value is missing - add this below line before adding the parameter to myCommand2
returnEmail.Value = "abc@codeproject.com"
|
|
|
|