How to force a specific format on xml generated by xsd

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
    - Newbie with a Problem Hi There, Hope Somebody dosn`t mind Helping a Newbie? I have the Follwoing Code: Private Sub frmSystemUsers_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'File Datasets Try dsSystemUsers.EnforceConstraints = False Try Me.odcSystemUsers.Open() odaSystemUsers.Fill(dsSystemUsers) cmSystemUsers = DirectCast(BindingContext(dvSystemUsers), CurrencyManager) mlLoading = True Catch fillException As System.Exception Throw fillException Finally Me.odcSystemUsers.Close() End Try Catch eLoad As System.Exception System.Windows.Forms.MessageBox.Show(eLoad.Message) Finally mlLoading = False End Try 'End of Fill Datasets End Sub Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click cmSystemUsers.AddNew() txtFirstname.Enabled = True txtSurname.Enabled = True txtUsername.Enabled = True txtPassword.Enabled = True End Sub Private Sub btnAccept_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAccept.Click If txtFirstname.Text = "" Then ValidDataMessage = "First Name Required" txtFirstname.Focus() ElseIf txtSurname.Text = "" Then ValidDataMessage = "Surname Required" txtSurname.Focus() ElseIf txtUsername.Text = "" Then ValidDataMessage = "Username Required" txtUsername.Focus() ElseIf txtPassword.Text = "" Then ValidDataMessage = "Password Required" txtPassword.Focus() If ValidDataMessage = "" Then If MessageBox.Show("This Will Save All Changes - Are You Sure?", "Warning!", MessageBoxButtons.OKCancel) = DialogResult.OK Then cmSystemUsers.EndCurrentEdit() If dsSystemUsers.HasChanges Then odaSystemUsers.Update(dsSystemUsers) dsSystemUsers.Clear() odaSystemUsers.Fill(dsSystemUsers) End If Else End If MessageBox.Show(ValidDataMessage, "Data Entry Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End If End If End Sub Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim DeleteResult As DialogResult = MessageBox.Show("Delete " & txtUsername.Text & " ?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) If DeleteResult = DialogResult.Yes Then Me.dvSystemUsers(cmSystemUsers.Position).Delete() End If End Sub Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click txtFirstname.Enabled = True txtSurname.Enabled = True txtUsername.Enabled = True txtPassword.Enabled = True End Sub Private Sub btnCancelChanges_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancelChanges.Click If MessageBox.Show("This Will Cancel All Changes - Are You Sure?", "Warning!", MessageBoxButtons.OKCancel) = DialogResult.OK Then cmSystemUsers.CancelCurrentEdit() End If txtFirstname.Enabled = False txtSurname.Enabled = False txtUsername.Enabled = False txtPassword.Enabled = False End Sub End Class First Question - Am I writing my code the correct way for a Database Application, or am I going about it totally the Wrong Way? Second Question is - Why I try and click my Update Button, it dosn`t Update the Data to my Database. It Adds a Row but with just Blank Data Third Question - When I delete a Row, It deletes it on Screen but dosn`t Update My Database Again Sorry for been sooooooo Stupid but like I said Im a newbie thats confused, I`ve search the Net but got even more confused because it seems there is so many ways of doing things. Hope omebody dosn`t mind Helping out? Many Thanks NSC Tag: How to force a specific format on xml generated by xsd Tag: 119965
  - 2
    - Is there an XMLDataAdapter? I have two, dynamic XML files that contain data. My customer insists on using XML for a number of quite valid reasons. Being new (read naive) to XML, I thought there might be some form of SELECT statement that could be used with XML files. A number of books have referred me to the .NET SDK. However, I can't seem to find what I need. Is there a data adapter for XML? If so, where might it be documented? If not, must I program my own queries against the contents of various dataset tables (read by <data-set>.ReadXML)? I must stay within the Microsoft provided .NET framework and not purchase software from another vender. I also must assume that the user will have neither SQL nor Access available. TIA, Gus Tag: How to force a specific format on xml generated by xsd Tag: 119956
  - 3
    - how to know the table is exist in the database Tag: How to force a specific format on xml generated by xsd Tag: 119942
  - 4
    - Connect to a password protected MS Access DB After I set the password for MS Access DB , i modify the connection string from connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=System.Environment.SystemDirectory\" & "MyDBName.MDB" to connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=System.Environment.SystemDirectory\" & "MyDBName.MDB" & ";User Id=admin;Password= " & "MyPassWord" & ";" Afterward I open the Access DB, it return error "cannot start your application. the workgroup information file is missing or opened exclusively by another user." Any idea? thanks. Peter Tag: How to force a specific format on xml generated by xsd Tag: 119937
  - 5
    - ANN: New VistaDB 2.1 release supports Visual Studio .NET 2005 VistaDB 2.1 embedded SQL database has been released. Free major update features over 60 improvements including improved .NET Provider support for Visual Studio .NET 2005, .NET 2.0 and .NET Compact Framework. 2.1 now includes a free 2-User VistaDB Server that extends the 500KB embedded engine to provide true client/server SQL database support. Embedded and server feature royalty free distribution. Read more: http://www.vistadb.net/Press_051024_VistaDB21Released.asp -- Anthony Carrabino www.vistadb.net Tag: How to force a specific format on xml generated by xsd Tag: 119927
  - 6
    - Update Multiple table using Dataset Hi, I have an issue in updating the Primary Key in the Parent table. I have set of three tables (Database SQL2000, VB.NET), where A is related to B and B is related to C. I have written a stored procedure which returns all the records in these tables and fill up a single DataSet. All these table have primary key which is an Identity Column. The dataset then populates the three grids in the client application. The users can add/update/delete the values in all the three tables and there is single save button to do the updates. I am code I have created DataRelation between table A,B and C. Also when I add a new add to the child table, I set the parent row as well. All these is working fine. I am using the example as described in the CodeProject article http://www.codeproject.com/cs/database/relationaladonet.asp?df=100&forumid=14883 But my problem here is when I add a row in the Parent table say A and then add new rows in the child table B. The new generated ID in the Parent table is not propagated to the rows in the child table. I am using RowUpdated event to capture get the latest ID returned from the stored procedure as output parameter. I use the latest ID to update the datatable. When I debug the application, I can retrieve the new ID in the RowUpdated event and set it back to the datarow: e.Row.Item("ColumnName") = newID. e.Row.AcceptChanges() But these changes are not seen in the dataset. It still has same old ID but in the DEBUG mode the e.row has the new value. Moreover, its an issue because the event arguments are passed as Byval and not as ByRef. i.e. I am not getting the actual reference to the DataRow. Has anybody faced this problems before? Please help... Tag: How to force a specific format on xml generated by xsd Tag: 119923
  - 7
    - Fill table in dataset with query and then add columns? I'm filling up a dataset table with a database query. Then I'm binding the dataset to an ASP.Net asp:DataGrid. However, some derived columns have values that are too complicated to fill out in the SELECT statement in the query. Can one add additional columns to a dataset after initially creating a dataset with a database query? What I want to do is to fill up the dataset with a query, create additional columns (unless I can/should do that in the SELECT list?), loop thru the dataset and on each row do some logic to decide how to fill out the derived columns. The derived columns can all be text. I do not need to do updates on this table back into the database. Is this a reasonable approach? Tag: How to force a specific format on xml generated by xsd Tag: 119919
  - 8
    - Fill related tables in dataset with one query? Thought this would be simple, but apparently its not. I have a strongly-typed dataset with tables that have relations set in the DataSet designer. I've been stymied when attempting to fill this dataset using a join query. Without TableMappings, nothing is filled in the dataset. I can't use table mappings, however, because it won't allow me to split one result set among four different tables. I can create a tablemapping for each table in the dataset, but the "source table" is the same in each one--the result set. No two table mappings can have the same source table, so it fails. If I was grabbing all data, it wouldn't be such a problem, as I could fill each table in turn. However, I'm performing a search at the same time, which means only relevant data is returned. Pulling it all down and then sorting through everything is not feasable, since the database could hypothetically contain millions of rows. What should I do? Use a DataReader and fill the dataset manually? TIA. Tag: How to force a specific format on xml generated by xsd Tag: 119916
  - 9
    - Do DataTable's in ASP.NET 2.0 support "blob" datatypes? I have potentially large PDF legal files (up to 10MB) that will be passed to an imaging system via a webservice. Does anyone know which datatype I should use for this? IOW, is there something akin to a "blob", since this is binary data. Tag: How to force a specific format on xml generated by xsd Tag: 119912
  - 10
    - Copy a table using ADO.Net OK, I think the answer is no, but I need to ask. I have a table structure defined in my Access database (SQL Server is not available), I would like to take that table and create a new table with a unique name. Can I do this using ADO.NET? Thanks, Dave Tag: How to force a specific format on xml generated by xsd Tag: 119902
  - 11
    - Newbie with Database Connection Problem Hi, Wonder if Somebody could help me? I`ve been searching all over for a solution but am totally lost. I have a Class called Connection as below: Public Class Connection Private Shared mConnectionsstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" Private Shared mLocation As String Private Shared connArray As ArrayList Public Shared Sub setString(ByVal ind As Integer) Dim connArray As New ArrayList connArray.Add("J:\Database\MasterDB.mdb") connArray.Add("J:\Database\TestDB.mdb") mLocation = connArray(ind).ToString End Sub Public Shared ReadOnly Property [String]() As String Get Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mLocation & ";" End Get End Property End Class On my Main Form I have my Database Connection Setup as: Dim UP As New OleDb.OleDbCommand() Dim Con As New OleDb.OleDbConnection() Connection.setString(Me.cboSelectDB.SelectedIndex) Con.ConnectionString = Connection.String UP.Connection = Con UP.CommandType = CommandType.Text UP.CommandText = "Select * From Passwords Where Users_Name=? and Users_Password=?" End Sub But when I run my App it Errors on line "mLocation = connArray(ind).ToString" with the following error: "Additional information: Index was out of range. Must be non-negative and less than the size of the collection" Anybody point me in the right direction? Many Thanks in Advance Regards Not_So_Clever Tag: How to force a specific format on xml generated by xsd Tag: 119899
  - 12
    - Adding deleted rows back to a DataTable I'm trying to add rows marked as deleted back into their parent DataRowCollection by using DataRowCollection.Add. The behavior I was expecting was having the DataRowState switch back to it's last value before the delete, i.e. Unchanged->Deleted->Unchanged, Modified->Deleted->Modified, etc. Instead I get an ArgumentException with the message "This row already belongs to this table." Obviously the row does belong to the table, however it is not currently part of it's row collection. How would I go about implementing this? I know I can use RejectChanges but that will revert the state back to the last Original, which will undo any field changes as well. All I want to do is undo the last Delete action. I was considering adding a duplicate new row and loading the deleted row's values into it, but that might result in constraint violations when running the related stored procedures against the data source. Thanks in advance. Tag: How to force a specific format on xml generated by xsd Tag: 119893
  - 13
    - Hierarchical search of tree flattened to dataset--advise pls I have a search problem that I'm seeking some advice in. I'm dealing with the need to search node names in a tree structure that is flattened into a database table (I have no say over the design, just over how to search). The tree consists of nodes that represent rooms, cabinets in each room, drawers in each cabinet, etc. The flattened representation is as what you would expect--each data row has a column representing the room, cabinet, drawer, etc. When I search this data, I need to do it in a hierarchical fashion--I look at the first room, then the first cabinet in that room, then the first drawer in that cabinet, etc. If I search the dataset linearly, I end up showing the same hit multiple times (if I hit on the room name, once I finish showing hits on that row, I encounter the room again the next row). I could, once a hit is found, move vertically down the column in the dataset, erasing all names that match, but that isn't easily done without performing multiple checks to make sure I'm still in the same branch of the tree. Any hints on a better way to perform this search would be appreciated. I could convert the data to xml and use xpath, or create a normalized dataset and fill it appropriately, but I'm not sure this will ease the search later. Thanks. Tag: How to force a specific format on xml generated by xsd Tag: 119890
  - 14
    - SQL Server Raiserror and .NET SqlDataAdapter Running SQL Server 2000 SP4 and .NET Framework 1.1.43322 SP1 I have a trigger that does some work and then, when it decides there is a problem does: if @ErrMsg is not null BEGIN RAISERROR (50001,16,1, 'AssetConfig', 'AssetKey/Site', @ErrMsg) ROLLBACK transaction In my Windows Forms application I have try { SqlTransaction sqlTrans = â?¦.BeginTransaction(); Update several tables, including the one with the trigger sqlTrans.Commit(); } catch (SqlException e) { sqlTrans.Rollback(); } When the trigger raises the error, I do not get the @ErrMsg because the SqlDataAdapter does not trap the error. Instead, I get System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.Rollback() at the Rollback statement. This is because the Commit threw this SqlException Message # 3902 "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION." What I WANT is to have the SqlDataAdapter.Update throw the error that I have specified, just as it would do if, for example, a primary or foreign key had been violated. Then the catch block would do the rollback and handle the error. I tried taking the Rollback out of the trigger, but then I got no message, no error, and the database was updated with bad data. What is the secret to making SQL Server Raiserror work with the Framework to return a meaningful error? Tag: How to force a specific format on xml generated by xsd Tag: 119889
  - 15
    - Data Grid - Style Hi All! How can i add styles like combo box, checkbox in my datagrid control TIA Viswanathan S Tag: How to force a specific format on xml generated by xsd Tag: 119884
  - 16
    - Datagrid - format Hi All! I want to display the currency symbol in the datagrid for all the rows of the salary (currency) field. How to do this? 'This is my sample code Dim cm As New OleDbCommand Dim da1 As New OleDbDataAdapter Dim ds1 As New DataSet Try cm.CommandText = "select distinct d.dept_name as deptname ,sum (e.salary) as salary from department d ,employee e where d.dept_id=e.dept_id group by d.dept_name" cm.Connection = Con da1.SelectCommand = cm da1.Fill(ds1, "employee") dg.DataSource = ds1.Tables("employee") Catch ex As Exception MsgBox(ex.Message) End Try TIA Viswanathan S Tag: How to force a specific format on xml generated by xsd Tag: 119883
  - 17
    - build SQL text from SqlCommand Hi, is it possible to retrieve exact sql text which will be executed from a prepared SqlCommand or DBCommand? I need this for logging all activity. Something like this would be helpfull: Command.CommandText = "ExecProc" Command.Paramaters.Add..... SQL = Command.GetInternalSql 'or Command.GetType.InvokeMember ("GetInternalSql") Tag: How to force a specific format on xml generated by xsd Tag: 119874
  - 18
    - vs2k5 Beta2 'Code Analysis' returns warnings on generated code I built a simple Data Access Layer with the Visual Studio 2005 DataSet Designer using the wizard. All who I have talked to who use it, articles I haver read by those who use it speak very highly about the quality of code that vs2005 creates. Before adding any code of my own I ran "Code Analysis" (from debug menu) against the code and got (no errors but) 90 warnings! I know nothing about the "Code Analysis" and can find nothing in the help. Some of the warnings are just good suggestions that the user should consider based on best coding practice and the users intension for the code such as; Warning 4 CA2210 : Microsoft.Design : Sign 'NorthwindDataAccess' with a strong name key. 1 Other warnings point out things I think the Wizard should have handled; Warning 42 CA1804 : Microsoft.Performance : EmployeesTableAdapter.GetData(Nullable`1<System.Int32>):EmployeesDataTable declares a local, 'GetData', of type NorthwindDataAccess.EmployeeDataSet+EmployeesDataTable, which is never used or is only assigned to. Use this local or remove it. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 1229 NorthwindDataAccess More Examples: Warning 10 CA1801 : Microsoft.Performance : The 'this' parameter (or 'Me' in VB) of EmployeeDataSet.ShouldSerializeEmployees():Boolean is never used. Mark the method as static (or Shared in VB) or use 'this'/Me in the method body. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 188 NorthwindDataAccess Warning 48 CA1709 : Microsoft.Naming : Correct the casing of parameter name 'LastName'. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 1333 NorthwindDataAccess Warning 89 CA1706 : Microsoft.Naming : 'Id' is an abbreviation and therefore is not subject to acronym casing guidelines. Correct the capitalization of 'ID' in parameter name 'EmployeeID' by changing it to 'Id'. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 1460 NorthwindDataAccess Can anyone who knows more about this comment on this feature and the results I am getting.=20 Thank you,=20 dbuchanan Tag: How to force a specific format on xml generated by xsd Tag: 119873
  - 19
    - Concurrency management in XML Files Hi, I was wondering how it is possible to manage optimistic concurrency in XML files. Indeed, i store my data in xml files in an asp.net application. My data access layers accepts custom entities, and then uses dataset.WriteXml() to write the new data. The problem is that this way of doing erases all file content, and writes the content of the dataset. If a user wrote his changes just before we write ours his changes are lost. Is there a simple way to manage optimistic concurrency, like what we can do with a DataAdpter with SQL databases? Thanks a lot for your help PS: I use .net v1.1 ;) Tag: How to force a specific format on xml generated by xsd Tag: 119870
  - 20
    - Where namespace have ObjectSpace? Where namespace have ObjectSpace? I need to write application using ObjectSpace, but I cannot find it on VS.NET 2005. Tag: How to force a specific format on xml generated by xsd Tag: 119863
  - 21
    - Some newbie questions Hi All Wondering if someone might have a few seconds to clear up some newbie queries I have with VB.NET and ADO.NET. I know their are limitless situations that require different approaches but would love to know some of the fundementals as a place to start. Have been through quite a few examples but are unsure about the following. 1. For a simple database with a couple of tables do you create a dataadapter for each table and then create a dataset that includes each of these tables? 2. Do you use the same adapters and datasets througout the application on different forms? If so how do you make them available to the other forms if you have used the wizard to create them? 3. Is it best to reference rows/records by ID number in the table or the row index? 4. Should you link tables in the database using views/queries in the database or by creating a separate datatable in the dataset that joins the tables from the database? 5. Any other advice on best practices for learing this stuff. Appreciate any assistance. ilr Tag: How to force a specific format on xml generated by xsd Tag: 119858
  - 22
    - calling a stored procedure in ADO.NET 2.0 How can I calling a stored procedure (say "sp_example") in ADO.NET 2.0? I used to do this in ADO.NET 1.1, but in 2.0 (beta2 vs2005), after the following ... sqlConnection con = new sqlConnection(strCon) sqlCommand cmd = sqlCommand("sp_example", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.??? under the Parameters property, I only find the AddRange() and AddWithValue() method, but not the Add() method which is in ADO.NET 1.1. Does anyone have an idea how to call a stored procedure in the new 2.0 framwork? Thanks in advance. David Tag: How to force a specific format on xml generated by xsd Tag: 119856
  - 23
    - How do I retreive warnings? If I do something like this: SqlConnection connection = new SqlConnection( ... ) SqlCommand command = new SqlCommand( ... ) // initialize command object. command.ExecuteNonQuery(); How do I determine if the sql server generated a warning, and how do I "read" the warning? Thanks in advance, Peter Strøiman Tag: How to force a specific format on xml generated by xsd Tag: 119850
  - 24
    - Datagrid forecolor from dataview. Hi, How do I associate a column in the dataview with a color property of datagrid forecolor, more specifically a particular cells forecolor. I'm associating a dataview with the datagrid and the values are showing OK. But I want the fore color of a cell being set on specific condition. I'm thinking of adding a new column to the table which has an expression to determine the color. And if this is associated with the cell fore color, it should work great as I just need to keep on updating the data. I tried but couldn't find a way to do this. Any help would be of great use. Thanks in advance, Gobi. Tag: How to force a specific format on xml generated by xsd Tag: 119848
  - 25
    - question i use enterprise services for having transaction management. i use one transactional component that is creating an ado.net connection, and i pass this connection to not enterprise services components to use and have transaction control in a central place in the project. i can commit or rollback the operations from outside those objects. as i tested this works. i need to work this way since my programming model requires the use of friend properties/methods that are not supported by enterprise services. is there some reason why not to work this way? TIA! Tag: How to force a specific format on xml generated by xsd Tag: 119847
- Next
  - 1
    - System.Data.OleDb.OleDbException: Unspecified error My ASP.NET web page was working just fine connecting to an Access DB and displaying data in a DataGrid. Couldn't be much simpler really. Then, I had to move the page and its underlying database file to a new server. Now it ceases to work and gives me ... Unspecified error 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: Unspecified error It is NOT a security issue, I assume, since I gave the ASPNET user full access to the database folder. What else could cause this error? Anyone know? Thanks. Tag: How to force a specific format on xml generated by xsd Tag: 119844
  - 2
    - Modeless Form Lose Accelerator and Tabbing Keys All, I am using COM Interop with C# to display a modeless form via a COM call from an application written in Visual studio C++ 6.0. I can display the form as modeless however the accelerator and tab keys do not work. Interestingly, if the form is modal the accelerator and tab keys work properly. Also if the same form is launched from a C# appication (not using COM) the forms accelerator and tab keys work properly. The form is a Class library (DLL) that has a COM interface. There is a COM method that calls .Show() for the form. Does anyone know how to get the accelerator and tab keys to work when calling the form through COM? Thanks in advance, Scott Tag: How to force a specific format on xml generated by xsd Tag: 119841
  - 3
    - Find duplicate rows in datatable Hi All I need to detect duplicate rows in a datatable in VB net 2003 using MS Access 2K I can do it at database level with sql e.g sql = "select membernumber from members group by membernumber having count(membernumber) > 1" dt = getdata(sql, "dupes") ' getdata is my sub routine which returns a datatable Can you do a similar thing querying an Ado.net Datatable? i.e can you do advanced querying on a populated datatable? Any tips appreciated Regards Steve Tag: How to force a specific format on xml generated by xsd Tag: 119832
  - 4
    - Querying a scalar in DataTable Hi, I have a DataTable with three columns (2 int, and 1 string). Now I would like a query that return the total number of different integers in one of the interger columns. For example Name Age Class A 12 4 B 13 5 C 11 3 D 12 3 Now if I select the total number of different integers in the Age column the answer is 3(because 11, 12 ,13). I hope someone understands my problem. Can some one help me out Thanks in Advance Tag: How to force a specific format on xml generated by xsd Tag: 119831
  - 5
    - Help with using DataView to insert Record..Please! I'm new to ado.net/asp.net and have been on a crash course these last few days. I've been stuck on this current problem for over a day and it seems pretty simple, but I can't get it to work. I'd like to create a data view from a data table, insert a record into that data view and have it inserted back into the actual database (Access 2000). Following tutorials online, I've been able to use a dataadapter to connect to the database, then using a datatable, insert new rows and have them inserted in the actual database. But when it comes to doing that same functionality via a dataview, I've had no luck. Here is the code I've been using. It generates no errors, and a new row is added to the underlying datatable, but nothing is ever sent back to the database. I think it might have something to do with the myAdpater.InsertCommand code (are these used the same way in DataViews as in DataTables?). Thanks in advance for any advice. Public Sub editLevelProgressFromView() 'Objects used to connect/read from database Dim cs As ConnectionStringSettings Dim myConnection As OleDbConnection Dim myAdapter As OleDbDataAdapter Dim myTable As DataTable Dim myView As DataView Dim myRow As DataRowView Dim sqlStr As String cs = ConfigurationManager.ConnectionStrings("strConn") myConnection = New OleDbConnection(cs.ConnectionString) sqlStr = "Select * from tblTest" myAdapter = New OleDbDataAdapter(sqlStr, myConnection) 'Set up insert commands for use on myAdapter.Update method myAdapter.InsertCommand = New OleDbCommand("INSERT INTO tblTest (c_name, c_number) VALUES(?, ?)", myConnection) myAdapter.InsertCommand.Parameters.Add("@c_name", OleDbType.VarChar, 15, "c_name") myAdapter.InsertCommand.Parameters.Add("@c_number", OleDbType.VarChar, 30, "c_number") 'Fill Table and create View myTable = New DataTable() myAdapter.Fill(myTable) myView = myTable.DefaultView 'Add Row to myView, insert data via BeginEdit and EndEdit methods myRow = myView.AddNew() myRow.BeginEdit() myRow("c_name") = "testName" myRow("c_number") = "testNumber" myRow.EndEdit() 'Accept changes in table from view myTable.AcceptChanges() 'Commint changes to database (does not work, but no error thrown) myAdapter.Update(myTable) End Sub Tag: How to force a specific format on xml generated by xsd Tag: 119827
  - 6
    - DataSet and Grid I want to hook up a DataSet to a grid but control the error display to the user. An exaple is user inputs invalid data and program puts up special message display instead of default eror messge from DataSet/grid combinatio. Thanks, Marc Tag: How to force a specific format on xml generated by xsd Tag: 119822
  - 7
    - Confused about the DataAdapter I'm trying to learn/use ADO.Net and am puzzled by the DataAdapter. It has a TableMappings property which is a collection of mappings from the source into the DataSet. This implies that the DataAdapter can retrieve many tables from a source and store each in a single DataSet. But it only has a single SelectCommand so Fill() will only return single result set. I want to read 4 tables out of an access db. Do I need to create 4 DataAdapters to do it? Confused Tag: How to force a specific format on xml generated by xsd Tag: 119811
  - 8
    - C# function within DataReader query Hi, I've a parameterised query that is used as the basis for an Excel export. I need to add an additional column that doesn't map to a field in my SQL table. What I have done in the past in my Access apps is to include a function I've created in the query SQL. Is there a way to achive the same with C#/ado.net? Many thanks, Simon Lane Tag: How to force a specific format on xml generated by xsd Tag: 119810
  - 9
    - Optimistic Concurrency and TimeStamp Hi, I would like to implement optimistic concurrency where I retrieve the timestamp of a record in a table with a stored procedure and save the timestamp value into a vb.net variable. This represents the original timestamp for the record. When a user updates the record, I would like to pass the original timestamp to a stored procedure that performs the update to ensure the record has not been changed by another user. The problem is, how do I store the original timestamp value from SQL Server 2000 in vb.net? I have tried: Dim OrigTstamp() as Byte I can assign an incoming timestamp to a byte array but I'm not certain if anything is there. I then have great difficulty passing the OrigTstamp() to the update stored procedure. -- Thanks, Scott H. Tag: How to force a specific format on xml generated by xsd Tag: 119806
  - 10
    - Parameterized query nightmares I'm having a very strange problem with a parameterized query failing. I grabbed the query in Profiler to see if something weird was going on. Here it is, nonsense stripped out for brevity: exec sp_executesql N'SELECT CabinetID, CabinetName FROM Cabinets WHERE (CabinetName LIKE N''%@SearchText%'') ORDER BY CabinetName', N'@SearchText nvarchar(16)', @SearchText = N'tech' If I manullay change the LIKE statement to replace @SearchText directly with tech (i.e., "LIKE N''%tech%''), the command completes successfully in Query Analyzer and I get back the data I expect. If I run it as is in QA, I get back nothing. I've checked my authentication, and that's not the problem (if I go back to a concatenated select statement in my program it works fine), I've tried different sizes (and no size at all) for the nvarchar, and that doesn't change the result. I'm probably missing something very simple, but I haven't been able to figure it out thorugh research. Help! Tag: How to force a specific format on xml generated by xsd Tag: 119799
  - 11
    - SQL Server Parameters I have a typed DataSet with say 50 fields in it. On the form, I only show 40. I have a stored procedure that takes in all 50 parameters. When I call SqlDataAdapter.Update(ds.Tables(0).GetChanges(DataRowState.Modified)), I get a SQL error back that Procedure XYZ is expecting Parameter '@myParameter' which was not supplied. In looking at Profiler, I can see that this parameter is being passed to SQL Server as Default, not as the value that the field has in the Original DataSet. Any suggestions? - I know that I can set the Default values inside of SQL Server, but that isn't going to work for this situation. Thanks in advance Tag: How to force a specific format on xml generated by xsd Tag: 119794
  - 12
    - How to find out what the column's data type is? Hi all, How would I find out what the data type is for the below column? I'm using ADO.NET, C# and MS Access 2000. col_Source.ColumnName Thank you. -- Message posted via http://www.dotnetmonster.com Tag: How to force a specific format on xml generated by xsd Tag: 119784
  - 13
    - Setting Oracle Schema At present, when I write Oracle SQL in .net, I have to embed the schema name as a prefix for all of the table names so I end up with code like "select * from " + GetSchemaName() + ".mytable". It would be much neater if I could change the schema for the connection. I could add a "alter session set current_schema="+GetSchemaName() every time a connection is opened, however as we open a new connection for almost every statement (and rely on connection pooling), this would double the number of db round trips. Is there any other way of setting the current schema without a round trip or only only running the "alter session" command when the connection is a new connection rather than one in the pool (I presume this would work)? Thanks, Jonathan Tag: How to force a specific format on xml generated by xsd Tag: 119780
  - 14
    - Displaying n:m relation without showing the in-between table. Hi, I want to display an n:m relation in Windows without showing the in-between table. As an example, I used the Orders, Order Details and Products tables from the Northwind database. I use a ComboBox for the parent and want the details in a DataGrid I have set up a form and added some SqlDataAdapters and a DataSet, ComboBox and DataGrid. (using Visual Studio 2003). Here is the code I added: System.Data.DataColumn masterCol; System.Data.DataColumn detailCol; DataRelation dr; // Let the DataAdapters fill the DataSet DA_Orders.Fill(dataSet11); DA_Products.Fill(dataSet11); DA_OrderDetails.Fill(dataSet11); //add relation Orders - Order Details masterCol = dataSet11.Tables["Orders"].Columns["OrderID"]; detailCol = dataSet11.Tables["Order Details"].Columns["OrderID"]; dr = new DataRelation("OrdersToOrderDetails",masterCol,detailCol); dataSet11.Relations.Add(dr); //add relation Order Details - Products masterCol = dataSet11.Tables["Order Details"].Columns["ProductID"]; detailCol = dataSet11.Tables["Products"].Columns["ProductID"]; dr = new DataRelation("OrderDetailsToProducts",masterCol,detailCol,false); dataSet11.Relations.Add(dr); // Let the ComboBox display the OrderID comboBox1.DataSource = dataSet11; comboBox1.DisplayMember = "Orders.OrderID"; // Let the DataGrid display the OrderDetails dataGrid1.DataSource = dataSet11; dataGrid1.DataMember = "Orders.OrdersToOrderDetails"; When the DataGrid has "AllowNavigation" set to true, everything works fine. I get 3 Order details records, and by pressing "+" I can go to the Products information. !!!! However, I don't want to see the in-between table Order Details !!!!! So I tried setting dataGrid1.DataMember = "Orders.OrdersToOrderDetails.OrderDetailsToProducts", in an attempt to leave out the in-between table, and directly show the Products. But now I don't see 3 Products anymore, I only see the first one. What is the best way to hide the Order Details? Thanks in advance, Alexander van Buitenen. Tag: How to force a specific format on xml generated by xsd Tag: 119774
  - 15
    - Question Hi All, I got an error here, and don't know what might have caused this. any input is gladly appreciate it Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30002: Type 'selectCompanyEvents' is not defined. Source Error: Line 7: <script runat="server" language="VB"> Line 8: Sub Page_Load() Line 9: Dim objWebService As New selectCompanyEvents() Line 10: dgCompanyEvents.DataSource = objWebService.selectEvents() Line 11: dgCompanyEvents.DataBind() Source File: c:\inetpub\wwwroot\project\index.aspx Line: 9 Show Detailed Compiler Output: C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.1.4322\vbc.exe" /t:library /utf8output /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\project\90c16606\11e52b47\-o3a17q8.dll" /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\project\90c16606\11e52b47\qitahgw0.dll" /R:"c:\windows\assembly\gac\system.web\1.0.5000.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll" /R:"c:\windows\assembly\gac\system.web.services\1.0.5000.0__b03f5f7f11d50a3a\system.web.services.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll" /R:"c:\windows\assembly\gac\system.web.mobile\1.0.5000.0__b03f5f7f11d50a3a\system.web.mobile.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.5000.0__b03f5f7f11d50a3a\system.drawing.dll" /R:"c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system.data.dll" /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.5000.0__b03f5f7f11d50a3a\system.enterpriseservices.dll" /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\project\90c16606\11e52b47\inoglfew.dll" /out:"c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\project\90c16606\11e52b47\w6q0mkhc.dll" /debug- /win32resource:"c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\project\90c16606\11e52b47\w6q0mkhc.res" "c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\project\90c16606\11e52b47\w6q0mkhc.0.vb" Microsoft (R) Visual Basic .NET Compiler version 7.10.6001.4 for Microsoft (R) .NET Framework version 1.1.4322.2032 Copyright (C) Microsoft Corporation 1987-2002. All rights reserved. c:\inetpub\wwwroot\project\index.aspx(9) : error BC30002: Type 'selectCompanyEvents' is not defined. Dim objWebService As New selectCompanyEvents() ~~~~~~~~~~~~~~~~~~~ Tag: How to force a specific format on xml generated by xsd Tag: 119773
  - 16
    - How do I get the SqlDbType from a DataTable? I need to know what the native SQL data type is. How can I figure this out once I have filled a dataset? Thanks in advance. -- Robert Tag: How to force a specific format on xml generated by xsd Tag: 119770
  - 17
    - DDL via Command.ExecuteNonQuery Hello all: Consider the following: CREATE PROCEDURE procname @input1 int, @input2 int AS execute some stuff here --this is a comment END Suppose this were entered in a text box, including the line feeds and carriage returns. If I pass this to the ExecuteNonQuery method of a command object, it will fail. If I strip out the comment and also replace the line feeds/carriage returns with spaces, it will succeed, but if I review the stored procedure with, say, Enterprise manager, the procedure looks like this: CREATE PROCEDURE procname @input1 int, @input2 int AS execute some stuff here END in other words, not having included line feeds in the command, they do not end up in the script either. What I would like to do is have the script execute, as it appears, just as though I had entered it in, say, Query Analyzer. Suggestions? Thanks much, zdrakec Tag: How to force a specific format on xml generated by xsd Tag: 119769
  - 18
    - Sorted data is not sorted I have a table [CoverageLimits] with the following columns Coverage, Limit, LimitDescription, PerPerson, PerAccident I load the data from a stored procedure into a datatable Select Coverage, Limit, LimitDescription, PerPerson, PerAccident From CoverageLimits Order By Coverage, PerPerson, PerAccident. I have manually executed this procedure in Query Analyzer and the data comes out in the desired order. 'A', 'J', '20/40', 20, 40 'A', 'K', '25/50', 25, 50 'A', 'C', '100/300', 100, 300 While the data is actually stored in the heap in this order 'A', 'K', '25/50', 25, 50 'A', 'C', '100/300', 100, 300 'A', 'J', '20/40', 20, 40 When I attempt to populate a combobox with this data from my datatable dim drs() as datarow drs = mydatatable.select("Coverage = '" & A & "'") cbo.DataSource = drs cbo.DisplayMember = "LimitDescription" cbo.ValueMember = "Limit" The data is displayed in its natural ordered state. So then I attempted to sort the data in the table dim drs() as datarow mydatatable.defaultview.sort = "Coverage, PerPerson, PerAccident" drs = mydatatable.select("Coverage = '" & A & "'") cbo.DataSource = drs cbo.DisplayMember = "LimitDescription" cbo.ValueMember = "Limit" The data is still displayed in its natural ordered state. Now I can attempt to sort the array of datarows, but this seems kind of a wasted step, I would prefer the data be ordered by my stored procedure. Anyone have any ideas how I can achieve the desired result? TIA Tag: How to force a specific format on xml generated by xsd Tag: 119766
  - 19
    - HOW FILL A DATATABLE FROM THE DATASET ??? Hi, I usually work with dataset I fill from SQL Server through a SQLDataAdapter. I would like to fill a table of my dataset reading the records from another table of the dataset, because I would like to change the order of the column without reconnect to SQLServer. The first time I connect to import the records through a parametric stored procedure stored in SQL Server.Is there a specific dataadapter to read and fill datatable from the dataset control ??? Any suggest ??? Many thanks Tag: How to force a specific format on xml generated by xsd Tag: 119762
  - 20
    - ADO.Net data adapter doesn't allow a table of more than 100 column In our VB.Net project, we are using VS.Net's data adapter wisard to generate SQLDataAdapter. What we find out is that if the table we use for this contains no more than 99 columns, everthing will be fine. But as soon as you go beyung that, the process will error out with a message indicating that generating select statement failed. I wonder is that a limitation of ADO.net? But I can run select query against the same table without any issue. What is wrong? Thanks in advance Feng Tag: How to force a specific format on xml generated by xsd Tag: 119746
  - 21
    - SQL Server does not exist or access denied I have developed a small application using ASP.NET and VB.NET on my development machine it works great. When I copy across the files manually to my test machine and create a Virtual Directory all of the functionality works well except for a page with a datagrid that retrieves data from an MSDE database (error message is detailed below). I have checked the connection string and that looks good and MSDE is properly installed and configured on the test box. By the way I have tried this on two separate test machines I get the same error. At a loss to understand why. Do I need to run some exe that lets my ASP.NET application to use MSDE, is it a permissions thing or what? By the way the error I get is as follows: SQL Server does not exist or access denied. 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: SQL Server does not exist or access denied. Tag: How to force a specific format on xml generated by xsd Tag: 119745
  - 22
    - DB insert problems with apostrophe in a Surname and Datetime value Iâ??m copying data across from an Access database to an MSDE database through the use of some vb.net code. Unfortunately the application crashes when it goes to copy across data, in particular surnames that have an apostrophe such as Oâ??Shay etc. Also I have a â??date/timeâ?? value in my Access database that I have to copy across to my MSDE database in a field that is of datatype â??datetimeâ?? and length â??8â??. How do I get this right I tried to get this working and the page would crash every time. The code Iâ??m using is as follows. Dim conAuthors As OleDbConnection Dim cmdSelectAuthors As OleDbCommand Dim dtrAuthors As OleDbDataReader Dim txt_RC_TITLE, txt_RC_GIVENNAME, txt_RC_SURNAME, txt_RC_MOBILE, txt_RC_EMAIL, txt_RC_GROUPS as Object Dim dte_RC_DATESTAMP as object 'the dte_RC_DATESTAMP is a datestamp that is in the Access database that I have to copy across but Iâ??m having a lot of trouble not sure how to do it 'open Access database with customer details conAuthors = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\CustomerDatabase.mdb") conAuthors.Open() cmdSelectAuthors = New OleDbCommand( "Select * From CUSTOMERTABLE", conAuthors ) dtrAuthors = cmdSelectAuthors.ExecuteReader() 'loop through all customer details in Access database, copy these details to a new set of two tables in the MSDE database While dtrAuthors.Read() 'set up read in values from Access database txt_RC_TITLE = dtrAuthors( "txtTITLE" ) txt_RC_GIVENNAME = dtrAuthors( "txtGIVENNAME" ) txt_RC_SURNAME = dtrAuthors( "txtSURNAME" ) txt_RC_MOBILE = dtrAuthors( "txtMOBILE" ) txt_RC_EMAIL = dtrAuthors( "txtEMAIL" ) 'dte_RC_DATESTAMP = dtrAuthors( "dteDATESTAMP" ) 'insert details into CUSTOMERDETAILS table in MSDE database and get that intCUSID(customer id) that is a unique integer that is created for each record that is inserted into the table Dim conDB As SqlConnection Dim strInsert As String Dim cmdInsert As SqlCommand conDB = New SqlConnection("SERVER=xxx.xxx.xxx.xxx;UID=sa;PWD=xxxx;DATABASE=customerdb") strInsert = "Insert into CUSTOMERDETAILS (txtTITLE, txtGIVENNAME, txtSURNAME, txtMOBILEPHONE) Values ('" & txt_RC_TITLE & "', '" & txt_RC_GIVENNAME & "', '" & txt_RC_SURNAME & "', '" & txt_RC_MOBILE & "'); SELECT SCOPE_IDENTITY()" cmdInsert = New SqlCommand(strInsert, conDB) conDB.Open() Dim intCUSID As Integer intCUSID = cint(cmdInsert.ExecuteScalar()) conDB.Close() 'Add the customers email address and the intCUSID(customer id) to the CUSMARKETING table Dim strConn As String = "SERVER=xxx.xxx.xxx.xxx;UID=sa;PWD=xxxx;DATABASE=customerdb" Dim cmd As New SqlCommand("INSERT INTO CUSMARKETING (intCUSID, txtEMAILADDRESS ) VALUES('" & intCUSID & "', '" & txt_RC_EMAIL & "')", New SqlConnection(strConn)) cmd.Connection.Open() cmd.ExecuteNonQuery() cmd.Connection.Close() End While dtrAuthors.Close() conAuthors.Close() Tag: How to force a specific format on xml generated by xsd Tag: 119744
  - 23
    - SQL Server 2000 SELECT COUNT(*) Issue Ok. I can't figure this one out, but maybe someone has some experience with this. Seperate boxes (1 running SQL Server 2k, 1 app server, both running win Server 2003). .Net app that connects from app server to SqlServer box, does a select count(*) from a table, if count == 0, then process aborts, else process continues. For the last two wednesdays in a row, at the same time, the process counts 0 instead of the actual number. I can take the Sql for the count and run it manually through QA and get back the correct count. I can take the app down to my dev environment and run it, everything runs as expected. The app is able to connect to the DB, but when it runs the select count(*), then it returns 0. Has anyone ever experienced this behavior, know what causes it? TIA AP Tag: How to force a specific format on xml generated by xsd Tag: 119739
  - 24
    - Insert Into Syntax error Hi all, Please can someone tell me what's wrong with the following INSERT INTO statement. The error message return that an 'INSERT INTO syntax error' I have a feeling that it is because of the 'Sensor offset' field name having a space between the two names, although it is like that in the MS Access 2000 database that I'm using? But I would like someone to clarify or suggest the problem. da_Target.InsertCommand.CommandText = "INSERT INTO Layouts (Name,Picture, Sensor offset) VALUES ('David',' ',7)"; Thank you. -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200510/1 Tag: How to force a specific format on xml generated by xsd Tag: 119730
  - 25
    - Howto move in a datatable rows Hi All, I come from Microsoft Access programming, so when I use a recordset from code, I can use MoveFirst, MoveLast, MoveNext, MovePrevious So my question is: In a DataTable, how can I simulate this methods? TIA Erny Tag: How to force a specific format on xml generated by xsd Tag: 119715

Hi all,
I need some help:
I have a DataSet object created by the .NET "xsd designer". The DataSet is being filled from a Stored Procedure which returns the results of a few select statements.

I have no problem filling the DataSet, but when I use the method GetXml() I get an XML string that is not in the format I wanted.

I get somthing like this:

<Table>
<Field_1>1</Field_1>
<Field_2>eng</Field_2>
</Table>
<Table1>
<Field_1>1</Field_1>
<Field_2>eng</Field_2>
</Table1>

When actually I wanted something like this:

<Table>
<Field_1>1</Field_1>
<Field_2>eng</Field_2>
<Table1>
<Field_1>1</Field_1>
<Field_2>eng</Field_2>
</Table1>
</Table>

I created the xsd by dragging & droping tables in the designer. I put "Table1" into "Table" when I did that, but nothing happened.

Is there a way to force a selected format on the XML I generate from the data in such a DataSet, or do I have to create the whole thing by code?

Thanks!

Lea

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Top