Dataset and typed datasets

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
 - Oracle Connection Pooling Problem (Type your message here) I am using Oracle Data Provider ( System.Data.OracleClient) to connect to Oracle Database 8.1.7. When I set connection pooling to true in my connection string, sometimes, My application can not open connection to database. But when I set connection pooling to false, then everything works fine. It looks like that something is going wrong with connection pooling. -------------------------------- From: Basharat Ali ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>OUNLxeOji0iVMYBPJLFE/w==</Id> Tag: Dataset and typed datasets Tag: 94920
 - 2
 - sqldatareader compare to server side read only cursor in ado Hi, SqlDataReader must be connected to the database in order to bring data. this is like server side cursor read only in ado. the point is that in the SQL Profiler, when my code is running over the records in ado recordset with server side cursor, i see SQL activity for each move in the record. in SqlDataReader i don't see the same activity in the profiler for each record. can someone explane why is the difference and is the DataReader really a server side cursor? TIA, z. Tag: Dataset and typed datasets Tag: 94917
 - 3
 - Ado.Net can't create Adapter ? I create a table in SQL 2000 with 100 columns, want to use SqlAdapter or OleDbAdapter access it, but I can't create Insert,Delete,Update command, why? How to do it? thanks! -----> create table kjcg ( itemid numeric identity, item_cglb nvarchar(1) not null, item_32 nchar(1) not null, item_140 nchar(1) not null, item_110 nchar(1) not null, item_64 nvarchar(3) not null, item_304 nchar(1) not null, item_47 nchar(2) not null, item_305 nchar(1) not null, item_46 nchar(2) not null, uid int not null, item_21 nchar(1) not null, item_163 nchar(1) not null, item_200 nvarchar(15) not null, item_51 nchar(1) not null, item_300 nchar(1) null, item_125 nvarchar(15) null, item_2 nchar(1) not null, item_126 nvarchar(50) null, item_62 nchar(1) not null, item_15 nvarchar(10) not null, stateid int not null, item_9 nvarchar(140) null, item_41_3 nchar(2) not null, item_12 nvarchar(12) not null, item_16 nchar(1) not null, item_12_1 nvarchar(12) not null, item_63 nvarchar(3) not null, item_33 nchar(1) not null, item_201 nchar(1) not null, item_124_1 nvarchar(15) null, item_123 nchar(1) not null, item_15_1 nvarchar(10) not null, item_210 nchar(1) not null, item_1 nchar(1) not null, item_dqdm nvarchar(3) not null, item_4 nvarchar(10) not null, item_share bit not null, item_year int not null, item_upload bit not null, item_120 nvarchar(20) null, item_121 datetime not null, item_125_1 nvarchar(7) null, item_127 nvarchar(30) null, item_128 nvarchar(80) null, item_13 text null, item_13_1 text null, item_13_2 text null, item_13_3 text null, item_130 nvarchar(80) null, item_131 nvarchar(1) null, item_133 text null, item_32_1 nvarchar(10) null, item_14 nvarchar(200) null, item_141 money not null, item_142 money not null, item_142_1 money not null, item_142_2 money not null, item_142_3 money not null, item_143 money not null, item_144 money not null, item_145 money not null, item_148 money not null, item_149 money not null, item_150 money not null, item_151 money not null, item_152 money not null, item_153 money not null, item_154 money not null, item_160 nvarchar(30) null, item_161 nvarchar(10) null, item_162 money not null, item_22 nvarchar(30) null, item_3 nvarchar(140) null, item_301 nvarchar(80) null, item_302 nvarchar(14) null, item_303 text null, item_306 nvarchar(14) null, item_34 nvarchar(14) null, item_37 nvarchar(100) null, item_38 nvarchar(6) null, item_39 nvarchar(30) null, item_40 nvarchar(30) null, item_41 nvarchar(20) null, item_41_1 nvarchar(20) null, item_41_2 nvarchar(30) null, item_420 nvarchar(20) null, item_45 int not null, item_52 nvarchar(80) null, item_53 nvarchar(12) null, item_56 nvarchar(12) null, item_60 nvarchar(100) null, item_61 nvarchar(80) null, item_8 nvarchar(22) null, item_sjdc nvarchar(1) null, item_sjdr nvarchar(1) null, item_xh money not null, item_243 money not null, item_244 money not null, item_51_1 nvarchar(1) null, item_51_2 money not null, item_51_3 money not null, item_151_1 money not null, item_152_1 money not null, constraint PK_KJCG primary key (itemid) ) go Tag: Dataset and typed datasets Tag: 94905
 - 4
 - database path and dataadapters Hello, I connect to an access database through the ui oledbdataadapters. This is fine becuase the wizard prompts for a file location. Puttig my page on a server, I have run into a few diffilculties. The page still asks for c:\database\database.mdb. I have changed all the other events such as submit/delete etc to server.mappath("/database/database.mdb"). How then do i change that in the dataadapters? Tag: Dataset and typed datasets Tag: 94904
 - 5
 - How to execute a Transform SQL Query? I try to use a data adapter to fill a dataset with a transform sql query from ms access database. The query string works at ms access's query area but when I run the asp.net application, this error occures : "There is a syntax error near TRANSFORM ..." (error is in Turkish language so maybe this is not the exact translation). Isn't it possible to run TRANSFORM queries at ADO.Net? My querystring is : strQuery= "TRANSFORM iif(Count(records.isPaid) is null, 0,Count(records.isPaid)) AS PaymentCount" strQuery &= " SELECT records.paymentGroupID, records.explanation, Count(records.paymentGroupID) AS TotalPaymentCount, MAX(paymentDate) AS LastPaymentDate" strQuery &= " FROM(records)" strQuery &= " WHERE(records.paymentGroupID <> 0)" strQuery &= " GROUP BY records.paymentGroupID, records.explanation" strQuery &= " PIVOT records.isPaid;" Tag: Dataset and typed datasets Tag: 94903
 - 6
 - Error: Can't create child list I have a master table named keywwordsets and two child tables keywords and searchphrase. I created relations in the xsd file: ID to KeywordSetID in both cases. In the underlying Access database these same relationships are also defined. The KeywordSet table is bound to 3 textboxes and a checkbox. The child tables are bound to grids. The datasources are the dataset dsWKS1 and the datamembers are the relations KeywordSets.KeywordSetsKeywords KeywordSets.KeywordSetsSearchPhrase I tried several times to make a datamember that didn't start with the KeywordSets table (somehow this seems wrong to me) but the compiler rejected all my attempts. When I try to open frmFullWord I get the following error system.argumentexception cannot create a child list for field KeywordSetsKeyword system.windows.forms.bindingcontext.ensurelistmanager system.windows.forms.bindingcontext.get_item frmFullWord_Load line 679 The line is cmK = CType(BindingContext(dsWKS1, "KeywordSets.KeywordSetsKeyword"), CurrencyManager) in the snippet Try cm = CType(BindingContext(dsWKS1, "KeyWordSets"), CurrencyManager) AddHandler cm.ItemChanged, AddressOf cm_ItemChanged AddHandler cm.PositionChanged, AddressOf cm_PositionChanged AddHandler daWKS.RowUpdated, AddressOf OnRowUpDated cmK = CType(BindingContext(dsWKS1, "KeywordSets.KeywordSetsKeyword"), CurrencyManager) cmSP = CType(BindingContext(dsWKS1, "KeywordSets.KeywordSetsSearchPhrase"), CurrencyManager) daWKS.Fill(dsWKS1, "KeywordSets") daWK.Fill(dsWKS1, "Keywords") daWSP.Fill(dsWKS1, "SearchPhrase") Can somebody please help me solve this error? Thanks. Dennis Tag: Dataset and typed datasets Tag: 94901
 - 7
 - A good site to learn asp.ent, ado.net and access databases? hello, What is a good site to learn asp.net, ado.net, and access databases? TIA Aaron Tag: Dataset and typed datasets Tag: 94895
 - 8
 - Advice on ORaacle Data Provider. What would be the best provider to support the Lobs's (clob in particular) data type. I'm aware that the OLEDB provider doesn't support the data type. My choices then are ODP.net provided by Oracle and the Oracle Client provider by Microsoft. Using a Data Access Layer that uses both an OLEDB and SQL Client providers. Please advise on the better choice for Oracle 9i support. Thanks you. Tag: Dataset and typed datasets Tag: 94894
 - 9
 - dataset.writexml and diffgrams, not writing well formed xml Hello, I am using vb.net and trying to write a local copy of a strongly typed dataset as a diffgram when the user is offline, so that when they connect to the server again their changes can be sent back. I am writing the diffgram using: dataset.writexml(filename,xmlwritemode.diffgram). If I load the original data from the server, then write it as a diffgram, then exit, then run the program again (this time offline) and load the diffgram, all works fine. However, if I then write the diffgram again, from the same dataset but this time with the local copy of the data (which has just been loaded from the diffgram), then exit, then run the program again and try and load the diffgram I get an xmlexception with errorcode "Xml_badnamechar" and the message "The ':' character, hexadecimal value 0x3A, cannot be included in a name. Line 9983, position 49." This is presumably because one of my field names includes a ':' (which I now suspect may have been a mistake!). But why does it not cause a problem the first time round, and is there anyway of making writexml encode the offending characters? I would be very grateful for any help, Edward Murray Tag: Dataset and typed datasets Tag: 94892
 - 10
 - Problem with DataView.Add() : the new item isn't shown/focused in Hi, I have a real serious problem I can't figure out myself. Here's the pretty plain scenario: I have a DataSet with one table. I created a DataView on that table. I have a Listbox bound to the DataView to select items to display and edit in a couple of TextBoxes. So far everything is fine. Now I'd like to add a button that allows the user to add an item to the list. In the event handler of the button click I call the Add()-method of the DataView. Unfortunately nothing happens to the UI visually. The selected item in the list stays unchanged. I can select the newly added 'empty' item manually at the bottom of the list though. But the TextBoxes still show all the details of the last selected 'real' item. When I press the add-button I would like to have the newly added item (row) selected in the ListBox automatically and all the TextBoxes blanked out. That's exactly the result that I got when I dropped the DataView and bound all controls to the DataTable of the DataSet directly. I just don't understand it. But I need to use a DataView so I will be able to filter the data that will be displayed. Oh, I might mention that there is NO RowFilter set on the DataView (yet) that might prevent the newly added row from showing. Can somebody please help me?! I would really appreciate it. PS: I also already tried to use the Add()-method of the underlying CurrencyManager. It's still the same :-( Best regards, Lorenz Tag: Dataset and typed datasets Tag: 94890
 - 11
 - Tracking Down Source of Constraint Exceptions I have a dataSet that loads in Xml Data that could be created externally. It is using the DataSet.ReadXML command. Constraint errors can occur as a result of the data being passed. When a Constraint exception occurs is there any way of getting more information as to which table, row within the data set is causing the problem or which line of the XmlFile being read is causing it to occur as opposed to just sorting through The xml file to find the cause??? Tag: Dataset and typed datasets Tag: 94889
 - 12
 - Typed datasets & sorting with parent-child data... I have a two-table typed dataset. For the sake of argument, the tables are "tbl_Parent" and "tbl_Child" (no, these are the real names). What I want to do is show a sorted list of all the parents & within each parent, a sorted listed of the children. However I'm not having much success sorting the internal list... For example, I have an ASP.NET Repeater that I can bind to the tbl_Parents table to... but to sort it, I used a DataView. Then, with in the ItemDataBound in that repeater, I'm grabbing the specific DataItem (in this case, a tbl_ParentRow) and getting the child rows... but I can't sort the children. I'm sure this is possible, I'm just not approaching it the right way. Ideas? -AC Tag: Dataset and typed datasets Tag: 94887
 - 13
 - Using DataSet Data from another class How can I bind a datatable to a datagrid in another form Tag: Dataset and typed datasets Tag: 94882
 - 14
 - Apostrophe in SQL string Hi, in my application I add personal information about customers to a database by sending a SQL string. Now, sometimes there are customers with names that contain an apostrophe (like D'Artienne, etc.). Now, when I create a SQL string with such an apostrophe it gets malformatted (like: "insert into table1 (Firstname) values ('D'Artienne')" ). So, is there any way to insert a name that contains an apostrophe into a table by SQL? Thanks a lot peter Tag: Dataset and typed datasets Tag: 94880
 - 15
 - How to access individual table column data? Say I have a table object that contains several columns, and the first column is the column I'm intested in, and it contains numeric values. I'd like to call a function and pass in those column values, like this: (Calling code) MyFunction(table.columndata(0)) (function definition) MyFunction(col as arrayofint?) This is pseudo code to illustrate my point -- but does anyone know if this can be done, and what the syntax would look like please? TIA, -dnw. Tag: Dataset and typed datasets Tag: 94876
 - 16
 - AllowSorting in datagrid Hi, when I set AllowSorting to true in datagrid, when user sorted a column, does this raise an event? if yes, how can I catch it? Thanks in advance. Tag: Dataset and typed datasets Tag: 94852
 - 17
 - Exceptions & Open Connections Hi, quick question.. If I have a try/catch block like this, which I use all the time Try conn.Open() somevar =3D CStr(cmd.ExecuteScalar()) Catch ex As Exception Throw Finally conn.Close() End Try I throw the exception again because this is within my own object, and I = am handling the exception on the presentation level (where it will be = shown to the user). My question is, will the Finally block still be = called?, or should I put a conn.Close before I throw the exception again = to ensure that it will be closed. This is an asp.net application if it = matters. Thanks, --Michael Tag: Dataset and typed datasets Tag: 94850
 - 18
 - Informix Connection Anyone out there connect to Informix using the IBM .NET data provider? None of the connection strings that I've tried work and I just need an example. Thanks. Todd Tag: Dataset and typed datasets Tag: 94849
 - 19
 - Best practice to update rows in other tables? Hi, I'm relatively new to ADO.NET, so here is my question: What is the best way to get the some data from various tables and write it to other table? Say, I want to show some info on the winform from the table1, table2 and table3. What's the simplest way to write these infos to the table "table4"? Thank you! Don Tag: Dataset and typed datasets Tag: 94848
 - 20
 - Creating a dataset from an Excel File I am having trouble with getting all data back in a dataset from the excel spread sheet. Each column is named, however I am finding if the first value under the named column is not populated the rest of the values are ignored within that column. I would like to know if this is a bug or a problem with my approach. The code that is generating the dataset is as follows: Dim ds As DataSet Dim myCommand As OleDbDataAdapter Dim myConnection As OleDbConnection myConnection = New OleDb.OleDbConnection( _ "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source=" & FileLocationTextBox.Text & _ "; Extended Properties=Excel 8.0;") Dim row As DataRow ' Select the data from header sheet of the workbook. myCommand = New OleDbDataAdapter( _ "select * from [" & "Sheet1" & "$]", myConnection) ds = New DataSet myCommand.Fill(ds) DataGrid1.DataSource = ds Tag: Dataset and typed datasets Tag: 94844
 - 21
 - oledb version problem in connection string vb.net I have a program where i connect to an access database and get some information out of it. I'm using the oledb.3.51 version, my computer doesn't seem to have the 4.0 version, but the computer that is trying to run it only have the 4.0 version. So as you will see with the code below, i first try to open the 4.0 version... if that doesn't work, do the 3.51 version. When i run the program from my computer... the 4.0 fails and it goes to the 3.51 and it works fine. On his computer NEITHER version works. Is there anyway to either include my oledb version in the program, OR get the version of oledb on the computer running that program.. and use that in the connection string? Thanks! Chris Thunell cthunell@pierceassociates.com Code (Please excuse the numerous rem out statements... i've been trying all kinds of combinations): Dim myprovider As String Dim myAccessConn As String 'myAccessConn = "Jet OLEDB:Registry Path=;User ID=Admin;Jet OLEDB:Database Password=;Provider='Microsoft.Jet.OLEDB.3.51';Persist Security Info=False;Jet OLEDB:System database=;Jet OLEDB:Global Partial Bulk Ops=2;Mode=Share Deny None;Extended Properties=';COUNTRY=0;CP=1252;LANGID=0x0409';Data Source='" 'myAccessConn = "Jet OLEDB:Registry Path=;User ID=Admin;Jet OLEDB:Database Password=;Provider='Microsoft.Jet.OLEDB.4.0';Persist Security Info=False;Jet OLEDB:System database=;Jet OLEDB:Global Partial Bulk Ops=2;Mode=Share Deny None;Extended Properties=';COUNTRY=0;CP=1252;LANGID=0x0409';Data Source='" myAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" myAccessConn = myAccessConn & Trim(lblFileLocation.Text) myAccessConn = myAccessConn & "'" Me.OleDbConnection1.ConnectionString = myAccessConn 'open the database Try Me.OleDbDataAdapter1.Fill(Me.DataSet11.BILL_OF_MATERIALS) Catch ex As Exception MessageBox.Show("4.0 didn't work - Trying 3.51") myAccessConn = "" 'myAccessConn = "Jet OLEDB:Registry Path=;User ID=Admin;Jet OLEDB:Database Password=;Provider='Microsoft.Jet.OLEDB.3.51';Persist Security Info=False;Jet OLEDB:System database=;Jet OLEDB:Global Partial Bulk Ops=2;Mode=Share Deny None;Extended Properties=';COUNTRY=0;CP=1252;LANGID=0x0409';Data Source='" myAccessConn = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source='" myAccessConn = myAccessConn & Trim(lblFileLocation.Text) myAccessConn = myAccessConn & "'" Me.OleDbConnection1.ConnectionString = myAccessConn Me.OleDbDataAdapter1.Fill(Me.DataSet11.BILL_OF_MATERIALS) End Try Tag: Dataset and typed datasets Tag: 94843
 - 22
 - Best practice for inserting new DataRows with lots of 'not null'-columns Hi again, I'm pretty new to Winforms & DataBinding and I'm currently running into a lot of issues. Sorry if this has been explained before. I have a DataSet containing a table 'Member' that holds a lot of columns with info about members. Most of these columns are declared to be 'not null' in the DB. My WinForm for displaying members consists of a Listbox showing basic info (full name) of a member, and a Textbox for each column showing the details of the currently selected member. Ok, pretty much standard. I'd like to have a button 'insert new member'. When it is pressed I'd like to have a new (empty) entry in my Listbox and the detail-Textboxes blanked out. I tried it the way as it's propagated in many tutorials and books I found: * use the NewRow()-method of the Member-table * add it to the Member-table But when I try to add it all the 'NoNullAllowedException's are fired - ok that's what they are there for ;-) I'm looking for a best practice for this one - since it is so standard there must be someone with a good solution. I'd like to avoid creating a seperate 'create new member dialog' that duplicates all the fields on the other form, so i cann collect data before adding the new row... Any suggestions greatly appreciated, Lorenz Tag: Dataset and typed datasets Tag: 94837
 - 23
 - Update db with multiple dataset changes Datasets are great because you can manipulate the table data they contain in a disconnected state, right? Then simply call the Update method on the adapter that created the contained table to write changes back. But the controls I use to effect these data manipulations launch repeated postbacks. I'm saving the dataset in ViewState and reloading on PostBack, but the original DataAdapter is long gone by the time I'm ready to write the multiple changes back. What am I missing here? Sure, I can get around this by immediately writing each change back to the db and refilling the dataset on postback, but that kind of kills the spirit of the disconnected dataset. Tag: Dataset and typed datasets Tag: 94833
 - 24
 - Issue binding a DateTimePicker to a DataView Hi, when I'm trying to bind a DateTimePicker to a DataView I receive a System.Exception when the form loads. I don't get an error when binding it to a DataSet.Table that is representing exactly the same data. The error-message is in German saying: "DataBinding konnte keine Zeile in der Liste finden, die für alle Bindungen verwendet werden kann." I'll try to translate that: "DataBinding wasn't able to find a row in the list, which could be used for all bindungs." Any ideas? Thanks and regards, Lorenz Tag: Dataset and typed datasets Tag: 94829
 - 25
 - dso-support in .net-2.0 hallo, can anybody answer me following questions. 1. what is the name of the namespace which supports dso in the new beta-framework 2. is the data-access native .net or is it through the com-module 3. are classes available in framework 2.0 (beta) or do i have to install yukon thanx you a lot, Robin Saberi Tag: Dataset and typed datasets Tag: 94828
