|
How are you trying to debug the stored procedure? I usually just use Query Analyzer to debug stored procedures. Just right click on the stored procedure name in the treeview and click 'debug...'. It will open a dialog box to allow you to enter values for all the parameters, then you click 'Execute' to start debugging.
|
|
|
|
|
hello,
thanks for that but i know it already ,my problem is that when i go for debug it simply execute and not stops for single breakpoint .do u getting my point or not.
Please anybody knowing it...
|
|
|
|
|
Sorry,
Thats why I asked how you were trying to debug; I thought maybe you were tying to use the Visual Studio integrated debugging, which has not always worked well for me. I have never had any problems debugging in Query Analyzer, and I use it for all my stored procedure and trigger debugging.
I hope you can find a solution.
|
|
|
|
|
Sorry sir,
would u tell me which edition of SQL SERVER U HAVE INSTALLED ,i.e; personal,developer,standard,or any other.Is there any setting while installing for debugging stored procedure. Please tell me i am in very much need.
|
|
|
|
|
|
hello,
Actully when i right click on stored procedure after that i click debug then i got a pop up msg telling that,
"sp debugging may not work properly if you logon as 'local system account while sql server is configured ro run as service.You can open event viewer to see details."
"do you wish to continue?"
"yes","no","cancel"
I selected yes but it is simply not debugging.Even i login as 'sa'.Please tell me any other configuration is there or not
|
|
|
|
|
I am using SQL Server 2000 Developer edition. A setup with nothing special selected; I just clicked 'Next' and accepted all the defaults.
|
|
|
|
|
need to filter a dataset to a data view (.RowFilter). I want the functionality of the wild card character "_" which matchs any chartacter once, sometimes "?" is used but in dataset none are supported. Im sure there is a way around this using "%" (Matches any character any number of times) as a wildcard and the "Count()" function which is supported but i cant figure it out. This one is tricky any takers????
The users passes in a string to filter the dataset so i was thinking about using the lengh of this as a parameter in the filter string???????
|
|
|
|
|
Can you specify user account and password with Reporting Service / URL access?
I know you could with Reporting Service Web Service Library:
Dim rs As New ReportingService()<br />
rs.Credentials = System.Net.CredentialCache.DefaultCredentials<br />
'Or<br />
rs.Credentials = New System.Net.NetworkCredential(username, password, domain)<br />
<br />
... configure parameters and stuff...<br />
<br />
'Now, render with credential specified...<br />
result = rs.Render(reportPath, format, historyID, devInfo, parameters, _<br />
credentials, showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs)<br />
but... URL access... not so sure... any pointer? Thanks.
REFERENCE:
1. MSDN - Reporting Service Web Service Library
2. MSDN - ReportingService class - Render Method:
3. MSDN - Reporting Service - URL Access
Norman Fung (c)
|
|
|
|
|
when i use find method of DataRowCollection, it returns DataRow. i need to know the row number of this returned DataRow in the DataRowCollection. but i cant. how should encounter with this DataRow to find that number?
thanks
Rastegar
|
|
|
|
|
There is no IndexOf method either in DataTable.Rows or CurrencyManager.List. If your collection is huge you can use the following function
public int GetIndex(DataRow findRow) {
for (int i = 0; i < _dt.Rows.Count; i++) {
DataRow row = _dt.Rows[i];
if (row == findRow) {
return i;
}
}
return -1;
}
Alomgir Miah
Live Life King Size
|
|
|
|
|
The IndexOf method is available in .NET Framework 2.0.
|
|
|
|
|
dim conn as new oledb.oledbconnection("provider=microsoft.jet.oledb.4.0;user id=admin;data source = f:\emp.mdb")
conn.open()
DIM CMD AS NEW OLEDB.OLEDBCOMMAND("SELECT * FROM EMP",CONN)
DIM ADP AS NEW OLEDB.OLEDBADAPTER(CMD)
DIM DS AS NEW DATASET
DIM DT AS DATATABLE
DIM DR AS DATAROW
ADP.FILL(DS,"EMP")
DT=DS.TABLES("EMP"
DR=DT.NEWROW
DR("EMPNO")=TEMPNO.TEXT
DR("ENAME")=TENAME.TEXT
DR("SAL")=VAL(TSAL.TEXT)
DT.ROWS.ADD(DR)
ADP.UPDATE(DS,"EMP")
ADP.FILL(DS,"EMP")
CAN ANYONE PLEASE GUIDE ME IN THIS CODE, I WANT TO INSERT THE NEW RECORD IN TO THE TABLE
WITHOUT USING THE DATABASE CONTROL. THE ABOVE CODE IS NOT INSERTING THE VALUES INTO THE TABLE. HOW TO INSERT, UPDATE, DELETE RECORDS INTO THE TABLE WITHOUT USING DATABASE CONTROLS IN ADO.NET
|
|
|
|
|
Did you provide an InsertCommand command object for the dataAdapter? (retorical question, clearly you did not, judging from your code). The constructor you used only sets the SelectCommand command object for the dataAdapter. You still need to provide the insert and update ones...
btw YOUR CAPS KEY IS STUCK. THAT MAKES ME THINK THAT YOU ARE SHOUTING, which is rude...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
IMO you should update / insert only with stored procedures.
Here is an example of how I would code an insert statement.
Dim conn As New SqlConnection
conn.ConnectionString = Session("ConnectionString")
Dim cmd As New SqlCommand
cmd.Connection = conn
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "prc_Update_Notation_Types"
Dim Prm1 As New SqlParameter("@Original_Type", SqlDbType.VarChar, 50)
Prm1.Direction = ParameterDirection.Input
cmd.Parameters.Add(Prm1)
Prm1.Value = DBNull.Value
Dim Prm2 As New SqlParameter("@New_Type", SqlDbType.VarChar, 50)
Prm2.Direction = ParameterDirection.Input
cmd.Parameters.Add(Prm2)
Prm2.Value = Me.txtNotationType.Text
Dim Prm3 As New SqlParameter("@Type_Description", SqlDbType.VarChar, 50)
Prm3.Direction = ParameterDirection.Input
cmd.Parameters.Add(Prm3)
Prm3.Value = Me.txtNotationDescription.Text
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
"People who never make mistakes, never do anything."
My blog
http://toddsnotsoamazinglife.blogspot.com/
|
|
|
|
|
That, however, was not the question posted, and your answer sheds no light on the original problem.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
respected members thanks for ur response
one of the member was giving the sugession that we have to provoide the insert command. do you mean that i have to use (INSERT INTO) command of SQL at last to inserst rows to the table. when I use the SQL insert command the data's are getting added. I want to known whether there is any other method of storing data's in to the table without using SQL command or Data contorls to the forms.
i have given one statement DR=DT.NEWROW, this inserts an row is added to the datatable, it means that i am in iserting mode and atlast after moving the values to the datarow, the dataadapter is updated & filled. kindly guide me what showed be the actual procedure to be follwed to insert,update & delete records programatically with out using form controls.
|
|
|
|
|
Hi all
There are two ways to do this; either design the adapter and dataset at design time. If u design it in design time, system will automatically create update, insert & delete command for adapter.
System generated insertcommand for sql adapter :-
INSERT INTO Link_Policy(BatchID, TransNo, BarCodes) VALUES (@BatchID, @TransNo, @BarCodes); SELECT BatchID, TransNo, BarCodes FROM Link_Policy WHERE (BatchID = @BatchID) AND (TransNo = @TransNo)
Otherwise, create the adapter and create each sql command [just like select command] and assign it to adapter.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif) Ammu
|
|
|
|
|
The dataadapter has 4 different command objects, on each for select, update, insert, and delelte. The coinstructor you used creates and initializes the selectCommand object with the Select string you pass it. If it did not, then selection (and Fill) would fail. The other three are left up to you. You can either create them manually as new oledbCommand objects with the desired SQL for the command statement, or wrap the dataadapter in an oledbCommandBuilder, which will build the command objects for you (table must have a primary key for this to work). Alternatively, you can create the adapter in design mode, and add the insert (etc) comannds there.
This example from the MSDN docomentation shows how to use the oledbCommandBuilder:
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(myDataAdapter);
myConn.Open();
DataSet ds = new DataSet();
myDataAdapter.Fill(ds, myTableName);
myDataAdapter.Update(ds, myTableName);
myConn.Close();
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
Hi All,
I execute the following code:
con.Open "server=(local);database=pubs;uid=sa;pwd=apwd;driver=sql server;app=testapp"
MsgBox "Click ok to close connection"
con.Close
Once I all the con.close, it takes approximately 1 minute for the connection to the sql server to be released. I have verified this by doing a sp_who2 in query analyser and by looking at connections in the perf mon.
I am having this problem with C++ using ADO.net via smartpointers, and C# using ado.net. The apps are not using connection pooling, and my simplest test above involves only the above code actually running, i.e. no other apps are running
Can anyone tell me why the connection is so slow to release, and how i can resolve this?
Thanks in advance,
Q
Quintes
|
|
|
|
|
With ADO (both System.Data.Oledb and System.Data.Sql namespaces) connection pooling is active by default, and your connection string does nothing to turn it off.
If you are using SQL server (which your connection string says you are) you should use the SQLClient class rather than the OledbClient. The SQL client is much more performant. See the framework documentation on connection string settings to control the pooling.
I'm not sure why you would want to disable the pooling, since this significantly improves performance on reopening connections with the same connection string...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
hi Rob,
Thanks for the reply.
Its not that I want to disable connection pooling, its just that I've taken it out of the equation. If fact I definitely want pooling.
VB and c++ are using ADO though, so while i understand and agree with you that I should be using the sqlclient class for c#, this doesnt have an effect on the VB and c++ as im using ADO and not ADO.net.
Any other ideas?
Q
Quintes
|
|
|
|
|
I'm confused. Are there 3 different apps, 1 VB (6?), one C++ (VC6?) and one C#?
If not, and all are VS2003 based, then all of them could use SqlClient namespace - VB.Net, C# both have access to this namespace, and C++ does as well through the managed classes (which can be mixed with unmanaged code like MFC if need be).
If they are a mix of legacy and new apps, then the older ones could continue to use ado (your present install must be putting the right stuff in...) and the new C# could move on to the SqlClient namespce stuff which is a different Oledb Provider. All have independant connection pools now anyway (even if the connection strings are the same, they are different processes, so each gets a new pool)...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
guys, not sure why this one isn't working right, but i need to check the db for that info and if it is null push exception 1 if its not then verify the string saved on the table, if that doesn't pass then push exception 2
enclosed is the C# code....
dataConnection.ConnectionString = "user ID=sa; Pwd=password;Initial Catalog=mydb;Data Source=mycomputer";
dataConnection.Open();
dataCommand.Connection = dataConnection;
dataCommand.CommandText = "SELECT password FROM users WHERE username = 'dash' ";
dataReader = dataCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (dataReader.Read())
{
if (dataReader["password"].ToString()!=null)
{
if (dataReader["password"].ToString().Equals("board"))
{
dataReader.Close();
}
else MessageBox.Show("Sorry, unable to verify license at this time \n\r Please try again later, or contact the system administrator.", "Incorrect License");
}
else MessageBox.Show("Sorry, We are unable to verify your license at this time. \n\r Please try again later, or contact the system admin.");
}
PS... I put a space between the user id and password becaues the browser was inputting a smiley!
Dim Beautiful As String
Beautiful = "ignorant"
Label1.Text = "The world is full of " & Beautiful & " people."
Why is common sense such an un-common comodity?
|
|
|
|
|
First, since you are only expecting a single value, I would use ExecuteScalar instead of a DataReader:
dataCommand.Connection = dataConnection;
dataCommand.CommandText = "SELECT password FROM users WHERE username = 'dash' ";
try
{
object o = dataCommand.ExecuteScalar();
if(o == null)
{
...
}
else
{
string thePwd =(string)o ;
if(thePwd.Equals("myPwd"))
{
...
}
}
}
finally
{
dataConnection.Close();
dataConnection.Dispose();
}
....
Note that I did not use ToString() to convert the return value, but instead cast the object to a string. ToString is not strictly a conversion function, but instead returns the 'string representation' of an object. what ToString returns could be different from the 'value' of the object as a string. Also note that your comparison is case sensitive...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
