I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong

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
    - Returning Xml as text from Oracle Stored Proc I am returning Xml from an oracle stored procedure using the Oracle managed provider, using a ref cursor to fill a dataset. The Xml is stored as a varchar on the database, but when I retrieve it, all newline tab and double quote characters have been escaped. e.g. "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<regstudio>\n\t It looks fine when running the stored proc in Sql+. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91524
  - 2
    - Psuedo code for ADO .NET procedure I've ordered Bill Vaughn's book, which I hope will help me with this, but in the meantime, can someone point me to an RTFM or give me some outline of how to attack this problem? I've read the docs and even a book on ADO .NET, so I'm familiar in general with all the components (DataAdapters, DataReaders, DataSets, DataTables, etc.) I'd simply like to display all athletes in a specific grade joined to a table that shows their sport (table defs and query below). I'd like this to be in a grid that the user can edit to change athlete information, then update the database. I don't care if the solution is manual or disconnected, or whatever... I just need to get started with this stuff to better understand it. CREATE TABLE ATHLETE (ATHLETE_ID INT NOT NULL, SPORT_ID INT NOT NULL, LNAME VARCHAR(100), FNAME VARCHAR(50)) CREATE TABLE SPORT (SPORT_ID INT NOT NULL, SPORT_NAME VARCHAR(100), MAX_PARTICIPANTS INT) SELECT LNAME, FNAME, SPORT_NAME FROM ATHLETE, SPORT WHERE ATHLETE.SPORT_ID = SPORT.SPORT_ID Simple example, but it will get me moving. Thanks, billy Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91512
  - 3
    - ADO.NET (XML) missing I would like to select the ADO.NET (XML) option under "Make New Connection" for Crystal Reports, but it is missing. How can I get this to appear on the list? Thanks, Dominic Isaia disaia@earthlink.net Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91509
  - 4
    - MySQL and count(*) Is there a known issue with MySQL and count(*) ? Whenever i use count(*) in a SELECT command it returns 0 rows. Thanks Robert Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91500
  - 5
    - Creating views from linked servers I have created a linked server to an Oracle database (using the Oracle ODBC driver 8.01.07.00) that I wish to query in SQL Server 2000. My SQL server contains other applications that my web application uses. The web application has a data access layer (a series of classes) which call stored procedures, which in turn call views. Using Query Analyzer, I can query data with the following: SELECT TOP 100 PERCENT * FROM OPENQUERY(PAY_PERS_EXTR, 'Select * from TABLE1') Appointment_Distributions INNER JOIN OPENQUERY(pay_pers_extr, 'select * from TABLE2') Person ON Appointment_Distributions.EMPLOYEE_ID = Person.EMPLOYEE_ID ORDER BY Appointment_Distributions.EMP_NAME My problem is that I'm not able to successfully save a view that contains the results that I wish, using the above syntax. The error is: ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction. [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoi JoinTransaction returned 0x8004d01b]. Looking this up, I found this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;280106 However, I'm using Oracle's driver, not Microsoft's. Any ideas or contacts? Thanks, Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91498
  - 6
    - Oracle date problem We are having problems while retrieving dates from the oracle provider. If we make a query with SQLPLUS we obtain the exact date. Using the oracle client provider included in ado.net we obtain dates with 1 or -1 differences. For example, in the table the date is 11/Jan/2004 , and it returns 10/Jan/2004 The problem is with the time recorded in the field. What can the problem be??? Thanks. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91497
  - 7
    - sqlcommand stored procedure returning date Parameter Hi all, Trying to just return a date, keep getting vb.net error on "Dim DataReader As SqlDataReader = EusCmd.ExecuteReader()" ***VB.net Private Function getLastDate() As DateTime FunctionMainConnection() Dim EusCmd As New SqlCommand("getlastdate", MainSQLConn) MainSQLConn.Open() Dim DataReader As SqlDataReader = EusCmd.ExecuteReader() EusCmd.CommandType = CommandType.StoredProcedure EusCmd.CommandTimeout = 20 EusCmd.Connection = MainSQLConn EusCmd.Parameters.Add("@out", SqlDbType.DateTime) ' Output Parameter EusCmd.Parameters("@out").Direction = ParameterDirection.Output While DataReader.Read getLastDate = DataReader.GetString(0) End While DataReader.Close() MainSQLConn.Close() End Function **********SQL stored procedure CREATE PROCEDURE getlastdate @lastd datetime out AS set @lastd = (select CONVERT( CHAR(12), max(incrementDate),101) from EusBatchIncrement) GO Thanks for your help Gerry Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91487
  - 8
    - Update access file from datagrid Look my prog. I have combobox where is have all tables names of access file. The user select one table and the content is show in datagrid. The user can add, erase or modify some record or row. Until now is ok but went I want to update access file, VB send me error. Some body can help me Dim myCnn As New OleDb.OleDbConnection Dim objDataAdapteur As OleDbDataAdapter Dim objDataSet As New Data.DataSet Dim objDataTable As DataTable ---------------------------------------------------------------------------- --------------------------------------------------------------- Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged myCnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AccessFile & ";" myCnn.Open() Dim strSQL As String = "SELECT * FROM [" & TableName & "]" objDataAdapteur = New OleDb.OleDbDataAdapter(strSQL, myCnn) Dim objCB As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(objDataAdapteur) objDataAdapteur.Fill(objDataSet, TableName) objDataTable = objDataSet.Tables(TableName) DataGrid1.SetDataBinding(objDataTable, "") End Sub ---------------------------------------------------------------------------- -------------------------------------------------------------- 'Click on button to copy modify on datagrid in access file Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click objDataAdapteur.Update(objDataSet, TableName) myCnn.Close() End Sub Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91485
  - 9
    - Loaddatarow adds a row even when pk exists in the dataset Here is the code. I know I am doing something wrong, but for the life of me I can't see it. I keeps adding a new row to the table rather than updating the current row. This is being called from a web form. I am really stuck and I need some guidance. Private Sub updateuser() Dim username As String Dim xmdr(5) As Object On Error GoTo handler xmdr(0) = recordid xmdr(1) = Trim(Me.email.Text) xmdr(2) = Trim(Me.loginid.Text) If Me.passwrd.Text <> Nothing Then xmdr(3) = FormsAuthentication.HashPasswordForStoringInConfigFile(Trim(Me.passwrd.Text), "sha1") Else Me.passwrd.Text = DataGrid1.SelectedItem.Cells(3).Text xmdr(3) = FormsAuthentication.HashPasswordForStoringInConfigFile(Trim(Me.passwrd.Text), "sha1") End If xmdr(4) = Me.company.Text If CheckBox1.Checked = True Then xmdr(5) = "A" Else xmdr(5) = "S" End If Dim userrow As DataRow DataSet11.User_table.BeginLoadData() DataSet11.User_table.LoadDataRow(xmdr, False) DataSet11.User_table.EndLoadData() 'DataSet11.User_table.AcceptChanges() Me.OleDbDataAdapter1.Update(DataSet11) Me.DataSet11.Clear() Me.OleDbDataAdapter1.Fill(DataSet11) DataGrid1.DataBind() Exit Sub handler: Dim errorval As String errorval = Err.Description 'MsgBox(errorval, MsgBoxStyle.Information, "Error") Resume Next End Sub --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91484
  - 10
    - Loaddatarow adds a row even when pk exists in the dataset Here is the code. I know I am doing something wrong, but for the life of me I can't see it. I keeps adding a new row to the table rather than updating the current row. This is being called from a web form. I am really stuck and I need some guidance. Private Sub updateuser() Dim username As String Dim xmdr(5) As Object On Error GoTo handler xmdr(0) = recordid xmdr(1) = Trim(Me.email.Text) xmdr(2) = Trim(Me.loginid.Text) If Me.passwrd.Text <> Nothing Then xmdr(3) = FormsAuthentication.HashPasswordForStoringInConfigFile(Trim(Me.passwrd.Text), "sha1") Else Me.passwrd.Text = DataGrid1.SelectedItem.Cells(3).Text xmdr(3) = FormsAuthentication.HashPasswordForStoringInConfigFile(Trim(Me.passwrd.Text), "sha1") End If xmdr(4) = Me.company.Text If CheckBox1.Checked = True Then xmdr(5) = "A" Else xmdr(5) = "S" End If Dim userrow As DataRow DataSet11.User_table.BeginLoadData() DataSet11.User_table.LoadDataRow(xmdr, False) DataSet11.User_table.EndLoadData() 'DataSet11.User_table.AcceptChanges() Me.OleDbDataAdapter1.Update(DataSet11) Me.DataSet11.Clear() Me.OleDbDataAdapter1.Fill(DataSet11) DataGrid1.DataBind() Exit Sub handler: Dim errorval As String errorval = Err.Description 'MsgBox(errorval, MsgBoxStyle.Information, "Error") Resume Next End Sub --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91483
  - 11
    - CurrencyManager_ItemChanged Question. Hi There, I have a windows form that uses binding through a currency manager. A dataset fills tan Adapter and everything thing is good in life. A list box gets populated with a list of names and that works good, whenever I click on a item on the list box the data on the side updates. This is the problem that I'm getting though, When I change some data on the right, let's say the lastname or first name that does not get reflected on the listbox, for that, I have included this code on the currencymanager_itemchanged event. Private Sub mCurrencyManager_ItemChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.ItemChangedEventArgs) Handles mCurrencyManager.ItemChanged Dim combined_name As String Dim data_row As DataRow combined_name = txtLastName.Text & ", " & txtFirstName.Text data_row = mCurrencyManager.Current.Row If data_row.Item("FullName") & "" <> combined_name Then data_row.Item("FullName") = combined_name End If End Sub The thing is, this code should fire up whenever I change and item on the currencymanager right? but It does not, it ignores it totally. Can anybody tell me what Am I doing wrong here? give me some hints on how I can accomplish this? Thanks in advance. Manny Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91480
  - 12
    - Data Access Application Block - Using UPDATEDATASET and Returning an Identity? Hi, I am tring to use the Microsoft Data Access Application Block v2 to update the database. However, i need the stored procedure to return the Identity value to the client application so it can know the ID of the inserted record. Example: Stored Procedure: CREATE PROC Person_Insert @LASTNAME VARCHAR(30), @FIRSTNAME VARCHAR(30), @PersonID BIGINT OUTPUT as INSERT INTO PERSON (LASTNAME, FIRSTNAME) VALUES (@LASTNAME, @FIRSTNAME) SET @PersonID = (SELECT SCOPE_IDENTITY()) C# Code: public void SavePerson(DataSet ds) { SqlConnection CurrentConnection = new SqlConnection connString); CurrentConnection.Open(); SqlCommand insertCommand = SqlHelper.CreateCommand CurrentConnection, "Person_Insert", "LASTNAME", "FIRSTNAME"); SqlCommand updateCommand = SqlHelper.CreateCommand(CurrentConnection, "Person_Update", "PersonID", "LASTNAME", "FIRSTNAME"); SqlCommand deleteCommand = SqlHelper.CreateCommand(CurrentConnection, "Person_Delete", "PersonID"); SqlParameter outParam = new SqlParameter(); outParam = updateCommand.Parameters.Add("@PersonID",SqlDbType.BigInt); outParam.Direction = ParameterDirection.Output; SqlHelper.UpdateDataset(insertCommand, deleteCommand, updateCommand, ds, "table"); Console.WriteLine("UPDATE COMMAND OUTPUT PARAM:"); Console.WriteLine(outParam.Value.ToString()); } Console Output: UPDATE COMMAND OUTPUT PARAM: The program '[2120] SmartClient.exe' has exited with code 0 (0x0). This isn't working though. Any thoughts??? {Thanks in advance} Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91471
  - 13
    - DataRelation - update parent and child at same time? Hello ADO.NET gurus :) I am fairly new to database work and am hoping someone can help me with a DataRelation question. Anyway, I am working with an orders database. I have a DataTable of orders, and another DataTable of order details, and need to get new orders into my database. I was able to set up a DataRelation between the two tables, however I have an unfortunate limitation: I need to add the new orders and their details in the same database transaction. (This is due to the limitations of my database, which is proprietary and not relational.) Therefore I can't follow David Sceppa's recommendation of first adding the order and then updating the line items. I think the best solution would be to pull in the details table when I update the master (or vice versa), but I'm not sure if this is possible. Is it? The other alternative I see is to maintain a cache, have the details table update to this cache, and then pull in the cache when you update the master table. However, I'd rather avoid this for a variety of reasons. Can anyone offer some suggestions? Thank you! Mike Milner Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91468
  - 14
    - IDataParameter.ParameterName Hi all, Excerpt from the docs: "The ParameterName is specified in the form @paramname". What's the so called "form" supposed to be? It's a string starting with '@', what else? radi Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91459
  - 15
    - ADO.NET C#: varchar() fields are padded with spaces on some records Hi, I'm reading a table with varchar() strings. For some reason this fields is sometimes padded up to the max length with spaces. To be sure that the length is correct in the MSSQL 2000 database I added a len(MyField) in the query. SELECT MyField, LEN(MyField) FieldLen FROM MyTable If I watch the contents of SqlDataReader on a 'good' record I see: _comBuf[0] "Estna" _comBuf[1] "5" In case the field is padded I see: _comBuf[0] "Kos " _comBuf[1] "3" So the length that SQL returns is 3, but in ADO the length is 20 (which is in fact the maximum length). I create a workaround to trim the field in the code, but it seems incorrect behaviour. Any comments? Regards, Rene Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91458
  - 16
    - ConnectionState issue I'm seeing something weird and I must just be overlooking something. I have a connection and I open it(connection is named 'cn'). I close it in my execution block but I have it wrapped in a Try/Catch/Finally and in finally I check if the connectionState <> ConnectionState.Closed - if it's not then I call .Close. However, even though it successfully closes and the debugger tells me it's closed in the If Statement, it still runs to Close. This isn't a big deal in that it doesn't cause any problems but I've verified that the connection is closed and I'm wondering what's up with that? Finally Debug.Assert(cn.State = ConnectionState.Closed) 'The assertion doesn't fail indicating that it's in fact close If cn.State <> ConnectionState.Closed Then cn.Close() If I put my cursor here (On cn.State) it indicates closed as well, but it always calls Close anyway. Any ideas? End Try -- W.G. Ryan, eMVP Have an opinion on the effectiveness of Microsoft Embedded newsgroups? Let Microsoft know! https://www.windowsembeddedeval.com/community/newsgroups Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91457
  - 17
    - Modificar filas añadidas a un DataSet Hola a todos: Tengo un DataSet al cual se le han añadido unos registros. Antes de actualizar la BD accedo a las filas añadidas y modifico un campo a partir de unos cálculos y después hago el AccepChanges del dataset temporal, tras el cual hago los INSERT con un ExecuteNonQuery de esas filas. With ds If .HasChanges Then Dim tempDS As DataSet = .GetChanges(DataRowState.Added) If Not IsNothing(tempDS) Then Dim iContador As Integer = 0 For Each row as DataRow In tempDS.Tables(0).Rows tempDS.Tables(0).Rows(iContador)("Calculo") =iContador*........ iContador += 1 Next tempDS.AcceptChanges() For Each row In tempDS.Tables(0).Rows InsertaDatos(row) Next El caso es que funciona correctamente pero no se me actualizan los datos del campo "Calculo" en el DataSet ds, con lo que tengo que recargar el Dataset cada vez. ¿Como puedo recuperar la alguna referencia a la fila en el dataset ds desde la fila añadida en el dataset temporal de filas añadidas para poder actualizar el campo "Calculo"? Gracias por anticipado. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91454
  - 18
    - Apply DataView.Sort once, for sorting snapshot, data update should not resort Hi. Is there anyone who knows how I can use a datatable, dataview (and datagrid) and have the sorting that I specify, DataView.Sort="col dir", to only be evaluated when set (once) and not have the view resorted constantly. Currently I'm drowned with Moved events. If I try to do this smart stuff dv.Sort = "colA ASC"; dv.Sort = ""; the view immediately goes back to some default sort. (primary key in table) The datatable holds dynamic data that is update continously but I don't want my grid rows to fly around.. sigh Regards & TIA /Stefan Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91452
  - 19
    - Using DataView or Select expression on a DataTable to filter distinct records From the brief research that I have done, nothing is mentioned about being able to filter out distinct records from a DataTable using DataView or or using the select method like: someDataTable.Select() = someExpression. Because I need my DataTable to contain all the records, but I only want to show distinct records, I have a for loop and some register variables that test whether current record is distinct or not. This method works the way I want to, but is there a better way to do it using a DataView or the select method as mentioned above? Thank You, John Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91447
  - 20
    - Problem with binding data retrieve from oracle DB to textbox Did anyone know how to bind the data retrieve from Oracle Database to textbox control. I try with following code but it display this error message: "An unhandled exception of type 'System.ArgumentException' occurred in system.windows.forms.dll Additional information: Cannot bind to property or column dName on DataSource." This error indicate this code"txtDept.DataBindings.Add("Text", ds, "dName");" I call these function when form load. private void fillDataSet() { try { staff = new Staff(); da = staff.GetStaffDetail(); ds = new DataSet(); da.Fill(ds,"Staff"); dt = new DataTable("Staff"); dv = new DataView(dt); dgStaff.DataSource = ds.Tables["Staff"].DefaultView; cm = (CurrencyManager)(BindingContext[dv]); ds = null; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } private void bindFields() { txtDept.DataBindings.Clear(); txtDeptId.DataBindings.Clear(); txtStaffId.DataBindings.Clear(); txtStaffName.DataBindings.Clear(); txtTel.DataBindings.Clear(); txtDept.DataBindings.Add("Text", ds, "dName"); txtDeptId.DataBindings.Add("Text", ds, "dId"); txtStaffId.DataBindings.Add("Text", ds, "sId"); txtStaffName.DataBindings.Add("Text", ds, "sName"); txtTel.DataBindings.Add("Text", ds, "sContact"); } This is a Staff class which responsible to retrieve data from oracle database. public class Staff { private string connStr = "Provider=MSDAORA;Data Source=HONG;User ID=scott;Password=tiger"; private System.Data.OleDb.OleDbConnection conn; private System.Data.OleDb.OleDbDataAdapter da; private System.Data.OleDb.OleDbCommand comm; private System.Data.OleDb.OleDbDataReader dr; private string strSQL; private int maxId; public OleDbDataAdapter GetStaffDetail() { strSQL = "SELECT s.sId, s.sName, s.dId, s.sContact, d.dName " + "FROM Staff s, Department d WHERE s.dId = d.dId"; conn = new OleDbConnection(connStr); conn.Open(); da = new OleDbDataAdapter(strSQL, conn); return da; } } Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91440
  - 21
    - PHP and ASP.NET go HEAD to HEAD PHP and ASP.NET Go Head-to-Head By Sean Hull http://otn.oracle.com/pub/articles/hull_asp.html SUMMARY at the BOTTOM Speed and efficiency. As I mentioned earlier, ASP.NET is a framework allowing you to use various programming languages. In addition, it is touted as having a great object-oriented model. All this is true, but it becomes a detriment as far as speed is concerned. For all that advantage, there is a lot more code to run through to execute the same ASP page than you have to execute in the PHP engine for an equivalent PHP page. PHP is the quick-and-dirty type of solution, the one to get the job done. And though a lot of robustness has been added to it since its 2.0 and 3.0 days, it still retains that core optimized high-speed approach. Speed is not the only consideration. Memory usage is also important. SECURITY COMPARISON ASP.NET officially requires that you use IIS. Unfortunately, IIS has a long history of vulnerabilities, which makes many administrators reluctant to deploy it to handle their web site. Whether these weaknesses are because of Microsoft's ineptness or because IIS is a real red flag to hackers is irrelevant: Those systems have a history of being hacked and compromised. PHP runs on Apache, too, which is fast and open source and has a good security track record. Also, as I mentioned, Apache runs on many platforms. So is PHP really faster than ASP.NET or is that for certain unoptimized pages? And are they comparing this against the DataGrid instead of the repeater control or even the fastest way using asp.net's inline code render block, <% %> comments? Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91438
  - 22
    - How to insert an "object" into a DataRow? Hi all, I have a problem adding an object or a structure (made with "struct" keyword) into a DataRow object?? How can I do so? The problem is that I can add it but when trying to read the content, the compiler tries to read the data as STRING?!??! I don't know why? Can anyone help me? I'd highly appreciate your help, Veszko ---------------------------------------------------------------------------- ----------------------------- Example ---------------------------------------------------------------------------- ----------------------------- public struct UserData { public string sSerial; public int iSUP_Id; public Image imgPhoto; } . . . DataTable dtTable = new DataTable("Users"); dtTable .Columns.Add("iID"); dtTable .Columns.Add("sName"); dtTable .Columns.Add("oData"); UserData oUserData = new UserData(); oUserData.sSerial = "something"; oUserData.iSUP_Id = -1; oUserData.imgPhoto = PictureBox1.Image; DataRow drRow = dtTable.NewRow(); drRow["iID"] = -1; drRow["sName"] = "some name"; drRow["oData"] = oUserData; // Here the data is not stored correctly, when watching it inside the debugger you can cleary see that only the name of the structure is stored as String! . . . UserData oCurrentUserData = (UserData) drRow["oData"]; // Here an error occurs!! ---------------------------------------------------------------------------- ----------------------------- Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91436
  - 23
    - Force Requery I have a dropdownmenu which is databound to a table via a dataadapter and dataset. A control on another part of the form updates the same table in the database. On postback the dropdown does not show the new record. I have tried the autopost back on true or false. I am assuming the dataset is remaining disconnected. Is there an easy way to get the dataadapter to requery itself. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91432
  - 24
    - Insert problem !! Hi all I am having an insert problem with values of different data types. I have a form that has text boxes accepting information that goes into a table with String int & decimal data types. I have used the convert.toInt and convert.toDecimal but i am having trouble building the SQL statement Here is a sample of my code ***************************************************** Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click Dim strSQL As String Dim strCnn As String 'create a connection string to connect to the database strCnn = BuildCnnStr("MainPC", "SDSDatabase") 'create the connection Dim cn As New OleDb.OleDbConnection(strCnn) 'conection is open cn.Open() 'set up the sql string to insert the values collected from the Text Boxes strSQL = "INSERT into inletCone( DrawingID, SupplierID, Internal_Code, " & _ "Model_Number, Description, Diameter, Angle_Of_Intake," & _ "Mass, Flange_Dimensions, No_Of_Holes, Notes) " & _ "Values( Convert.ToInt32(txtDrawingID.Text) & _ Convert.ToInt32(txtSupplierID.Text)& _ Convert.ToInt32(txtInternalCode.Text)& _ " '" & txtModelNumber.Text & " ' " , & _ " '" & txtDescription.Text & "' ", & _ Convert.ToDecimal(txtDiameter.Text) & ", " & _ Convert.ToDecimal(txtIntake.Text) & , & _ Convert.ToDecimal(txtMass.Text) & " , " & _ Convert.ToDecimal(txtFlangeDimension.Text) & " , " & _ Convert.ToDecimal(txtNo_Of_Holes.Text) & " , " & _ " '" & rtbNotes.Text & " ')" 'create a command object Dim cmd As OleDb.OleDbCommand ' set the object as create command cmd = cn.CreateCommand() ' strSQL is the insert statement cmd.CommandText = strSQL cmd.Connection = cn cmd = New OleDb.OleDbCommand(strSQL, cn) cmd.ExecuteNonQuery() *********************************************************************** The text books i have used seem to just show all string values in thier Query statements. Am i approaching this the right way or is there a better approach Thanks in advance Greg Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91429
  - 25
    - DataGrid - Catching backspace key click before its processed. Hi, I am trying to catch the user clicking the backspace key, Keys.Back. I need to do this as I cant allow the datagrid to add a new blank row when the user clicks the backspace key whilst they are in the last row in the grid, if the row is also empty. Anyway I've derived my own custom control from the DataGrid and want to pre process the backspace key. However I've found that I'm not catching the backspace with any of these overrides: public override bool PreProcessMessage(ref Message msg) protected override bool ProcessKeyMessage(ref Message m) protected override bool ProcessKeyEventArgs(ref Message m) protected override bool ProcessCmdKey(ref Message msg, Keys keyData) protected override bool ProcessDialogKey(Keys keyData) protected override bool ProcessKeyPreview(ref System.Windows.Forms.Message msg) The problem is none of these methods is getting called when I click the backspace, it seems like the DataGrid is immediately processing it. I'm a little confused over this as I also needed to handle the Delete key, Keys.Delete. I managed to do this as the ProcessKeyPreview is raised when the user clicks the Delete key so I have no idea why it isnt raised for the backspace key. Anyone got any suggestions? Ta, Colin Jack Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91428