- Next
 - 1
 - IDataParameter (OUTPUT) not working without size! Hi there, (re-post since I never got any reply some weeks ago) IDataParameter does not have a size property (for string/varchar parameters), and without setting it it will not return a value! If I use SqlParameter (by temporarily casting the idataparameter to a sqlparameter) and set the size, all works well. My code is like so (sketch): IDbConnection [...] // create a sql connection, sql server for example IDbCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "aStoredProcedureName"; IDataParameter para = cmd.CreateParameter(); para.ParameterName = "@someOutParameter"; // (para as SqlParameter).Size = 20; // <--- works if included para.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery; Console.Write( Convert.ToString( para.Value ); Now, this actually exists in a certain layer so this code does not convey the design, obviously. What is the solution to this? The IData/Db interfaces have worked fine so far as an abstraction layer, it does not seem logical that this would be unworkable. Help greatly appreciated!! /mawi Tag: Dataset and typed datasets Tag: 94827
 - 2
 - xsd.exe Typed DataSet generation Hello, I am loading a DataSet from an xml file and binding it to a hierarchical datagrid. I am trying to write some keys between the elements in my xml file into the xsd file. When I write the keys as elements it works and I get the public QuestionRow FindByorder(short order) { return ((MenuTitlesRow)(this.Rows.Find(new object[] {order}))); } however when I change these to attributes I loose my this method when running xsd.exe test.xsd /d I need my xml to be structured with attributes, is there anyway I can do this without have to transform the final output. There is curiously very little literature available on the web about this and what is very basic. Here is my xsd file.... <?xml version="1.0" standalone="yes"?> <xs:schema id="Test" targetNamespace="http://tempuri.org/test.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/test.xsd" xmlns:mstns="http://tempuri.org/test.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Test" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Question"> <xs:complexType> <xs:sequence> <xs:element name="Option" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:attribute name="parent" type="xs:short" /> <xs:attribute name="suborder" type="xs:short" /> <xs:attribute name="Text" type="xs:string" /> <xs:attribute name="Selected" type="xs:string" /> <xs:attribute name="Tooltip" type="xs:string" /> <xs:attribute name="Answer" type="xs:string" /> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="id" type="xs:short" use="required" /> <xs:attribute name="Text" type="xs:string" use="required" /> <xs:attribute name="Type" type="xs:string" use="required" /> <xs:attribute name="Score" type="xs:string" use="required" /> <xs:attribute name="Mandatory" type="xs:string" use="required" /> <xs:attribute name="Tooltip" type="xs:string" use="required" /> <xs:attribute name="MultiSelect" type="xs:string" use="optional" /> <xs:attribute name="AllowNoSelection" type="xs:string" use="optional" /> <xs:attribute name="Multiline" type="xs:string" use="optional"/> <xs:attribute name="MaxLength" type="xs:string" use="optional" /> <xs:attribute name="MinLength" type="xs:string" use="optional" /> <xs:attribute name="InitialValue" type="xs:string" use="optional" /> <xs:attribute name="Validation" type="xs:string" use="optional" /> <xs:attribute name="Answer" type="xs:string" use="optional" /> </xs:complexType> <xs:key name="QuestionKey2" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Question" /> <xs:field xpath="mstns:id" /> </xs:key> <xs:keyref name="QuestionOption" refer="QuestionKey2" msdata:AcceptRejectRule="Cascade" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade"> <xs:selector xpath=".//mstns:Option" /> <xs:field xpath="mstns:parent" /> </xs:keyref> <xs:key name="QuestionKey1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Option" /> <xs:field xpath="mstns:parent" /> <xs:field xpath="mstns:suborder" /> </xs:key> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> I am trying to the following in the Update_click method of the datagrid.... Test dst = (Test)Session("Test"); short order = Convert.ToInt16(HierarGrid1.DataKeys[e.Item.ItemIndex]); Test.QuestionRow row = (Test.QuestionRow)dst.Question.FindByorder(order); also it appears DataKeys are empty... Thanks for any light shed on this area, Matt Tag: Dataset and typed datasets Tag: 94826
 - 3
 - Pool connections Hi, From time to time, I get an error message : "... all pooled connections were in use and ... " and I want to check how many connections are opened by my .NET application. How can I do this ? There is a tool in Sql Server ? My Ms Sql Server 2000 is on a remote computer (with Small Business Server 2000). Thanks for any advice or link Tag: Dataset and typed datasets Tag: 94822
 - 4
 - strange problem with access query and parameter ... hi, here is my code : szQry = "SELECT SubCategory_ID , " & _ " Loc1.Description as Descrizione " & _ " FROM C_SubCategories " & _ " LEFT OUTER JOIN D_Localizations Loc1 " & _ " ON ( C_SubCategories.Description_ID = Loc1.Localization_ID AND Loc1.Language_ID = @LanguageID ) " & _ " WHERE Category_ID = @CategoryID " & _ " AND StateActive = 1 " & _ " ORDER BY SubCatOrder " now i set the szqry to the command and i set the parameter .... if set first the @languageID paramater and then the @CategoryID then command returns always 0 record. but if i change the order and put first the @CategoryID and the @languageID all work great !!!! Why ? Does Access convert my query ? It's a problem of the outer join ???? very strange ....... any suggestion? tnx in advance andrew acc Tag: Dataset and typed datasets Tag: 94821
 - 5
 - Finding the Number of a New Row If I have a table ("tbl") in a dataset ("ds") with these three fields: pk - autoincrement, seed = -1, step = -1 fld0 fld1 and I add a new row, how can I find its row number for the default view? Here's some sample code: --------------- dim dr as datarow dim lngIndex as long dr = ds.tables("tbl").newrow dr("fld0") = 100 dr("fld1") = "Hello World" ds.tables("tbl").rows.add(dr) lngIndex = getNumberOfTheRowIJustAdded --------------- What do I replace "getNumberOfTheRowIJustAdded" with in order to get the new row number if I want it for a default view? Unfortunately, the find method returns the row itself, rather than its number. Since I can't see any way to determine the row number from that, it doesn't solve my problem. The only solution I see is to iterate through the data until I have a match. Also, am I correct in assuming that the number of the newly added row is the same as ds.tables("tbl").rows.count - 1 if I am not using a view? Thanks for any help. -- Greg ---- greg -at- spencersoft -dot- com Tag: Dataset and typed datasets Tag: 94817
 - 6
 - adding a new datarow to a datalist at runtime? Hi There, I am still resonably new to asp .net and I have a datalist which I am using to display search results, one of the columns has a status in it and in this particular case I am wanting to display an image on top of each row that returns a status of sold (reuturned from stored procedure,hidden from display). I had a play around with the function below and when I removed that tables from the datalist it seemed to be applying the changes correclty, I am just unsure about how I can add a new row dynamically bacsed on a literal value. Could someone help me out with somecode so I can get this working if possible? Joey !--- item template display <ItemTemplate> <tr bgcolor="d9d9d9" class="tabletext"> <td align="center" width="100"><%# DataBinder.Eval(Container.DataItem, "ListingID") %></td> <td align="center" width="60"><%# DataBinder.Eval(Container.DataItem, "Manufacturer") %></td> <td align="center" width="100"><%# DataBinder.Eval(Container.DataItem, "model") %></td> <td align="center" width="70"><%# DataBinder.Eval(Container.DataItem, "quantity") %></td> <td align="center" width="140"> <asp:HyperLink CssClass="tablelink" runat="server" Text="Specfications" NavigateUrl='<%# "ListingDetails.aspx?ListingID=" & DataBinder.Eval(Container.DataItem, "listingID")%>' /></td> </tr> </ItemTemplate> !-- event handler Public Sub ItemDataBoundEventHandler(ByVal sender As Object, ByVal e As DataListItemEventArgs) If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then Dim drv As DataRowView = CType(e.Item.DataItem, DataRowView) Dim strStatus As String strStatus = CType(drv("status").Trim(), String) if strStatus = "Sold" Then e.Item.CssClass = "tabletext" e.Item.Font.Bold = True e.Item.BackColor = System.Drawing.Color.Aquamarine End If End If End Sub Tag: Dataset and typed datasets Tag: 94815
 - 7
 - Unexplained VersionNotFoundException I've run into a problem that has me pretty confused. I'm getting a VersionNotFoundException when trying to change the RowFilter property of a DataView. This happened in a large system that I'm working on, but I've been able to duplicate the behavior in a relatively small (80 lines) program, which I've included below (assuming it doesn't get munged by the upload software). There is some discussion of similar problems in previous posts here, but I didn't see a small reproducible case or any kind of resolution to the problem. Short explanation of program: I have a DataSet with two tables: Legislators and Authors. The Legislators table contains a list of all Legislators who can potentially be an author or coauthor on a bill. The Authors table contains a record for each Legislator who has signed onto the bill as an author or coauthor (the Authors table will contain information for one bill at a time). The DataSet enforces a relation: the LegislatorCode value in an Authors record must match a LegislatorCode that's in the Legislators table. I use a DataView to maintain a view of the Legislators table showing only those legislators who have not signed onto the bill. This all works on the initial load, as shown in the program below. However, if I then add an Authors record, the DataView isn't updated to reflect the change. That is, even though there now is an Authors record for a legislator, that legislator still shows up in the DataView. So, figuring I had to trigger a refresh of the DataView, I set RowFilter to string.Empty, and then set it back to what it was. I then get an exception "System.Data.VersionNotFoundException: There is no Original data to access." I have two questions: 1) Why doesn't the DataView update when I enter the new Authors record? 2) Why do I get this exception? Any help, especially a workaround or somebody pointing out where I'm doing something wrong, would be appreciated. Program follows. Jim -------------- .using System; .using System.Data; .namespace dvTest .{ . class Class1 . { . [STAThread] . static void Main(string[] args) . { . DataSet myds = new DataSet(); . // Create the tables . DataTable tblLegislators = new DataTable("Legislators"); . tblLegislators.Columns.Add("LegislatorCode"); . tblLegislators.Columns.Add("DisplayName"); . DataTable tblAuthors = new DataTable("Authors"); . tblAuthors.Columns.Add("BillNumber"); . tblAuthors.Columns.Add("LegislatorCode"); . // AuthorType: P = Primary author, C = Coauthor . tblAuthors.Columns.Add("AuthorType"); . // Add tables to dataset . myds.Tables.Add(tblLegislators); . myds.Tables.Add(tblAuthors); . // Add a relationship. . myds.Relations.Add(tblLegislators.Columns["LegislatorCode"], . tblAuthors.Columns["LegislatorCode"]); . // populate the legislators table . tblLegislators.Rows.Add(new object[] {"A0123", "Smith (A0123)"}); . tblLegislators.Rows.Add(new object[] {"A1234", "Jones (A1234)"}); . tblLegislators.Rows.Add(new object[] {"A5038", "Jackson (A5038)"}); . tblLegislators.Rows.Add(new object[] {"A0191", "Morton (A0191)"}); . // Populate the Authors table. . // LegislatorCode must be present in Legislators table . tblAuthors.Rows.Add(new object[] {"001", "A0123", "P"}); . tblAuthors.Rows.Add(new object[] {"001", "A5038", "C"}); . // Accept changes on the dataset. . myds.AcceptChanges(); . // dvLegislators is a dataview that contains legislators . // that do not have a record in tblAuthors. . DataView dvLegislators = new DataView( . tblLegislators, . "Count(Child.LegislatorCode)=0", . "DisplayName", . DataViewRowState.CurrentRows); . // Show contents . ShowLegislators(dvLegislators); . // Add another coauthor . Console.WriteLine("Add Legislator 0191 as a coauthor"); . tblAuthors.Rows.Add(new object[] {"001", "A0191", "C"}); . // Show contents -- why is 0191 still in this DataView? . ShowLegislators(dvLegislators); . // Re-filter the DataView . dvLegislators.RowFilter = ""; . try . { . // Why does this throw an exception? . dvLegislators.RowFilter = "Count(Child.LegislatorCode)=0"; . } . catch (Exception ex) . { . Console.WriteLine(ex); . } . . Console.WriteLine("Press Enter"); . Console.ReadLine(); . } . static void ShowLegislators(DataView dvLegislators) . { . // Display contents of dvLegislators . Console.WriteLine("dvLegislators contains:"); . foreach (DataRowView drv in dvLegislators) . { . Console.WriteLine(drv["DisplayName"].ToString()); . } . Console.WriteLine(); . } . } .} Tag: Dataset and typed datasets Tag: 94811
 - 8
 - Problem reading data from Access 2000 I cereated a database with only one table (person) in Access 2000 and created and ODBC system DNS (PersonDB). I have following code in my ASP.Net string ConStr = "DSN=PersonDB"; string ComStr = "Select Name from Person"; OdbcDataAdapter dataAdapter = new OdbcDataAdapter(ComStr, ConStr); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet, "Person"); I am using the same machine as server and client. I ran this after restarting the machine so I know DB is not used. I get the followin error on the last line above. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. 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. I have given read access to ths mdb to IUSR_ account. Thanks Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. Tag: Dataset and typed datasets Tag: 94807
 - 9
 - Re: Performance issue with ODP.NET and FillSchema This issue has been solved in ODP Version 9.2.0.4.05. Oracle has changed query performed when trying get metadata information from Oracle Server. Thanks. Tag: Dataset and typed datasets Tag: 94804
 - 10
 - Connecting to MySQL dbase Hi I am in the process of porting a MySQL dbase over to Microsoft SQL2000 and am building a .NET app that will interface with the SQL2000 dbase. Anyhow some of the tables are quite large and thinking it may be easiest just to connect to MySQL read each table into a dataset and then write it to the SQL 2000 database. I already have the table structure in 2000 setup. Just wondering if there is any information how to do this, can one use the ODBC data adapter? Thanks. -- Paul G Software engineer. Tag: Dataset and typed datasets Tag: 94802
 - 11
 - OleDbDataReader and Oracle Using VS 2005 and C# and the OleDb components. The OleDbConnection works fine as does the OleDbCommand object with a simple select against an Oracle 9i DB. However when The code below is executed on the first row, I get an exception saying the number to be cast has to be less than infinity. I know for a fact its 2. The column is defined as a NUMBER(5) in Oracle. I've tried to 'Get' float, double, value. All with the same result. if (!q.IsDBNull(2)) short s = (short) q.GetInt16(2); - Arnie Tag: Dataset and typed datasets Tag: 94799
 - 12
 - Use datagrid to update dataset w/ multiple tables The Northwind database serves to illustrate my question. I want to display order details in a WebForms datagrid and provide user the ability to delete items and/or change the quantity of particular items. I'd like the user to be able to make all her changes, then click Submit to save them. Seems reasonable for grid to display ProductName from Products and Quantity and UnitPrice from [Order Details] (keep it simple). It's easy to populate a dataset from a SQL join query and bind, but then I can't update because the dataset is read-only. So I've tried putting [Order Details] and Products tables in the dataset w/ a DataRelation built on ProductID. But when I bind the datagrid, I get "A field or property with the name 'ProductName' was not found on the selected datasource." So, how do I make the Bind process look for fields in all tables (what if there are like-named fields in two tables!). Is this even the correct approach for making multiple changes to a table in a dataset, then writing all changes back to the database? Thank you. Steve stevet@liferaft.org Tag: Dataset and typed datasets Tag: 94798
 - 13
 - Where's my Oracle namespace? Using VS 2005 Beta1, C#. If I type: using system.data. There's no Oracle namespace in the completion list. Does it come with VS or does it have to be installed with the Oracle client (using 10G)? Thanks - Arnie Tag: Dataset and typed datasets Tag: 94797
 - 14
 - Check SQL syntax Hello, I don't know if it is the right place for my question but I would like to know if ther's a way to validate a SQL request before sending it to the database. I was thinking abut using Regular Expresssion or something like that . Thanks for your answer. Tag: Dataset and typed datasets Tag: 94795
 - 15
 - Calling a class in VB I have developed several ASP.NET programs (with VB backend) recently and have called VB classes from my ASP pages in VS.NET. Now I have my first actual VB.NET app and I can't seem to get that to work. I have created a class called OnCallDB/DBAccess/DBAccess, referenced it just like I do in my ASP apps and changed my code in the calling form to look as follows: ---------------------------------------------------------------------------- - Imports OnCallDB Public Class Form1 Inherits System.Windows.Forms.Form [Windows Form Designer Generated Code] Public oDBAccess As OnCallDB.DBAccess Private Sub Form1_Load(.... Dim ds As DataSet = oDBAccess.GetRecs("Select * from people") Grid1.Datasource = ds.Tables(0) Grid1.Refresh() End Sub End Class ---------------------------------------------------------------------------- - The debugger stops on the "Dim ds As DataSet = oDBAccess..." line without even trying to run it with the error message: "An unhandled excpetion of type 'System.NullReferenceException' occurred in OnCall.exe. ...Object reference not set to an instance of an object". It appears that the debugger is not even getting to the data access code. Normally I would interpret this to mean my ds object is not instantiated properly, but if I replace that line with the following the code runs fine (I also reference the MS Data Access App Block of course) : ---------------------------------------------------------------------------- - Dim ds As DataSet = sqlHelper.ExecuteDataset(strConnect, CommandType.Text, "select * from people") ---------------------------------------------------------------------------- - The GetRecs Procedure in the oDBAccess class is Public and returns a DataSet. Actually the code in the class was copied from a class I am using in an ASP.NET project so I know the code in the class has been proven (it's pretty simple anyway). My question is: "Why is this not instantiating my object? What do I have to do to get the declaration to recognize the data being returned from the class as a dataset so it can assign it to the 'ds' variable?" Scott Tag: Dataset and typed datasets Tag: 94789
 - 16
 - Distinct rows from a dataset? Can I select DISTINCT rows by using Dataset.DefaultView.RowFilter = "Distinct Col1, Col2" Tag: Dataset and typed datasets Tag: 94787
 - 17
 - SQL syntax help I'm programmatically adding a column to a table in an existing Access DB. I'm having a problem with table and field names that are strings composed of more than one word. This command works just fine: "ALTER TABLE Test ADD COLUMN ID varbinary" but this doesn't work and gives an Alter Table syntax failure: "ALTER TABLE 'Test Step' ADD COLUMN 'ID Type' varbinary" It seems that it doesn't like the quote marks. Any suggestions? Thanks Brad Tag: Dataset and typed datasets Tag: 94776
 - 18
 - OleDbTypes (Decimal vs Double) and Oracle binding parameters. Hi all, I'm using ADO.NET's OleDB provider to execute a procedure in Oracle (I also use SQLServer and therefore prefer OleDB). The problem is that not all parameters get bound, some are hardcoded in the execution call. Those that don't get bound are of type OleDbType.Decimal (and Numeric). If I change it to OleDbType.Double then it gets bound correctly but the type System.Double isn't working in the same way as System.Decimal (and we use Decimal everywhere). The reason why we need the make this work is because all of the sudden Oracle blew up because it had filled the "v$sqlarea" which is used to store preparsed statements (we were calling the procedure very often). So we have one line for each procedure call in the v$sqlarea like this: begin :V00001 := spmy_proc (:V00002,:V00003,1414.45); end; So the question is, how can this be fixed and isn't this a bug in OleDB? Thanks, Atli Tag: Dataset and typed datasets Tag: 94774
 - 19
 - Array of SQLParameter (Type your message here) Code taken from MSDN: public void CreateMySqlCommand(SqlConnection myConnection, string mySelectQuery, SqlParameter[] myParamArray) { SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection); myCommand.CommandText = "SELECT CustomerID, CompanyName FROM Customers WHERE Country = @Country AND City = @City"; myCommand.Parameters.Add(myParamArray); for (int j=0; j<myParamArray.Length; j++) { myCommand.Parameters.Add(myParamArray[j]) ; } string myMessage = ""; for (int i = 0; i < myCommand.Parameters.Count; i++) { myMessage += myCommand.Parameters[i].ToString() + "\n"; } MessageBox.Show(myMessage); } In this query "SELECT CustomerID, CompanyName FROM Customers WHERE Country = @Country AND City = @City"; how do we know which parameter of the parameter array is passed to the query. For Eg: what would be the value of @Country as we are not using any indexer. Thanks in adavnce, Jaya. -------------------------------- From: kagitas jaya -------------------------------- From: kagitas jaya ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>H80DX++ssk++oiFXDhfx2w==</Id> Tag: Dataset and typed datasets Tag: 94772
 - 20
 - Is it possible to pass a DataSet TableName as a parameter? Is it possible to pass a DataSet TableName as a parameter? For instance say I have the following code which I would like to repeat for table1 --> table9. : For i = 0 To DS.table1.Rows.Count - 1 Response.Write(" " & DS.table1.ToString & " Row " & i.ToString & "") Response.Write(" ID: " & DS.table1(i).ID) Response.Write(" Beg: " & DS.table1(i).BEG) Response.Write(" End: " & DS.table1(i).END) Response.Write(" Top: " & DS.table1(i).TOP) Response.Write(" Bot: " & DS.table1(i).BOT) Next Thanks, Grey Tag: Dataset and typed datasets Tag: 94767
 - 21
 - Reading Tab Delimited Data With Imbedded Double Quotes I can't get the Microsoft Jet OLEDB 4.0 driver to read a tab delimited text file that has double quotes imbedded in the data. For example Field1 | Field2 | Field3 Bob | Pant Size 34" Waist | 22 (I'm using a vertical bar here for the tab) Field2 will contain: Pant Size 34 Field3 will contain: Waist I have a schema.ini [MyFile.txt] ColNameHeader=True Format=TabDelimited MaxScanRows=25 CharacterSet=OEM How do I get it to read the double quote? Tom Tag: Dataset and typed datasets Tag: 94764
 - 22
 - Re: Performance Testing... Hi, I vaguely remember something called the Web Application Stress Tool ? I think it was a free MS download, and did similar stuff to ACT... Aaron Tag: Dataset and typed datasets Tag: 94760
 - 23
 - Large schema returned from web service when using strongly typed dataset I have created a web service to return a dataset that is strongly typed, how due to the number of functions available in the service the schema created is quite large 40k, is there any way of passing back schema information for the particular function I am calling. Tag: Dataset and typed datasets Tag: 94756
 - 24
 - Problem graphically binding to an externally referenced DataSet in Hi, unfortunately I couldn't make up a subject, that describes the problem better. Here's what I tried to do: I'm writing a WinForms application that consists of three layers (assemblies / projects), the WinForms-UI / the business logic layer (BLL) / the data access layer (DAL). The DAL defines a typed DataSet 'MemberDataSet'. It also has a class 'MemberDALC' with a method 'GetAllMembers()' which returns a properly filled instance of the MemberDataSet. Next I would like to use the VS.NET designer surface to bind my controls to this DataSet graphically(!). So I pulled a DataSet-component on the surface and chose the externally referenced DataSet definition DAL.MemberDataSet. Then I can bind everything as usual. So far everything works just fine. NOW THE PROBLEM: The generated code of the designer instantiates a new (empty) instance of the DataSet using the default constructor like this: InitializeComponent() { this.memberDataSet1 = new DAL.MemberDataSet(); ... } Well, that's fine - but as I said it's empty. I would like to have a filled DataSet, when the form loads. So I did this: private void FrmTest_Load(object sender, System.EventArgs e) { this.memberDataSet1 = (new MemberDALC()).GetAllMembers(); ... } This shows no effect and all bound controls will still be shown empty, although the memberDataSet1 actually holds the data after this function call. I guess my problem is that I'm lacking real experience with WinForms-Databinding and I really just have to call an additional 'refresh', 'update' or 'redraw'-function. But I couldn't find anything. I found two workarounds though. One is to replace the generated code in the InitializeComponent-method to call the GetAllMembers method directly instead of the DataSet-constructor. But I don't like messing with auto-generated code plus VS.NET gives me several warnings afterwards. The second way I figured out is to call Merge() on the empty DataSet like so: private void FrmTest_Load(object sender, System.EventArgs e) { this.memberDataSet1.Merge((new MemberDALC()).GetAllMembers()); } That works but looks kind of awkward to me. Any other suggestions will be greatly appreciated. Sorry for this long post ;-) Best regards, Lorenz Tag: Dataset and typed datasets Tag: 94754
 - 25
 - Performance Testing... Hi, I am developing C#.net Web application. It is all most completed. Now I want to test of my web site with multi-user like 100 users. I have problem that I have only 13 computers, so how can I create 100 user environments. Any one have idea how testing this application. And how another people load test of there web site. I want to create just create 100 user environments.... Any tools are available on net??? Any site help full for this load testing?? Any have document copy for testing, I want to see how make document of it. Please help me. Samir. (Software Developer, Ahmedabad, INDIA.) Tag: Dataset and typed datasets Tag: 94749

