include rowstate in dataset.getxml

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
    - deleting rows in one-to-many relationship Dear Ng, I have a 1(master table) : n(first child table) : m(second child table) relationship in my sql server and strongly typed dataset. Now I locate the corresponding row in the master table. DataAccessControl.DocumentTemplateRow rowTemplate = tblTemplate.FindBydocumentTemplateId(templateId); Then i request all child rows: DataRow[] rowsToDelete = rowTemplate.GetChildRows("DocumentTemplateDocumentField"); Then I want to delete all child rows in the child tables: foreach (DataAccessControl.DocumentFieldRow row in rowsToDelete) { tblFields.RemoveDocumentFieldRow(row); } dac.updateDataAccessLayer(); The delete rules of both relations (from the master to the first child and from the first to the second child) is set to cascade (in the database and in the dataset). But if I execute the code, just the rows in the second child table are deleted. What do I do wrong? If I use additionally the row.delete() command foreach (DataAccessControl.DocumentFieldRow row in rowsToDelete) { row.Delete(); if (row.RowState == DataRowState.Deleted) tblFields.RemoveDocumentFieldRow(row); } dac.updateDataAccessLayer(); I'll get a DBConcurrencyException! What is wrong? What I want to achieve is that the master record is kept and all child records are deleted. Thanks in advance and best regards, Patrick Braunschweig Tag: include rowstate in dataset.getxml Tag: 100403
  - 2
    - Trouble with OleDbDataAdapter Hi there, I am trying to display information from Active Directory using a DataGrid. Now, I know MS have put out the System.DirectoryServices classes to make this easy. But if you just want to query and display, it seems an easier path is to use the AdsDsoObject provider with OleDb, and get back a DataTable, pour into a DataView, bind to the DataGrid, voila! At least, that's the theory. The main driver is that trying to bind a SearchResultCollection to a DataGrid doesn't yield very satisfactory results, and that's the only useful class in the DirectoryServices namespace that implements ICollection and IEnumerable. The problem is, if I manually construct a DataTable with dummy data, pour into a DataView, bind to DataGrid and display then I see exactly what I would expect. If I setup an OleDbDataAdapter, query the AD, fill a DataSet and serialize to XML I see what I would expect. If I setup an OleDbDataAdapter, query the AD, fill a DataTable, pour into a DataView, bind to the DataGrid and display, I get: System.Web.HttpException: DataGrid with id '' could not automatically generate any columns from the selected data source Here is the source for Page_Load that generates the last result: string ldapString = "<LDAP://DC=acme,DC=com>;(&(objectClass=user)(objectCategory=person));cn,distinguishedName;subtree"; string connstr = "Provider=ADsDSOObject;User ID=acme\\Administrator;Password=notthispassword"; OleDbConnection conn = new OleDbConnection(connstr); OleDbDataAdapter da = new OleDbDataAdapter(ldapString, conn); DataTable dt = new DataTable("Table1"); da.Fill(dt); DataView dv = new DataView(dt); dg1.DataSource = dv; dg1.DataBind(); Now, I'm fairly new to all this, but I've spent a good couple of days butting up against this one. The only checking I haven't really done is using OleDb with a different provider and seeing if it is a general problem. The main reason I haven't done that is that I can see the data there if I use an alternate means of accessing it! So, any ideas? MTIA, Mick Heywood Tag: include rowstate in dataset.getxml Tag: 100402
  - 3
    - Create Stored procedure Hi, there I want to create a Stored procedure for my Access database using the code below. ' Conn is an opened connection to my Access database Dim cmd As OleDbCommand cmd = Conn.CreateCommand cmd.CommandType = CommandType.Text cmd.CommandText = _ "CREATE PROCEDURE udpGetSampleIDByName" & vbCrLf & _ "@zSampleName VarChar(64)" & vbCrLf & _ "AS " & vbCrLf & _ "Select zSampleID FROM TSamples " & _ "Where zSampleName = @zSampleName " cmd.ExecuteNonQuery() After running, I got a error message: "invalid SQL Syntax£ºneeded symbol AS¡£" It goes well when I create SQL Server stored procedure using SQLCommand . Now I turn to OleDB and the error occurs. Anybody can help me? Peter Tag: include rowstate in dataset.getxml Tag: 100401
  - 4
    - "Cannot create a child list for field MyTable" I'm having a frustrating problem trying to set up a master-detail relationship between 2 datagrids. I've used DataSets extensively before, but only in code and basically only in a disconnected state. Now as I try to set up this simple master-detail thing, I'm having problems. I have about 6 tables in a SQL Server 2000 database. All tables have single field primary keys, and I've created appropriate relationships betwen the tables in SQL Server. In VS 2003, I've created a SQLDataAdapter for each table, that interacts with the table via stored procedures created by the SQLDataAdapter wizard. I then used the "Generate Dataset..." functionality of one of the data adapters to autogenerate dataset that included all 6 tables (i.e. it was based on all 6 data adapters). So far so good. In the DataSet schema editor, I created relationships between the datatables to mimic the relationships in SQL Server. This seems to go ok, and when I "Preview DataSet" from the schema editor, all seems ok - including the relationships. I also have a WinForm that has 2 DataGrids on it. Both DataGrids have the DataSet I created as their DataSource. When I try to list the DataTables in the DataGrid.DataMember property so I can set up the DataGrids for the master-detail, I the the error, "Cannot create a child list for field MyTable", where 'MyTable' is one of my DataTables in the DataSet. If I remove all of the relations from the DataSet, and save the .xsd schema a few times (moving the datatables on the designer between saves so there's something to save), the error will go away - but then I have no relationships. So, I re-create the relationships in the DataSet schema editor, and I start getting the error again. Sometimes I don't get the error until I have more than one relationship, and sometimes by moving the datatables on the schema designer and re-saving the dataset schema a few times, I don't get the error - even when the dataset has 2 relationships. It seems some code is getting corrupted somewhere. I've tried restarting VS, and I've rebooted my machine. I've also deleted the DataSet and created it again from scratch. The same thing happens. When running my project, I can successfully fill my DataSet from the DataAdapters, but I get the same error when I try to set the DataMember property of one of the DataGrids in code. What's going on? Tag: include rowstate in dataset.getxml Tag: 100400
  - 5
    - SQLDMO Code Sometimes Works I have this code on two identical machines, named DEVONE and DEVTWO. Both on the network. It works on DEVONE, finding (local) and DEVONE and populates the combo box with them, but does not find any server(s) on DEVTWO, putting <No Servers Found> in the combo box. Can anyone shed any light. Code below: Private Sub GetSQLServers() Dim i As Integer Dim sqlApp As New SQLDMO.ApplicationClass Dim sqlServers As SQLDMO.NameList = sqlApp.ListAvailableSQLServers() For i = 0 To sqlServers.Count - 1 Dim srv As Object = sqlServers.Item(i + 1) If Not IsNothing(srv) Then Me.cboRelevantServer.Items.Add(srv) Me.cboMainServer.Items.Add(srv) End If Next If Me.cboRelevantServer.Items.Count > 0 Then Me.cboRelevantServer.SelectedIndex = 0 Else Me.cboRelevantServer.Text = "<No Servers Found>" End If End Sub Thanks, Michael Tag: include rowstate in dataset.getxml Tag: 100399
  - 6
    - DataSet and Stringbuilder? Hi expert, I received a sample from bank for the header record in the output file (attached at the bottom). I want to use same method to have a stringbuilder to arrange the fix length positions, and the fields will be retrieved from database and put into the dataset. But I am familiar at how to use dataset and put into .insert stringbuilder. Here is the code that I am working on (the function should return 1 string line at a time. The loop of reading rows will be controled in main form): Can someone show me how to retrieve a column, say LastName and put into strResult.Insert()??? Thanks. Imports System.Data.SqlClient Module Module1 Public Function GenerateA(ByRef strEmpID As String, ByRef strClientAcct As String, ByRef strAcctStatus As String, ByRef strAddressFlag As String, ByRef strNameFlag As String) Dim strResult As New System.Text.StringBuilder Dim GPConnection As SqlConnection Dim dr As SqlDataReader Dim GPDataset As New DataSet GPConnection = New SqlConnection("............................") Dim GPDataAdapter As New SqlDataAdapter("SELECT LASTNAME,FRSTNAME,MIDLNAME,PHONE1,BRTHDATE FROM UPR00102 where EmployID="+strEmpID,GPConnection) Try GPConnection.Open() GPDataAdapter.Fill(GPDataset, "AcctInfoTble") Dim DS As DataSet = New DataSet 'position 1 20A strResult.Insert ????????????????? Catch ex As Exception MessageBox.Show(ex.ToString) Finally GPConnection.Dispose() End Try Return strResult.ToString End Function End Module ------------------------------------------------------------------------------------- Module GenerateFile Public Function GenerateFH(ByRef strCompanyName As String, ByRef strTopCorp As String, ByRef strBatchNum As String, ByRef dtFileDate As Date) Dim strResult As New System.Text.StringBuilder strResult.Capacity = 731 'Position 1 2A FH strResult.Insert(0, "FH") 'Position 3 10A Header Date strResult.Insert(2, dtFileDate.Date.Year & "/" & dtFileDate.Date.Month.ToString.PadLeft(2, "0") & "/" & dtFileDate.Date.Day.ToString.PadLeft(2, "0")) 'Position 13 8A Header Time strResult.Insert(12, dtFileDate.TimeOfDay.Hours.ToString.PadLeft(2, "0") & ":" & dtFileDate.TimeOfDay.Minutes.ToString.PadLeft(2, "0") & ":" & dtFileDate.TimeOfDay.Seconds.ToString.PadLeft(2, "0")) 'Position 21 10A Transfer File Version strResult.Insert(20, "4.0".PadRight(10, " ")) 'Position 31 10A Product Type strResult.Insert(30, "EFUNDS".PadRight(10, " ")) ............. Return strResult.ToString End Function End Module --------------------------------------------------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: include rowstate in dataset.getxml Tag: 100394
  - 7
    - Moving solution to another machine, SQL Failure Hi all, I've developed a .NET 2003/SQL Server 2000 application. When the app fires up, it loads combo boxes (Using SQLDMO) with available servers, databases and tables. It works great. However, when I move the solution to another PC and try to run it, it fails saying "Login failed for user DEVONE\Guest'. DEVONE is the name of the machine where I developed the application, which is running SQL Server 2000 Developer. No where in my code does it reference DEVONE, so somewhere a reference to the previous machine name or SQL Server instance name is being held in the solution. Any ideas? Thanks Michael Tag: include rowstate in dataset.getxml Tag: 100390
  - 8
    - GetChanges false positives, How to avoid? I was curious if anybody know of a way to avoid false positives while using the GetChanges method. In most of my updateable aspx pages I have text/ddl/checkboxes that are populated from the existing data that the user can change, then hit the save/update button. When the save/update button is clicked the dataset is updated from the controls values regaurdless if the values in the controls have changed or not. Such as ds.Table1.Col1 = TextBox1.Text; // set whether text has changed or not. ds.Table1.Col2 = TextBox2.Text; The problem arises when a user hits the save/update button without changing anything on the page. This means that all the values in the dataset get set to exactly what they were before; however, the GetChanges returns rows with no real changes in them. Take the following code. The last GetChanges always returns 1 row even though no values in the row have changed. Dataset1 ds = new Dataset1(); Dataset1.UsersRow r = ds.Users.NewUsersRow(); string s = "asdf"; r.UserName = s; r.UserID = 1; ds.Users.Rows.Add(r); ds.AcceptChanges(); DataTable dt = ds.Users.GetChanges(); if(dt != null) Console.WriteLine("# of changed rows " + dt.Rows.Count); ds.Users[0].UserName = s; // change the value to exactly what it was. dt = ds.Users.GetChanges(); if(dt != null) Console.WriteLine("# of changed rows " + dt.Rows.Count); Any help is appreciated, EntDevGuy Tag: include rowstate in dataset.getxml Tag: 100388
  - 9
    - SchemaTable I'm using the following code to obtain information about any table in a database. Now _schemaTable contains the info about the table and one of its fields is "IsKey" which as far as I know should identify the columns that are the primary keys in the table. Unfortunately "IsKey" is always false for me even though some columns are the primary keys. Why is that? Is there something I'm doing wrong or something that I'm not doing? Some of the other information in the _schemaTable such as "ColumnName" is correct for each of the columns in the table. The following is the code sample: Thanks for help in advance. Tom. System.Data.IDataReader reader; this._Command.CommandText = "SELECT * FROM [" + tableName + "]"; reader = _Command.ExecuteReader(System.Data.CommandBehavior.SingleRow); _schemaTable = reader.GetSchemaTable(); Tag: include rowstate in dataset.getxml Tag: 100385
  - 10
    - Row-wise vs columnwise If I need to iterate through all the field values in a dataset, is there any preference for organising the outer iterations by row or by column . ie should I do (in VB.Net): For i as integer = 1 to table(0).columns.count For j as integer = 1 to table(0).rows.count ......... Next j Next i or swap columns or rows, or is it immaterial? TIA JGD Tag: include rowstate in dataset.getxml Tag: 100383
  - 11
    - SqlException - Help pls Using SQLServer database. UserId defined as numeric and First/LastName fields defined as nvarchar(50). Here is my SQL Statement: SELECT UserId, LastName & ', ' & FirstName AS FullName FROM Users ORDER BY LastName, FirstName; What does this error mean? Server Error in '/Test' Application. ________________________________________ Invalid operator for data type. Operator equals boolean AND, type equals nvarchar. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid operator for data type. Operator equals boolean AND, type equals nvarchar. Source Error: Line 136: End If Line 137: Line 138: Dim dr As SqlDataReader = MySqlHelper.ExecuteReader(CONNECTION_STRING, CommandType.Text, strSql) Line 139: Line 140: Return dr Source File: c:\inetpub\wwwroot\Test\Components\dbUsers.vb Line: 138 Stack Trace: [SqlException: Invalid operator for data type. Operator equals boolean AND, type equals nvarchar.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText) Test.dbUsers.GetAllUsers(Int32 UserId) in c:\inetpub\wwwroot\Test\Components\dbUsers.vb:138 Test.ManageUsers.FillUsersDdl() in c:\inetpub\wwwroot\Test\Secured\ManageUsers.aspx.vb:139 Test.ManageUsers.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\Test\Secured\ManageUsers.aspx.vb:59 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731 ________________________________________ Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Tag: include rowstate in dataset.getxml Tag: 100382
  - 12
    - How to effiently load many, many SQL records I have a need to effiently load millions of fairly small records into SQL Sever 2000. I have some financial data with many, many observations (one set has 37 million records) and I need to get it into a SQL server. I create a comma separated variable (CSV) file using a VB.NET program acting on the raw data. I have tried importing it into SQL Server using DTS import, but it says that it completes after about 18 million records, with no error. Using Visual Studio 2004 VB, I wrote a windows program that uses a SQL dataadapter to the table I want to insert records in, set the field parameters to the generated SQL insert command and then call ExecuteNoQuery to insert each record. This process works, but is seems to take forever to create a lot of records this way. I am fairly well versed in VS 2003 and VB.NET, but I am new to using these tools to load so many records. I must be doing something wrong or not using the appropriate technique to do this. Any help will be appreciated. Thanks! Bill Patterson UW-Madison School of Business Tag: include rowstate in dataset.getxml Tag: 100378
  - 13
    - Navigating child rows of a relationship Hi there, Here's my problem : I have 2 tables with a one-to-many relationship. I setup the relationship via the dataset component. ParentTable : Parentkey col1 col2 ChildTable : Childkey ParentKey col1 col2 I Have setup the databindings like this : textBox1.DataBindings.Add("Text",ds,"ParentTable.Parentkey"); textBox2.DataBindings.Add("Text",ds,"ParentTable.col1"); textBox3.DataBindings.Add("Text",ds,"ParentTable.col2"); textBox4.DataBindings.Add("Text",ds,"ParentTable.MyRelation.Childkey"); textBox5.DataBindings.Add("Text",ds,"ParentTable.MyRelation.Parentkey"); textBox6.DataBindings.Add("Text",ds,"ParentTable.MyRelation.col1"); textBox7.DataBindings.Add("Text",ds,"ParentTable.MyRelation.col2"); I setup a currency manager to track position and navigate in the dataset like this : myCurrency = (CurrencyManager)this.BindingContext[ds,"ParentTable"]; myCurrency.Position = 0; The events to navigate through the ParentTable rows are as follows : private void navPrevious_Click(object sender, System.EventArgs e) { if(myCurrency.Position != 0) { myCurrency.Position -= 1; } } private void navNext_Click(object sender, System.EventArgs e) { myCurrency.Position += 1; } My question is : since the ParentTable can have one or many chlidren, how can i navigate (Navigate next, previous,etc ) through these rows ? Do i have to setup another currency manager ? I tried this : myCurrency2 = (CurrencyManager)this.BindingContext[ds,"TableParent.MyRelation"]; myCurrency2.Position = 0; This doesn't seem to work if i setup the events like this : private void navPrevious_Click(object sender, System.EventArgs e) { if(myCurrency2.Position != 0) { myCurrency2.Position -= 1; } } private void navNext_Click(object sender, System.EventArgs e) { myCurrency2.Position += 1; } What am i doing wrong ? Is there a solution ? Thanks a lot for the help. Tag: include rowstate in dataset.getxml Tag: 100375
  - 14
    - Connection Pool Hello, Is it ado provider by default do the connection pooling? or it is depending on the database. I know sqlclient provider does the connection pooling but can I use connection pooling with MYSQL? thanks ap Tag: include rowstate in dataset.getxml Tag: 100371
  - 15
    - All data is text in ADO Update to Excel... I am updating several excel worksheets using ADO.NET (OLEDB objects). = Everything is working fine except all the data is inserted as text = despite being typed in the DataTable object and when the Excel worksheet = was actually created. If the user-specified Excel Workbook does not exist, one is created and = worksheets are added using "CREATE TABLE" statements with type-specific = data columns. The data type for each column is specified in the = DataTable object as well as the actual "CREATE TABLE" SQL statement. However, if the user-specified workbook already exists, the worksheets = will be updated correctly, but all data will be inserted as text values = regardless of how it is typed in the DataTable. Any help, suggestions, or advice would be greatly appreciated. - Carl Tag: include rowstate in dataset.getxml Tag: 100367
  - 16
    - Cascade without relation I have two datatables, dtTable1 has an INDENTITY column, dtTable2 has a integer column to have the value of table1 indentity column but it can be null. so I can't create the relation between tables (unless there is some kind of ignore null relation). Now when I add new row to dtTable1, then add new row to dtTable2 with the same indentity value (of cause a temp value, will change in dtTable1 when save to database) from dtTable1, is there any way to cascade value to dtTable2 when I save data into database? Please... Wei Tag: include rowstate in dataset.getxml Tag: 100363
  - 17
    - ADO.NET text driver not importing data as text I have the following comma delimited file to read: Date,campaign code,count 12/1/2004,DM31,10 12/1/2004,DM32,15 12/1/2004,DM33,20 12/1/2004,DM34,25 12/1/2004,DM35,30 I'm using the ADO.NET, System.Data.Odbc namespace to create and ODBCConnection to this file and read it using the following (simplified) code. Dim cn As New OdbcConnection("Driver={Microsoft Text Driver (*.txt; _ *.csv)};DefaultDir=d:\websites\jpg\dataimport;") Dim cmd As New OdbcCommand ("select * From cfr.csv") Dim myreader As OdbcDataReader cn.open() cmd.connection = cn myreader = cmd.executereader() response.write("<table>") While myreader.read() response.write("<tr><td>" & myreader.getstring(0) & "</td><td>" & _ myreader.getstring(1) & "</td><td>" & _ myreader.getstring(2) & "</td></tr>") End While response.write("</table>") cn.close() It outputs the following: 2004-12-01 00:00:00 31.0000 10 2004-12-01 00:00:00 32.0000 15 2004-12-01 00:00:00 33.0000 20 2004-12-01 00:00:00 34.0000 25 2004-12-01 00:00:00 35.0000 30 It converted the second field to a numeric value. I can get it to treat the field as character data if I put the values inside quotes but I don't have control of this file, it's delivered to me from a third party as is. Is there anyway to get it to read the data as plain character data without modifying the file? --Buddy Tag: include rowstate in dataset.getxml Tag: 100360
  - 18
    - DateTimePicker problem with .AddNew Hi! My Windows Form contains DateTimePicker to show date-type data from DataTable. Because application need to be able to save "no date" ie. NULL into database table, I solved it like way... ("dtpRepaired" is DateTimePicker-control) dtpRepaired.Checked = Not IsDBNull(dt.Rows(cm.Position)("Repaired")) If dtpRepaired.Checked Then dtpRepaired.Value = Date.Parse(dt.Rows(cm.Position)("Repaired").ToString()) End If Private Sub dtpRepaired_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dtpRepaired.TextChanged dt.Rows(cm.Position)("Repaired") = IIf(dtpRepaired.Checked, dtpRepaired.Value, DBNull.Value) End Sub ...because I didn't succeeded to do this like this way bounding it directly to the DataTable... 'dtpRepaired.DataBindings.Add(New Binding("Text", dt, "Repaired")) This is almost working fine, but it occurs an error after cm.AddNew when trying to change dtpRepaired-controls value or Checked-state. Error message is: "There is no row at Position 5.". I understand this why, but don't know how I could solve to make it possible to "add new" and make it possible to edit dtpRepaired too without this problem. Any succestions? Is it really impossible to bound DateTimePicker-control to DataTable, and make it possible to change date in DataTable to "NULL" ? Hopefully you understand my problem with my poor english, I'm finnish :) -- Thanks in advance! Mika Tag: include rowstate in dataset.getxml Tag: 100358
  - 19
    - Problem catching exception from a procedure Hi! I wrote a procedure in my sybase database this procedure is one line only, and attemp to insert a record in a table generating a constraint violation of a primary key and an exception. I do this only for test... then when I call the procedure from .net: com.Connection = conn com.CommandType = CommandType.StoredProcedure com.CommandText = "PRUEBA" Dim valor Try conn.Open() com.ExecuteNonQuery() Catch ex As System.Data.OleDb.OleDbException ms = ex.Message finally conn.Close() End Try there is not excetion catch!!! , I try several code modification whitout result... Tag: include rowstate in dataset.getxml Tag: 100351
  - 20
    - SqlDataAdapter aand transaction Hello, I'm using SqlDataAdapter to insert data from one table into another with SqlCommand after I start a transaction. If I have convertion error for the insertion of the data, The transaction is no longer valid, I'ts rolled back. Is there a property to leave the transaction open ? my code : SqlTransaction trans = m_Conn.BeginTransaction(); SqlCommand oCmd1 = new SqlCommand("Insert into tbl1(col1) select col1 from tbl2", m_Conn); oCmd1.Transaction = trans; oCmd1.ExecuteNonQuery(); Thanks, Sharon Tag: include rowstate in dataset.getxml Tag: 100349
  - 21
    - DataSet, new row and default values ? When I add a new row to a DataSet that was filled with info from a database the new row does not get the default values defined in SQL Server, how do I accomplish this seemingly simple task ? I don't want to have to fill in the default values in the row first, I want it to understand the defaults set in the database and fill it automatically as you would expect it to. Thank you PL. Tag: include rowstate in dataset.getxml Tag: 100348
  - 22
    - Best aproach to update DataAdapters with XML-Data Hi all What's the best aproach to import xml-based data into an oracle 9i database with ado.net DataAdapters, when the data is in an xml-file? The operations should insert new rows and update changed rows. Does ado.net provide some automatisms for this or do i have to do this with functions written myself? Is there anywhere some example code? Thank you Adrian Tag: include rowstate in dataset.getxml Tag: 100347
  - 23
    - Help ... I need somebody Help I have create such a DB -> look at the end: And I would like to have a 2 comboboxes in which I could select all Prog_Id And Profile_Id and in this way modified datasource in each of Rows in table Progs and aloso 6 textboxes to display and modified datasource in each of rows in Profile_Base. How it can be done in the fastest way ?? It is really urgent, beacuse i sit on it 3 days !! Thanks in advance ----------------------------------------- CREATE DOMAIN For_Prog_ID AS VARCHAR(20); CREATE DOMAIN For_SubProgs As VARCHAR(20); CREATE TABLE Profile_Base( Profile_ID For_SubProgs NOT NULL PRIMARY KEY, Param_1 FLOAT, Param_2 FLOAT, Param_3 FLOAT, Param_4 FLOAT, Param_5 FLOAT, Param_6 FLOAT ); CREATE TABLE Progs ( Prog_ID For_Prog_ID NOT NULL PRIMARY KEY, Profile_S1 For_SubProgs, Profile_S2 For_SubProgs, Tenon_S1_S1 For_SubProgs, Tenon_S1_S2 For_SubProgs, Tenon_S2_S1 For_SubProgs, Tenon_S2_S2 For_SubProgs, FOREIGN KEY (Profile_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Profile_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S2_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE ); -------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: include rowstate in dataset.getxml Tag: 100344
  - 24
    - How To Recursively Search Directories by Using C# .NET I've found this script on microsoft site that searches for file with given extension, its window based. How can i convert it to make it web based? I am looking for a c# script that will search a particular drive with given file extension and email the search result. http://support.microsoft.com/default.aspx?scid=kb;en-us;303974 Please help.. many thanks in advance. Tag: include rowstate in dataset.getxml Tag: 100340
  - 25
    - Updating table at a different database Hello, I'm using SqlDataAdapter to get records from table at database different from my connection using the databasename at the select statment "Select * from otherdb..myTable" After updating the data I want to update the table, I'm using SqlCommandBuilder to set the UpdateCommand at the SqlDataAdapter. But when I use the SqlDataAdapter.Update I get an error : "Invalid object name 'myTable'" I tried to change the UpdateCommandText to "Update otherdb..myTable ..." but it's not working. I don't want to use another connection. Is there a way of making it work? Thanks, Sharon. Tag: include rowstate in dataset.getxml Tag: 100336
- Next
  - 1
    - Printing excel files Hi. Can anybody help me on how to print excel files that has been read via ADO.NET. Or anyway, what I want to avoid is automation (instantiating an excel application object). Hopefully, there is way aroudn this.. Thanks in advance. Tag: include rowstate in dataset.getxml Tag: 100324
  - 2
    - higher reads when using ADO.NET thatn when using Query Analyzer I was doing some testing and noticed that when I execute a stored procedure from my ADO.NET (using the Command class of the System.Data.SQLClient namespace) the number of reads on a relatively simple query were significantly higher. As a matter of fact I have not found a case where the reads when executed from ADO.NET are lower than the reads when executing in QA. Sometimes they may be the same but QA is always has equal or fewer reads. Any reason why this is and is there any thing I can do to get ADO.NET to perform like QA? --Buddy Tag: include rowstate in dataset.getxml Tag: 100317
  - 3
    - OleDbConnection problem with more than 1 connection Hi, I had wrote 2 app in c#.net one Windows Form base and one Web Base and those 2 connect to a access database and some time I got this error in my web base application and I can't figure out what's wrong, I just hit reload and it's work Thanks for your time Sylvain Bissonnette Server Error in '/WebApplication1' Application. Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. Source Error: Line 77: // Open database connection Line 78: OleDbConnection MyConn = new OleDbConnection(ConnectionString); Line 79: MyConn.Open(); Line 80: Line 81: // Create the data adapter and execute the query Source File: C:\Inetpub\wwwroot\WebApplication1\Light.aspx.cs Line: 79 Stack Trace: [OleDbException (0x80004005): Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 WebApplication1.Light.MyDataGrid_ItemCommand(Object source, DataGridCommandEventArgs e) in C:\Inetpub\wwwroot\WebApplication1\Light.aspx.cs:79 System.Web.UI.WebControls.DataGrid.OnItemCommand(DataGridCommandEventArgs e) +110 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +68 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +106 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +121 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Tag: include rowstate in dataset.getxml Tag: 100315
  - 4
    - Command Builder in tables without primary key Hi every one, i'm trying to use a sqlcommandbuilder in an application using a table without a primary key, when i call the DataAdapter.Update Method there comes an Error saying that "the selectcommand does not return information about the primary key" or some thing like that... Does some one knows a way to implement the command builder or similar method to work around on updating tables with out primary key?? Tag: include rowstate in dataset.getxml Tag: 100306
  - 5
    - SqlHelper.UpdateDataSet with transaction Hi, I'm trying to use the SqlHelper.UpdateDataSet method with transactions. The DAAB 2.0 documentaion only say: "SqlHelper.UpdateDataset does not include transaction support. If you need this, you can implement it yourself by a preceding call to the helper method SqlHelper.ExecuteScalar("begin transaction")." but I didn't find any matching overload in the ExecuteScalar method. What would be the correct way of using the UpdateDataSet with transaction? Thanks, Gwenda Tag: include rowstate in dataset.getxml Tag: 100293
  - 6
    - encapsulating SQL queries into OO framework Right now I'm putting my query strings into static functions in a DbQuery class that returns Datatables. Eg. public class DbQuery { public static Datatable GetMyData() { Dataset ds; ... string query = "select * from SomeTable"; .... return ds.Tables[0]; } } Over time, I'm accumulating a lot of static methods in my DbQuery class. This way seems very procedural. I'm trying to make it more object oriented. Any recommendations on how to encapsulate individual queries into a more object oriented framework? Tag: include rowstate in dataset.getxml Tag: 100291
  - 7
    - How to update one table based on a match found in another Hi I'm trying to figure out the best way to perform a simple but repetitive task in vb.net. Access DB with 2 tables: first table - a list of phone numbers not to call and a table holding contact information. Both tables have a 'telephone' column and I need to set a logical flag = 1 in the second table only if a match is found in the first. I've tried using a single Dataadapter for each and two Datasets and every other combination. I've even tried example code from MS (KB Q308057) but this doesn't work. However, when I try to retrieve a record it all falls apart and vb.net throws a relation exception that I cannot fathom out. I know I can run a simple update query - but want to do this programatically. If anyone can throw me a bone or suggest a place to start again - I really would appreciate any help. With thanks Tag: include rowstate in dataset.getxml Tag: 100284
  - 8
    - MSDN Webcast: Introducing ADO.NET 2.0 for SQL Server 2005 We'll host a webcast on ADO.NET 2.0 & SQL Server 2005 next week. I thought you guys might be interested. For more information you can check out: http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032263284&Culture=en-US This is part of a webcast series on SQL Server that will take place during the week. For more information about the series you can look at: http://msdn.microsoft.com/sql/2005webcasts/default.aspx Thanks, -- Pablo Castro Program Manager - ADO.NET Team Microsoft Corp. This posting is provided "AS IS" with no warranties, and confers no rights. Tag: include rowstate in dataset.getxml Tag: 100282
  - 9
    - DataObjects.NET OR mapping, any opinions ? Hajo, I consider to use DataObjects.NET (http://www.x-tensive.com/Products/DataObjects.NET/) and I need any opinions about this solution. 1. Is is mature enaugh to use it in commercial project? 2. Can it work seamlessly with Oracle data base? thanks in advance for info Gawel Tag: include rowstate in dataset.getxml Tag: 100281
  - 10
    - Storing missing values For a column in (eg an Access) database that's used to store numeric data, is there a specific way to designate a missing value for a given row (ie the value was simply never measured or assigned). Or must I set up my own convention, ie if it's a short type then to use eg -32768 or -999 (or some other value obviously outside the valid range for that column)? JGD Tag: include rowstate in dataset.getxml Tag: 100279
  - 11
    - System.Data.OracleClient Version Recently I started a project attempting to connect to an Oracle 9i database using the System.Data.OracleClient namespace with .Net 1.1. The database's service name is longer than 16 characters & I have since found that their is indeed a bug limiting service names to 16 characters in the namespace. What is the latest version of the library I should be using? The assembly version (installed on my development environment) for System.Data.OracleClient is 1.0.5000.0. Is there a fix forthcoming if this is the latest version? Tag: include rowstate in dataset.getxml Tag: 100277
  - 12
    - Passwords with Special Characters I'm trying to figure out a general algorithm to allow any valid MS SQL 2000 username/password combination to log into a Winform application. I'm having trouble with special characters. I'm created a user named test The password assigned is test'"; (that is, the word test, followed by a single quote, followed by a double quote, followed by a semi-colon) In the connection string, I've tried quoting the password with double quotes and doubling each double quote in the password. That causes the code to run fine (no runtime exceptions), but it can't log into the SQL server. I also tried the above with single quotes instead of double quotes. That doesn't work either. If I change the password to test' I can then place double quotes around it, and it works fine. If I change the password to test" I can plance single quotes around it and it works fine. But I can't get the combination of both single and double quotes in a single password to work. Thanks in advance! Tag: include rowstate in dataset.getxml Tag: 100276
  - 13
    - Stored procedure not returning a value in @RETURN_VALUE Hi everyon, I am experiencing a problem with a stored procedure not returning a value in the parameter @RETURN_VALUE when debugging in C#. The stored procedure looks something like this: CREATE PROCEDURE dbo.ListSomething @myParam int AS declare @rc int set @rc = 0 select * from dbo.myTable where myField = @myParam if (@@error <> 0) set @rc = @@error return @rc When I run this stored procedure in Query Analyzer, it works as expected returning any matching records and a return value of 0. For information, the SQL I'm using in Query Analyzer is: declare @rc int exec @rc = ListSomething 123 select @rc In my C# code though, when I query the @RETURN_VALUE parameter in the Parameters collection of the SqlCommand, all I ever get is "undefined value". Even if I change the stored procedure to return something specific such as 1, 2, 3, etc. The code I'm using is: SqlConnection DBConnection = new SqlConnection(); SqlCommand DBCommand = new SqlCommand(); DBConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=myDatabase;server=myServer"; DBConnection.Open(); DBCommand.Connection = DBConnection; DBCommand.CommandText = "ListSomething"; DBCommand.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(DBCommand); if (DBCommand.Parameters.Count > 1) { foreach (SqlParameter SPParameter in DBCommand.Parameters) { // set the value of each input parameter } } SqlDataReader CommandResults = DBCommand.ExecuteReader(CommandBehavior.CloseConnection); if (DBCommand.Parameters["@RETURN_VALUE"].Value == 0) { // display results from stored procedure } else { // raise an error } CommandResults.Close(); I have read that the use of DeriveParameters is not recommended because of the additional roundtrip to the server, but this isn't an issue for me as the stored procedures are not going to be used that often, and I need a way of dynamically building the parameters list for population without having to define all of them in advance. When I debug the code, the line that reads the value of @RETURN_VALUE fails as it has an "undefined value". The return value just isn't coming back from the stored procedure, even though through Query Analyzer it is being returned. Is anyone able to help me get the return value from my stored procedure please? I've searched the internet but haven't had much luck. Many thanks in advance Adam Ainger Tag: include rowstate in dataset.getxml Tag: 100272
  - 14
    - Aggregate data columns not working after the dataset is deserializ Hi, I have a dataset with three tables in it. A parent table MenuPricing and two child tables Labor and Parts. In the MenuPricing table I created a data column named TotalPrice with the following expression: Sum(Child(relParts).TotalPrice). See the xml source below. This dataset will work fine if used locally ie in the same app domain. But if I access this dataset from a web service, I get the error below. Is there a way arround this bug? System.InvalidOperationException: There is an error in XML document (1, 4190). ---> System.Data.EvaluateException: Cannot find column [TotalPrice]. at System.Data.AggregateNode.Bind(DataTable table, ArrayList list) at System.Data.DataExpression.Bind(DataTable table) at System.Data.DataExpression..ctor(String expression, DataTable table, Type type) at System.Data.DataColumn.set_Expression(String value) at System.Data.Merger.MergeSchema(DataTable table) at System.Data.Merger.MergeTableData(DataTable src) at System.Data.Merger.MergeDataSet(DataSet source) at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction) at ServiceMonitor.SMService.MenuPricingDS.ReadXmlSerializable(XmlReader reader) in C:\softdev\CS\SM2\ServiceMonitor\Web References\SMService\Reference.cs:line 7407 at System.Data.DataSet.System.Xml.Serialization.IXmlSerializable.ReadXml(XmlReader reader) at System.Xml.Serialization.XmlSerializationReader.ReadSerializable(IXmlSerializable serializable) at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read13_GetMenuPricingResponse() --- End of inner exception stack trace --- Dataset definition: <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="MenuPricingDS" targetNamespace="http://tempuri.org/MenuPricingDS.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/MenuPricingDS.xsd" xmlns:mstns="http://tempuri.org/MenuPricingDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"> <xs:element name="MenuPricingDS" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Labor"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" minOccurs="0" /> <xs:element name="MpHeaderID" type="xs:int" minOccurs="0" /> <xs:element name="MpLaborID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" minOccurs="0" /> <xs:element name="Description" type="xs:string" minOccurs="0" /> <xs:element name="Quantity" type="xs:float" minOccurs="0" /> <xs:element name="HourRate" type="xs:decimal" minOccurs="0" /> <xs:element name="TotalPrice" type="xs:decimal" minOccurs="0" msdata:Expression="Quantity * HourRate" /> <xs:element name="OpCode" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Parts"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" minOccurs="0" /> <xs:element name="MpHeaderID" type="xs:int" minOccurs="0" /> <xs:element name="MpPartID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" minOccurs="0" /> <xs:element name="PartNo" type="xs:string" minOccurs="0" /> <xs:element name="Quantity" type="xs:float" minOccurs="0" /> <xs:element name="Description" type="xs:string" minOccurs="0" /> <xs:element name="UnitPrice" type="xs:decimal" minOccurs="0" /> <xs:element name="TotalPrice" type="xs:decimal" minOccurs="0" msdata:Expression="Quantity * UnitPrice" /> <xs:element name="Cost" type="xs:decimal" minOccurs="0" /> <xs:element name="Profit" type="xs:decimal" minOccurs="0" msdata:Expression="UnitPrice - Cost" /> <xs:element name="TotalProfit" type="xs:decimal" minOccurs="0" msdata:Expression="(Quantity * UnitPrice) - (Quantity * Cost)" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="MenuPricing"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" /> <xs:element name="MpHeaderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /> <xs:element name="Description" type="xs:string" /> <xs:element name="YearID" type="xs:int" /> <xs:element name="ModelID" type="xs:int" /> <xs:element name="CategoryID" type="xs:int" /> <xs:element name="ShowOnWeb" type="xs:boolean" /> <xs:element name="PrePaid" type="xs:boolean" /> <xs:element name="Rental" type="xs:boolean" minOccurs="0" /> <xs:element name="TotalParts" type="xs:decimal" minOccurs="0" msdata:Expression="Sum(Child(relParts).TotalPrice)" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="MenuPricingDSKey1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:MenuPricing" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:unique> <xs:keyref name="relParts" refer="MenuPricingDSKey1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade"> <xs:selector xpath=".//mstns:Parts" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:keyref> <xs:keyref name="relLabor" refer="MenuPricingDSKey1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade"> <xs:selector xpath=".//mstns:Labor" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:keyref> </xs:element> </xs:schema> Tag: include rowstate in dataset.getxml Tag: 100269
  - 15
    - Datagrid SortCommand does not work ??? Hi There I have a datagrid with a Select(LinkButton) Column followed by several Bound Columns. I have enabled the columns to sort and created the correct event handler (I think) - however the crux of my problem is that when I click on one of the column headers to sort by it the ItemCommand fires rather than the SortCommand. in the .aspx file I have: OnItemCommand="SalesGroupInitial_ItemCommand" OnSortCommand="SalesGroupInitial_SortCommand" which correlate to the .aspx.vb file (I also have an OnItemDatabound event if that is of any significance) I have not included the code at this juncture as it is a flat case of the wrong event firing when I click the Column Header Any ideas would be very much appreciated Stuart Tag: include rowstate in dataset.getxml Tag: 100267
  - 16
    - Error Message: Timeout expired. Hello there, I have about 50 users who use an asp.net application i made. For a while there were no problems but now i see a lot of timeout expired messages i diiferent forms of my application. See the stack trace below: What can i do to avoid this? Thnx in advance, Victor Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Page Error Occured: /webgabprod/Administration/administration.aspx ExceptionType: System.Data.SqlClient.SqlException Stack trace: at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at WebGab.WebForm1.GetAanvragen() at WebGab.WebForm1.btn_zoek_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() Tag: include rowstate in dataset.getxml Tag: 100251
  - 17
    - concurrency violation with bound control Hi. I'm sorry if this is a repost. Please reply with existing links, if any. I have a list box with a datatable as data source. I edit an item from the list box (by changing the item in the datatable) and call the update method() of a data adapter. My problem is I get a concurrency violation saying no rows were affected. Tag: include rowstate in dataset.getxml Tag: 100241
  - 18
    - DataTable.LoadDataRow - can you improve on this? DataTable is dt, filled already and with keys defined, uid, seq etc, suitable variables ... object[] newRow = new object[5]; newRow[0] = uid; newRow[1] = seq; newRow[2] = text; newRow[3] = type; newRow[4] = data; dt.LoadDataRow(newRow,false); >>>> I don't like this because it relies on the column positions - of course I could use an enumeration for readability but that wouldn't remove the underlying problem >>>> I can create a detached row with thr right schema DataRow newRow = dt.NewRow(); >>>> and then fill the columns by name .... newRow["uid"] = uid; newRow["seq"] = seq; >>>> which is great, but then there is no overloaded method for .LoadDataRow, which allows me to load that data ... any suggestions for achieving the required effect - loading data without hardwiring the column positions? Cheers Jim Tag: include rowstate in dataset.getxml Tag: 100239
  - 19
    - ado vs oledb Hi, I use to program using VB + ADO with MS Access. however, i've read that oledb is faster and better then ADO to access to DB. could you tell me in which wqy is it faster ? what i've seen till now, it's that i need 3 times more code lines to do the same thing. thanks a lot, PM Tag: include rowstate in dataset.getxml Tag: 100230
  - 20
    - Using DSN in connection string with SqlConnection Object I want to use DSN in Connection string. But for opening connection i am using 'SqlConnection' object. i.e using System.Data.SqlClient; So is it possible to use DSN in connection string with 'SqlConnection' object. OR i should go only for 'OdbcConnection'. Tag: include rowstate in dataset.getxml Tag: 100229
  - 21
    - best way to retrieve thousands of records. I have currently using a dataset to access my data from sql server 2000. The dataset contains 3 tables that is related to each other. parent/child/grandchild relationship. My problem is it's very slow to retrieve records from sql server. I'm using sqldataadapter.fill method to populate dataset. Parent table contains more than 3,000 records and child table contains more than 10,000 records and grandchild table contains more than 90,000 records as of now. I tried to limit the number of records to return by a select command using the criteria but my problem is I dont know how to limit the number of records return by a 3rd table (grandchild). I'm using textboxes in parent table and datagrid in 2nd and 3rd table. There is no problem querying the 1st and 2nd table but I don't know how to query the 3rd table. 3rd table must know first the primary key value of the 2nd table that is stored in a datagrid. but don't know how to do this. Anyone know what is the better way to access this data? I would love to read some article about techniques on accessing table that has a relationship up to 3rd table (grandchild). thanks in advance. Tag: include rowstate in dataset.getxml Tag: 100222
  - 22
    - Is there any way to know if a connection is in a transaction? Greets. A very simple question in the topic, probably takes about 10 seconds for an expert to answer =) Thanks .. Tag: include rowstate in dataset.getxml Tag: 100217
  - 23
    - DataGridView error Hi, i have DataGridView whose sourse i set to a datatable with 5 columns containing data. i then remove the 3rd column, created a DataGridViewComboBoxColumn, set it's DataSource, ValueMember and DisplayMember. the Valumeber is an integer and the displaymember is a string. I then instert this into the same location as the column that was removed. the problem i am getting is when the Grid is loaded, i get errors stating "System.FormatException: the value of the DataGridViewComboBoxCell is invalid. To replace this default dialog, please handle the DataError event.". Why is this error happening? here is the code that does the replacing and adding of a combo box: private void addExchangeLookUpCombs( DataGridView dt ) { dt.Columns.Remove( "exchange_id" ); DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn( ); cb.DataSource = DbConnection.instance.getDbTable("StockExchange"); cb.ValueMember = "exchange_id"; cb.DisplayMember = "symbol"; cb.FlatStyle = FlatStyle.Flat; dt.Columns.Insert( 2, cb ); } Tag: include rowstate in dataset.getxml Tag: 100215
  - 24
    - RowState Question Hi folks, I'm reading through David Sceppa's excellent ADO.NET book, trying to teach myself ADO.NET, and have a question about the RowState property. If I add a new row to a DataTable, it has a RowState of 'Added'. If I modify an existing row, its RowState is 'Modified'. If I add a row, but before I call AcceptChanges I modify that row, is it still 'Added'? I guess it has to be ... but what happens to the data I first entered into the row that I might have overwritten with the subsequent edit? Just trying to get a handle on how this stuff fits together :) Cheers, Matt Tag: include rowstate in dataset.getxml Tag: 100209
  - 25
    - RowState Undelete? A row was deleted in a DataTable, and now I want to bring it back so I can remove it (so my dataadapter will not touch it later). How can I do that? Thanks. replaceExisting Tag: include rowstate in dataset.getxml Tag: 100201

