get record count from stored procedure without passing DATA back?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Data Controls or Code I'm fairly new to .NET, so bear with me if this question is naive. But do most developers use the VS data controls for connections, adapters, and datasets, or do you write all that code manually? And if you use the controls, how do you wrap your connection and adapter code so that you can easily switch between SQL Server, OLE DB, and ODBC? I've been writing the code manually, and I'm comfortable with that, but I'm wondering whether I'd be more productive using the Visual data controls. Thanks, Steve Murphy Tag: get record count from stored procedure without passing DATA back? Tag: 103927
  - 2
    - need to know the primary key of a table Hi, in order to know the primary key of a table in my dataset, i've the folowing code sql "select * from table1" create a dataadapter with this sql DA fill the dataadapter in a dataset DS DS.Tables(0).PrimaryKey but the expression returns me an empty array, is there any problem? is there another way to get the primary key of a table. I use vb.net and an MSACCESS2000 database. Thanks Tag: get record count from stored procedure without passing DATA back? Tag: 103923
  - 3
    - Copying from DBF into MDB - alternative to ADO method Hi! Currently we are using the following method to copy (or link in this case) a DBF table into an Access database. I'm running into very odd problems with using ADO within .NET and was hoping i could eliminate the need for referencing the ADO libraries by rewriting the code in ADO.NET. Here is a snippet of the original code: connMDB = new ADODB.ConnectionClass(); connMDB.Open( @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + MDBPathAndFileName_ + ";User ID=Admin;Password=", null, null, 0 ); ADOX.Catalog cat = new ADOX.CatalogClass(); cat.ActiveConnection = connMDB; //Create the new table. ADOX.Table tbl = new ADOX.TableClass(); tbl.Name = NewTableName_; tbl.ParentCatalog = cat; //Set the properties to create the link. tbl.Properties[ "Jet OLEDB:Create Link" ].Value = true; tbl.Properties[ "Jet OLEDB:Link Datasource" ].Value = DBFPath_; tbl.Properties[ "Jet OLEDB:Link Provider String" ].Value = "Dbase IV"; tbl.Properties[ "Jet OLEDB:Remote Table Name" ].Value = DBFName_; //Append the table to the tables collection of the catalog. cat.Tables.Append( tbl ); ---------- Does anyone know of an ADO.NET equivalent? Thanks in advance, Charles Tag: get record count from stored procedure without passing DATA back? Tag: 103920
  - 4
    - ARITHABORT.... I have a stored procedure that is being called from ado.net and it is failing with an exception that is related to the option ARITHABORT - 'UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'. This stored procedure works perfectly fine from query analyzer and from enterprise manager in sql server. Is this a problem with ado.net? The database is sql server 2000 with .net framework version 1.1 Cheers in advance Ollie Riches Tag: get record count from stored procedure without passing DATA back? Tag: 103917
  - 5
    - Execute Query on a TOTALLY disconnected DataSet Hi All Is there a way to Execute a query (possibly including two tables and joins) on a totally disconnected dataset. By 'Totally Disconnted' , I mean there is no DB and there is no DBConnection / DBCommand - all the data and structure is in memory. The query is to be used to databind a grid, so some sort of view is needed ( i.e. its not a one time query ). Its like having a mini in-memory DB on the client side and looking for a way to have a view running stored procedure. ( NOTE: DataView's RowStateFilter and DataTables Select might not be helpful in this case ) Thank You rawCoder Tag: get record count from stored procedure without passing DATA back? Tag: 103915
  - 6
    - db file lock problem, permissions help I'm having a problem with my test server where I get the following message when i run a simple test app created in VisualStudio.net: The Microsoft Jet database engine cannot open the file 'E:\WebSites\DamarStone\db\damarstone.mdb'. It is already opened exclusively by another user, or you need permission to view its data. I know i need to change a permission. The question is which one and wher do i find it? thank oyu kes Tag: get record count from stored procedure without passing DATA back? Tag: 103914
  - 7
    - Timeout error when filling an OleDbDataAdapter Hi, In a ReadCommited transaction I update a row 'A' in a table. Before the transaction ends, another transaction is trying to read ANOTHER row 'B' from the same table and fill a dataset using an OleDbDataAdapter but it seems to be locked and I get a timeot error. Using sp_lock I can see that for row 'A' the table is locked in X mode, type KEY (the table and the page are IX locked), for row 'B' the lock is KEY type and S mode and the status is WAIT. If I try to get data from the row 'B' with an OleDbCommand.ExecuteScalar there is no problem (so, as far as I can understand means that the row itself is not locked), but I cannot get the data with and OleDbDataAdapter.Fill. Is it not possible to do that? Thanks -- Message posted via http://www.dotnetmonster.com Tag: get record count from stored procedure without passing DATA back? Tag: 103912
  - 8
    - Null Exception on OleDbDataAdapter.Fill I am getting Null Exception error when I try to fill a dataset. I am providing a value for my parameter so I'm not sure, what's going on. Please see below..... Thanks Dim cmd1 As OleDbCommand = New OleDbCommand cmd1.Parameters.Add("@adate", OleDbType.DBDate) cmd1.Connection = mycnn cmd1.CommandType = CommandType.Text cmd1.CommandText = "SELECT * FROM Mytable WHERE adate = @adate" MsgBox(cmd1.CommandText.ToString) Dim ds As DataSet = New DataSet Dim da As Data.OleDb.OleDbDataAdapter = New Data.OleDb.OleDbDataAdapter da.SelectCommand = cmd1 cmd1.Parameters("@adate").Value = #1/3/2005# Try da.Fill(ds, "Mytable") Catch ex As OleDbException MsgBox(ex.Message) End Try Tag: get record count from stored procedure without passing DATA back? Tag: 103904
  - 9
    - string name = dataSet.GROUP.FindByID_GROUP(id_group).GROUP_NAME invokes NullReferenceException I vant to receive group name by automaticalyy generated function FindByID_GROUP in VS C#. I know, that mentioned function returns string type value. What is wrong with this line? Why this exception occures, altrought I know that argument id_gropu is properly, and I am sure that the value in column GROUP_NAME for this ID exists ??? Tag: get record count from stored procedure without passing DATA back? Tag: 103898
  - 10
    - update a DataSet object with a GridView hi, it seems, that a lot of people have the problem (including me), that isn't possible, to update a dataSet object with a gridview (without a data objet). does anybody knows something about this problem??? thanks. Tag: get record count from stored procedure without passing DATA back? Tag: 103895
  - 11
    - problem of using ACCESS I've written an asp.net application using ACCESS as the database. It works well first. But after a while, I found the application cound not make response to user's request quickly. It seems dead. You couldn't the ASP.NET page. Why? And how to solve the problem. Someone please help me. Here are something about the application: 1. the debug mode has been turned off in the web.config 2. I close opened connections it after I used. 3. I write a class for handling general operation to the ACCESS database like query, insert, update etc. And the all static methods. Tag: get record count from stored procedure without passing DATA back? Tag: 103885
  - 12
    - Three-Tier Application Examples. Where can i find simple Three-Tier Application Examples? Thank you. Tag: get record count from stored procedure without passing DATA back? Tag: 103879
  - 13
    - How to update dataset with multiple tables in C#? I create 2 tables, ParentTable and ChildTable. The row in ChildTable is referenced to ParentTable. But after updated and saved to database, the row in ChildTable doesn't refer to the correct row in ParentTable. You can see the following example to get the problems. Is there any good way to update multiple tables by using SqlDataAdapter.Update()? Thank you /* New Rows in ParentTable and ChildTable * * ------ParentTable------ * ID Animal * 1 Cat * * * ------ChildTable------ * ID NAME ParentID * "1 small cat 1" */ /* * But after the new rows saved back to the database, the new rows saved wrongly as: * * ------ChildTable------ * ID NAME ParentID * 1 small bird 1 * 2 small dog 2 * 3 small cat 1 =====> The ParentID doesn't dynamically change to 3 but keep the same as 1. * This makes it doen't reference to the correct row in ParentTable */ ------------------------------------------------------------------------------------ I try to use 2 different ways to update tables. But they both result in the same problem. The first way I use is to follow the update sequence recommended by book: adapter1= new SqlDataAdapter("Select * from ChildTable", con); SqlDataAdapter adapter2= new SqlDataAdapter("Select * from ParentTable", con); SqlCommandBuilder sb = new SqlCommandBuilder(adapter1); SqlCommandBuilder sb1 = new SqlCommandBuilder(adapter2); adapter1.Update(NewDataSet.Tables["ChildTable"].Select(null, null, DataViewRowState.Deleted)); adapter2.Update(NewDataSet.Tables["ParentTable"].Select(null, null, DataViewRowState.Deleted)); adapter2.Update(NewDataSet.Tables["ParentTable"].Select(null, null, DataViewRowState.ModifiedCurrent)); adapter2.Update(NewDataSet.Tables["ParentTable"].Select(null, null, DataViewRowState.Added)); adapter1.Update(NewDataSet.Tables["ChildTable"].Select(null, null, DataViewRowState.ModifiedCurrent)); adapter1.Update(NewDataSet.Tables["ChildTable"].Select(null, null, DataViewRowState.Added)); ------------------------------------------------------------------------------------- The 2nd way is to use 2 SqlDataAdapter seperately to update tables, but still get the same problem : The Child table row "3 small cat 1" is wrong adapter1= new SqlDataAdapter("Select * from ChildTable", con); SqlDataAdapter adapter2= new SqlDataAdapter("Select * from ParentTable", con); SqlCommandBuilder sb = new SqlCommandBuilder(adapter1); SqlCommandBuilder sb1 = new SqlCommandBuilder(adapter2); adapter1.Update(NewDataSet.Tables["ChildTable"]); adapter2.Update(NewDataSet.Tables["ParentTable"]); Please refer to the UpdateTableMethod1() and UpdateTableMethod2() in the codes I provide. ------------------------------------------------------------------------------------ I just put some codes on the website. If you are also interested, you can just copy-paste the code on your file and run it. This code would generate 2 tables and insert content to the tables in NorthWindCs database in MsSql server. Please change the connection string to yours. using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; namespace UpdateMultipleTables { /// <summary> /// Summary description for Form1. /// </summary> public class Form1 : System.Windows.Forms.Form { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.Container components = null; private System.Windows.Forms.DataGrid dataGrid1; //private conStr = "Server=Local; SSPT = true; "; private string conStr = "server=Local;User ID=sa; PWD=hello;database=NorthWindCs"; SqlDataAdapter adapter1 ; SqlConnection con ; private DataSet NewDataSet; public Form1() { InitializeComponent(); //Create the connection to DataBase CreateConnection(); //Create tables "ParentTable" and "ChildTable". And Insert content to the 2 tables CreateDB(); //Create a new row in both ParentTable and ChildTable CreateNewRow(); //I try 2 ways to update the tables. But both of them gave me the same problem, //The new row in "ChildTable": is WRONG! //UpdateTable1Method1(); UpdateTableMethod2(); } public void CreateConnection() { con = new SqlConnection(conStr); } //Create tables "ParentTable" and "ChildTable". And Insert content to the 2 tables public void CreateDB() { string commandText = "if exists (select * from NorthwindCS.dbo.sysobjects where name like 'ParentTable') "+ "Begin " + "DROP TABLE ParentTable "+ "CREATE TABLE ParentTable( ID INT IDENTITY(1,1) NOT NULL , Animal VARCHAR(40) NOT NULL ) "+ "INSERT INTO ParentTable( Animal) values('Bird') "+ "INSERT INTO ParentTable( Animal) values('Dog') "+ "END "+ "ELSE "+ "Begin "+ "CREATE TABLE ParentTable( ID INT IDENTITY(1,1) NOT NULL , Animal VARCHAR(40) NOT NULL ) "+ "INSERT INTO ParentTable( Animal) values('Bird') "+ "INSERT INTO ParentTable( Animal) values('Dog') "+ "END "+ "IF exists (select * from NorthwindCS.dbo.sysobjects where name like 'ChildTable') "+ "Begin "+ "DROP table ChildTable "+ "CREATE TABLE ChildTable( ID INT IDENTITY(1,1) NOT NULL , Name VARCHAR(40) NOT NULL , ParentID INT Not NULL) "+ "INSERT INTO ChildTable( Name, ParentID) values('small bird', 1) "+ "INSERT INTO ChildTable( Name ,ParentID) values('small dog', 2) "+ "END "+ "ELSE "+ "BEGIN "+ "CREATE TABLE ChildTable( ID INT IDENTITY(1,1) NOT NULL , Name VARCHAR(40) NOT NULL , ParentID INT Not NULL) "+ "INSERT INTO ChildTable( Name, ParentID) values('small bird', 1) "+ "INSERT INTO ChildTable( Name ,ParentID) values('small dog', 2) "+ "END "; adapter1 = new SqlDataAdapter(commandText, con); try { DataSet ds = new DataSet(); adapter1.Fill(ds); dataGrid1.DataSource = ds; } catch(Exception e) { Console.WriteLine(e.Message); } } /* New Rows in ParentTable and ChildTable * * ------ParentTable------ * ID Animal * 1 Cat * * * ------ChildTable------ * ID NAME ParentID * "1 small cat 1" */ /* * But after the new rows saved back to the database, the new rows saved wrongly as: * * ------ChildTable------ * ID NAME ParentID * 1 small bird 1 * 2 small dog 2 * 3 small cat 1 =====> The ParentID doesn't dynamically change to 3 but keep the same as 1. * This makes it doen't reference to the correct row in ParentTable */ //Create a new row in both ParentTable and ChildTable public void CreateNewRow() { //carete data in parent table NewDataSet = new DataSet("NewDataSet"); DataTable ParentTable = new DataTable("ParentTable"); DataColumn dc = new DataColumn("ID", typeof(int)); dc.AutoIncrement = true; dc.AutoIncrementSeed = 1; dc.AutoIncrementStep = 1; ParentTable.Columns.Add(dc); dc = new DataColumn("Animal", typeof(string)); ParentTable.Columns.Add(dc); NewDataSet.Tables.Add(ParentTable); DataTable ChildTable = new DataTable("ChildTable"); dc = new DataColumn("ID", typeof(int)); dc.AutoIncrement = true; dc.AutoIncrementSeed = 1; dc.AutoIncrementStep = 1; ChildTable.Columns.Add(dc); dc = new DataColumn("Name", typeof(string)); ChildTable.Columns.Add(dc); dc = new DataColumn("ParentID", typeof(int)); ChildTable.Columns.Add(dc); NewDataSet.Tables.Add(ChildTable); // DataRelation relation = new DataRelation("ParentChildRelation" , ParentTable.Columns["ID"], ChildTable.Columns["ParentID"], true); // NewDataSet.Relations.Add(relation); DataRow dr = NewDataSet.Tables["ParentTable"].NewRow(); dr["Animal"] = "Cat"; NewDataSet.Tables["ParentTable"].Rows.Add(dr); //carete data in child table dr = NewDataSet.Tables["ChildTable"].NewRow(); dr["Name"] = "small cat"; dr["ParentID"] = NewDataSet.Tables["ParentTable"].Rows[0]["ID"]; NewDataSet.Tables["ChildTable"].Rows.Add(dr); dataGrid1.DataSource = NewDataSet; } //This update method followed by the recommended sequence of updateing tables in Oreilly book. But it doesn't solve //my proble. The Child table row "3 small cat 1" is wrong public void UpdateTableMethod1() { try { adapter1= new SqlDataAdapter("Select * from ChildTable", con); SqlDataAdapter adapter2= new SqlDataAdapter("Select * from ParentTable", con); SqlCommandBuilder sb = new SqlCommandBuilder(adapter1); SqlCommandBuilder sb1 = new SqlCommandBuilder(adapter2); adapter1.Update(NewDataSet.Tables["ChildTable"].Select(null, null, DataViewRowState.Deleted)); adapter2.Update(NewDataSet.Tables["ParentTable"].Select(null, null, DataViewRowState.Deleted)); adapter2.Update(NewDataSet.Tables["ParentTable"].Select(null, null, DataViewRowState.ModifiedCurrent)); adapter2.Update(NewDataSet.Tables["ParentTable"].Select(null, null, DataViewRowState.Added)); adapter1.Update(NewDataSet.Tables["ChildTable"].Select(null, null, DataViewRowState.ModifiedCurrent)); adapter1.Update(NewDataSet.Tables["ChildTable"].Select(null, null, DataViewRowState.Added)); } catch(Exception e) { Console.WriteLine(e.Message); } } //I try to use 2 SqlDataAdapter to update tables, but still get the same problem : The Child table row "3 small cat 1" is wrong public void UpdateTableMethod2() { try { adapter1= new SqlDataAdapter("Select * from ChildTable", con); SqlDataAdapter adapter2= new SqlDataAdapter("Select * from ParentTable", con); SqlCommandBuilder sb = new SqlCommandBuilder(adapter1); SqlCommandBuilder sb1 = new SqlCommandBuilder(adapter2); adapter1.Update(NewDataSet.Tables["ChildTable"]); adapter2.Update(NewDataSet.Tables["ParentTable"]); } catch(Exception e) { Console.WriteLine(e.Message); } } /// <summary> /// Clean up any resources being used. /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.dataGrid1 = new System.Windows.Forms.DataGrid(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.SuspendLayout(); // // dataGrid1 // this.dataGrid1.DataMember = ""; this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Location = new System.Drawing.Point(16, 24); this.dataGrid1.Name = "dataGrid1"; this.dataGrid1.Size = new System.Drawing.Size(496, 216); this.dataGrid1.TabIndex = 0; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(560, 294); this.Controls.Add(this.dataGrid1); this.Name = "Form1"; this.Text = "Form1"; ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.ResumeLayout(false); } #endregion /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main() { Application.Run(new Form1()); } } } *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: get record count from stored procedure without passing DATA back? Tag: 103874
  - 14
    - NullReferenceException in call to DataTable Select I'm trying to use the Select() method on a DataTable but I'm getting a NullReferenceException. Here's the stack trace: at System.Data.Select.Evaluate(Int32 record) at System.Data.Select.FindFirstMatchingRecord() at System.Data.Select.GetBinaryFilteredRecords() at System.Data.Select.SelectRows() at System.Data.DataTable.Select(String filterExpression, String sort) I've found a work-around but I can't explain why it works. The work around is to call the Select() method once first without a filter argument, then to call it again with the actual filter argument you're interested in. Like this: DataRow[] records = ds.Tables["MyTable"].Select("", "C1, C2, C3, C4, C5, ID"); //note the empty string as the filter records = ds.Tables["MyTable"].Select(myFilter, "C1, C2, C3, C4, C5, ID"); //myFilter contains the actual filter value And for some reason the sorting string to the first Select() call has to be the same string that's used in the second Select() call. So doing this wouldn't work: DataRow[] records = ds.Tables["MyTable"].Select(""); records = ds.Tables["MyTable"].Select(myFilter, "C1, C2, C3, C4, C5, ID"); The reason I discovered this work-around is that if you copy and paste the entire call to the Select() method into one of the debugger watch windows, you'll get a message stating the same null reference exception as the value of the expression. But if you replace the filter with "" in the Select() call in the watch window, it will return the correct result as the expression value. Then if you step through the actual code it works (it doesn't throw the exception)! It's like the DataTable needs to be re-initialized before you can call the Select() method, even if you do it in the debugger watch window. Does anyone have any ideas about what's going on here? Thanks, Dave Tag: get record count from stored procedure without passing DATA back? Tag: 103868
  - 15
    - Like keyword Hi Group I have one column which can be either Null or with some value. I have one filter criteria in From End with "All", 'RTF Yes' and 'RTF No'. Depending on the filter selected by user i have to select the pertaining rows as below If Filter "All" select all rows from table if Filter = 'RTF yes' select only rows where 'RTF yes' in rows ( where columns in not null ) if Filter = 'RTF No' select only rows where column is null how can i put this into where clause. Please advice. Thanks Pat.... Tag: get record count from stored procedure without passing DATA back? Tag: 103863
  - 16
    - Optimizing multiple rows storing into Access 2003. Need Help! Hi I am looking for a way to optimize my data storing into an Access 2003 Table (the mdb file I am using is Access 2000 version) oleDbDataAdapter seem to write one row at time even if it receives multiple rows I tried this code below CalBackFunc() <- My call back func is called every second approx { ...... TypedDataSet1.Merge(?? ) //<- My main dataset in updated here if(CycleCount>20) { CycleCount=0; //<- Every 20 times I make an update into the //- database to reduce the I/O stuff MyDt=new MyTypedDataSet(); MyDt.Merge(TypedDataSet1.MyTable1.GetChanges()); <- I copy //the new data here TypedDataSet1.MyTable1.AcceptChanges(); oleDbDataAdapter1.Update(MyDt.MyTable1); <-I make my storing into the database here with 20 rows each time } } This don't seem to work as I want it; I am looking if there is an auther way to store multiple rows in the same time into Access database. Maybe like storing into an xml file and periodically store it back to the database in one shot. Could some one tell me how can I optimize this kind of storing, it would be very healpful. Thanks a lot Yachea Tag: get record count from stored procedure without passing DATA back? Tag: 103861
  - 17
    - Re: DataAdapter problems... OK I have made a little progress on this.... Seems I was missing: dataset.Tables[0].AcceptChanges(); However, this alone did not fix it.... I needed to manually assign the value from the 'bound' textbox, by doing... dataset.Tables[0].Rows[0]["Name"]=boundtextbox.Text.ToString(); This seems odd to me... as the textbox appears bound to the datatable, but when I change the value, it doesn't seem to be writing back properly.... although a MessageBox.Show(dataset.Tables[0].Rows[0]["Name"].ToString()); shows the correct value... it doesn't have the same (required) effect until I specifically assign the value in code. Can anyone help?? Thanks "Paul Aspinall" <paul@aspy.co.uk> wrote in message news:... > Hi > I have a dataset which consists of a datatable. > > I make changes to the data in the datatable, via the use of a bound > textbox. When debugging, I output the value of: > > dataset.Tables[0].Rows[0]["Name"].ToString() > > and this reflects the correct value that I want. However, the dataadapter > does not seem to recognise the change, and doesn't update the underlying > table back to the DB. > > > > However, if I specifically set the value of the DB, via > > dataset.Tables[0].Rows[0]["Name"]="aaaaa"; > > then all seems to work fine..... > > > > Any ideas?? > > > > Thanks > > > > Tag: get record count from stored procedure without passing DATA back? Tag: 103860
  - 18
    - DataAdapter problems... Hi I have a dataset which consists of a datatable. I make changes to the data in the datatable, via the use of a bound textbox. When debugging, I output the value of: dataset.Tables[0].Rows[0]["Name"].ToString() and this reflects the correct value that I want. However, the dataadapter does not seem to recognise the change, and doesn't update the underlying table back to the DB. However, if I specifically set the value of the DB, via dataset.Tables[0].Rows[0]["Name"]="aaaaa"; then all seems to work fine..... Any ideas?? Thanks Tag: get record count from stored procedure without passing DATA back? Tag: 103858
  - 19
    - SQL Server Error Trapping in ASP/ASP.NET I've run into an odd bit of behavior when dealing with SQL Server 2000 and ASP/ASP.NET that I wanted to discuss. The issue I encounter is that in a stored procedure, once a SELECT statement succeeds and returns a recordset, all resulting errors are ignored by ASP/ASP.NET in certain cases (see details below). Wouldn't you expect the ADO/ADO.NET command to fail if the procedure it calls fails? For example, I created a simple stored procedure that is meant to fail after successfully returning a recordset. -------------------------------------------------------------------------- CREATE PROCEDURE spt_TestSqlErrors @ErrMsg VARCHAR(255) = '' OUTPUT AS --SUCCEEDS returns a recordset SELECT 'Test' AS FirstName, 'User' AS LastName --SUCCEEDS but does not return a recordset DECLARE @SelectResults VARCHAR(255) SELECT @SelectResults = FirstName FROM tblUsers WHERE UserID = 12345 --SUCCEEDS but updates 0 records UPDATE tblPerson SET ID=0 WHERE 1=0 --FAILS divide by zero SELECT 12/0 AS DivisionError --SUCCEEDS and raises an error SET @ErrMsg = 'Error Message.' RAISERROR(@ErrMsg, 16, 1) WITH LOG GO -------------------------------------------------------------------------- With ASP.NET Command.ExecuteNonQuery - will return an error (Divide By Zero) Command.ExecuteDataReader - will not return an error (Divide By Zero) Adapter.Fill - will return an error (Divide By Zero) With ASP Command.ExecuteNonQuery - err object does not register an error Recordset.Open - err object does not register an error Use whatever hypothetical situation you like to explain why a stored procedure would return multiple recordsets and would raise an error if the second recordset didn't exist. Wouldn't you expect the DivideByZero or Raiserror to roll up to ASP and ASP.NET in all situations and not be ignored by the ExecuteDataReader or by ASP completely? What do you think? Paul Tag: get record count from stored procedure without passing DATA back? Tag: 103852
  - 20
    - Lock tables during SELECT I am doing a transfer operation from one database to another. During that time, I want to lock some tables so no new data can be written. How can I do this ? -- incognito...updated almost daily http://kentpsychedelic.blogspot.com Texeme Textcasting Technology http://texeme.com Tag: get record count from stored procedure without passing DATA back? Tag: 103851
  - 21
    - vb.net version 1.1 Can't connect to SQL server2000 on a server. Can someone tell me why I can't use the data adapter to SQL server 2000 on my server using vb.net 1.1? When I try from my workstation, I get a good test connection message, but then VB will tell me the following message "Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine Database with this version of Visual Studio." Can someone tell me how to get around this, or what I need to buy to enable this data connection? Thanks a lot for any help. Tag: get record count from stored procedure without passing DATA back? Tag: 103850
  - 22
    - TableMappings Hi, I got a problem by putting 3 SELECT statements in one DataAdatper. I try to build a 'Select' DataAdatper, which only has select command. I put following lines in select commandtext Select * from Orders; Select * from OrderProducts; Select * from Products; I use DataAdapter wizard. DataAdapter wizard will generate 3 tables automatically like Table, Table1, Table2. Then I go to set table mappings like Table --> Orders, Table1-->OrderProducts, and Table2 ---> Products. It seems work find until I try to remove 2nd select. After I remove 2nd Select, my table mappings are all messed up, Table-->Orders, Table1-->OrderProducts. It is wrong. I thought if I remove 2nd Select, 2nd tab mapping should be remove too. In fact, I am wrong. So my question is how to let TabMappings be synchronized when a Select commad is removed. Thanks ! fei Tag: get record count from stored procedure without passing DATA back? Tag: 103848
  - 23
    - Cannot Create a Dataset for an OLEDB DataAdapter Hello, I have an OLEDB DataAdapter and cannot create a Dataset to use with the adapter because the SelectCommand contains a parameter. Is there a work around for this? Any Help is appreciated. Thank You Tag: get record count from stored procedure without passing DATA back? Tag: 103847
  - 24
    - Error while using Scope_Identity() instead of @@identity. WHY? Hello everyone, I am trying to get back the primary key and was using @@identity without any problem. However, when I use scope_identity() I get the following error. "Cast from type 'DBNull' to type 'Integer' is not valid." Please help. Thanks Tag: get record count from stored procedure without passing DATA back? Tag: 103846
  - 25
    - Error joining tables from separate db's using SqlCommand object I'm trying to run a query that joins tables from 2 databases on the same server. The query is like this: SELECT TitleID, u.Name as Assignee FROM tblTitle t LEFT JOIN titlepost..Portal_Users u ON t.TitleProcessor = u.email When I put it in a stored procedure and execute the sp using SqlCommand object, there are no problems. But I need to be able to run this query using the CommandText property rather than by calling a stored procedure. When I attempt this, I get "Invalid object name 'titlepost.dbo.PortalUsers'". My connection string is "server=10.10.10.10;Trusted_Connection=true;database=abstractors" Any suggestions are appreciated. Corbin Tag: get record count from stored procedure without passing DATA back? Tag: 103843
- Next
  - 1
    - Constructing a Dataset from XML I have an XML file I've created in another application that contains information on files, forms, and job header. My plan is, in my new "consumer" app, to read in this data and work with it, ultimately producing labels for shipping, etc. My planned approach is to construct a Dataset with 3 DataTables from this data: One table for job header; one table for form info; and one table for specific records. Then I want to set up one-to-many relations from the top, down. It's probably the SQL Server programmer in me that I'm taking this approach, am I overthinking it? Should I just stick with a flat DataTable? Would a collection be a better choice? What benefits will I get from the DataRelations? If I set up a DataGrid on my form, can I easily display, say, Job Number | Form Code | Record Filename, etc.? In other words, if I'm not creating a database on some other server, do I benefit by going to the trouble of normalizing the data in this way? I'd appreciate any comments. -- Michael Kellogg Tag: get record count from stored procedure without passing DATA back? Tag: 103835
  - 2
    - ASP.NET Connection String Hello, I have successfully been using the following connection string to connect via a SQLConnection object in my ASP.Net application for many weeks: Data Source=MARS-TEST;Initial Catalog=CascadeWMCClient;UID=marsweb;PWD=marsweb Today, after our Network Support Technician added a hard drive to the machine, I can no longer connect to the machine via an ASP.Net application on my development PC. When I attempt to do so, I get this error: SQL Server Does Not Exist Or Access Denied. I am using the same connection string on our Web Server, and this will connect fine, using the same connection string. Can anyone explain the likely cause for the error above? It seems odd that this has only occurred since the machine was rebooted? Tag: get record count from stored procedure without passing DATA back? Tag: 103834
  - 3
    - copy datatables between datasets.. How do I copy a table from one dataset to another ? code I am using and that is not working : dataset2.tables.add(dataset1.tables(tablename)) Please help me. prashant Tag: get record count from stored procedure without passing DATA back? Tag: 103832
  - 4
    - Use data designers in non-visual component Is there any way of using the ADO data wizards in a non-visual component? If you create a "web service" project, you drag ADO components onto a designer and use wizards, but I can't work out how to do this with a standard class library. Cheers. Tag: get record count from stored procedure without passing DATA back? Tag: 103830
  - 5
    - Create a parameter for the oledb data adapter Hello, Is it possible when configuring an OLEDB DataAdapter, using the Query Builder, to specify parameters? I've tried placing =@parametername in the criteria section of the Query Builder, but this seems to always gerenate errors and then the Datasets won't fill. The datasource is a set of Visual Fox Pro tables. Any help is appreciated. Thank you Tag: get record count from stored procedure without passing DATA back? Tag: 103826
  - 6
    - Why does first reader.Read take all time in stead of command.ExecuteReader? Hi All, I am using CoreLab.Oracle.dll (2.40.2.0) to access an Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production server. In C#, I am using CoreLab classes to access the database. Typically, I create a command object of CommandType StoredProcedure and open a reader on it. The Procedure returns a ref cursor. I am surprised to see that the command.ExecuteReader() takes little time (e.g. 0.1 s) to complete, while the first reader.Read() takes much more time (e.g. 10 s). In fact, if I execute the procedure some other way (SQL editor in Toad), execution time is comparable to the time reader.Read takes. I do not think that command.ExecuteReader works asynchronously, since putting the thread to Sleep for 10 seconds does not help reader.Read to complete faster. Does anybody know why this is so? Also, how does this combine with the Command.Cancel method? I cannot execute command.Cancel while reader.Read is working. How could I use command.Cancel properly? See below for details. Thanks in advance, Roel Schreurs // Sample code OracleDataReader reader = null; OracleConnection conn = new OracleConnection("<ConnectionString>"); conn.Open(); OracleCommand command = conn.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "<Package>.<Procedure>"; OracleParameter parameter = command.CreateParameter(); parameter.OracleDbType = OracleDbType.RefCursor; parameter.ParameterName = "<CursorVariable>"; parameter.Direction = ParameterDirection.Output; command.Parameters.Add(parameter); Debug.WriteLine("Starting ExecuteReader at " + System.DateTime.Now.TimeOfDay); reader = command.ExecuteReader(); Debug.WriteLine("Finished ExecuteReader at " + System.DateTime.Now.TimeOfDay); //Optional Thread.Sleep(10000); Debug.WriteLine("Starting first Read at " + System.DateTime.Now.TimeOfDay); while (reader.Read()) { Debug.WriteLine("Finished Reading at " + System.DateTime.Now.TimeOfDay); } -- Results: Starting ExecuteReader at 15:07:58.063 Finished ExecuteReader at 15:07:58.188 0.125 Starting first Read at 15:07:58.203 0.016 Finished first Read at 15:08:07.922 9.719 Starting ExecuteReader at 15:04:27.859 Finished ExecuteReader at 15:04:27.984 0.125 Starting first Read at 15:04:38.000 10.016 Finished first Read at 15:04:47.688 9.688 Tag: get record count from stored procedure without passing DATA back? Tag: 103823
  - 7
    - Copying a table in ADO.net and the pesky identity column I am finding problems in trying to copy a databse table from one SQL 2000 server to another using ADO.net. However the source table has an identity column and I need to preserve the values in the destination table. Obviously every time I run the below code the destination table does not have the correct identity column. For Each objDataRow In dsSource.Tables(0).Rows With dsDest.Tables(0) objDBRow = .NewRow() For Each c In .Columns objDBRow(c.ColumnName) = objDataRow(c.ColumnName) Next .Rows.Add(objDBRow) End With ObjCmdBuilder = New SqlCommandBuilder(objAdapter) objAdapter.Update(dsDest, tablename) Next What is the best approach in acheiving this? Bear in mind that the two SQL servers cannot talk to each other so that I cannot use sp_addlinkedserver and use a stored procedure. Am I going about this incorrectly? Thanks Rippo *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: get record count from stored procedure without passing DATA back? Tag: 103818
  - 8
    - Multi DB. And now? Hi all, That is a really bad, bad question, but some of us have problem with a application with more than one DB. Anyone here dev. the same app. for more than one DB? Why the best solution in the ADO.NET for that, thinking in time and cost, of course. In my case, for example, I have a app. that work only by webservices and should be installed in many bases, like SQL Server, Oracle and PosgreSQL. That's a fruit salad!! :-) Tag: get record count from stored procedure without passing DATA back? Tag: 103814
  - 9
    - Removing row pointed to by bound combo Hi I have a combo which is bound to a datatable. I want to remove the record from the datatable, which the combo points to. Can anyone confirm the correct syntax.... I believe it will be something like datatable.Rows.Remove(.......??how do I find the row that is bound to the combo??); Thanks Tag: get record count from stored procedure without passing DATA back? Tag: 103809
  - 10
    - Correct syntax for pasing a SELECtT statement in a string What is the correct syntax for passing a select statement via the Reader. The following code doesn't return anything. Dim strSQL2 As String = "SELECT * from ATable WHERE ' " & ComboBox1.Text & " ' = ' " & TextBox1.Text & " '" Dim cmd As New OleDbCommand(strSQL2, Conn) Dim rdr As OleDbDataReader rdr = cmd.ExecuteReader ListBox1.Items.Clear() ListBox1.Items.Add("") While rdr.Read ListBox1.Items.Add(rdr("Col_One") & " " & rdr("Col_Two") & " " & rdr("Col_Three") & " " & rdr("Col_Four")) End While rdr.Close() Thanks -- Gordon Tag: get record count from stored procedure without passing DATA back? Tag: 103798
  - 11
    - MyGeneration for .NET (100% Free Code Generator / OR Mapper) MyGeneration is 100% free, tired of hand coding business objects, stored procedures, spend your time wisely doing other thing and let us help you. See http://www.mygenerationsoftware.com 1) MyGeneration is a Template Based Code Generator Supporting Four Template Languages - JScript, VBScript, C# and VB.NET 2) Ability to Create Your Own Embedded User Interface in your Templates 3) Supported ORM Architectures - Gentle.NET, Opf3, NHibernate 4) MyGeneration dOOdads Architecture Included for Both C# and VB.NET (See Menu) 5) Support for 11 Different Database Systems. Microsoft SQL, Oracle, IBM DB2, MySQL, PostgreSQL, Microsoft Access, FireBird, Interbase, SQLite, VistaDB, and Advantage. 5) Online Template Library for Publishing and Downloading Templates 6) Very Active Support Forums 7) No Hassle, No Questions asked Download Tag: get record count from stored procedure without passing DATA back? Tag: 103797
  - 12
    - Web service on two tables Please could anyone show me how to create a web service which accesses and updates information in two tables. I have seen examples in MSDN based on one table but these fail when using the DataAdapter Config Wizard tries to join two tables. Many thanks Tag: get record count from stored procedure without passing DATA back? Tag: 103795
  - 13
    - Synchronize Question I have a situation where I have read only access to an Access database. I need to query the database and insert the rows retrieved into my own database. However there is no gaurantee that the original query won't return rows that I've already inserted into my own database. So my question is what is the best way to handle the situation? Just trap the errors when the insert fails? Query my own database for primary keys and then discard those rows from the original query? Check each row of the original query for existance in my own database before attempting to insert? This is a desktop application which is basically single user so performance isn't of the utmost priority. I'm basically looking for a best practice approach to this problem. Thanks Slonocode Tag: get record count from stored procedure without passing DATA back? Tag: 103793
  - 14
    - OracleDataAdapter filling Dataset with duplicate rows Hi, I am using OracleDataAdapter to fill my DataSet. I am using Select Distinct in my sql querry to get unique recored. I am getting duplicate rows in DataSet. My SqlPlus shows only one row of Data. When I execute the code to fill DataSet My DataSet.tables[0]. rows.count gives me count of 2. When I loop through DataSet to display Values I am getting same values twice. Anyone has any suggestion on how to get distinct rows in dataSet. Thanks in Advance, MS Tag: get record count from stored procedure without passing DATA back? Tag: 103792
  - 15
    - Error: "System.Data.OleDb.OleDbException: No value given for one or more required parameters" I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I don't think I made any changes to either page other than changing the user control that creates the header). Server Error in '/myApp' Application. ---------------------------------------------------------------------------- ---- No value given for one or more required parameters. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters. Source Error: Line 721: Line 722: myDataAdapter.SelectCommand.Parameters("Thing_ID").Value = CInt(Session("Thing_ID")) Line 723: m_intNum1 = myDataAdapter.Fill(myDataSet1, "Thing") Line 724: ---------------------------------------------------------------------------- ---- I'm not having any other data access problems in the application - other pages do lookups to populate drop down lists, and I can add records to other tables in the database. I've checked the table that the code in question is trying to read, and it seems to be fine. I've debugged it, and the value of the parameter (which is the only parameter for that command) IS set and it IS an integer, which is the type of the parameter. It seems that the problem is NOT because of the value of the parameter, but something else - does anyone have any ideas? Tag: get record count from stored procedure without passing DATA back? Tag: 103790
  - 16
    - ORA-01461 while moving data from sqlserver to oracle I worte a conversion program which moves all data from SqlSrv to Oracle, using the OracleClient and SqlClient classes of .Net. Now when a column has 2001 characters or more I get this error. I've read a lot of it, but I do not fully understand what is wrong, and more important, how it can be solved. I know a lot about SqlServer, but very little about Oracle. I am using a standard SqlDataAdapter, and a OracleDataAdapter. I am using the OracleCommandBuilder to generate the Oracle insertcommand. The conversion method is very straightforward and simple: I open a SqlDataAdapter with a 'Select * from Table' command, and an OracleDataAdapter with the same command. I fill two Datatables using this two adapters, which results in a filled datatable from the sqlserver db, and an empty datatable from the oracle db. Then I simply move all data from the first table to the second, and then I execute the Update methode of the OracleDataAdpater. As said, this is working properly for 99,9% of my database. Only strings with a length of >2000 will fail with the Oracle ORA-01461 exception....:-( Dim strSelect = "selectr * from test" Dim sqlC as new SqlConnection(sqlConnectionString) Dim sqlDa as new SqlDataAdapter(strSelect, sqlC) Dim oraC as new OracleConnection(oraConnectionString) Dim oraDa as new OracleDataAdapter(strSelect, oraC) Dim oraCB as new OracleCommandBuilder(oraDa) Dim sqlDt as new Datatable sqlDa.Fill(sqlDt) Dim oraDy as new DataTable oraDa.Fill(oraDt) Dim oraRow as Datarow For Each sqlRow as Datarow in sqlDt.Rows oraRow = oraDt.NewRow For i as Integer = 0 To sqlDt.Columns.Count - 1 oraRow(i) = sqlRow(i) next oraDt.Rows.Add(oraRow) Next oraDa.Update(oraDt) Currently I have added some extra lines in the inner loop to handle string data (using sqlDt.Columns(i).DataType) and to substring too long strings to a length of 2000 maximum. That's only way I can have this routine error free....:-(( Can anyone help me? Jan van Veldhuizen Tag: get record count from stored procedure without passing DATA back? Tag: 103785
  - 17
    - Good Practice on ListBox Greetings I want to display a listbox on the form which will include two columns from the data table" FirstName" & "LastName" What I've done now, is modify the DataAdapter to include two additional colums as: [FirstName] + " " +[LastName] As NameFN [LastName] + " " +[FirstName] AS NameLN I've selected NameFN as the DisplayMember of the listbox However, I've also selected the Sort option to be true So what I see on the listbox doesn't correspond to the record selected on the form. The record is selected automatically on the form because my DataSource Property is bound to the dataset object. Is this a good practice ? Or its better to create a dynamic Array List on loadup and use that ? If that is the case how can I make the list selection, make the record on the form change ? Thanks Tag: get record count from stored procedure without passing DATA back? Tag: 103784
  - 18
    - How to save/update DataTable when its structure is unknown? Hi all, I would like to have a functionality that saves/updates a given DataTable into the DB while its structure is unknown. I think of 2 possible solutions: 1) to use SqlCommandBuilder - which is very expensive in the runtime (performance issues) 2) constructing my own commands - iterating over the DataTable and construct update, delete and insert commands. In this approach I have a small problem as I don't know the original sql types of the columns and it seems to be an equivalent to the first solution either. Does anybody think/may suggests another solution, approach ? Thanks in advance, Uri Tag: get record count from stored procedure without passing DATA back? Tag: 103783
  - 19
    - MSDataSetGenerator and strongly typed DataSets in VS.NET 2005 Beta I have having a problem compiling a strongly typed DataSet in VS.NET 2005 Beta 1 when it contains an <xs:include> tag. Everything compiles fine under VS.NET 2002 and 2003. Here is an example: File 1 - PRLEntityGroups.xsd : <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="PRLEntityGroups" targetNamespace="http://tempuri.org/PRL" xmlns="http://tempuri.org/PRL" xmlns:mstns="http://tempuri.org/PRL" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:group name="AccessLevelGroup"> <xs:sequence> <xs:element name="AccessLevelID" type="xs:int" /> <xs:element name="AccessLevelName" type="xs:string" /> </xs:sequence> </xs:group> </xs:schema> File 2 - ImportShape.xsd : <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="PRLImportShape" targetNamespace="http://tempuri.org/PRL" xmlns="http://tempuri.org/PRL" xmlns:mstns="http://tempuri.org/PRL" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:include schemaLocation="PRLEntityGroups.xsd" /> <xs:element name="ImportShape" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="AccessLevel"> <xs:complexType> <xs:sequence> <xs:group ref="AccessLevelGroup" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> The line that fails is <xs:group ref="AccessLevelGroup" /> in File 2. MSDataSetGenerator tells me AccessLevelGroup is an "undeclared model group". However, I have included the XSD file containing this declaration and both xsd are using the same Root namespace. Again, this worked fine in VS.NET 2002 and 2003. Any help on figuring out a work around would be helpful. I could declare the types within each xsd and not include an external xsd with all my type definitions, but that would be a waste of time. The point is to be able to include external xsd files and use those types defined in the external xsd files. Thanks! Tag: get record count from stored procedure without passing DATA back? Tag: 103781
  - 20
    - ADO.NET Oracle Varchar2 BUG? Hi, I have an Oracle 8.1.7 server and I'm extracting a Varchar2(length 300) using an aspx page and the field is always Null, even if it's not in the DB. I tried the EXACT same code in a windows form and it works perfect. Is there a bug in asp.net/ado.net with Varchar2 bigger than 256 char ? (I have no problems with Varchar2 of length < 256). Also, I tried creating a copy of my table with a Varchar1 instead of the Varchar2 and it worked too (>256). Tag: get record count from stored procedure without passing DATA back? Tag: 103779
  - 21
    - sending mail through stored procedure Hi Can anyone tell me how can I send email through stored procedure in sql server ? I want to send attachment with this email too. TIA Tag: get record count from stored procedure without passing DATA back? Tag: 103777
  - 22
    - SQLDataReader and Columns How would I get the length of a column from a SQLDataReader? I'm looking for something like Query Analyzer uses to display its data. So, I would need to know that a varchar(200) is 200 where a varchar(20) is only 20. Also I need to know how many characters a datetime would fill up. This kinda information. Does this make sense? -Roger Tag: get record count from stored procedure without passing DATA back? Tag: 103773
  - 23
    - Execute File SQL in AdoNET VB Hello, I have a file .SQL Containing a Script to Create Tables and Stored Procedure... Example : if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_ADVANCED_SEARCH]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_ADVANCED_SEARCH] GO ....... SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TABLE [dbo].[TBLTEST] Etc Etc.... It is possible Execute Then Scirpt With AdoNet ... Tag: get record count from stored procedure without passing DATA back? Tag: 103768
  - 24
    - Passing OracleDateTime.null.value to store procedure??? using Data access application block for oracle, I try to pass a null value to the OracleDateTime to the store procedure. but I got an exception saying "this value si null", what am I missing here? shouldn't I be able to pass null parameters? Kevin Tag: get record count from stored procedure without passing DATA back? Tag: 103766
  - 25
    - Databinding in c# - Important Hello All the samples I found are based on datagrid for the child table. What if I don't want the child records to be displayed in a datagrid, but in their own data bound controls like "text box, combo & list boxes). And I want to provide a second level of navigation buttons to traverse those child records in the child table. I'm sure this is possible, but I can't seem to find any sample on it. Please let me know if you can throw any light on it. Thank You Tag: get record count from stored procedure without passing DATA back? Tag: 103761

