Add Row to table in XML File

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
    - ForeignKeyConstraint problem with insert Hello! I'm using a dataset to manage SQL db. I created two tables into DataSet (Headers and Items), I fill them with data, and I make relation between them like (Headers-table column ID (AutoNumber) (int) to Items-table column HeaderID (int)) ... ds.Relations.Add(New DataRelation("Items", ds.Tables("Headers").Columns("ID"), ds.Tables("Items").Columns("HeaderID"))) ... then I have bound Headers DataTable into TextBoxes and Items DataTable into Grid. So far application I working well, but when I add a new record (this only happends when trying to add new records) after clicking 'New'-button ... .EndCurrentEdit() .AddNew() ... I fill TextBoxes bound to parent DataTable, and then try to insert a new row to the grid, I'll get the following error... "ForeignKeyConstraint Items requires the child key values (2) to exist in the parent table." I know I don't have a datarow in parent DataTable with a primary key value of 2 yet, but I think it must be possible to fill both TextBoxes and Grid before saving (insert) these into database. I hope to have explained well the problem. -- Any help? Thanks in advance! Mika Tag: Add Row to table in XML File Tag: 87437
  - 2
    - Sainty checks on new data input to a strongly typed dataset? A contract programmer wrote a lot of code for us dealing with updating a database. He is gone and I am clueless. I THINK we have a strongly typed dataset. What I have in VS is a ClientDataSet.xsd that has a tool (MSDataSetGenerator) associated with it. The resulting .CS has lots of code. One example is below. public int Count { get { try { return ((int)(this[this.tableClientStationSpec.CountColumn])); } catch (InvalidCastException e) { throw new StrongTypingException("Cannot get value because it is DBNull.", e); } } set { this[this.tableClientStationSpec.CountColumn] = value; } } In the graphical XSD display, Count is simple marked as int with no restrictions as to value etc. From what I can tell we have a DataGrid Control that is used to populate and edit the values in the database. The DataSource property of the DataGrid is set at form design time to a instance of the DataSet class. The DataGridshows 2 columns one being a name and the other being the Count previously discussed. The problem I am having is that when I enter a new row via the DataGrid, if I fill in name only and move the cursor to the next row the Count column displays (Empty) and when I try to update the database I get an Invalid Cast Exception from the cast that is shown in the Count property code above. I understand that a null, can not be considered an int at this point, but what I want to do is prevent any attempt to update the database when the column is empty (and perhaps apply other sanity checks in the process). Obviously I don't want to mess with the generated code shown above, so where do I look in the plumbing for a place to review the data as it leaves the DataGrid and goes to the DataSet/database. In my mind we should not let the user leave the current row of the DataGrid until all the columns are correct. The second choice would be to abort the 'Apply' operation if the data is invalid. Please pardon me if some of this does not make sense to you. This is my first ever effort at database programming and needless to say my first go at DataGrids and DataSets. Thanks ------------------------------------------- Roy Chastain KMSystems, Inc. Tag: Add Row to table in XML File Tag: 87436
  - 3
    - data binding We are experiencing problems during data binding. If the text property of the control is bound to a datacolumn, when the user clears the field and tabs out, the texteditor puts the original value back. This is particularly for Date and numeric fields. I feel that the datarow is rejecting the value being passed ( which would be string.empty? and Column change gets cancelled). I would expect a value a of DBNull to be passed to the datarow when the user clears the field. Is there some property I can set to prevent the old value from reappearing when the user clears a field ? Tag: Add Row to table in XML File Tag: 87435
  - 4
    - visual studio .net autocomplete does not work Visual Studio.net is not autofilling the names of object members, etc. I've checked the appropriate box in "Tools/Options/Text Editor" Any suggestions as to why, for instance, "cmdLogin.CommandType = commandType.StoredProcedure" will not fill in the "StoredProcedure" after I type the "." I'm working in a .aspx page. It doesn't seem to matter if I have a solution open or not. I still have to type in everything. Shouldn't this work out of the box? Do I need to import some obscure library or have some window open in my environment? TIA--Will Tag: Add Row to table in XML File Tag: 87434
  - 5
    - Nested DataRelation Am setting DataRelation.Nested = true, because using DataSet.WriteXml() to export and want nesting in resulting doc Get impenetrable error message when try to turn nesting on in DataRelations, which work fine without nesting (e.g. as created in VS Designer). (Message appears when trying to add the offending data relation, not when exporting.) Looks like the rule appears to be: cannot have more than one nested data relation where parent table == A and child table == B, regardless of columns chosen in each. But I have a pair of tables where A on column A1 is parent of B on column B1 *AND* A is also parent on column A1 of B on column B2 Anyone understand why? Anything I can do about it? Tag: Add Row to table in XML File Tag: 87433
  - 6
    - How to create a new DataRow - curious NewRow behavior I am wondering how to create an instance of a row of a table in a typed dataset to use as a local variable. I can't use the DataTable's method NewRow() because it seems that the table has a new row buffer, to which it returnes a reference on every call to NewRow() Take a look at the following code: Dataset1 ds = new Dataset1(); DataRow nr = ds.Tbl.NewRow(); ds.Tbl.Clear(); //DataRow nr2 = (new Dataset1()).Tbl.NewRow(); DataRow nr2 = ds.Tbl.NewRow(); nr2["ID"] = 1; nr2["Name"] = "Name"; ds.Tbl.Rows.Add(nr2); //data result //nr["ID"] is "1" //nr["Name"] is "Name" nr2 = ds.Tbl.NewRow(); nr2["ID"] = 2; nr2["Name"] = "Name2"; ds.Tbl.Rows.Add(nr2); ds.Tbl.AcceptChanges(); nr["ID"] = ds.Tbl.Rows[1]["ID"]; nr["Name"] = ds.Tbl.Rows[1]["Name"]; //data result //ds.Tbl.Rows[0]["ID"] is "2" //ds.Tbl.Rows[0]["Name"] is "Name2" You see from the data results that when a value is changed to a row that is created with NewRow() the values in the other row that we create with NewRow() are also changed. A way to work this around is to call NewRow() method of a new dataset's table, as commented out in the code: //DataRow nr2 = (new Dataset1()).Tbl.NewRow(); Any other ideas? Well, i just realised that I can use ds.Tbl.Clone().NewRow() instead of (new Dataset1()).Tbl.NewRow() that lowers the overhead but the problem still remains. Any oppinions are appreciated. P.S. I'm using the following dataset: <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="Dataset1" targetNamespace="http://tempuri.org/Dataset1.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/Dataset1.xsd" xmlns:mstns="http://tempuri.org/Dataset1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Dataset1" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Tbl"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:int" minOccurs="0" /> <xs:element name="Name" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:key name="PK_Tbl" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Tbl" /> <xs:field xpath="mstns:ID" /> </xs:key> </xs:element> </xs:schema> Tag: Add Row to table in XML File Tag: 87431
  - 7
    - Does anybody use Data Access Application Block in Asp.Net? I found "Data Access Application Block" has a feature of caching sqlparameters. I'm doubt that feature can use under multi-thread environment such as Asp.Net. Maybe one SqlParameter instance is using by SqlCommand.ExecuteXXX(), while another SqlCommand attempt to use the SqlParameter instance again! Tag: Add Row to table in XML File Tag: 87419
  - 8
    - "Additional information: Object must implement IConvertible." HI I am using Microsft Data Access building block And i am getting following error An unhandled exception of type 'System.InvalidCastException' occurred in eval.ex "Additional information: Object must implement IConvertible. my code look like thi SqlParameter paramFName = new SqlParameter("@FNAME",SqlDbType.Char,25) paramFName.Value = "A" SqlParameter []parm = new SqlParameter[1] {paramFName }; SqlHelper.ExecuteNonQuery(this.connectionstring1, "AddPatient", parm) thanks in advanc -p Tag: Add Row to table in XML File Tag: 87418
  - 9
    - OUTPUT parameters Hi everybod I have a Stored procedure(SyBase 12.5) that returns a OUTPUT value, but it always returns a DBNull. I test the SP in other application (DBArtisan like a Query Analizer) and it returns the correct value, but when I test in my NET application (made in C#) it returns DBNull. If I try to make a cast I get the exception "Object cannot be cast from DBNull to other types This is my code my SP CREATE PROCEDURE dbo.sp_Prueba @vsTransId char(4) @vsContratoId varchar(4) @vsLoginUser varchar(40) @vsParamList varchar(200) @iResp int OUTPU A Declare @iError in Declare @OK in BEGI Select @iError = Select @OK = BEGIN TRAN Prueba Insert into LogTransacc Values (@vsTransId,@vsContratoId,@vsLoginUser,"Pruebas Juan",@vsParamList,"Ini",getdate() Select @iError = @@erro if(@iError = @OK) Begi Select @iResp = @OK COMMIT TRAN Prueba En els Begi Select @iResp = @iErro ROLLBACK TRAN Prueba En EN And this my function private void Insertar() string strcadena = cadenaConn OleDbConnection oleConn = null try oleConn = new OleDbConnection(strcadena) oleConn.Open() OleDbCommand oleCmmd = new OleDbCommand() oleCmmd.CommandType = CommandType.StoredProcedure oleCmmd.Connection = oleConn oleCmmd.CommandText = "sp_Prueba" oleCmmd.Parameters.Add("@vsTransId",OleDbType.Char,4) oleCmmd.Parameters["@vsTransId"].Value = "9500" oleCmmd.Parameters.Add("@vsContratoId",OleDbType.VarChar,4) oleCmmd.Parameters["@vsContratoId"].Value = "0000" oleCmmd.Parameters.Add("@vsLoginUser",OleDbType.VarChar,40) oleCmmd.Parameters["@vsLoginUser"].Value = "Juan Carlos Gonzalez" oleCmmd.Parameters.Add("@vsParamList",OleDbType.VarChar,200) oleCmmd.Parameters["@vsParamList"].Value = "Esta es una prueba para insertar utilizando Threads" oleCmmd.Parameters.Add("@iResp", OleDbType.Integer) oleCmmd.Parameters["@iResp"].Direction = ParameterDirection.Output oleCmmd.ExecuteNonQuery() if(oleCmmd.Parameters["@iResp"].Value.Equals(System.DBNull.Value) MessageBox.Show("OUTPUT Null") els MessageBox.Show("OUTPUT No null") oleCmmd.Dispose() catch(Exception Ex) Console.WriteLine(Ex.Message) finally if(oleConn != null) if(oleConn.State != System.Data.ConnectionState.Closed) oleConn.Close() Does someone help me, please Regard J.C. Tag: Add Row to table in XML File Tag: 87409
  - 10
    - Drop Down List Help Hey guys! I wrote a script with 2 dropdown lists. When the value on one is selected it should automatically load the corresponding value from the table on the second list. This for some apparent reason is not working. Label1.Text=this.ddList1.SelectedItem.ToString(); SqlCommand sqlCmd2 =new SqlCommand("SELECT Name FROM pricesTB1 WHERE Location="+Label1.Text,conn); conn.Open(); SqlDataReader read2=sqlCmd2.ExecuteReader(); while (read2.Read()) { //ListItem NewItem2 = new ListItem(); //NewItem2.Text=read2.GetString(0); //NewItem2.Value = read2.GetValue(0).ToString(); //ddList2.Items.Add(NewItem2); Label2.Text=this.ddList1.SelectedItem.ToString(); } conn.Close(); It works fine when i explicitely define the SQL Command but when i read it using this.ddList1.SelectedItem.ToString(); it messes up...Please help me. Thanks Tag: Add Row to table in XML File Tag: 87407
  - 11
    - using hyperlink on data grid, need to spawn new window I am using a hyperlink as a column in a datagrid. I noticed that it does redirect to the hyperlink but just wondering ho to have it open a new broswer window, leaving the window with the datagrid open in the background Thanks Paul. Tag: Add Row to table in XML File Tag: 87405
  - 12
    - Simple Q: SqlParameter.Value and Boxing After posting this in .performance newsgroup, I thought it may be more appropriate here. In the following code, when I assigned a ValueType to the Value of a SqlParameter, it gets boxed System.Data.SqlClient.SqlCommand Cmd = new System.Data.SqlClient.SqlCommand("T-SQL HERE", Cn) Cmd.Parameters.Add("@my_id", SqlDbType.Int) Cmd.Parameters["@my_id"].Value = prmMyId; //Boxing of integer happens here Is there any way around this Tag: Add Row to table in XML File Tag: 87403
  - 13
    - OleDb.OleDbParameterCollection does not work over DBLink Hi, I am trying to pre-fetch parameter info for a stored procedure in a remote DB over a dblink. When I execute the DeriveParameter statement I get an exception message: "The stored procedure" {name} doesn't exist". However, if I add the parameter manually and call ExecuteNonQuery, the call succeeds. Info: .NET v1.1 Oracle 9i client driver private synonym for SP on local DB (DBINST1) SP resides on DBINST2 public DBLink below is the code that fails: string ConnectionString = "Provider=MSDAORA;Data Source=DBINST1;User ID=user;Password=..."; System.Data.OleDb.OleDbConnection con = new OleDbConnection(ConnectionString); try { con.Open(); OleDbTransaction tx = con.BeginTransaction(); OleDbCommand cmd = new OleDbCommand(_spName,con, tx); cmd.CommandType = CommandType.StoredProcedure; /* THE OFFENDING CODE THAT THROWS THE EXCEPTION */ if( _callDeriveParam ) { System.Data.OleDb.OleDbCommandBuilder.DeriveParameters ( (System.Data.OleDb.OleDbCommand) cmd ); } else cmd.Parameters.Add("@PID", OracleType.Number).Value = 102; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Call to stored procedure using MS OLEDB succeeded"); } catch ( Exception ex) { MessageBox.Show("ERROR: " + ex.Message + '\n' + ex.StackTrace, "Call to OleDBCommandBuilder.DeriveParameters failed!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } Any help would be appreciated. -Arif Tag: Add Row to table in XML File Tag: 87399
  - 14
    - rowchanged event Hi, This is a half question/half gripe: In the RowChanged event of a DataTable, if the event signals a row addition (e.Action == DataRowAction.Add), why oh why is the DataRow added only after the event has been fired? This is completely unintuitive, and seems just plain wrong. It also allows for the following code: private void DataTable_RowChanged(object sender, DataRowChangeEventArgs e) { if (e.Action == DataRowAction.Add) // evaluates true! { if (myDataTable.GetChanges() == null) // quite possibly evaluates true! { BecomeFrustrated(); QuitJob(); StartDeliveringPizza(); } } } Erik Tag: Add Row to table in XML File Tag: 87398
  - 15
    - Like problem and question I am using an access database and executing the following piece of code: IDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\test.mdb;Persist Security Info=False"); try{ con.Open(); IDbCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM MyTable WHERE Tag Like 'A*'"; IDataReader reader = cmd.ExecuteReader(); if(!reader.Read()) MessageBox.Show("Fail"); else reader.Close(); } The fail message box is always shown, what means that no data was found. My column "Tag" has several registers with the value "AlrDigCmd[1]". If I try to use Tag = 'AlrDigCmd[1]', it works. I need to use wildcards, does anyone know what am I doing wrong? Also, is the "Like" predicate available to any provider or it may not be depending on the implementation? Another issue that I have is that I would like a case insensitive query. What would be the best way to do it? I would really appreciate any help. Lourenço. Tag: Add Row to table in XML File Tag: 87397
  - 16
    - Multi-table DataSet...Select statement?? Hi, I am fairly new to DataSets and such and am hoping there is am obvious answer to my problem. I am retrieving data from XML and dumping it into an dataset. The resulting dataset contains 4 related tables, that is, the data relations are already there. Now to my problem. I want to be able to select only certain colunms of data from accross the tables in the dataset. Basically, I just need to do a T-SQL like multi-table join. Is there a way to retrieve my records in this way? The idea is to retrieve only the columns of data I need and then insert them into my database. If not possible, perhaps using a dataset is the wrong way to go. Any help would be greatly appreciated. Thanks. -Phil Tag: Add Row to table in XML File Tag: 87390
  - 17
    - DataSet/DataTable relationships question Hi.. I've been working with standalone DataSets and DataTables. I've defined a schema to model some xml data like the following <Root><Client id="1" total="Sum(Child(rel).cost)" updated="Max(Child (rel).updated"><Order id="1" cost="12" updated="<date>"/><Order id="1" cost="3" updated="<date>"/ .. </Client .. </Root With the schema to represent this, I end up with 2 tables, Client and Order with a relationship defined making Order the child of Client. Two columns in Client are defined as operations on the child table orders The problem I'm running into now is that after the first query on Client, total and updated both get set according to the current state of Order but never get updated again. Subsequent queries on Client after there have been changes on Order don't reflect the Order changes Is there a way to structure this or a flag to set to allow this to work Thank -Mar Tag: Add Row to table in XML File Tag: 87381
  - 18
    - How do I write a "null" into dateTime and decimal columns? I am attempting to parse data from a flat file into a DataSet table. Some of the columns are amount fields (decimal) or dateTime. The flat file can contain spaces or low-values in cases where there is no valide money or date. These should be treated as "null". How do I initialize these columsn to null in this case. (I'm thinking of something like DBNull) Tag: Add Row to table in XML File Tag: 87377
  - 19
    - Newbie - Development vs Deployment with MSDE Hi all! I have installed MSDE on the development machine. Server Name = DevComp When using the wizard to generate the SqlConnectCommand it sets the server name to DevComp. Thinking ahead to when I deploy this application... The end user's computer will not be DevComp, it may be DaComputer (who knows). What is the best way of handling this? Tag: Add Row to table in XML File Tag: 87376
  - 20
    - Datagrid Child Insert New Row ForeignKeyConstraint Problem Hi, This is a strange problem... I have a Access database with 2 tables, a master with 1 primary key (pk) and a child with 2 pk's. One client can have one or more orders. Clients *id name Orders *fkClient *id units price So far so good. I created in VS2003 using the "DataForm Wizard" a simple master-detail form with the "Single record with individual controls" option. (I only have this problem with this option, there's no problem with to data grids). This creates a simple data form with some text boxes and a data grid, witch is ok view data.. The problem is, when i add a new record (this only happends to the new added records) and when a insert a new row on the data grid I get the folowing error "Error when commiting the row to the original data store : ForeignKeyConstraint rel_FKClient_ID requires a child key value (1) to exist in the parent table. Do you want to correct the value?" The dataset is MyDS and the relation is parent.id to client.fkClient. I beliave that this is due to the fact that the new created record does not yet exist in the parent dataset. But why!? Instead of having individual controls if I put 2 datagrid, one for the parent and the one for the child, this problem does not exist. I have tried to put an autoincrement, just for testing, and when i add a new row to the orders datagrid the correct client id appears, but the problem remains. How can I overcome this without having to update the dataset before adding a new row to the child datagrid. Please share some information, cause I'm freaking out....... Thanks to all. -------------------------------- From: Rui Gon?alves ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>rxyhmE7dn06wiA5MoAlEiw==</Id> Tag: Add Row to table in XML File Tag: 87375
  - 21
    - Recursive fill of a tree from sql query Hello, Has anyone here ever used recursion to take the results of ONE sql = query, and fill a tree object accordingly. Here is my situation. I'm = storing data on "templates", and certain templates can fall under other = templates. From a data standpoint in sql server, I have a [parent] = column, that contains the id of its parent (the primary key of the = table), if this parent is "0", I'm assuming its parent will be my root = node. My strategy for doing this was to have one datatable (the results of the = query), and then set dataviews in the recursive function to look at the = desired [parent], if one exists, add that node to the tree, then call = the same function again with the new parent. Here is my code I have: 'dt is my datatable, it is filled before this Dim node As TreeNode =3D New TreeNode node.Text =3D "All Templates" node.NodeData =3D "0" FillTemplates(dt, "0", node) tv.Nodes.Add(node) ... Private Sub FillTemplates(ByRef dt As DataTable, ByVal parent As = String, ByRef node As TreeNode) Dim dv As DataView =3D dt.DefaultView dv.RowFilter =3D "[parent] =3D '" & parent & "'" Dim i As Integer, count As Integer count =3D dv.Count - 1 For i =3D 0 To count Dim newNode As TreeNode =3D New TreeNode newNode.Text =3D CStr(dv.Item(i)("label")) newNode.NodeData =3D CStr(dv.Item(i)("tmpID")) FillTemplates(dt, newNode.NodeData, newNode) node.Nodes.Add(newNode) Next End Sub .... This works..., until I have a nested depth of 3, then it breaks (the = dataviews are getting messed up from prior recursive calls). I'm not = really after fixing this function just yet, I'm throwing this question = out in hopes someone may offer an entirely different way of going about = this. Anyone ever know of an easier way? --Michael Tag: Add Row to table in XML File Tag: 87373
  - 22
    - How fill Dataset from XML file? How do I use an XML file to fill a dataset? Any code examples? XML format: <Server> <Name></Name> <Ip></Ip> <OS></OS> </Server> The XML file has 10 of these records. Thanks! Tag: Add Row to table in XML File Tag: 87371
  - 23
    - hellp datagrid/dataset columns is there a way to set a column in a datagrid to a size and not wrap text nor expand the column to allow the all the items in that cell to be seen. I want the string in that dataset to be cut short if the string is too long for the cell? Tag: Add Row to table in XML File Tag: 87365
  - 24
    - datagrid question Hi all, I bind an sql table to a datagrid. The table has a status column, this is smallint. I would like to write "Busy" to the datagrid, if status=0, "Done", if status=1, and "error" if status=2 and not 1,2,3. How can I solve this problem? Thank you very much in advance! Best regards, Bálint Tóth Tag: Add Row to table in XML File Tag: 87364
  - 25
    - Visual Database Tools and Oracle 9i I'm stumped. We recently switched from Oracle 8i to Oracle 9i and now I am unable to use the Visual Database Tools on them in Visual Studio Tag: Add Row to table in XML File Tag: 87356
- Next
  - 1
    - OlsDbCommand.Cancel does not stop SQL Dear Newsgroup when I kick off stored procedure through an OleDbCommand, it seems impossible to stop it again. In a different thread, I call OleDbCommand.Cancel, but this call waits for the stored procedure to finish instead of killing it. Unlike SQL Query Analyzer, my c#-programm can not interrupt a running stored procedure What's the trick ?? Tag: Add Row to table in XML File Tag: 87355
  - 2
    - getting ADO-like properties from OleDbConnection ADO connection objects had a Properties array which you could iterate to determine connection string values, such as "Persist Security Info" and the like. Is there any facility in ADO.NET to do this aside from parsing the ConnectionString? Tag: Add Row to table in XML File Tag: 87348
  - 3
    - General Network Error I get the following exception when doing a simple statement like SELECT * FROM MyTable, I am using SQL Server 2000 and ADO.Net as the client using framework 1.1, I get this error periodiodically. Please help, Exception message: iE.AM.Runtime.AMSQLException: Unable to perform SqlCmd --- > System.Data.SqlClient.SqlException: General network error. Check your network documentation. at System.Data.SqlClient.SqlConnection.OnError (SqlException exception, TdsParserState state) at System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, TdsParserState state) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected) at System.Data.SqlClient.TdsParser.ReadBuffer() at System.Data.SqlClient.TdsParser.ReadByteArray(Byte [] buff, Int32 offset, Int32 len) at System.Data.SqlClient.TdsParser.ReadDouble() at System.Data.SqlClient.TdsParser.ReadValue (_SqlMetaData md, Int32 length) at System.Data.SqlClient.TdsParser.ProcessRow (_SqlMetaData[] columns, Object[] buffer, Int32[] map, Boolean useSQLTypes) at System.Data.SqlClient.SqlDataReader.PrepareRecord (Int32 i) at System.Data.SqlClient.SqlDataReader.GetValues(Object [] values) at iE.AM.Sql.Utilities.SqlBase.ProcessSqlCurOpenOperation (Object param) --- End of inner exception stack trace ---: General network error. Check your network documentation.: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state) at System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, TdsParserState state) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected) at System.Data.SqlClient.TdsParser.ReadBuffer() at System.Data.SqlClient.TdsParser.ReadByteArray(Byte [] buff, Int32 offset, Int32 len) at System.Data.SqlClient.TdsParser.ReadDouble() at System.Data.SqlClient.TdsParser.ReadValue (_SqlMetaData md, Int32 length) at System.Data.SqlClient.TdsParser.ProcessRow (_SqlMetaData[] columns, Object[] buffer, Int32[] map, Boolean useSQLTypes) at System.Data.SqlClient.SqlDataReader.PrepareRecord (Int32 i) at System.Data.SqlClient.SqlDataReader.GetValues(Object [] values) at iE.AM.Sql.Utilities.SqlBase.ProcessSqlCurOpenOperation (Object param) Tag: Add Row to table in XML File Tag: 87345
  - 4
    - Creating Access 97 database programatically HI , Can anyone tell me how can i create a .mdb(access 97) database using ado.net in vb.nety. I dont want to use adox. Can this be acheived in ado.net . any help will be appreciated. Cheers, Jiten --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: Add Row to table in XML File Tag: 87342
  - 5
    - "A connection pooling error has occurred." exception thrown randomly when SqlConnection.Close(). (In Dispose() method) I'm making a databse management tool with VS.NET 2003 C#. The InvalidOperationException occured RANDOMLY. "A connection pooling error has occurred." I'm accessing SQL server 2000 (MSDE Release A) through SqlConnection. The database that I'm using is set as SINGLE USER by EM. So I created one connection object and reused it repeatly. (Connection is keeping open during application is running.) No exception when working and running, but the exception thrown when application closing. (Exactly, when SqlConnection.Close () method called.) I searched ms .net newsgroup (by google), I know I have not to use SqlConnection.Close() in any destructor routine, and my code has no destructor at all project. (Even no "~" character on whole sources.) I didn't call Close() method at any destructor, and Close () method is places on Dispose() method currently. My SqlConnection is wrapped by a component that placed on a form by the designer. PS. I have to use SINGLE USER option, cause there is special reason, please don't discuss about it. THIS IS EXCEPTION DETAILS: - $exception {System.InvalidOperationException} System.InvalidOperationException - System.SystemException {"A connection pooling error has occurred."} System.SystemException - System.Exception {"A connection pooling error has occurred." } System.Exception System.Object {System.InvalidOperationException} System.Object _className null string _COMPlusExceptionCode -532459699 int _exceptionMethod <undefined value> System.Reflection.MethodBase _exceptionMethodString null string _helpURL null string _HResult -2146233079 int _innerException { } System.Exception _message "A connection pooling error has occurred." string _remoteStackIndex 0 int _remoteStackTraceString null string _source null string + _stackTrace {System.Array} System.Object _stackTraceString null string _xcode -532459699 int _xptrs 0 int HelpLink null string HResult -2146233079 int InnerException { } System.Exception Message "A connection pooling error has occurred." string Source "System.Data" string StackTrace " at System.Data.SqlClient.SqlConnection.Close()\r\n at F176.Database.Generator.Dispose()\r\n at F176.Database.Server.Dispose()\r\n at F176.Database.Manager.Dispose(Boolean disposing)\r\n at System.ComponentModel.Component.Finalize()" string + TargetSite {System.Reflection.RuntimeMethodInfo} System.Reflection.MethodBase + this {F176.Database.Generator} F176.Database.Generator Tag: Add Row to table in XML File Tag: 87339
  - 6
    - "A connection pooling error has occurred." exception thrown randomly when SqlConnection.Close(). (In Dispose() method) I'm making a databse management tool with VS.NET 2003 C#. The InvalidOperationException occured RANDOMLY. "A connection pooling error has occurred." I'm accessing SQL server 2000 (MSDE Release A) through SqlConnection. The database that I'm using is set as SINGLE USER by EM. So I created one connection object and reused it repeatly. (Connection is keeping open during application is running.) No exception when working and running, but the exception thrown when application closing. (Exactly, when SqlConnection.Close () method called.) I searched ms .net newsgroup (by google), I know I have not to use SqlConnection.Close() in any destructor routine, and my code has no destructor at all project. (Even no "~" character on whole sources.) I didn't call Close() method at any destructor, and Close () method is places on Dispose() method currently. My SqlConnection is wrapped by a component that placed on a form by the designer. PS. I have to use SINGLE USER option, cause there is special reason, please don't discuss about it. THIS IS EXCEPTION DETAILS: - $exception {System.InvalidOperationException} System.InvalidOperationException - System.SystemException {"A connection pooling error has occurred."} System.SystemException - System.Exception {"A connection pooling error has occurred." } System.Exception System.Object {System.InvalidOperationException} System.Object _className null string _COMPlusExceptionCode -532459699 int _exceptionMethod <undefined value> System.Reflection.MethodBase _exceptionMethodString null string _helpURL null string _HResult -2146233079 int _innerException { } System.Exception _message "A connection pooling error has occurred." string _remoteStackIndex 0 int _remoteStackTraceString null string _source null string + _stackTrace {System.Array} System.Object _stackTraceString null string _xcode -532459699 int _xptrs 0 int HelpLink null string HResult -2146233079 int InnerException { } System.Exception Message "A connection pooling error has occurred." string Source "System.Data" string StackTrace " at System.Data.SqlClient.SqlConnection.Close()\r\n at F176.Database.Generator.Dispose()\r\n at F176.Database.Server.Dispose()\r\n at F176.Database.Manager.Dispose(Boolean disposing)\r\n at System.ComponentModel.Component.Finalize()" string + TargetSite {System.Reflection.RuntimeMethodInfo} System.Reflection.MethodBase + this {F176.Database.Generator} F176.Database.Generator Tag: Add Row to table in XML File Tag: 87338
  - 7
    - Transaction deadlock Hi All, Does anyone know how to prevent dead lock when selecting records within Transaction?? Let me describe abit clear. I created & open a transaction and before i commit/ rollback the transaction i have to select few records within the same table but the problem is once i execute a select sql statement for serveral times (usually more than 2 times)... the select sql will be hold and the whole application will be hung... I guess the reason is because the transaction haven't finished and as a result the select sql should be on queue I have tried various solutions like changing the transaction level ... but none of them work as needed so.. please tell me if anyone know the solutions... thanks to all Ivan Tag: Add Row to table in XML File Tag: 87335
  - 8
    - sqlpp framework hi! Have someone work with the sqlpp framework so we can share experiences. sqlpp is a full Database Abstraction Layer Generator. Since version 2.14 sqlpp use a xml to generate c# modell and connection classes, sql querrys and stored procedures. Some interesting features are: * No SQL manipulation: with the generator, you don't write a single line of SQL, * Multiple Database system support: MSSQL, MySQL. Others could be implemented easily, * Handles the stored procedure problem by storing the queries in the web.config if necessary, * Supports complex table join: the generator uses the Boost.Graph.Library on the background to generate the queries * The C# code is documented ! * It's totally free for non-commercial and commercial use!!! (source http://www.codeproject.com/cs/database/dalgen.asp is not up tp date) project homepage: http://sourceforge.net/projects/sqlpp/ Tag: Add Row to table in XML File Tag: 87332
  - 9
    - Are ado.net apps supported on this platform Hi Can I write ado.net apps that would run on this device; http://www.xda-2.co.uk/under_the_bonnet.html If yes, is an emulator available? Thanks Regards Tag: Add Row to table in XML File Tag: 87324
  - 10
    - MS DataProvider for Oracle / GUIDs Hi there, are there any future plans to support the GUID datatype within MS DataProvider for Oracle? GUIDs could easily be mapped to a RAW(16) coulnn. Right now I have to do on-the-fly conversion (GUID to Bytearray), and still, OracleCommandBuilder does not seem to map Bytearrays to RAW-columns either (optimistic locking syntax fails on equals operator, as the Bytearray is expanded to lowercase symbols (e.g. 'ff'), where Oracle expectes uppercase symbols). Kind regards, Arno Huetter Tag: Add Row to table in XML File Tag: 87319
  - 11
    - Replication notification. I am calling a web service that is generating some data that will be replicated to a SQL Server. I would like to know what is the best way to wait for the replication. I would either like to have a function that does not return until replication occurs on a specified table (this particular replication will add a row although there are some instances where the row is simply updated) or somehow flush the information that is replicated. The problem that I am seeing is I am calling the web service but when I look at the DB the row is now present. I have tried to sleep for up to 10 seconds and still I don't see the added row. If I run query analyzer after the web service call I can see the added row. It seems that the thread that called the web service never sees the updated record. Any suggestions Thank you Kevin Burto kburton@visa.co Tag: Add Row to table in XML File Tag: 87317
  - 12
    - Test - Ignore Tag: Add Row to table in XML File Tag: 87314
  - 13
    - Dynamic CommandText for an SqlDataAdapter I'm using a DataGrid to display and edit entries from a database= table called Contacts=2E I've completed the MSDN document= "Walkthrough: Using a DataGrid Web Control to Read and Write= Data" and it's working out fine=2E My SQL select command looks= like this: SELECT Id, Name, Phone, Email FROM Contacts Now I want to restrict that query to only display entries with a= certain OrganizationId=2E The OrganizationId I want to use can be= found in Session["OrganizationId"]=2E I basically want this: SELECT Id, Name, Phone, Email FROM Contacts WHERE OrganizationId= =3D THE_ID_FROM_THE_SESSION What I'm asking is how I should do this=2E I've tried editing the= sqlSelectCommand manually in "Web Form Designer generated code"= that was generated for me by the SqlDataAdapter wizard, but if I= even touch that code, VS=2ENET freaks out and removes the= CommandText property completely (and then I am unable to re-add= it!)=2E I guess I could add it via the properties for the= SelectCommand for the SqlDataAdapter in design mode, but I can't= see how to add dynamic data such as a session variable in that= textbox=2E What am I missing/doing wrong? -------------------------------- From: Rickard Andersson ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>Tbf5aLbxl0q3Fn6LEuWR9A=3D=3D</Id> Tag: Add Row to table in XML File Tag: 87311
  - 14
    - SortOrder's column in GetOLEDBSchemaTable Hi, How do I know SortOrder(ASC or DESC) of key fields in ADO.NET? I could get SortOrder by using ADOX. I can't find near column by GetOLEDBSchemaTable.Primary_Keys/Foreign_Keys. Thanks Tom -------------------------------- From: Tom Hadler ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>z96rY7znZU2INR0oSrCqQg==</Id> Tag: Add Row to table in XML File Tag: 87310
  - 15
    - nothing or dispose hi iam closing the connection and later iam using dispose method should i need to use nothin is it neccessary to use nothing for an object?????? pls give me suggestion Tag: Add Row to table in XML File Tag: 87309
  - 16
    - creating a setup to install into GAC, where can I find an example? Could anyone suggest me some examples/articles on creating a setup program in VS.NET that can install the assembly into the GAC? I have done some search and research myself and have some basic understanding on how to create a setup program. All the articles about Windows Installer 2.0 is the best way to install your assembly into GAC but I haven't found one shows what exactly I need to do differently in my VS.NET setup project in order for it to stick the assembly into GAC. Bob Tag: Add Row to table in XML File Tag: 87303
  - 17
    - Strongly typed DataSet with xsd.exe I generate an XML file with the WriteXmlShema method of the DataSet object. Then, I use xsd.exe to make it a strongly typed DataSet, witch generate a Visual basic code file, MyDataSet.vb. xsd.exe /d /l:VB "MyDataSet.xsd" When I add both files, MyDataSet.xsd and MyDataSet.vb, to my Visual Studio project, MyDataSet.vb does not appears as a child node of MyDataSet.xsd like when you create a strongly typed Dataset by dropping a table on the DataSet designer. Is there a way to tell VSNet that MyDataSet.vb is to be linked with MyDataSet.xsd? Thanks a lot Frederic Goulet Tag: Add Row to table in XML File Tag: 87301
  - 18
    - Exporting XML Schema This is a multi-part message in MIME format. ------=_NextPart_000_00A3_01C4382A.B02408F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know there is a way to do this as I have done it before with Crystal = Reports tech support on the phone. I (mistakenly) have misplaced that = code. What I need to do is convert a dataset into an XML schema file = that I can use to generate another Crystal Report.=20 Thanks in advance for any help that you can give me. ------=_NextPart_000_00A3_01C4382A.B02408F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I know there is a way to do this as I = have done it=20 before with Crystal Reports tech support on the phone. I (mistakenly) = have=20 misplaced that code. What I need to do is convert a dataset into an XML = schema=20 file that I can use to generate another Crystal Report. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks in advance for any help that you = can give=20 me.</FONT></DIV></BODY></HTML> ------=_NextPart_000_00A3_01C4382A.B02408F0-- Tag: Add Row to table in XML File Tag: 87299
  - 19
    - What's the benefit of using VS.Net's "Generating Dataset..."? This may be a newbie question. I used to just define (VB.Net for example): dim dt as new DataTable dataAdp.fill(dt) But in VS.Net, You can also right click the SQLDataAdapter1 component and click "Generating Dataset...", after specify a name, the new xsd file will be created as well as a correspond vb file. The VB file basically created another class inherit DataSet class. But in the vb code, it seems still need to do: dataApt.fill(AutoGeneratedDataset, "SameNameOfTheTableWhenGenerating") What's the benefit to use this function of VS.Net? I know one is you can use the visual tool to do data binding after you have generated dataset placed on the form designer.... Others? Tag: Add Row to table in XML File Tag: 87297
  - 20
    - Populating disconnected ADODB.Recordset with System.Data.DataTable data. I need to support a VB6 application that will be receiving disconnected ADODB.Recordset from out DotNet solution. Our dotnet solution deals with System.Data.DataTable. I need to populate a disconnected ADODB.Recordset from System.Data.DataTable data. Below is the source code I am implementing to test the process. I do not get any error, that I can see. The problem I have is that at the end, the recordset seems to be empty. Any suggestions are very much appreciated. At this moment I do not know what to do. Thank you so much for the time and effort you may spend on this matter. Elcc. private bool testConvertDT_RS() { System.Data.DataTable dt; ADODB.Recordset rs; // create dummy data table. dt = PopulateDataTable( ); // attempt to populate disconnected ADODB.Recordset with System.Data.DataTable data rs = ConvertToRS ( dt ); if( null == rs ) { throw new Exception(" Recordset is null."); } if( 0 == rs.Fields.Count ) { throw new Exception(" Recordset Field count is zero."); } return true; } private System.Data.DataTable PopulateDataTable() { System.Data.DataTable dt = new System.Data.DataTable(); System.Data.DataRow dr; string[,] ColValues = {{"R1-C1", "R2-C1", "R3-C1", "R4-C1", "R5-C1"} , {"R1-C2", "R2-C2", "R3-C2", "R4-C2", "R5-C2"} , {"R1-C3", "R2-C3", "R3-C3", "R4-C3", "R5-C3"}}; dt.Columns.Add(new System.Data.DataColumn("Column01", System.Type.GetType("System.String"))); dt.Columns.Add(new System.Data.DataColumn("Column02", System.Type.GetType("System.String"))); dt.Columns.Add(new System.Data.DataColumn("Column03", System.Type.GetType("System.String"))); for( int i = 0 ; i < 5 ; i++ ) { dr = dt.NewRow(); for( int n = 0 ; n < 3 ; n++ ) { dr[n] = ColValues[ n, i]; } dt.Rows.Add(dr); } return dt; } private ADODB.Recordset ConvertToRS(System.Data.DataTable dt) { ADODB.Recordset rs = new ADODB.Recordset(); try { rs.CursorLocation = ADODB.CursorLocationEnum.adUseClient; rs.ActiveConnection = null; for( int i = 0; i < dt.Columns.Count; i++) { rs.Fields.Append( dt.Columns[i].ColumnName, ADODB.DataTypeEnum.adBSTR, dt.Columns[i].MaxLength, ADODB.FieldAttributeEnum.adFldUnspecified, null ); } rs.Open( Type.Missing, Type.Missing, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach(System.Data.DataRow dr in dt.Rows) { rs.AddNew(Type.Missing, Type.Missing); for( int n = 0; n < dt.Columns.Count; n++) { rs.Fields[n].Value = dr[n]; } rs.Update(Type.Missing, Type.Missing); } rs.Close(); return rs; } catch(Exception e) { throw e; } } Tag: Add Row to table in XML File Tag: 87295
  - 21
    - concurrency questions I am using an access db via ole db from an asp.net page. When I open a connection, if there are no more connections in IIS's connection pool it'll try and open a new connection. If there are no more connections available what exception get's thrown? By the same token, when using a data adapter to do an update, what exception gets thrown if the server (the access mdb) is busy? Lastly, where can I read up on this. I already know about switching the MSDE etc. Sounds great, but not an option for the near term. Thanks ... Ed Tag: Add Row to table in XML File Tag: 87292
  - 22
    - Storing Date/Time with Daylight savings Dear All, I am developing an application that will save historical data; The table is very simple, it will have a Time Stamp column and other columns to save real values. The application should be able to work with several different databases. My problem now is to make a decision about the date/time to be saved in the Time Stamp; I can use either System Time (GMT) or Local Time; if I choose the first one, the users will get confused when they try to open the tables using a GUI other than mine. On the other hand, if I save using Local Time, I can have problems with Daylight saving. Does anyone have any idea about how to avoid problems with daylight saving other than saving the System Time? Note: I thought about using an additional field (maybe save both, System Time and Local Time), but I think that you experts should have a better solution. Thank you in advance, Lourenço. Tag: Add Row to table in XML File Tag: 87290
  - 23
    - How to handle NULL fields-error with fill method I have a data adapter that is using a stored procedure and when I get to the fill method to fill a dataset I get the following error Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. The results of the procedure has 6 columns by 50 rows with some NULL field values throughout so think the NULLs are causing the problem. Just wondering how to handle this? Thanks Paul. Tag: Add Row to table in XML File Tag: 87289
  - 24
    - OracleType.NVarChar parameters handled differently in framework 1.1? There appears to have been a change in behaviour between handling of OracleType.NVarChar parameters in 1.1? In my case this breaks code using DbType.String or the IDataParameter interface with strings over 2000 characters. A 2001 character string parameter, consisting entirely of 7 bit characters, sent to a 9.2.0.1 stored procedure works under the optional 1.0 Oracle driver. The exact same code and database now falls over with "ORA-01460:unimplemented or unreasonable conversion requested" using the supplied 1.1 OracleClient.dll. This change in behavior leads me to the conclusion that the biggest string you can now pass to an Oracle database using the IDataParameter interface is now only 2000 characters, primarily because OracleClient 1.1 maps the String native type to OracleType.NVarChar with a 4000 byte limit? This 2000 char limit would be required to handle the possibility that the database *may* be configured with a 16bit NLS_NCHAR_CHARACTERSET like AL16UTF16 as is sometimes recommended by Oracle? Even though you are could actually be inserting a plain old ascii string into a plain old varchar2(4000) column on a plain old USASCII7 Oracle instance? Assuming this is the case, can anyone think of a workaround, other than 1. Having to abandon the database independent IDataParameter interface and change all the client code to discover and use whichever native <database>Type is appropriate for the connection? 2. Stick to strings of less than 2000 characters. Rich. Tag: Add Row to table in XML File Tag: 87288
  - 25
    - Copy data between two dataadapters Hi, we want to build an application which copies all data from the source to the destination without changing anything. We use data adapters for this process. So we open both adapters, use "fill" on the source and give an "update" to the destination. The problem is that the table we want to copy is quite large. So we see quite a memory usage. So we decided to move the data in blocks, 1000 records at a time. We use the dataadpter.fill(dataset,0,1000,tablename) to read the first records, then we do an update, then the next fill (dataadpater.fill(dataset,1001,2000,tablename) and loop that till EOF. We see that the programm moves the first records quite quickly but gets slower and slower over time. Our idea is that the dataadapter take more and more time to skip the first records of the source to get to the real "payload". Is there anything we can do better? We simply want to move the first 1000 records, then the next 1000, and so on... Thanks, Thomas Tag: Add Row to table in XML File Tag: 87287

Hi All

I have an XML file with data stored as a composite within other data. When I try to add a new row to a perticular element, which is within another element, it simply adds it to the root element? For example, I have the following XML
<?xml version="1.0" encoding="utf-8" ?><config xmlns="http://tempuri.org/config.xsd"><file><file_extension>txt</file_extension><modify_runtime>true</modify_runtime></file><threads><thread><file_type>INVOICE,CREDIT_NOTE</file_type><max_threads>3</max_threads></thread><thread><file_type>STATEMENT</file_type><max_threads>1</max_threads></thread></threads></config

I read this into a DataSet, but when I try to add a new 'thread' element, it gets added to the 'config' element rather than 'threads'. The (ASP.NET\VB.NET) code I am using is

Dim oDSConfig As DataSet = New DataSet(
oDSConfig.ReadXml(Server.MapPath(Request.ApplicationPath) & "\config.xml"
With oDSConfig.Tables("file").Rows(0
.Item("file_extension") = txtFileEx.Tex
.Item("modify_runtime") = "true
End Wit

Dim oDR As DataRo
oDR = oDSConfig.Tables("thread").NewRo
oDR.Item("file_type") = txtFileType.Tex
oDR.Item("max_threads") = txtFileType.Tex
oDSConfig.Tables("thread").Rows.Add(oDR

oDSConfig.WriteXml(Server.MapPath(Request.ApplicationPath) & "\config.xml"

Thanks for any help
Steve

Top