- Next
  - 1
    - Filtering GetChildRows I have an xml file which has defintions for "event" elements. Each event (currently) has 2 standard fields "id" and "name", and a number of custom fields, the number and descriptions of which may be different for each event. An example file is below <event> <id>1</id> <name>Event One</name> <fields> <custom1>Custom Value 1</custom1> <custom2>Custom Value 2</custom2> </fields> </event> <event> <id>2</id> <name>Event Two</name> <fields> <custom3>Custom Value 3</custom3> <custom4>Custom Value 4</custom4> <custom5>Custom Value 5</custom5> </fields> </event> I can load this file into a DataSet and look at the "event" table. Taking the first DataRow in that table (event one) I Call GetChildRows. However The resulting table not only has the "custom1" and "custom2" columns (with the correct values) but custom3, custom4, custom5 (with null values). My question is, is there any way of filtering this so the only columns returned are the ones specific for that event, eg custom1 and custom2. Thanks in advance Dan Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91425
  - 2
    - Dataset/Datareader and filter Hi, when we worked with recordsets in VB6 we had the possibility to filter our recordset. Does this option still exist in a dataset or a datareader? If not, how can we have the same effect ? Thanks. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91424
  - 3
    - Oracle Probs with ADO.NET Hi, I'm using Oracle Client 8.1.7 with VB.NET DotNet 2003. I'm trying to connect to an Oracle DB using Microsoft OLE DB Provider for Oracle. I'm being able to create the Data Connection but when i try to create the OracleConnection and the OracleDataAdapter, i'm getting the folowing message: Unable to find an entry point named OCIEnvCreate in DLL oci.dll I checked the permission on the Oracle Home folder (c:\orant) but it is set to full control for everyone. I tried to add authenticated users and set their permissions for read and execute but it didnt work. Can you help me please? Thanks Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91421
  - 4
    - Performance question - Output parameters vs single row? I'm aiming this question at Bill Vaughn but anyone is welcome to jump in. I have seen several articles claiming that it is faster to return a set of output parameter values rather than a single row. You make a reference to this for ADO on Page 269 of ADO.NET and ADO Best Practices. I don't see any numbers to back this up and attempted to run a simple test of my own. My test just ran a loop to populate the fields on a form based on a single record from the Northwind Orders table. I ran the loop 100,000 times using two different stored procedures. The first one used output parameters, the second returned a single row into a datareader and I looped through it to get the column values. I ran the test a half dozen times for each, just to see if I was experiencing any variation between tests. The single row test completed in approx 22 seconds and the output parameters test in approx 27 seconds each time. This was not what I was expecting so I'm looking for any comments on these two approaches. Joel Reinford Data Management Solutions LLC CREATE PROCEDURE dbo.dp_OrderSingle ( @OrderID int = NULL , @CustomerID nchar(5) = NULL OUTPUT , @EmployeeID int = NULL OUTPUT , @OrderDate datetime = NULL OUTPUT , @RequiredDate datetime = NULL OUTPUT , @ShippedDate datetime = NULL OUTPUT , @ShipVia int = NULL OUTPUT , @Freight money = NULL OUTPUT , @ShipName nvarchar(40) = NULL OUTPUT , @ShipAddress nvarchar(60) = NULL OUTPUT , @ShipCity nvarchar(15) = NULL OUTPUT , @ShipRegion nvarchar(15) = NULL OUTPUT , @ShipPostalCode nvarchar(10) = NULL OUTPUT , @ShipCountry nvarchar(15) = NULL OUTPUT ) AS SET NOCOUNT ON SELECT @OrderID = o.OrderID , @CustomerID = o.CustomerID , @EmployeeID = o.EmployeeID , @OrderDate = o.OrderDate , @RequiredDate = o.RequiredDate , @ShippedDate = o.ShippedDate , @ShipVia = o.ShipVia , @Freight = o.Freight , @ShipName = o.ShipName , @ShipAddress = o.ShipAddress , @ShipCity = o.ShipCity , @ShipRegion = o.ShipRegion , @ShipPostalCode = o.ShipPostalCode , @ShipCountry = o.ShipCountry FROM Orders o WHERE o.OrderID = @OrderID CREATE PROCEDURE dbo.dp_OrderSingleRow ( @OrderID int ) AS SET NOCOUNT ON SELECT o.OrderID , o.CustomerID , o.EmployeeID , o.OrderDate , o.RequiredDate , o.ShippedDate , o.ShipVia , o.Freight , o.ShipName , o.ShipAddress , o.ShipCity , o.ShipRegion , o.ShipPostalCode , o.ShipCountry FROM Orders o WHERE o.OrderID = @OrderID Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91415
  - 5
    - CommandTimeOut Problem Hello, I have a table with about 1 million rows. I need to scroll them and use sqldatareader for that. The TimeOut property of command object i use to create the reader is set to 0. I use MSDE 2000 on my local computer. The problem is that although my timeout is set to 0 which assumes that it is infinite it still gives me TimeOut exception after retrieving approximately 20000 rows (different each time). The interesting thing is that reader.Read() works fine and returns true, but reader.getvalue(<anyindex>) crashes. This is obviously a bug because if i set my command's timeout to 65000 it works fine. Is there any bugfix? Or an explanation to this probelm? Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91406
  - 6
    - ADO.NET and SQL Server 2000 XML We are converting an existing VB/SOAP 3/SQL 2000 app to VB.NET/Web Services/Remoting/SQL 2000. Currently stored procedures return data using "FOR XML RAW" and we use the DOM (MSXML 4.0) to populate fields and cached data on the client. All parameters are sent to SQL 2000 as an XML string and stored procedures process this XML string using OPENXML. This application needs to be a Windows Forms app as the functionality can not be provided via Web Forms. The app runs across LAN/WAN with some users accessing data stored in a central database situated 4000km away. The main reason for using SQL 2000 XML in the current version was to try and reduce network traffic and passing XML via SOAP was easier than trying to pass ADO Recordsets. From a scalability and performance perspective, should we: 1. Keep using FOR XML/OPENXML via ExecuteXMLReader and Command objects and pass data as xml between the client/web service/remoting object/database, or 2. Should we fully parameterised stored procedures and stick to using Datasets/Datareaders and command objects and pass data as datasets between the client/web service/remoting object/database. We want to move away from using the DOM and purely use datasets so even if we keep using option 1, we will need to convert the XML to a dataset at some stage. I realise that this question is hard to answer without a full understanding of the architecture of the app, so any information would be appreciated. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91405
  - 7
    - ADO.NET and SQL Server 2000 "FOR XML" We are converting an existing VB/SOAP 3/SQL 2000 app to VB.NET/Web Services/Remoting/SQL 2000. Currently stored procedures return data using "FOR XML RAW" and we use the DOM (MSXML 4.0) to populate fields and cached data on the client. All parameters are sent to SQL 2000 as an XML string and stored procedures process this XML string using OPENXML. This application needs to be a Windows Forms app as the functionality can not be provided via Web Forms. The app runs across LAN/WAN with some users accessing data stored in a central database situated 4000km away. The main reason for using SQL 2000 XML in the current version was to try and reduce network traffic and passing XML via SOAP was easier than trying to pass ADO Recordsets. From a scalability and performance perspective, should we: 1. Keep using FOR XML/OPENXML via ExecuteXMLReader and Command objects and pass data as xml between the client/web service/remoting object/database, or 2. Should we fully parameterised stored procedures and stick to using Datasets/Datareaders and command objects and pass data as datasets between the client/web service/remoting object/database. We want to move away from using the DOM and purely use datasets so even if we keep using option 1, we will need to convert the XML to a dataset at some stage. I realise that this question is hard to answer without a full understanding of the architecture of the app, so any information would be appreciated. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91404
  - 8
    - remove related rows from junction.. I have a form showing records from parent table - "Provider" (databound controls) I have a checkedlistbox bound to a child table - "Site", via a junction table -"PersonSite". Items in the checkedlistbox are checked if records exist for current parent record in the junction table. I am having problems removing rows from the junction table if the user deletes the parent record. Could someone tell me how to do this? The following code does not work, "there is no row at position 15" is the error i guess because i have removed a row in the middle of the for loop? ds.Tables("PersonSite").DefaultView.RowFilter = ("Provider_GUID = '" & ds.Tables("Provider").Rows(thisCurrencyManager.Position).Item("Provider_Guid ").ToString & "'") ds.Tables("PersonSite").DefaultView.Sort = "PersonSiteID" Dim y As String For i As Integer = 0 To ds.Tables("PersonSite").DefaultView.Count - 1 Dim s As String = ds.Tables("PersonSite").DefaultView.Item(i).Item("PersonSiteID").ToString 'gives us the personsiteid of current record For x As Integer = 0 To ds.Tables("PersonSite").Rows.Count - 1 y = ds.Tables("PersonSite").Rows(x).Item("PersonSiteID").ToString If y = s Then ds.Tables("PersonSite").Rows.RemoveAt(x) End If Next Next Similarly the following code causes "cannot access deleted row through row number" error Dim y As String For i As Integer = 0 To ds.Tables("PersonSite").DefaultView.Count - 1 Dim s As String = ds.Tables("PersonSite").DefaultView.Item(i).Item("PersonSiteID").ToString 'gives us the personsiteid of current record y = ds.Tables("PersonSite").Rows.Find(s).Item("PersonSiteID").ToString For x As Integer = 0 To ds.Tables("PersonSite").Rows.Count - 1 If ds.Tables("PersonSite").Rows(x).Item("PersonsiteID").ToString = y Then ds.Tables("PersonSite").Rows(x).Delete() End If Next Next Any chance of a helping hand here? -- Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91403
  - 9
    - Expression Aggregate Question I am using a Winform. If I understand things right I can create a new field in one table of a dataset and get the aggreate value of a field in another table of the dataset that is related. To test this I have a form with the orders and order_details tables of the NorthWind Database of SQL Server 2000. In the .xsd file called DataSet1.xsd I added a new row to the Orders table. The E field = element, the field to the right of it equals TotQuant and the field to the right of that equals Int. This table is related to the Order_Details table with a relation name DrMain. In the expression of the new element I wrote the following Sum(child(drMain).UnitPrice). When I run the form I see the new field in the orders table called TotQuant but it equals Null. Is it possible to do what I want? If so, what is the method? Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91400
  - 10
    - Trouble updating access database with dataset Here is my code. It should be updating the first field in the first record of the table. No errors occur when I run this but no data is updated either. Any ideas? Thanks. System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Password=pass;User ID=username;" + @"Jet OLEDB:System database=q:\system.mdw;" + @"Data source=q:\db.mdb"; conn.Open(); string query = "select * from table1"; OleDbDataAdapter da = new OleDbDataAdapter( query, conn ); DataSet ds = new DataSet(); da.Fill( ds ); ds.Tables[0].Rows[0].ItemArray[0] = "newvalue"; da.Update( ds ); Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91399
  - 11
    - Ado.Net and COM+ Hello I'm pretty new to ADO.Net and I'm still a little confused about some things, I hope I can make myself clear. I'm writing a data-centric web application using ASP.Net, based on a SQL Server 2000 database. I have a table called Person that I'll take as an example of how I access data. I build a dataadapter that access a stored procedure and returns the data into a dataset. i take the datatable and pass it to a custom business object that i use as a PersonCollection. If I want a certain person i query the table and return a datarow that I wrap inside a custon Person object, with properties that wrap the datarow fields. What i want wo know is: how do I update 2 or three of my wrapped tables inside the same transaction using COM+? I'm a litte confused about this. I can update the fields inside the datarows and the write back the changes using a dataadapter using its Updatestatement. But as far as I know a COM+ transaction abort will not affect the datarows rowstate attributes. I'm not sure I make mayself clear here, I guess I'm just looking for beste practices to update several datatables inside the same transaction using COM+, maybe someone knows what I'm talkong about and can help Thanks in advance, PL Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91397
  - 12
    - how to use mysql database or other db(not sql server or oracle) In asp.net, it uses ado.net to connect to mysql or other type database. But I don't know how. Are there some articles that illustrate example? Thanks. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91389
  - 13
    - Is this a bad Idea? Can someone tell me what might go wrong with the following code. It seems to work fine for me but I'm doubtfull. I'm adding data to a MSAccess database with an autonumber column called "id". This is a single user app, so there will never be more than one connection to the database. I've seen posts where people queried "@@identity" within an RowUpdated event handler for the DataAdapter but I don't want that..so I just put the query for "@@identity" in line after the call to Update(). The code i'm curious about is just before the catch. public int CreateNewOrder(int operatorID,short typeID) { OleDbCommand dbc = null; OleDbDataAdapter da = null; OleDbCommandBuilder cb = null; DataSet dataSet = null; DataRow row = null; try { da = new OleDbDataAdapter("select * from [order]",m_dbConn); da.SelectCommand.Transaction = m_dbTrans; cb = new OleDbCommandBuilder(da); cb.QuotePrefix = "["; cb.QuoteSuffix = "]"; dataSet = new DataSet(); da.Fill(dataSet); row = dataSet.Tables[0].NewRow(); row["operator_id"] = operatorID; row["type_id"] = typeID; row["status_id"] = (short)Util.Constants.OrderStatus.OPEN; row["date_created"] = DateTime.Now; row["date_modified"] = DateTime.Now; dataSet.Tables[0].Rows.Add(row); DataRow[] dra = dataSet.Tables[0].Select(null, null, DataViewRowState.Added); da.Update(dra); da.Dispose(); dbc = new OleDbCommand("SELECT @@IDENTITY",m_dbConn); dbc.Transaction = m_dbTrans; return (int)dbc.ExecuteScalar(); } catch(Exception e) { m_bErrored = true; throw e; } finally { if(dbc != null) try{dbc.Dispose();} catch(Exception){} if(dataSet != null) try{dataSet.Dispose();} catch(Exception){} if(cb != null) try{cb.Dispose();} catch(Exception){} if(da != null) try{da.Dispose();} catch(Exception){} } } Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91384
  - 14
    - DataTable is Filled From DataSet each time a change is made Because I'm a beginner to ASP.NET, I may be not familiar with the way each ASP.NET page is processed. In the books that I have read (scanned), the purpose of DataSet is to keep your data in memory until you decide to commit the changes. Ok, so I create and fill my DataSet in the Page_Init section (I have tried in the Page_Load section as well), and then later use one of the tables from the DataSet in the DataGrid. But when I try to edit a row in the DataGrid (by pressing the Edit link in the EditCommandColumn) a request is made back to the server, thus reloading my page and reinitializing everything and making a request to the database and FILLING my DataSet AGAIN. I mean how is that different than just updating the database each time and skipping few steps? Am I doing something wrong? From my understaning it should reside in memory and not be reinitialized each time I make a request to the page. What would I have to do in order to keep it in memory and not reload it each time I make a request to the page? Would I have to keep my DataSet object in the Session variable or something? Thank you in advance. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91381
  - 15
    - Moving data What's the easiest way to move a subset of data from one access database to another in .Net? Dave Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91375
  - 16
    - System.Data ExecuteReader requires an open and available Connection Hello everyone, I'm new to .net and I'm trying to figure out the ado.net. I'm creating a login page for a new asp.net app. But I'm getting an error: "System.Data ExecuteReader requires an open and available Connection. The connection's current state is Closed." with the "If DA.SelectCommand.ExecuteReader.HasRows = False Then" line of code if there is no data returned. If I don't check for no data, I get an error: "System.Data There is no row at position 0." Can you give me any hints with this? thanks, Jason Try Dim DS As New DataSet Dim DR As DataRow Dim strUsername As String Dim strpassword As String DA.SelectCommand.CommandText = "Select Username, Password from tblFarmers where username='" & txtusername.Text.ToString & "'" If DA.SelectCommand.ExecuteReader.HasRows = False Then lblLoginFailed.Text = "--Login Failed. Username or Password is invalid" Exit Sub End If DA.Fill(DS) DR = DS.Tables("tblFarmers").Rows(Session("Row1")) strUsername = DR("username") strpassword = DR("password") If txtusername.Text.ToString = strUsername And txtpassword.Text.ToString = strpassword Then txtusername.Text = "Passed" 'Response.Redirect(strPassed) Else lblLoginFailed.Text = "Login Failed. Username or Password is invalid" End If Catch lblLoginFailed.Text = Err.Source & " " & Err.Description & " " & Err.Erl Err.Clear() End Try Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91373
  - 17
    - Expression Clairification I posted two questions yesterday with regard to expressions titled "Expressions and their limitations" and "Regenerate the dataset and expressions" I must appologize. It has been some time since I visited the subject of Expressions and it appears I have my facts wrong. Let me start again. I don't understand what's going on. Perhaps my notes are incorrect or perhaps there has been a change from VS 2002 to VS 2003. I am trying to add a field called "Name" to a table in .xsd dataset. This field should contain an expression. The expression should concotenate the first name field and the last name field of this table into one field called Name. My notes indicate that I should be able to add a row to the table. When I do, this row contains three fields or columns in it. The first field is to have a value in it of element, the second to have a value of name and the third to have a value of string. Then my notes say something I can't explain. Maybe someone else reading this can. They say, "In the properties field of the new element there will be a property called expression". It is here, my notes say, that I am to write the expression. I see no such place to write an expression. Can anyone tell or can anyone explain here what I am missing? Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91371
  - 18
    - Specify Multiple Column Relationship I am trying to relate two tables in a dataset but cannot find the right syntax to specify that the relationship consists of two columns. The following code specifies a single column but I need to add a 2nd column ("SeqNbr") to that to specify a unique relation? Dim ShowSetsRel As DataRelation = ds1.Relations.Add("ShowSets", _ ds1.Tables("CGShows").Columns("EventID"), _ ds1.Tables("CGPerfSched").Columns("EventID")) Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91350
  - 19
    - DataSet.Merge / auto number on PK -> duplicated rows problem Hi! I create a new row in dataset "ds" and press "save" where following is done: ds = the full dataset, that was loaded at the start up of the form dsChanges = that is simply ds.GetChanges(). this dataset is the one sent down to "data layer" Step 1. 'We can see that the new row is created - note the status "Added": ds.tables("PriceLists").rows.count ---> 21 Integer ds.Tables("PriceLists").Rows(20).Rowstate ---> Added System.Data.DataRowState 'Note that I have not entered ID for PK column - that is automaticly generated in "data layer": ds.Tables("PriceLists").Rows(20).Item("PriceListID") {System.DBNull} Object 'We can also see that the "difference dataset" contains the new row: dsChanges.Tables("PriceLists").Rows.Count ---> 1 Integer '...and of course is the PK column still correctly null: dschanges.tables("PriceLists").Rows(0).Item("PriceListID") {System.DBNull} Object Step 2. 'I send down dsChanges to data layer. The data layer returns a dsChanges that update is done on (using stored procedures...). 'We can no see that the row has successfully been added to the database, 'with a "Identity" (MSSQL) value as PK. Perfect!: dschanges.tables("PriceLists").Rows(0).Item("PriceListID") 1635 {Integer} Object Step 3. 'Let me now simply do a "ds.Merge(dsChanges)" and have a new look at the values. 'What! - Merge has added a NEW row instead of updating the newly created one. ds.Tables("PriceLists").Rows.Count ---> 22 Integer 'The row that was added by me was not touched by the Merge (status still "Added") - see: ds.Tables("PriceLists").Rows(20).Rowstate ---> Added System.Data.DataRowState ds.Tables("PriceLists").Rows(20).Item("PriceListID") {System.DBNull} Object 'But the - NOT WANTED - new row that Merge created has the new PK value. ds.Tables("PriceLists").Rows(21).Item("PriceListID") 1635 {Integer} Object Merge fails to understand how to merge the newly created row that was bounced to data layer and complemented with the "automaticly created unique primary key value" (quote from help file above). Can you understand my problem? Working with the combination of "GetChanges" / "Merge" / "MSSQL - Identity column" must be a common scenario. The scenario should really work - MS is describing it in the help file referred to above ;-) I really hope I am doing something wrong - but what ? Can it be the lack of .PrimaryKey constraint on the DataTable that makes it impossible for Merge to find the row to update? BUT I can NOT have a .PrimaryKey constraint - as I have understood - because the client dataset MUST ALLOW the PriceListID column to be NULL until complemented with "Identity generated PK" by data layer. Coding in VisualBasic. Best regards Benjamin Tengelin, Sweden Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91343
  - 20
    - DataTable.NewRow and DataTable.LoadDataRow Hi ADO.NET gurus, What is the difference between DataTable.NewRow and DataTable.LoadDataRow? Actually I want to find a row in the datatable. If the row is not there in the datatable then I will create a row and add it to the datatable, but I am not going to specify all the values of the columns in that newly added Datarow. In this scenario which method should I use? Also when should I use the BeginDataLoad and EndDataLoad method of the DataTable? -- regards, Ashish Sheth Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91340
  - 21
    - DataSet.ReadXmlSchema and DataColumn.DefaultValue problem Hi! When in the schema I have such element: <xsd:attribute name="id" type="xsd:long" use="optional" default="1"/> after reading this shema to DataSet column "id" have property DefaultValue = 1, and everything is fine. But now I have this element: <xsd:attribute name="typ" type="xsd:string" use="required" fixed="r"/> When use is "required" in schema you must set value by "fixed" attribute, not by default ! But why attribute fixed is NOT read by ReadXmlSchema ???!!!?? And column "typ" have DefaultValue empty !! How to read fixed attribute ? Help PLEASE ! Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91339
  - 22
    - datagrid blows out page width when in edit mode Hi There, I wanted to know if I alter the width of a datagrid when in edit mode? I have a datagrid which has a lot of columns and I waas wondering if I can make it smaller so that it fits into the page? cheers Moe <>< <asp:DataGrid runat="server" id="dgModifyListing" AutoGenerateColumns="False" CellPadding="2" width=8% HeaderStyle-BackColor="purple" HeaderStyle-ForeColor="White" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True" AllowPaging="True" OnPageIndexChanged="NewPage" OnCancelCommand="dgModifyListing_Cancel" OnEditCommand="dgModifyListing_Edit" OnUpdateCommand="dgModifyListing_Update"> <AlternatingItemStyle BackColor="White" /> <PagerStyle NextPageText="Next -->" PrevPageText="<-- Prev." HorizontalAlign="Right" /> <columns> <asp:EditCommandColumn EditText="Edit Info" ButtonType="PushButton" UpdateText="Update" CancelText="Cancel" /> <asp:BoundColumn HeaderText="Listing" DataField="listingID" readonly=true visible=false /> <asp:BoundColumn HeaderText="Equipment Type" DataField="formname" /> <asp:BoundColumn HeaderText="Manufacturer" DataField="manufacturer" /> <asp:BoundColumn HeaderText="Model" DataField="model" /> <asp:BoundColumn HeaderText="Description" DataField="descri" /> <asp:BoundColumn HeaderText="Quantity" DataField="quantity" /> <asp:BoundColumn HeaderText="Price" DataField="listprice" /> <asp:BoundColumn HeaderText="Comments" DataField="comments" /> <asp:BoundColumn HeaderText="Location" DataField="location" /> <asp:BoundColumn HeaderText="username" DataField="username" /> <asp:BoundColumn HeaderText="lbl1" DataField="username" /> <asp:BoundColumn HeaderText="username" DataField="username" /> </columns> </asp:datagrid> Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91334
  - 23
    - Simple 3 tier stuff Sorry about this but I'm new to ADO.NET (finally coming from simple ADO, bless it) and I'm trying to create a simple three tier program. Ie, User interface Layer / Business object layer / Database layer I've got a simple program that is activilly populating and writing my satasets. They are currently only mapping the database tables.So 1 dataset, 5 datatables and several relationships. In this program I can't seem to hide the database information very well from the user interface. What I'm looking for is an example that hides all the connection and data objects in the middle tier, so that the user interface simply has to deal with collections and such like. Any examples please would be greatly appricated. All the examples I have found so far have been writing to datagrids and missing the point completely. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91332
  - 24
    - Problem with HTA streaming data to client Hi, I've an .aspx page which I call from a .hta in IE6 (so I can get rid of the window control buttons etc) When I call the .aspx page directly and run the code below all is fine but when I call it from the .hta, the code below just hangs. Any hints are greatly appreciated! Thanks for your efforts! Martin Response.ContentType = "text/richtext" Response.AddHeader("content-disposition", "attachment; filename=""" & filename & """") 'Write the file directly to the HTTP output stream. Response.Write(RTFContent) Response.End() Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91330
  - 25
    - Regenerate the dataset and expressions I am struggling with the basics in Ado.net using VB.net for non web applications. I have been using expressions in the design mode of strongly typed datasets (.xsd files). However, I have discovered that if you regenerate the dataset, the expression goes away. This is not what I want. I am wondering how others deal with this issue. I can think of a couple of ways of dealing with it. Don't know which is best. One, don't regenerate the dataset. If you add a field in the underlying SQL Server table, for example, and you want your dataset to reflect it, add it explicitely in design mode of the .xsd file. Two, If you are going to use expressions do them in code as opposed to in the .xsd file. If this is bes, it becomes a matter of where to add them; that is, in what event? Any suggestions or thoughts would be appreciated. Thank you. Tag: I can't insert xmlnode.outerxml to sql 2000 text field --> What's wrong Tag: 91326

Hi NG,

I'm going crazy. Since two days I tried to insert a xml-String
(XMLNode.outerxml) into a SQL Table (column type=text).

myCommand.Parameters.Add("@ImportID", SqlDbType.UniqueIdentifier)
myCommand.Parameters.Add("@SourceXML", SqlDbType.Text)
myCommand.Parameters.Add("@DestXML", SqlDbType.Text)
myCommand.Parameters.Add("@ImportDate", SqlDbType.DateTime)

myCommand.Parameters("@SourceXML").value = MyXmlNode.outerXML
and so on...

My XML is at the moment 209225 Characters big (can be greater or
smaller)

If I'm executing a SELECT into the query analyser on my table, I can
view the SourceXML column with a truncated content. I can do what I
want there are always just a fraction in the column instead of the
whole XML.

Please, if anybody knows a answer to the problem post it for me.

Thanks

Xaver

PS: Project written in VB.Net with ADO.NET and SQL 2000

Top