Hi Gurus,

how can i include rowstate value in dataset.getxml string

<datatable>
<row1 state="Added">
<col1>v1</col1>
</row1>
<row2 state="Modified">
<col1>v2</col1>
</row2>
</datatable>
</dataset>

i am passign the above string to stored proc(sql200) to perform DML operations
any help on this.

regards
mak

Top

Re: include rowstate in dataset.getxml by amir

amir
Fri Dec 03 02:03:51 CST 2004

You can not, DataSet will not write RowState in Xml.

--
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only..

"mak" <mak@discussions.microsoft.com> wrote in message
news:AAFF27BA-DFA6-4796-9811-E2EF5C045A99@microsoft.com...
> Hi Gurus,
>
> how can i include rowstate value in dataset.getxml string
>
> <datatable>
> <row1 state="Added">
> <col1>v1</col1>
> </row1>
> <row2 state="Modified">
> <col1>v2</col1>
> </row2>
> </datatable>
> </dataset>
>
> i am passign the above string to stored proc(sql200) to perform DML
> operations
> any help on this.
>
> regards
> mak

Top

Re: include rowstate in dataset.getxml by Sahil

Sahil
Fri Dec 03 09:36:36 CST 2004

DataSet.GetXML is not what you need since it doesn't support such an
overload.

However you can use DataSet.WriteXML and pass in XmlWriteMode.DiffGram to
get the job done.

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

"mak" <mak@discussions.microsoft.com> wrote in message
news:AAFF27BA-DFA6-4796-9811-E2EF5C045A99@microsoft.com...
> Hi Gurus,
>
> how can i include rowstate value in dataset.getxml string
>
> <datatable>
> <row1 state="Added">
> <col1>v1</col1>
> </row1>
> <row2 state="Modified">
> <col1>v2</col1>
> </row2>
> </datatable>
> </dataset>
>
> i am passign the above string to stored proc(sql200) to perform DML
operations
> any help on this.
>
> regards
> mak

Top