Hi,

is there a way to cast a normal dataset to a typed dataset?
I tried using the directcast but that didn't seem to work.

Thx

Top

Re: Dataset and typed datasets by Cor

Cor
Mon Sep 06 04:10:11 CDT 2004

Bart,

>
> is there a way to cast a normal dataset to a typed dataset?
> I tried using the directcast but that didn't seem to work.
>

This makes me curious, why would you do that. Normally you should just use
the typed dataset. I see not any reason to do that, so it really makes me
curious why.

Cor

Top

Re: Dataset and typed datasets by Bart

Bart
Mon Sep 06 04:23:03 CDT 2004

I have several tables that have the same layout.
I wrote a function that gets me a dataset from the database.
This function returns a simple dataset.
And now in order to have the advantages of the typed dataset I would like to
cast the dataset returned from my database to a typed dataset.

"Cor Ligthert" <notfirstname@planet.nl> wrote in message
news:O81ILF$kEHA.2340@TK2MSFTNGP11.phx.gbl...
> Bart,
>
> >
> > is there a way to cast a normal dataset to a typed dataset?
> > I tried using the directcast but that didn't seem to work.
> >
>
> This makes me curious, why would you do that. Normally you should just use
> the typed dataset. I see not any reason to do that, so it really makes me
> curious why.
>
> Cor
>
>

Top

Re: Dataset and typed datasets by Miha

Miha
Mon Sep 06 04:24:07 CDT 2004

Hi Bart,

No, you can't as typed dataset is derived from dataset.
And you can't cast upwards.
Instead, you might consider doing a Merge into typed dataset.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Bart Schelkens" <BSchelkens@hotmail.com> wrote in message
news:eWrfUK$kEHA.1904@TK2MSFTNGP09.phx.gbl...
>I have several tables that have the same layout.
> I wrote a function that gets me a dataset from the database.
> This function returns a simple dataset.
> And now in order to have the advantages of the typed dataset I would like
> to
> cast the dataset returned from my database to a typed dataset.
>
>
> "Cor Ligthert" <notfirstname@planet.nl> wrote in message
> news:O81ILF$kEHA.2340@TK2MSFTNGP11.phx.gbl...
>> Bart,
>>
>> >
>> > is there a way to cast a normal dataset to a typed dataset?
>> > I tried using the directcast but that didn't seem to work.
>> >
>>
>> This makes me curious, why would you do that. Normally you should just
>> use
>> the typed dataset. I see not any reason to do that, so it really makes me
>> curious why.
>>
>> Cor
>>
>>
>
>

Top