Is it possible in ADO to execute a (select) stored procedure, but just
return the number of records, not the actual data.

My client has some stored procedures which if executed with certain
parameters can return thousands of rows. I would like to execute a check
prior to returning these rows across the (very slow) network

** I understand that the SP must execute on the server. It is just the
passing of the data back which concerns me. **

I cannot change the stored procedures, only the ADO code.

Thanks.

Top

Re: get record count from stored procedure without passing DATA back? by Sahil

Sahil
Wed Jan 26 14:33:25 CST 2005

It's just as possible as knowing what's inside a gift, without opening the
wrapping.
You wouldn't know unless someone told you in advance - you need a second
stored proc to return you the count.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

"John B" <spamfree@hotmail.con> wrote in message
news:Lv-dnQ6ENplKa2rcRVn-iQ@mycybernet.net...
> Is it possible in ADO to execute a (select) stored procedure, but just
> return the number of records, not the actual data.
>
> My client has some stored procedures which if executed with certain
> parameters can return thousands of rows. I would like to execute a check
> prior to returning these rows across the (very slow) network
>
> ** I understand that the SP must execute on the server. It is just the
> passing of the data back which concerns me. **
>
> I cannot change the stored procedures, only the ADO code.
>
> Thanks.
>
>

Top

Re: get record count from stored procedure without passing DATA back? by WJ

WJ
Wed Jan 26 14:44:00 CST 2005

"John B" <spamfree@hotmail.con> wrote in message
news:Lv-dnQ6ENplKa2rcRVn-iQ@mycybernet.net...

> I cannot change the stored procedures, only the ADO code.
>

In this case you do not need SP. Just code "select count(aField) as
TotalRecord from aTable where such and such.."

on return, check the field "TotalRecord"

John Webbs

Top