SQL Server 2000 Timestamp and Dataset

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
    - Accessing FoxPro Database using OleDB Hi, I am currently working on a project in which I need to interrogate a FoxPro database and present some results from the database in a web browser. I am using VS.NET 2003, Framework 1.1. I build a Select statement and then use the Select statement to query a table in the FoxPro database. The problem is, the query is taking a very long time to run from my .NET code. Running the same query from inside Visual Fox Pro is 20 times faster. Does anyone know what I can do from my .NET code to make the query much faster? The query string I use follows this pattern: SELECT * FROM myTable WHERE UPPER(myField) = myValue Thanks in advance Glenn Tag: SQL Server 2000 Timestamp and Dataset Tag: 62658
  - 2
    - Method returns a dadaset but .aspx page doesn't catch it hi i have written a stored procedure in Oracle 8 which takes in 3 parameters and returns a dataset.Now this procedure is called in a method in a class. this class is referenced from my .aspx page as //REFERENCING MY CLASS in the .aspx page CInvBQR lInvBQR = new CInvBQR(); DataSet ldsTempDe; ldsTempDe = lInvBQR.GetSerialNoDetailsPretoPost (Convert.ToDouble(sNewMobileNumber),"MB_00_000","M"); //PROCEDURE DEFINED in CInvBQR public DataSet GetSerialNoDetailsPretoPost(double dblSerialNumber, string sStockCode,string sSerialNumberType) { OleDbCommand locmdCommandObject = new OleDbCommand(); CDataHandler lDataHandler = new CDataHandler(); DataSet dsSerialNumberDetails=new DataSet(); try { locmdCommandObject.CommandType = CommandType.StoredProcedure; locmdCommandObject.CommandText = "Inv.spGetSerialNoDetailsPreToPost"; loprmSerialNumber= locmdCommandObject.Parameters.Add "@pinumSerialNumber",OleDbType.Numeric); loprmSerialNumber.Value = dblSerialNumber; loprmSerialNumber.Direction = ParameterDirection.Input; OleDbParameter loprmStockCode= locmdCommandObject.Parameters.Add ("@pivchStockCode",OleDbType.VarChar,12); loprmStockCode.Value =sStockCode; loprmStockCode.Direction = ParameterDirection.Input; OleDbParameter loprmSerialNumberType = locmdCommandObject.Parameters.Add ("@pivchSerialNumberType",OleDbType.Char,1); loprmSerialNumberType.Value =sSerialNumberType; loprmSerialNumberType.Direction = ParameterDirection.Input; dsSerialNumberDetails=lDataHandler.GetData (locmdCommandObject); return dsSerialNumberDetails; } The issue is that although the procedure is returnning a dataset containing a row , when i catch it on the .apsx page and i try to access the row count or value of any column i get the following error error: cannot obtain value I would appreciate ur advice or guuidance in this matter thanx Saurabh Bhargava Tag: SQL Server 2000 Timestamp and Dataset Tag: 62655
  - 3
    - Extracting the XML from Dataset Hi All, does anyone know how to extract the XML from an empty dataset (note the words empty dataset here). All I can seem to get is the root element, all child elements are not returned. Rgds, D Tag: SQL Server 2000 Timestamp and Dataset Tag: 62650
  - 4
    - [ANN] Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available Hello: Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available for download. Release Changes: Alpha 1 ( 2003-08-1 ) ------- -------------- - New GDS implementation. - Reorganization of XML documentation files using a new XML file format. - Design time support for connection string ( For MS .NET only ) - Support for database schema retrieval. - Support for SELECT ... FOR UPDATE statements. --------------------------------------------------- You can download binarys ( for Windows and .NET Framework 1.0 ) at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1.exe?download You can download sources at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1-Src.zip?download You can download documentation at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1-Doc.zip?download -- Best regards Carlos Guzmán Álvarez Vigo-Spain Tag: SQL Server 2000 Timestamp and Dataset Tag: 62649
  - 5
    - Streaming LIVE Video on My ASP.NET Website How do I add a live video stream to my website? Also, as a secondary option, can anyone suggest a good program that will update pictures from my camera every 30 seconds or so? But ideally, it would be a live stream! Thanks Jordan Tag: SQL Server 2000 Timestamp and Dataset Tag: 62645
  - 6
    - SQL User Defined Functions Dera all, i have created a UDF in SQL server and would to call it using following SQL statement. Any ideas how can i do that? The issues is that i can call a UDF by specifiying the parameter etc.. but in this case, i don't need to pass any parameters...since i am using UDF in select statement.. i don't know how to call fill the dataset in this case... SELECT B.BRAND_ID, SEGMENT_ID, B.LINE_ID, DBO.GetDeliveryFeesF(B.BRAND_ID, SEGMENT_ID) AS DELIVERYFEES From Brand B ***************************** create FUNCTION GetDeliveryFeesF ( @BrandID int, @segID int ) RETURNS int AS BEGIN RETURN(select case when b.chassis='Y' and deliveryfee is not null then b.DeliveryFee Else (Select isNull(sb.delivery_fee, pl.delivery_fee) from brand b, Segment_Brand sb, productline pl where sb.brand_id = b.brand_id AND b.brand_id = @BrandID and sb.segment_id =@segID and pl.line_id = b.line_id) end As DeliveryFee from brand b where b.brand_id = @BrandID ) END *********************************************** Tag: SQL Server 2000 Timestamp and Dataset Tag: 62633
  - 7
    - DataReader, mySQL and Text fields The following code has been working really well for me. Dim sSql as String = "Select ctDateTime,ctArea From tblContacts" Dim db As OleDbConnection = New OleDbConnection(sDBCS) Dim dc as OleDbCommand = New OleDbCommand(sSql,db) db.Open() Dim dr as OleDbDataReader = dc.ExecuteReader() dtgrid.DataSource = dr dtgrid.DataBind() dr.Close() db.Close() If I add one more field to the select (a "Text" data type) I get the error below. Any one with suggestions. Line 22 is the line that is failing. The ExecuteReader. TIA Larry Lowry ============================================================= No error information available: DB_E_NOTABLE(0x80040E37). 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 error information available: DB_E_NOTABLE(0x80040E37). Source Error: Line 20: Dim dc as OleDbCommand = New OleDbCommand (sSql,db) Line 21: db.Open() Line 22: Dim dr as OleDbDataReader = dc.ExecuteReader() Line 23: dtgrid.DataSource = dr Line 24: dtgrid.DataBind() Tag: SQL Server 2000 Timestamp and Dataset Tag: 62630
  - 8
    - SqlDataAdapter.Update replacing first row with second after update Hi, I have a WinForms app with a strongly typed dataset that contains two tables, FamilyMembers and ClassesTaken. For both FamilyMembers and ClassesTaken, I have a default value of -100000 for the AutoIncrementSeed with a step of 1. I am trying to simply use these default values temporarily, wait for the user to hit "save", post the changes to the database, and return the identity values into the appropriate columns (FM_ID, CT_ID). I have a datarelation mapped from FamilyMembers to ClassesTaken on FM_ID to FM_ID with an UpdateRule set to cascade and an Accept/Reject rule of none. (A FamilyMember may have 0 or more classes taken.) The problem is that when I add more than one family member, and then assign the FIRST family member entered to a ClassesTaken record, the DataAdapter is for some reason overwriting the first record in FamilyMembers with the second record. I have set the SqlCommand.UpdatedRowSource for the update and insert statement to UpdateRowSource.OutputParameters. This behavior does not occur when the 2nd or subsequent rows are assigned a "ClassTaken". For example: (PRE-UPDATE) FamilyMembers (FM_ID, First, Last) -100000, Jim, Smith -99999, Mary, Smith ClassesTaken (CT_ID,FM_ID,Class) -100000,-100000, English (POST-UPDATE) FamilyMembers (FM_ID, First, Last) 2, Mary, Smith 2, Mary, Smith ClassesTaken (CT_ID,FM_ID,Class) 1,1,English What is strange is that the data is inserted correctly into SQL, but the dataset is showing duplicate records for the FamilyMembers. When I set the UpdateRule to "NONE", this behavior does not occur, but I also lose the FM_ID foreign key update on ClassesTaken. Is there any explanation for this? I'm at wits end with this one. Thanks, Dave Tag: SQL Server 2000 Timestamp and Dataset Tag: 62624
  - 9
    - Connection question In the course of using VS.net I have generally setup my connections by dragging a SQLDataAdatper to the form and going from there. However, I am at a point where I would like to begin connecting to the database and creating DataAdapters and DataSets via code. On a form I go into the ConnectionString property of a SQLConnection object and copy the values there. I suppose that I can just copy these values to my connection string that I create in code, but I can not. I have code that looks like this: Dim myConnection As New SqlClient.SqlConnection myConnection = New SqlConnection Try 'myConnection = "workstation id=P426;packet size=4096;integrated security=SSPI;data source=P426;persist security info=False;initial catalog=Corp" Catch ex As Exception End Try With the code above I get a squiggly under the "Workstation id = P426...." line and it says, "Value of Type String can not be converted to System.data.sql.connection" What do I need to do to write a connection string that is palatable to my code? What is the easiest way of doing this? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62621
  - 10
    - very urgent...please From: "Nedu N" <nedu_n@hotmail.com> Subject: not able to read and bind the XML tag data from dataset Date: Tuesday, August 12, 2003 2:06 PM All, I am facing some problem in accessing the data (which is here XML tags itslelf as data) from dataset.... example: I have got data as <BTN> in one of the columns in my database table, and i am able to see this data when write the content of the dataset into a xml file with dataset.writexml(). But when i try to bind this dataset to a datagrid i am seeing only spaces in this specific column...i am okay with other columns... Any help will be greatly appreciated.. Thanks Nedu Tag: SQL Server 2000 Timestamp and Dataset Tag: 62615
  - 11
    - OracleConnection Hi, I'd like to ask You to solve my problem connecting to Oracle9.x database as SYSDBA. How can I specify that 'AS SYSDBA' ? When I try to login with 'User ID=SYS as SYSDBA' I always get Unknown user/password. Maybe I've placed my problem wrong and should check Oracle permissions to do that ? Thank You Best regards Rafa³ Grzybowski Tag: SQL Server 2000 Timestamp and Dataset Tag: 62612
  - 12
    - not able to read and bind the XML tag data from dataset All, I am facing some problem in accessing the data (which is here XML tags itslelf as data) from dataset.... example: I have got data as <BTN> in one of the columns in my database table, and i am able to see this data when write the content of the dataset into a xml file with dataset.writexml(). But when i try to bind this dataset to a datagrid i am seeing only spaces in this specific column...i am okay with other columns... Any help will be greatly appreciated.. Thanks Nedu Tag: SQL Server 2000 Timestamp and Dataset Tag: 62610
  - 13
    - how to cast a Recordset from ADO a ADO.NET Data Struct Hi! can somebody tell me how to cast a Recordset from ADO to a ADO.NET Data Struct the ado recordset is in a dll that is called from an app that is being build in C#.NET Thanks in advance Tag: SQL Server 2000 Timestamp and Dataset Tag: 62608
  - 14
    - One dataAdapter and two tables. Does it work? Hi all, I am using a dataapater, a dataset and an select sql command to retrieve data from two related tables using the following code: Dim da As New OleDb.OleDbDataAdapter("SELECT Materials.*, Material_Functions.fName FROM Material_Functions INNER JOIN Materials ON Material_Functions.ID = Materials.Function;", conn) Dim ds As New DataSet("DSMaterials") da.Fill(ds, "Materials") You cannot see it in the code but table 'Materials' and table 'Material_Functions' both have a field called 'fName'. For simple (one table) sql commands I had no problem binding textboxes to fields in the dataset using the following code: (Assume sql command is "Select * From Materials;") TextBox.DataBindings.Add("Text", ds, "Materials.fName") But this doesn't work any more. I checked the output window during run-time and all the fields are placed under one table (Materials) which is logical. I also noticed that the 'fname' field coming from the 'Material_Functions' table is named 'Material_Functions.fName', which is also logical. The question is when it comes to data binding what to I put in the third argument??? 'Materials.Material_Functions.fName' doesn't work. I know that I can use a second dataadapter to load the second table separately and set the relationship in the dataset manually, but I would prefer to do it in just one dataadapter (don't ask me why, because I don't know that either). So how do I work around it with just one dataAdapter? And if I should use 2 of them what is the advantage of that over the single DA? Thanks in advance Theo Tag: SQL Server 2000 Timestamp and Dataset Tag: 62602
  - 15
    - Oracle - Error when using DBLink Hi, I am using OracleClient with Oracle 8.1.7 & .NET framework 1.1. Everything works fine and I can read / write data to Oracle. However, if I try to access data from a table accessible via a DB LINK, I get following error : System.Data.OracleClient.OracleException: ORA-02041: client database did not begin a transaction Please Help ! Tag: SQL Server 2000 Timestamp and Dataset Tag: 62597
  - 16
    - Error messages from SQL Server Hi, I intentionally modified a stored proc to raise an error and this is the message in Query Analyzer when I run the sp: Server: Msg 8152, Level 16, State 9, Procedure MyTest, Line 5 String or binary data would be truncated. The statement has been terminated. Server: Msg 50000, Level 16, State 1, Procedure test, Line 8 Unknown Product ID: abc As you can see there are 3 error messages (last one is raised by RaisError function). The only one I can identify from my vb.net app via sqlException is: "String or binary data would be truncated." My question is how to view the rest of messages via VB.NET. Tia, Ray Tag: SQL Server 2000 Timestamp and Dataset Tag: 62591
  - 17
    - Help: Function that returns DataReader I have a function that returns a datareader. The problem is that in the function's FINALLY I close the datareader and set it to nothing. But, BEFORE the Finally I "Return" the datareader (in the Try). The problem is, by the time it's "returned" it says I already closed it. Any ideas how I can overcome this? Example: Private Sub x Dim dr as SqlDataReader .... .... dr = GetDr(...) ' FAILS BECAUSE THE DATAREADER IS CLOSED BY NOW! .... End Sub Private Function GetDr(...) as SqlDataReader Dim MyDataReader as SqlDataReader Try ..... .... Return MyDataReader Catch Finally MyDataReader.Close MyDataReader = Nothing End Function Tag: SQL Server 2000 Timestamp and Dataset Tag: 62590
  - 18
    - XMLDataDocument - improper Dataset row insert into XML hierarchy I have an interesting problem. I am synching and XMLDataDocument with a Dataset. The XML data is fairly simple (see below). I load a schema (using ReadXMLSchema) into the Dataset (as described in the MS examples). Then I synch the dataset and the XMLDataDocument. Finally the XML is loaded in to the XMLDataDocument. I then bind a textbox to the "Surname" element and a datagrid to the "Employment" repeating element This is all working fine for me except one hitch. It seems that both editing in the textbox or grid is fine. Also deleting a row from the grid is fine as well. However 'inserting' a row into the Employment grid (either manually or programatically - try adding one on the end of the grid - you'll see) does not seem to place the new node into the proper position in the XML hierarchy (it gets appended at the end of the structure - just before the 'NewDatset' element). Note that I am writing out the edited XML with the "Save" method for the XMLDataDocument" object. I think there is something improper going on in the data relations (as you can see I debugged them - they look fine). Also note that I used the Schema Designer to make the XSD file associated with this XML data. It just seems weird that editing and deleting are resoved correctly within the hierarchy, but inserting is not. All the code and XML is found below. You should just need a form with a few controls to get this going (datagrid called "dgdEmployHist", textbox called "txtCISurname", button called "btnLoadCtls", button called "btnSaveXML") '***CODE - see farther down for XML data and Schema and XML result of Save*** Imports System Imports System.Xml Imports System.Xml.Schema Imports System.Data Public Class Form1 Inherits System.Windows.Forms.Form Private dsRequest As New DataSet Private xddRequest As XmlDataDocument #Region " Windows Form Designer generated code " 'I REMOVED THIS TO SAVE SPACE #End Region Private Sub btnLoadCtls_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadCtls.Click Dim dtTemp As DataTable Dim drwTemp As DataRow Dim drlTemp As DataRelation Dim ParentArr() As DataColumn Dim ChildArr() As DataColumn Dim i As Integer Try 'LOAD A SCHEMA INTO THE EMPTY DATASET dsRequest.ReadXmlSchema("C:\test.xsd") Catch err As XmlSchemaException Console.WriteLine("LineNumber = {0}", err.LineNumber) Console.WriteLine("LinePosition = {0}", err.LinePosition) Console.WriteLine("Message = {0}", err.Message) Console.WriteLine("Source = {0}", err.Source) Catch err As DataException 'Console.WriteLine("LineNumber = {0}", err.LineNumber) 'Console.WriteLine("LinePosition = {0}", err.LinePosition) Console.WriteLine("Message = {0}", err.Message) Console.WriteLine("Source = {0}", err.Source) Catch err As Exception Console.WriteLine("Message = {0}", err.Message) Console.WriteLine("Source = {0}", err.Source) End Try 'SYNC THE XMLDATADOCUMENT WITH THE DATASET xddRequest = New XmlDataDocument(dsRequest) 'FILL THE DATADOCUMENT FROM THE XML DATA (FILLS THE DATASET AS WELL BECAUSE THEY ARE NOW IN SYNC) xddRequest.Load("c:\test.xml") Debug.Write("DataTables" & vbCrLf) For Each dtTemp In dsRequest.Tables Debug.Write(vbTab & dtTemp.TableName() & ", recs=" & dtTemp.Rows.Count & vbCrLf) Next Debug.Write("DataRelations" & vbCrLf) For Each drlTemp In dsRequest.Relations Debug.Write(vbTab & drlTemp.RelationName & ", nested=" & drlTemp.Nested & vbCrLf) Debug.Write(vbTab & "ParentColumns" & vbCrLf) ParentArr = drlTemp.ParentColumns For i = 0 To ParentArr.GetUpperBound(0) Debug.Write(vbTab & vbTab & ParentArr(i).ColumnName & vbCrLf) Next i Debug.Write(vbTab & "ChildColumns" & vbCrLf) ChildArr = drlTemp.ChildColumns For i = 0 To ChildArr.GetUpperBound(0) Debug.Write(vbTab & vbTab & ChildArr(i).ColumnName & vbCrLf) Next i Next 'Binding controls Me.txtCISurname.DataBindings.Add _ (New Binding("Text", dsRequest.Tables("Individual"), "Surname")) Me.dgdEmployHist.DataSource = dsRequest.Tables("Employment").DefaultView End Sub Private Sub btnSaveXML_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveXML.Click 'Adding an Employment row 'Dim drwTest As DataRow = dsRequest.Tables("Employment").NewRow 'drwTest("IndividualID") = "40992" 'drwTest("EmploymentID") = "" 'drwTest("JobTitle") = "Computer Programmer" 'dsRequest.Tables("Employment").Rows.Add(drwTest) 'removing an Employment Row 'dsRequest.Tables("Employment").Rows(0).Delete() 'Saving the changes to XML dsRequest.AcceptChanges() 'Console.WriteLine(xddRequest.OuterXml()) xddRequest.Save("C:\saved.xml") End Sub End Class '***XML DATA - test.xml <?xml version="1.0"?> <Request xmlns="http://tempuri.org/sample_database_request-11.xsd"> <RequestID>11</RequestID> <ClearanceTypeID>2</ClearanceTypeID> <Individual> <RequestID>11</RequestID> <IndividualID>40992</IndividualID> <Surname>Jones</Surname> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>39216</EmploymentID> <JobTitle>Painter</JobTitle> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73559</EmploymentID> <JobTitle>Sweeper</JobTitle> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73564</EmploymentID> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73566</EmploymentID> <JobTitle>Student</JobTitle> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73568</EmploymentID> <JobTitle>Manager</JobTitle> </Employment> <CurrentAddress> <IndividualID>40992</IndividualID> <AddressID>7913</AddressID> </CurrentAddress> <BirthAddress> <IndividualID>40992</IndividualID> <AddressID>7914</AddressID> </BirthAddress> </Individual> <RequestForm> <RequestID>11</RequestID> <FormID>1</FormID> <USOID>12997</USOID> </RequestForm> <RequestForm> <RequestID>11</RequestID> <FormID>4</FormID> <USOID>12997</USOID> </RequestForm> </Request> '***XML Schema - test.xsd <?xml version="1.0" ?> <xs:schema id="NewDataSet" targetNamespace="http://tempuri.org/sample_database_request-11.xsd" xmlns:mstns="http://tempuri.org/sample_database_request-11.xsd" xmlns="http://tempuri.org/sample_database_request-11.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified"> <xs:element name="Request"> <xs:complexType> <xs:sequence> <xs:element name="RequestID" type="xs:string" minOccurs="0" /> <xs:element name="ClearanceTypeID" type="xs:string" minOccurs="0" /> <xs:element name="Individual" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="RequestID" type="xs:string" minOccurs="0" /> <xs:element name="IndividualID" type="xs:string" minOccurs="0" /> <xs:element name="Surname" type="xs:string" minOccurs="0" /> <xs:element name="Employment" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="IndividualID" type="xs:string" minOccurs="0" /> <xs:element name="EmploymentID" type="xs:string" minOccurs="0" /> <xs:element name="JobTitle" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="CurrentAddress" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="IndividualID" type="xs:string" minOccurs="0" /> <xs:element name="AddressID" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="BirthAddress" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="IndividualID" type="xs:string" minOccurs="0" /> <xs:element name="AddressID" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="RequestForm" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="RequestID" type="xs:string" minOccurs="0" /> <xs:element name="FormID" type="xs:string" minOccurs="0" /> <xs:element name="USOID" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:EnforceConstraints="False"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element ref="Request" /> </xs:choice> </xs:complexType> </xs:element> </xs:schema> '***XML Result of Saving from synched XMLDataDocument - saved.xml <?xml version="1.0"?> <NewDataSet xmlns="http://tempuri.org/sample_database_request-11.xsd"> <Request xmlns="http://tempuri.org/sample_database_request-11.xsd"> <RequestID>11</RequestID> <ClearanceTypeID>2</ClearanceTypeID> <Individual> <RequestID>11</RequestID> <IndividualID>40992</IndividualID> <Surname>Jones</Surname> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>39216</EmploymentID> <JobTitle>Painter</JobTitle> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73559</EmploymentID> <JobTitle>Sweeper</JobTitle> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73564</EmploymentID> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73566</EmploymentID> <JobTitle>Student</JobTitle> </Employment> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>73568</EmploymentID> <JobTitle>Manager</JobTitle> </Employment> <CurrentAddress> <IndividualID>40992</IndividualID> <AddressID>7913</AddressID> </CurrentAddress> <BirthAddress> <IndividualID>40992</IndividualID> <AddressID>7914</AddressID> </BirthAddress> </Individual> <RequestForm> <RequestID>11</RequestID> <FormID>1</FormID> <USOID>12997</USOID> </RequestForm> <RequestForm> <RequestID>11</RequestID> <FormID>4</FormID> <USOID>12997</USOID> </RequestForm> </Request> <Employment> <IndividualID>40992</IndividualID> <EmploymentID>1</EmploymentID> <JobTitle>test</JobTitle> </Employment> </NewDataSet> Tag: SQL Server 2000 Timestamp and Dataset Tag: 62589
  - 19
    - ADO.net - How to insert long texts? Hello. I am a beginner concerning ADO.net. I want to access a Microsoft Access file (mdb). Opening the database, selecting rows and reading then from the table-object into my program is no problem. I use a SQL expression to load them (SELECT * FROM table WHERE ?.). But I do not know how to insert new data into the tables or how to update a row. I first tried to generate a SQL command (INSERT INTO table1(...) SET column='Value') but the data I need to handle is a multiline text (CR, LF) and may contain the inverted comma ( ' ) as well... so the SQL-cmd does not work... So I tried to use the Dataset and a CommandBuilder, as long as I do not know how the UpdateCommand and the InsertCommand have to look like (How knows ADO in which section of the SQL Command it should insert the data). But it did not work (Error: "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in microsoft.visualbasic.dll" at Dataset.Update) To cut a long story short: How do I update/insert multiline-texts in my MDB? Thanks Sebastian Walters News-mail.SW@gmx.net Tag: SQL Server 2000 Timestamp and Dataset Tag: 62587
  - 20
    - Application Memory Usage I noticed that any running .NET window application including .Net Visual Studio, when GUI is not minimized and keped running for long time, the memory useage of its could be high, but, when it is minimized the memory useage will be immedictely drop down. I think this is where .Net garbage collection takes place. I am wondering if you can correct on this, and also give me some hints with what are possible ways if I want keep the memory usage low, and how can I call garbage collection explicitlly. Tag: SQL Server 2000 Timestamp and Dataset Tag: 62579
  - 21
    - SqlDataAdapter.Update vs. SqlCommand.ExecuteNonQuery To issue update commands, should I use the Update method of the DataAdapter or use ExecuteNonQuery method of the Command object? Originally I thought the Update method would only update records in the dataset/datatable. I then learned that you first had to write an update command and assign it to the UpdateCommand of the DataAdapter. Further experimentation led me to find out that UNLESS you explicitly define the update command WITH THE SAME FILTERS as your select command that filled the datatable/dataset, the Update method can potentially update more than just the datatable/dataset. That being the case, why not save yourself the extra code and just simply issue the explicit update command with the ExecuteNonQuery???? Am I missing something here? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62574
  - 22
    - How to pass array to oracle function? We are trying to convert the existing java app to .net. I need to call oracle (8) function that takes as one of the parameters a string array (table of varchar2). I have tried oledb and oracleclient but cannot find a type to pass a string array. Is it possible at all? has anybody tried it? Thanks Tag: SQL Server 2000 Timestamp and Dataset Tag: 62561
  - 23
    - Merging multiples datatables I have to query two databases and merge the results to fit in a datagrid. I would like to make something like that : Select Customer.FirstName, Contact.Address From Customer, Contact Where Customer.customerID = Contact.customerID But my problem is the tables Customer and Contact are not in the same database ! I tried to put the two results in th same dataset but I didn't know how to make the reference between the two tables. Someone have an idea ? Thanks in advance, Martin PS : I cannot migrate the data from one database to the other Tag: SQL Server 2000 Timestamp and Dataset Tag: 62559
  - 24
    - Reading a return value from a store procedure with SqlDataReader Hello See the code below , i am trying to erase a row in a=20 table using a stored procedure with 2 parameters. If its=20 not legal to delete the row it 'return 0' or 'return -2'.=20 My problem is that reader.read returns nothing. Me.SqlConnection1.ConnectionString =3D constring Me.SqlConnection1.Open() With Me.SqlCommand1 .CommandType =3D=20 CommandType.StoredProcedure .CommandText =3D "apaga_linha_encomenda" With .Parameters .Add("@numenc", SqlDbType.Char,=20 7).Value =3D enc.DevolveNumEnc .Add("@pos", SqlDbType.Decimal,=20 3).Value =3D enc.DevolvePosEnc End With End With reader =3D Me.SqlCommand1.ExecuteReader While reader.Read If reader.GetInt16(0) =3D 0 Then MessageBox.Show("Esta posi=E7=E3o tem=20 uma obra associada e n=E3o pode ser apagada!", "GPDIN",=20 MessageBoxButtons.OK, MessageBoxIcon.Exclamation,=20 MessageBoxDefaultButton.Button1) Exit While ElseIf reader.GetInt16(0) =3D -2 Then MessageBox.Show("Esta posi=E7=E3o j=E1=20 foi facturada e n=E3o pode ser apagada!", "GPDIN",=20 MessageBoxButtons.OK, MessageBoxIcon.Exclamation,=20 MessageBoxDefaultButton.Button1) Exit While End If End While Me.SqlConnection1.Close() -- Any suggestion would most welcome. Kind Regards Jorge Tag: SQL Server 2000 Timestamp and Dataset Tag: 62556
  - 25
    - Date editing problem in datagrid I have a date field ( short date format in the source table ) set to Type DbType in the parameters for update. I can create a row with this field by specifying the date 01/02/2003 and this is fine. However, when I try to update the field in the grid its takes a while and then comes up with the littlle exclaim mark signifying the row has been modified and gives me a concurrency error if i enter the date in the 01/02/2003 format. Editing other fields are ok. Any ideas ? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62554
- Next
  - 1
    - lost/confused with DataView's Alright, I'm going to attribute this problem to my lack of knowledge on the subject, and that I can't find any good resources describing it. What I have is an application that is used to view the contents of a single table/query, who's contents I want filtered to show only the values with a certian string in a given column. The table/query can be very large, and it may take a bit to read and get to the user, so I don't want to re-read the entire database everytime I change what my filter value is. I thought the fastest/easiest way to do this would be to grab all the data right off the bat, put it in a dataset, and then use dataview's to filter what I wanted to see and display that. but I can't figure out the dataview. I can populate the dataset and then create the dataview, and properties like this: Dim tmp_dataview As DataView = New DataView(priv_dataset.Tables(0)) tmp_dataview.RowFilter = "Project='" & Me.ComboBox1.SelectedItem & "'" But once I get here... I am not sure what I can do with the dataview, or how to access it. Idealy I would like to get to the collection of rows that fit the RowFilter criteria. Any help is greatly appreciated. .: Kyle P.S. Would a Stored Procedure work better for this? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62553
  - 2
    - Question about an error message. Hi all, I am saving data to a Sybase database with a data adapter that call a stored procedures. The procedures have been testing and work fine. The problem is that when I do an update, they data in the data is updated, but the update command of the data adapter throw the exception "The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable." Everything seems OK, but obviously if it's throwing and exception it's a problem. Can anybody give me some backgroup on what this error means? I can't find anything that really explains what it is in the help or MSDN. Thanks, James Tag: SQL Server 2000 Timestamp and Dataset Tag: 62544
  - 3
    - The problem with Try Catch Finally... Variable scope doesn't make sense to me when it comes to Try Catch Finally. Example: In order to close/dispose a db connection you have to dim the connection outside of the Try Catch Finally block. But, I prefer to dim them "on the fly" only if needed (save as much resources as possible). A little further... I may wish to create a sqlcommand and datareader object ONLY if certain conditions are met. But, if I want to clean these up in the Finally then I am FORCED to declare them above the Try. Why??? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62528
  - 4
    - Help: Cleaning up: Close vs Dispose vs Set to Nothing 1. When cleaning up db connections, datareaders, datasets, sqlcommands, etc.. what should you do? (Close or dispose or set it to Nothing, etc...?) 2. What are the differences between Close, Dispose, and setting it to Nothing? 3. Is this code typically handled in the Finally part? Thanks! Tag: SQL Server 2000 Timestamp and Dataset Tag: 62525
  - 5
    - Dataset Errors and webservices Hi, I have a component that takes a dataset and updates it. It handles the concurrency update issue by setting the RowError property during the RowUpdated event. This all works well when it is called directly from a windows client. If I create a webservice to wrapper the component then the webservice fails when the RowError property is set. Any ideas please Ian Cox Tag: SQL Server 2000 Timestamp and Dataset Tag: 62524
  - 6
    - sql query return to a collection I want to do a query on an access db and have the results returned into a array or collection in vb.net... how do I do this? I know the basic connection and stuff.. just not how to get the result to an array thanks Tag: SQL Server 2000 Timestamp and Dataset Tag: 62519
  - 7
    - DataGrid cells, any way to get them to display combo boxes ? I have a field called event type, i wan the user 2 b able 2 choose one of three possible values by editing the cell directly, does anyone know if this is possible ? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62508
  - 8
    - Installing OracleClient Hi, I'm not able to import system.data.oracleclient in my asp.net webform after downloading and installing .net managed provider for oracle (oracle_net.msi) successfully. It doesn't showup in the list. Thx. Tag: SQL Server 2000 Timestamp and Dataset Tag: 62507
  - 9
    - stored Proc Returning only the Value 7 i have written a stored procedure in Oracle with client Oracle 8. This procedure is called by an ASP.NET Application with Code written in C# PROCEDURE Spvalidatemobilenumbernew( pinumOldMobileNumber IN SERIALNUMBERTRACK.N_SERIALNUMBER% TYPE, pinumSimNumber IN SIMMOBILE.N_SIMNUMBER%TYPE, pinumResult OUT NUMBER, ) IS countSerialnoTrack NUMBER; countItemMaster NUMBER; varStatus SERIALNUMBERTRACK.V_STATUS%TYPE; charDeleted SIMMOBILE.B_DELETED%TYPE; varCategory ITEMMASTER.V_ITEMCATEGORYTYPEID%TYPE; BEGIN SELECT COUNT(*) INTO countSerialnoTrack FROM SERIALNUMBERTRACK WHERE N_SERIALNUMBER =pinumOldMobileNumber AND UPPER(V_SERIALNUMBERTYPE)='M'; IF( countSerialnoTrack > 0) THEN --get the status of the mobile number if present SELECT V_STATUS INTO varStatus FROM SERIALNUMBERTRACK WHERE N_SERIALNUMBER =pinumOldMobileNumber AND UPPER(V_SERIALNUMBERTYPE)='M'AND V_STOCKCODE='MB_00_000'; --chk the status of the mobile number and take respective - --action IF(UPPER(varStatus)='ASSIGNED') THEN pinumResult :=1; RETURN; ELSE IF(UPPER(varStatus)='UNBLOCKED') THEN pinumResult :=2; RETURN; ELSE IF(UPPER(varStatus)='OUTOFSYS') THEN SELECT B_DELETED INTO charDeleted FROM SIMMOBILE WHERE N_SIMNUMBER=pinumSimNumber AND N_MOBILENUMBER= pinumOldMobileNumber; IF(UPPER(charDeleted) = 'N') THEN SELECT COUNT(*) INTO countItemMaster FROM ITEMMASTER WHERE V_STOCKCODE='MB_00_000'; IF(countItemMaster >0) THEN SELECT V_ITEMCATEGORYTYPEID INTO varCategory FROM ITEMMASTER WHERE V_STOCKCODE='MB_00_000'; IF(UPPER(varCategory)='CRPTP') THEN --success pinumResult :=3; RETURN; ELSE pinumResult :=4; RETURN; END IF; ELSE pinumResult :=5; RETURN; END IF; --countitemmaster ELSE pinumResult :=6; RETURN; END IF; END IF; -- outofsys END IF; --unblocked END IF; --assigned ELSE --old mobile no does not exist in SERIALNUMBERTRACK pinumResult :=7; pivarvchanswer:='seven'; RETURN; END IF; END Spvalidatemobilenumbernew; The issue is that irrespetive of whatever the value of input parameteres is the result returned is always 7 . i have validated the queries written in the procedure individually for some input values. when executed individually they retun a different value for an input. when the same input is passed as parameter to procedure, the procedure returns only 7. I would appreciate any help or guidance in solving this matter. Thanx and regrads Sabby Tag: SQL Server 2000 Timestamp and Dataset Tag: 62501
  - 10
    - DataColumn storing an Object when using Typed Datasets Hi Guys, I have a situation where i want to store an objet in the datacolumn, the doc stores that the data column can be only one of the basic data types like string etc... From one of the searches i came to know that it can store Object too, However has anyone used this approach of storing objects inside the datacolumn? i.e a datacolumn of type MyType? Can some one let me know 1) the way the schema needs to be modified to get this desired result? 2) Any drawbacks of using this way? The reason i want to do this is because i do not want to pass the entire Data set to all the objects as it is really huge.. and passing datacolumns is an alternative.. if it contains all i wantit to contain Best Regards, hitesh Tag: SQL Server 2000 Timestamp and Dataset Tag: 62498
  - 11
    - Dataset.Rows.Find and CurrencyManager Here's the problem, I am populating a TreeView with the contents of a (Strongly typed) dataset. for (int i = 0; i < dataSet.Cust.Rows.Count; i++) { DataSet.CustRow row = (DataSet.CustRow)dataSet.Cust.Rows[i]; TreeNode node = treeView1.Nodes.Add(row.CUST_NAME); node.Tag = row.CUST_ID; } I also have several field controls on the Form which are dataBound to the dataset fields. In the tree node AfterSelect event, I am trying to move the CurrencyManager.Postion value so that the Bound fields are updated with the values in the corresponding rows. (It would have been nice to have a databound treeview control) I retrieve the node.Tag and do a Find on the dataset row. This does not move the Postion in the Currency Manager. I tried saving the Position in the node.Tag. That worked until I started inserting new nodes into the Dataset and could not find the Position in the Currency Manager refering to the inserted dataset row. I also tried using CurrencyManager.AddNew(). The Position does not seem to change on that command and I am not clear as to how a new dataRow is added and populated as a result of AddNew. Any ideas how to implement this? Thanks Sol Tag: SQL Server 2000 Timestamp and Dataset Tag: 62496
  - 12
    - unwanted Type of System.DBNull I'm trying to get data out of an excel file, but for first column below the Type is System.DBNull. The other 2 columns the Type is System.String. But then after a few more rows, a second column's type becomes System.DBNull so whenever the type is System.DBNull, I can't get the cell value as a string. What causes a cells Type to be System.DBNull? tia Randy mytype = ds_sma.Tables["ExcelSheet"].Rows[intRow] [194].GetType(); mytype = ds_sma.Tables["ExcelSheet"].Rows[intRow] [195].GetType(); mytype = ds_sma.Tables["ExcelSheet"].Rows[intRow] [193].GetType(); Tag: SQL Server 2000 Timestamp and Dataset Tag: 62487
  - 13
    - DataBound WebForms DataSet goes Empty Having a little trouble getting at my data after the webform I'm using is submitted. Perhaps this is better posted to web forms, but its my ADO implementation that seems to be the problem. I'm using a DataSet control on a form that I bind the form's controls to. But when I check that DataSet at the server after a button click on the form, its completely empty, no DataTables in it at all. Any insights would greatly be appreciated. <form runat=server> <asp:TextBox id="txtTitle" runat="server" Text='<%# DataBinder.Eval(DsArticles1, "Tables[Table].DefaultView.[0].Title") %>'> </asp:TextBox> </form> Protected WithEvents DsArticles1 As News.DSArticles 'DS object on web form Sub Page_Load() Dim oArticles As Articles.Articles oArticles = New Articles.Articles() 'Custom Data Retrieval Object - returns a DS Dim oDS As DataSet oDS = oArticles.GetArticles("WHERE ID = '" & strID & "'") DsArticles1.Merge(oDS) DataBind() Response.Write(DsArticles1.Tables("Table").Rows.Count) '**** RETURNS 1 **** ' Works great, Form shows the data from this row per data bound control as above txtTitle End Sub Sub butSave_Click System.Diagnostics.Trace.Write(DsArticles1.Tables("Table").Rows.Count) ' **** NOW RETURNS 0 **** ' In fact, now there are no datatables in this dataset at all. System.Diagnostics.Trace.Write(DsArticles1.GetXml) ' **** RETURNS: '<DSArticles xmlns="http://tempuri.org/Schema_Articles.xsd" />' **** System.Diagnostics.Trace.Write(txtTitle.text) ' **** RETURNS PROPER FIELD VALUE **** End Sub Tag: SQL Server 2000 Timestamp and Dataset Tag: 62483
  - 14
    - AddNewRow Hi,I am trying to a several rows like this: 1. Get new datarow from typed DataTable object (datatable) 2. Set datarow's values (except the primary key - it's marked as identity and is generated by sql server) 3. Add datarow to my datatable object after adding several rows I call Update on dataadapter passing my datatable object to it. The error I get is that primary key constraint is being violated. Why? When I dump primary keys of my datarow collection, they are all unique. Any help? Thanks! Tag: SQL Server 2000 Timestamp and Dataset Tag: 62482
  - 15
    - ADO.NET vs. RDS The current version of my company's app uses RDS objects for all of our data access/updates. Our new version of the app will be built in .NET. In playing around with ADO.NET, it seems to me, it seems to me that ADO.NET is a TON slower than RDS was. Can anybody help me set up ADO.NET to work faster for me. I don't need any data binding or anything like that. Ideally I just want to grab a recordset, send that to the client, and when/if needed I'll post the changes back to the DB. Any help would be greatly appreciated! -Aaron Tag: SQL Server 2000 Timestamp and Dataset Tag: 62481
  - 16
    - DataAdapter,plz help ! am having problem updating data with dataadapter....in some of my tables. I realize that, Dataadapter doesn't SOMETIME fire event rowupdating even if there are new rows. Because of that,rows are not updating in Databases. I use olecommandbuilder to generate Insert command. Update and Delete work but only new rows are not inserted. i do not call acceptchanges before update. What to do??? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62475
  - 17
    - Binding a Business object to a datagrid with multiple levels I have a arraylist of workorders that I can bind to the datasource of a datagrid. However, each workorder has a building object that has properties as well. How can I access these subproperties of the building object in the datagrid? I can access these single level fields easily Workorder.Description but how do I access sub fields?? Workorder.Building.Description Tag: SQL Server 2000 Timestamp and Dataset Tag: 62467
  - 18
    - Question: Easiest way to update 1 field in db I have a text field with a value. What is the easiest way to update the database with this value? I think a dataset would be overkill. Can't I just run the UPDATE SQL command directly? Can you provide a sample? Thanks. Tag: SQL Server 2000 Timestamp and Dataset Tag: 62459
  - 19
    - dotNet - syntax for parms in SQL Connection? I need to pass along parms in an SQLConnection. EG con = (New SqlConnection("Data Source=mySQLserver;user id=UserName; password=UserPassword;Initial Catalog=northwind")) The function is passed the values as parms and needs to pass them along to SQLServer. ie: <WebMethod()> Public Function ValidateUser(ByVal UserName As String, _ ByVal UserPassword As String) As Boolean I have tried UserName, @UserName, &UserName in the SQLConnection string. None work.. It thinks it is a user name in plain text. What is the correct syntax for passing userid and password so that the VALUES are passed, rather than the literal? All the examples show either username/password in plain text or "Integrated Security=SSPI;". Thanks! Tag: SQL Server 2000 Timestamp and Dataset Tag: 62458
  - 20
    - OleDbCommand / ADO.Net Recordset I've used the OldDbCommand to retrieve some data (SELECT query) -- I have two questions. 1. How do I find out how many records where retrieved WITHOUT looping through the results and incrementing a counter? Is there a direct way of some sort? 2. How do I initialize an array and add all my Primary Keys ("ProductID") to an array while looping through the results? Thanks. Tag: SQL Server 2000 Timestamp and Dataset Tag: 62449
  - 21
    - nulled out - defaults instead? OK, I'm nulled out. I am converting a dbase based enterprise wide system that has almost 100 tables to convert into a vb .net system using ms sql server 2000 (I am posting this both to ado .net newsgroups and sql server newsgroups). I am working with a prototype where many of the columns in many of the tables allow nulls. But often I can't call ... is null (in tsql) or isdbnull(...) in vb .net on the same line as, say, 'or len(trim((dddd)) < 1' because this throws an error if the col is null, since you can't measure anything when a col is null. Now null might have a place in the universe - like black holes - but not being Stephen Hawkings I just don't know what that place is. But in vb .net especially and to some extent in tsql also, it's just a pain in the .... My question - is there any reason I shouldn't convert into tables where, when the data is converted if it's empty or 0 (int) or # / / # (date), I use defaults instead (eg, "", 0, 01/01/1900 respectively)? Do I lose anything by doing this? Tx for any help. Bernie Yaeger Tag: SQL Server 2000 Timestamp and Dataset Tag: 62443
  - 22
    - Re: Calling a procedure For some reason, this line didn't show correctly on the first post. It should be SqlCommand cmdSchedule = new SqlCommand("StudentSchedule", this.cnBCC); Jon Cosby Tag: SQL Server 2000 Timestamp and Dataset Tag: 62441
  - 23
    - Calling a procedure How do you call an existing procedure? My database has a procedure called "StudentSchedule" with one parameter, @StudentID. I'm trying to fill the results in a datagrid with a StoredProcedure command. The grid is not even showing on the page. SqlCommand cmdSchedule = new SqlCommand(, this.cnBCC); cmdSchedule.CommandType = CommandType.StoredProcedure; SqlParameter studID = cmdSchedule.Parameters.Add("@StudentID", SqlDbType.NChar, 9); studID.Value = this.tbSID.Text.Trim(); SqlDataAdapter daSchedule = new SqlDataAdapter(cmdSchedule); DataSet ds = new DataSet(); daSchedule.Fill(ds); this.dgStudents.DataSource = ds; Jon Cosby Tag: SQL Server 2000 Timestamp and Dataset Tag: 62440
  - 24
    - simple PrimaryKey question background: I have a table in the database, 1 column in the table is a primarykey. 2 columns in the table do not allow nulls (one of those columns being the column that is a primarykey) problem: DataColumn [] dc = myDataSet.Tables["mytable"].PrimaryKey; MessageBox.Show(dc.Length.ToString()); // shows "0" when it should show 1 somehow im not reading that there is a primarykey in the table in the db. also: foreach(DataColumn dc in myDataSet.Tables["mytable"].Columns) { if(dc.AllowDBNull) //this is ALWAYS true, which should not the case because 2 columns dont allow nulls. //do something } I know i am reading the table correctly with the DataAdapter, as I can display/edit rows in a dataset. because I can Update and save my changes, the table /must/ have a PrimaryKey, otherwise the Update wouldn't work.. But why can't I see it? Tag: SQL Server 2000 Timestamp and Dataset Tag: 62439
  - 25
    - Updating a dataset with both inserted and deleted records Is there a way to update a typed dataset with both inserted and deleted records back to datasource in a persistent way? Let's use the purchase order as example. If my typed dataset is built from joining PO table and Item table with parent and child relationship. When I inserting a new PO I'll have to insert the PO record first; while when I deleting a PO I'll have to delete the Item record first because the parent child constrain. In which case my update function will have to identify the insert and delete records and update accordingly. Is there an easier approach to handle this? Thanks. Tag: SQL Server 2000 Timestamp and Dataset Tag: 62437

Hi all

I experience Problem when using SQL Server Timestamp
attribute. I have a DataAdapter defined to use Stored
SQL Procedure for select, insert, update and delete.

When i fill the DataSet i also populate it with the
SQL2K Server Timestamp. How can i pass the Timestamp value
back in the Dataset or how is the correct definition of
the Dataset for the Timestamp value.

When i perform a update with the DataAdapter.Update Method
the Update will fail if i have a statement like this
in the Stored Proc:
Update Table set Name = @Name where ID_Table = @ID and
Tstamp = @Tstamp

If is use the statement :
Update Table set Name = @Name where ID_Table = @ID
with no Timestamp the Update is well working.

I guess that the Timestamp value is not passed in the Format
needed.

The DataAdapter is generated with the wizard. I'm using a typed
Dataset.

Do you have some suggestion / help ?

Best Regards
Paolo Taverna

Top