Error while using Scope_Identity() instead of @@identity. WHY?

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
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103843
  - 2
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103835
  - 3
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103834
  - 4
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103832
  - 5
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103830
  - 6
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103826
  - 7
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103823
  - 8
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103818
  - 9
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103814
  - 10
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103809
  - 11
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103798
  - 12
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103797
  - 13
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103795
  - 14
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103793
  - 15
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103792
  - 16
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103790
  - 17
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103785
  - 18
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103784
  - 19
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103783
  - 20
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103781
  - 21
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103779
  - 22
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103777
  - 23
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103773
  - 24
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103768
  - 25
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103766
- Next
  - 1
    - 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: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103761
  - 2
    - edit memory DataTable Hi, I created simple dataTable (one field numeric, one string). Then I prepared dataConnector and put DataGridView on the form. In datagrid I can edit now numeric field but string field after post is clear (NULL value). Can anyone help? Thanks Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103752
  - 3
    - edit string field in DataGridView Hi, I created simple DataTable (memory table) object with two fields -numeric Id -string Name then I configure dataConnection and put on the form DataGridView. I bind fields from table to columns and now I can edit numeric column but when I try edit string column then it is after post event clear (NULL value). Why? Thanks Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103751
  - 4
    - DataRow to XML Hello, I am creating a datarow (new or existing) in my data-tier and passing it to my business tier where it is filled with data and then passed back to data-tier to be inserted into the table. I need to keep original and updated versions of the datarow in xml format. Just need the datarow in xml format. So basically I need two strings - string1 containing data from initial state of datarow and string2 containing data from updated state of datarow. I think that xml read/write can only be done via datasets and not via datarow. Can anyone provide any pointers? Thanks Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103750
  - 5
    - Lock Table In a SQL Server 2000 Database I have a Table which is shared by many users. I have a VB.NET Procedure which contains many calls to Stored Procedures and ADO.Net Commands to clear and update this shared table. What I would like to do at the start of this lengthly procedure is to place an exclusive lock on the table until the whole procedure has finished running all its separate update statements. Then I will unlock it. If another user runs the same procedure while the table is locked by the first then I would like a message displayed to say that "the table is in use, Please try again later." Is there an easy way to achieve all of this? It would be difficult to put all the update commands in the same transaction as different connections are used. Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103741
  - 6
    - Current record of datatable in dataset Hi I have a datatable which I have linked to a combo control, via the datasource property of the combo control. I have also set the displaymember property of the combo, to ensure that my description is shown in the combo. However, I want to have another value of the same row of the datatable (as selected in the combo), displayed in a text box. ie. so that when I change the value in the combo, a text box displays a value from another field in the same datarow. Can anyone offer any tips, or code samples? Thanks Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103740
  - 7
    - how to prepare patch Sir, In a form i have kept 2 textboxes(a,b) and a button(add). which supports only of integer values i have written. after entering the values in the textboxes and after clicking the add button result is displayed on a message box. (this functionality supports only for ineteger values. after this i have given the exe of this program to the client. then client asks me to " if i give decimal values it must work ". now how to prepare the patch for the program to add decimal values also and how to update the exe which i have prepared. Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103327
  - 8
    - Cant connect to SQL Server 2000 Developer edition Hi, I have been trying to connect SQL Server2000 developer edition using the following string. SqlConnection conn = new SqlConnection("server=localhost;database=pubs;uid=sa;pwd="); I dont know where i am going wrong. SQL Server Service Manager shows the following: Server : Hemant Services : SQL Server Running \\Hemant -MSSQLServer Even tried this command and numerous other combination but none seems to work. SqlConnection conn = new SqlConnection("server=Hemant;database=pubs;uid=sa;pwd="); I want to establish connection using SqlConnection to the database pubs using C# in .NET IDE. Help me out. Where am i getting it wrong?? If someone else has answered this question then provide me the link. Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103130
  - 9
    - duplicate ids after insert Hi, I'm trying to create an archiving script, using the folowing query for all database tables insert into table2 select * from table1 (table1, table2 are 2 tables having exactly the same definition) The rpoblem is that the rows are,'t deleted from the table TABLE2, so the next time the user runs the script he'll find some rows already existing in TABLE2, so he'll have an error. How can I handle this without to know exacly what are the IDs or the structure, juste to say "if the row (the unique key) exists skip it, but continue with the other rows" Thanks. Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103126
  - 10
    - Timberline (Pervasive) ODBC Access Is anyone else out here working with Timberline version 7.x,8.x or 9.x and ODBC and .NET? If so any advice to offer? I am working with a number of older VB 6 applications that interface (mostly just read) Timberline data stored in a Pervasive SQL database that I am porting to VB.NET. Experimentation has shown me that I apparently need to use Timberlines own driver, I have had limited success with the Pervasive native drivers. I am trying to stay in an all managed solution so I have been using the System.Data.ODBC namespace but that appears to cripple my access to things like Schema info etc. Any suggestions or pointers to online resources would be appreciated. I am already aware of Event!'s web site. Thanks in advance. Bob Porter Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103125
  - 11
    - ExecuteReader requires an open and available Connection. The connection's current state is Closed. (Type your message here) -------------------------------- From: renu Friends, when I am trying to create a login page and connecting to the sqlserver database I am getting the following error ExecuteReader requires an open and available Connection. The connection's current state is Closed. and mycode is Dim strconn As String Dim strsql As String Dim command As SqlCommand Dim i As Integer Try strconn = "server =(local);trusted_connection=yes;database=consultants;" Response.Write("connection ok") Dim conn As New SqlConnection(strconn) strsql = "select count(*) from consul_login where uname='" & txtUname.Text & "'and pword='" & txtPassword.Text & "'" command = New SqlCommand(strsql, conn) conn.Open() Catch ex As Exception Response.Write(ex.Message) End Try i = command.ExecuteScalar() If i <> 1 Then Response.Redirect("e:\dotnet\authenticationdenied.aspx") Else Response.Redirect("e:\dotnet\timesheet.aspx") Response.Redirect("timesheet?n1" & txtUname.Text) End If can anybody help me out? thanks renu ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>gev9cu2MuEiLCsHn9s10qw==</Id> Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103113
  - 12
    - concurrency violation I have a dataset with a data adapter=2E The text fields are bound= to text boxes=2E When I use sqlprofiler to view the stored= procedure executed and the data, the fields of both the= @newComment and @orginalComment have both the same value=2E The= value in both fields is the same value entered into the textbox=2E= I know that the object is supposed to copy the orginal values= retrieved from the database, but I have no idea why the changes= are occuring to the @original=2E this=2EBindingContext[dsCollectionAgency1,= "Collection_Agency_Sel"]=2EEndCurrentEdit(); try =09{ =09daCollectionAgency=2EUpdate(dsCollectionAgency1,= "Collection_Agency_Sel"); =09} catch (Exception e) =09{ =09MessageBox=2EShow( Convert=2EToString(e=2EMessage), "Error Saving= Agency Information", MessageBoxButtons=2EOK,= MessageBoxIcon=2EExclamation); =09}=09=09=09 Does anyone have any idea why this occuring? From: Kevin Cabral ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>2NNKo4s1+06Jk0cWyZJuCw=3D=3D</Id> Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103112
  - 13
    - Fire query on DataSet DataSet is supposed to be an in-memory database=2E So is it= possible to fire a query on it=2E I want to fire a "Select" query= (with alises in it) and also a "Transform" (Crosstab) query=2E In= the current scenario I am putting things in an Access table but= for performance reasons want to deal with in-memory contents=2E Thanks in advance=2E -------------------------------- From: Arun Gupta ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>sTSX/kubC0qPi2iCiclPTg=3D=3D</Id> Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103111
  - 14
    - Can't get record to insert into Access I have a windows service that will insert records into an Access= database=2E Or at least that's the idea=2E The insert isn't= happening, but the code runs without raising any errors=2E When I= run the generated sql statement from a query window in Access,= the record inserts just fine=2E Can anyone help me? string sqlInsert =3D "INSERT INTO checks( PageNo, Template,= OriginFile, TargetFile, MICR, Account, Routing, CheckNumber,= CheckDate, CheckAmount, ScanBatchNum ) VALUES( '{0}', '{1}',= '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}'= )"; StringBuilder sb =3D new StringBuilder(); using( OleDbConnection cn =3D new OleDbConnection( m_ConnString )= ) { =09cn=2EOpen(); =09using( OleDbCommand cmd =3D new OleDbCommand( "", cn ) ) =09{ =09=09foreach( ChecksDS=2EChecksRow row in checkRecords ) =09=09{ =09=09=09sb=2EAppendFormat( sqlInsert, row=2EPageNo, row=2ETemplate,= row=2EOriginFile, row=2ETargetFile, row=2EMICR, row=2EAccount,= row=2ERouting, row=2ECheckNum, row=2ECheckDate, row=2ECheckAmount,= row=2EScanBatchNum ); =09=09=09cmd=2ECommandText =3D sb=2EToString(); =09=09=09cmd=2EExecuteNonQuery(); =09=09=09sb=2ERemove( 0, sb=2ELength ); =09=09} =09} =09cn=2EClose(); } Here's a generated sql statement=2E INSERT INTO checks( PageNo, Template, OriginFile, TargetFile,= MICR, Account, Routing, CheckNumber, CheckDate, CheckAmount,= ScanBatchNum ) VALUES( '3', 'Check', 'C:\Program= Files\FormStorm\urm\Queues\0120040901160314=2Etif', 'C:\Program= Files\FormStorm\URM\ImageExp\090920049091443253=2Etif',= 'A021204005A 0001538C 0404', '021204005', '0001538', '0404',= '', '20=2E00', '09092004909144325' ); I've tried with and without the ending semi-colon=2E What am I= missing? Thanks -------------------------------- From: Drew Burlingame ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>W3E/7KDtXkaxBUqfx/Y9Jg=3D=3D</Id> Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103110
  - 15
    - .Net master-detail interface I can build an interface for a master-detail database in about 5 minutes with vb6 using the data environment 1.0 reference. Does .Net have anything similar or must I define a connection, datadapters and the relational schema by hand? Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103109
  - 16
    - ADOMD.NET Hi, Does using Ado Md.Net require anything to be installed on the Analysis Services server (XMLA or as such) ? Thanks Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103108
  - 17
    - .Net Data Provider error help I've used the Microsoft .Net Data Provider for Oracle and also the Oracle .Net Data Provider . I'm issuing a simple select statement which would return a list of dates formatted as such 'MM/DD/YYYY'. The table is storing the dates in a field of date data type in the format of M/D/YYYY. There is no time portion on any of the dates, the data was imported from SQL Server. Here is the section of my statement which formats the date ' TO_CHAR(tblarInvoiceHeader.ARInvoiceDate,'MM/DD/YYYY')', I get the following error: ORA-01834: not a valid month I can issue the statement via SQL + and TOAD, and not generate the error, it has to be the data provider. Does anyone have a clue as to what's going on and the panacea to this issue? Best Regards, Ted. Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103106
  - 18
    - newbee needs help with code Hi, I have the following VB.Net code snippet: While datareader3.Read ......... strsql = "select * from InspectionViolations where propTableID=" & datareader3.Item(4) & " AND inspIDCleared IS NULL" ConnViolPresent.Open() CmdViolPresent = New SqlCommand(strsql, ConnViolPresent) adapterViolPresent.SelectCommand = CmdViolPresent adapterViolPresent.Fill(dsViolPresent) ConnViolPresent.Close() If (dsViolPresent.Tables(0).Rows.Count() > 0) Then 'For some reason, dsViolPresent.Tables(0).Rows.Count() always return 3 As you can see the code inside a while loop will generate a different SQL statement and send it to SQL server. However no matter what the SQL statement is, the result dataset stays the same and it's the result generated by the first SQL statement. What do I have to do to make dsViolPresent refreshed in every loop ? TIA Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103102
  - 19
    - Help! Operation is not allowed in this context. Hi, I got an error message - Operation is not allowed in this context. It said the error comes from the line objRS.Close() Anyone have any ideas why? Thanks a lot. Here is part of the code: Dim strConnectionString As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\test.mdb" objConn = New ADODB.Connection objConn.Open(strConnectionString) objRS = New ADODB.Recordset objRS.ActiveConnection = oCn objRS.LockType = ADODB.LockTypeEnum.adLockOptimistic objRS.CursorType = ADODB.CursorTypeEnum.adOpenDynamic objRS.Open("SELECT * FROM Customers WHERE CustomerID = " & Session("CustomerID"), objConn) ' DO SOMETHING HERE' objRS.Close() *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103099
  - 20
    - convert 2 XML files into a dataset Hi, I now have 2 xml files with same structure first.xml <dataset1> <table1> <col1>aaa</col1> <col2>bbb</col2> </table> ..... </dataset1> 2nd.xml <dataset1> <table1> <col1>ccc</col1> <col2>ddd</col2> </table> ..... </dataset1> how can I merge these 2 set of data into a single dataset? thanks Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103098
  - 21
    - No error information available: E_FAIL(0x80004005) SQL Server 2000 We have an e-commerce app built with ASP.NET, VB.NET and uses a SQL Server 2000 database. The app sustains moderate load in this particular environment (10-50 concurrent users). Note we also have this same codebase running in several other similar environments and everything works fine. For this one sql server 2000/windows 2003 server environment we get this error after the app has been up for a while: No error information available: E_FAIL(0x80004005). The SQL Server has to be restarted for the error to go away. My guess is there is some sort of sql server configuration or network problem because the app works fine in other similar environments. Any ideas on how to correct this? Thanks so much, Jenna Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103097
  - 22
    - SqlDataAdapter memory leak? I've been trying to track down a memory leak in a project and have been running around in circles for the past week or so. I've been using this as an opportunity to evaluate Compuware's devPartner, but unfortunately it seems to be doing more to confuse me than to help me. My problem can be illustrated by the block of code attached to KB article 318263 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q318263). The article gives this code as an example of a perceived, but not real, memory leak. However, I think there is a real memory leak within the SqlDataAdapter, unrelated to the perceived leaking that the article talks about. DataSet ds; SqlConnection cn = new SqlConnection("data source=localhost;initial catalog=Northwind;user id=USER;password=PASSWORD"); cn.Open(); SqlDataAdapter da = new SqlDataAdapter("Select * from Employees", cn); ds = new DataSet(); for (int i = 0; i < 1000; i++) { da.Fill(ds, "Table" + i.ToString()); } cn.Close(); The leak is not major -- devPartner only reports ~50k being leaked, and the entirety of it is reported as leaked by the da.Fill(...) method call. But, 50k in this snippet could (and seems to have been within my project) be amplified when adding larger tables to a DataSet. Has anyone looked into this before? Is this a real issue with the SqlDataAdapter, or am I hunting a snipe? Thanks for reading, -Matt Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103087
  - 23
    - Questions on Databinding Hello I've few questions regarding ADO & C#: 1) Is it possible to view tata from multiple tables in the Datagrid control ? Most of the examples I see are only for 1 table. 2) In Comboboxes, can we display multiple fields ? For example in a Form of customers, we have a combo box to select the customer you want to change, so in that combo box, when they drop down, can we have it to display "First Name, Last Name, Customer ID, Customer type" but its databound field is "Customer ID". I used to be able to do that in Access, C# is supposed to be powerful but how do I do it ? 3) If you copy an access database into MSDE or SQL and it has autogenerate fields, both in SQL & Access, how do we addresss that efficiently ? Any insight into the above questions would be helpful & very appreciated. Thank You Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103085
  - 24
    - Retrieving @@IDENTITY value from Access Database give always 0 !!!! I need to retrieve automunber ID from source access table after inserting new row... I tried to do this by this way: gRUPATableAdapter.Update(dataSetGrafik.GRUPA); oleDbConnectionForID.Open(); OleDbConnection oleDbConnectionForID = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Grafik\\GrafikApplication\\Import\\baza Access\\grafikStruktura.mdb;Persist Security Info=False"); OleDbCommand command = new OleDbCommand("SELECT @@IDENTITY", oleDbConnectionForID); IDnewAddedGRUPARow = (int)command.ExecuteScalar(); // why it always give 0 ???? oleDbConnectionForID.Close(); But it always gives me nothing... please, help me.. Previously i tried tho use standard solution my attending RowUpdated event (tutorial from MSDN website). This approach unfortunately cases that compliter gives my warning: Warning 5 The event 'GrafikApplication.GRUPATableAdapter.RowUpdated' is never used c:\Grafik\GrafikApplication\DataSetGrafik2.cs 71 67 I use VS C# Express - and it generics a lot of codes, declaration of events, like rowchanged, itd.. but I cannnot find where I can correctly attend RowUpdated event ? Is anyone who can help me ?? Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103084
  - 25
    - Warning: The event 'Application.SAMPLETableAdapter.RowUpdated' is never used - HELP WHY ??? In my applicaton I attend the RowUpdated event for retrieving the autonumber IDENTITY from Access Database (no stored procedure support) of new inserted row from one of my tables (SAMPLE). But event is not hanging properly, or not reqognized or doesn't fires, because I always receive 0 from database. I don't know what's wrong ??? I did accordantly to the microsoft's tutorial: 1) I declare: public event OleDbRowUpdatedEventHandler RowUpdated; in the body of definition SAMPLETABLEAdapter (thiss class was automaticalyy created by VS C# and is inherted from OleDbDataAdapter class - object of this class is the gSampleTableAdapter for SAMPLE table, in which RowUpdated event I want to detect, when I insert new row) 2) I Placed this line of code: gSampleTableAdapter.RowUpdated += new OleDbRowUpdatedEventHandler(OnRowUpdated); and below mentioned line i placed the code which can invoke this event: gSampleTableAdapter.Update(dataSetSample.SAMPLE); 3) and finally I define OnRowUpdated function: protected static void OnRowUpdated(object sender, OleDbRowUpdatedEventArgs args) { OleDbCommand command = new OleDbCommand("SELECT @@IDENTITY", oleDbConnectionDlaID); if (args.StatementType == StatementType.Update) { IDnewAddedRow = (int)command.ExecuteScalar(); MessageBox.Show("Database retrieve ID:" + IDnewAddedRow); args.Row["ID_SAMPLE"] = IDnewAddedRow; } } Everything compliles OK, except this one Warning: Warning: The event 'Application.SAMPLETableAdapter.RowUpdated' is never used what it's mean ??? When I checked the sample table in the access, I see, that the new rows are propery added, but is something wrong with this mechenism... Where is the case !! Please help me, because i'm starting to get nuts..... Tag: Error while using Scope_Identity() instead of @@identity. WHY? Tag: 103083

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

Top

Re: Error while using Scope_Identity() instead of @@identity. WHY? by Patrice

Patrice
Wed Jan 26 05:07:59 CST 2005

Seeing some code may help. It looks like the value is not returned correctly
and is NULL instead of the expected value...

Patrice

--

<nashak@hotmail.com> a écrit dans le message de
news:1106680428.327717.215220@f14g2000cwb.googlegroups.com...
> 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
>

Top