Strongly-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
    - Auto Increment in Datasets I have a dataset with a AutoIncrement column.. I write this to a XML file and read it back..to a Dataset.. The auto increment works perfectly every time. It picks up were it left...were does it pick up the last value from?.. I mean I thought it uses the max value + 1 logic for existing rows.. not until I saw this.. I had a dataset with 3 rows.. UnqColumn - 1 UnqColumn - 2 UnqColumn - 3 I removed the last row with ID 3.. and was left with 1 and 2. Now if I insert a row it should give 3 for the newly inserted row, but it gives me 4. This also happens even if I write to xml file after the delete and then reload xml back to a new dataset to insert the row. I can't see to find were the last value is stored in the XML file.. and how it keeps track of it.. Hey this is really good, works well. But I am curious to learn how this is done? Can somebody explain? BTW.. datasets are cool... I am totally in love with it.. endless possibilities.. no more painful TEMP tables... VJ Tag: Strongly-typed DataSets Tag: 72385
  - 2
    - problem connecting to SQL Server I am having a strange problem connecting to a SQL Server 2000 database from an ASP.NET application. The strange thing is that I can connect fine using ADODB in an old-fashioned ASP application, but I get the message "SQL Server does not exist or access denied" when I try to connect using the SqlConnection object in an ASP.NET C# application running on the same machine. The database is SQL Server 2000 running on Windows Server 2003, and the development machine is running Windows XP with VS.NET 2003, .NET Framework 1.1. The database server is named "mydbserver", and the developer machine is named "mywebserver". Here is the connection string from the old ASP application: Provider=SQLOLEDB;Server=mydbserver;Initial Catalog=Contacts;Trusted_Connection=Yes Here is the connection string from the new ASP.NET application: workstation id=mywebserver;packet size=4096;integrated security=SSPI;data source=mydbserver;persist security info=False;initial catalog=Contacts; I should also point out that I have no trouble connecting from the VS.NET environment itself, under the Data Connections subtree in the Server Explorer pane. The ASP.NET connection string above was generated automatically for me when I added a SqlConnection object in the designer, so you would think it would work. From this I would guess that there's some configuration that's wrong, but I've tried a number of things and numerous MSDN and google searches with no luck. I'm hoping someone here can help. Thanks, Greg Tag: Strongly-typed DataSets Tag: 72379
  - 3
    - Typed Dataset and Null Values I have found it very frustrating trying to work with typed datasets and null values. I'm starting to wonder if the typed dataset is more trouble than it is worth. The problem is partly solved by the 'NullValue' property of the typed dataset, but this only really works for reference types. For value types you always need to check if the field is null with IsFieldNameNull() before trying to reference the field. This makes databinding to a strong typed dataset impossible as far as I can tell. Surely I'm not the only one to encounter this problem. Could someone please explain the recommended 'Best Practices' for dealing with strong typed datasets and databinding. Thanks. Tag: Strongly-typed DataSets Tag: 72378
  - 4
    - Dataset HasChanges trouble I have window form with datadapter, typed dataset and textbox controls with text properties binding with dataset. Dataset does not reflect changing in controls typed by user and HasChanges method returns false. What is wrong? Thanks for help. Tag: Strongly-typed DataSets Tag: 72377
  - 5
    - I need some help with this code.... Hi, Can someone please look at this code and tell me why I get an exception error on the last line: For aa = 0 To ds.Tables(0).Columns.Count - 1 dbColumn = New SQLDMO.Column dbColumn.Name = "'" & ds.Tables(0).Columns(aa).Caption & "'" 'ds is the dataset dbColumn.Datatype = "VARCHAR(1000)" dbColumn.AllowNulls = False dbTable.Columns.Add(dbColumn) pgBar.Value += 1 'progressbar Next sqlServer.Databases.Item("sitelist").Tables.Add(dbTable) 'On this line I get an exception error. The database is created but the table won't. The exception error tells me only how the column definition should be, and as far as I know I have it right... thanks, Eric Tag: Strongly-typed DataSets Tag: 72376
  - 6
    - Quick data retrieval Using 'old' ado and VB6 I could use following two lines to quickly retrieve data from a MSSQL server into a fire hose cursor: Dim rst As ADODB.Recordset Set rst = cnn.Execute("{call a_stored_procedure}") Can I do something similarly in ADO.NET using VB.NET or C# to get results from a stored procedure into a data reader (using as little code as possible)? Paw Tag: Strongly-typed DataSets Tag: 72373
  - 7
    - Checking for changes to database Has anyone got code for checking if the database row being viewed has changed since it was delivered to the browser? ie before the UPDATE is run? I'd imagine it would work something like this: First page request (doing the select): ====================================== select row from table store row in session bind controls to row values (dataset or whatever) end Wait for user to do edit, and press submit. Page postback: ============== begin transaction select same row from database again compare with row held in session if they match, apply changes from user postback if they don't, inform user underlying data has changed, and request confirmation (showing 'befores' and 'afters') commit end Tag: Strongly-typed DataSets Tag: 72371
  - 8
    - Writing null values using WriteXML() I've got a dataset that contains fields of different types, including dates. I need to convert the dataset to a string and to do that i use WriteXML method. The only problem is that after the conversion all the null values are missing from the string. With string fields there is no problem cause I put "" in them but with dates it IS a problem. So how can a date field be saved when it contains null value? Tag: Strongly-typed DataSets Tag: 72369
  - 9
    - Error message I've got a VB.NET program that collects info from an Access database. I'm trying to use the following select command to select all the information from the "Families" table and store it in a dataset, plus join the Surname and FirstName fields to create a new field, FamilyName: selFamilies.CommandText = "SELECT Families.*, (Families.Surname + ', ' + Families.FirstName) AS FamilyName FROM Families ORDER BY Surname, FirstName" This has been working perfectly a number of times until recently, and now when I try to run the program, it stops on this line: adpFamilies.Fill(datSPARK, "Families") and gives me this error message: "An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: System.InvalidOperationException: Invalid attempt to NextResult when reader is closed. at System.Data.OleDb.OleDbDataReader.NextResult() at System.Data.Common.DbDataAdapter.FillNextResult(IDataReader dataReader) at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at SPARK.frmFamilyInfo.GetFamilies() in C:\Documents and Settings\Owner\My Documents\Visual Studio Projects\SPARK\Info Boxes\Family Information.vb:line 1511" I tried setting the CommandText properties in the form design with my original select query, then right-clicked the data adapter and went to Preview Data. When I fill the dataset with the selFamilies query, it returns the correct information. However, when I run the program without readjusting the query in code, I still encounter the error message. It is obviously gathering the correct data from the database; is it trying to do something else with the dataset? I would really appreciate any help anyone can give me. Thanks Carolyn Tag: Strongly-typed DataSets Tag: 72368
  - 10
    - damn messag"Timeout expired.The timeout period elapsed prior to completion of th When I'm Runung An insert Sql Stored procedure on SQL SERVER after some seconds this message is handled. I have tested this SP on Query Analyzer more and more,the execution time in Query Analyzer is about 45 seconds. But in my program , the progarm stop responding and then this exception thrown. the original message is: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." Tag: Strongly-typed DataSets Tag: 72361
  - 11
    - counting records Probably an easy question, but how do I count the number of records in a dataset when there are no bindings. I was using me.bindingcontext(dsName1).count, but it is always returning 1 when I know for a fact that the test data has three records. I am using dsName1.tables(0).newrow to add the new row; the user sets the information and then saves this row back to the dataset and then the data adapter is updated. What I want to do on form load is to return the number of records currently in the dataset. Thanks for the information. Brad Tag: Strongly-typed DataSets Tag: 72356
  - 12
    - Generel Questions Hello, I think I'm experienced at an average with .NET, but I'm going to plan a database application (Isolated application with low-level synchronisation capabilities between two clients; mainly for use on notebooks to collect time and operation data), which later should be shipped with the database engine, I'll use. Since the amount of data is not very extensive, I decided to go for the jet engine, to keep the deployment efforts and possible royalties as low as possible later on. I'm not that experienced with ADO.NET, so I played a little with the ADO.NET capabilities, and was impressed especially with the strong typed datasets. But I also noticed something which in my opinion could seem to be a weakness, since my application has to deal with null-values in the database a lot (which, in my case, will often appear in the front end, and have to be displayed with interstate checkboxes, empty textboxes or specially marked table cells). So my questions are: Would it make sense to create a general ValueType (something like the old vb-variant) and a correlating user control, which would be able to handle that variant (and therefore DBNulls) without additional case testing (If DBNull then blablabla else blablabla)? And: Is it the right decision to use the access-engine for my purposes? Any source from the net about that topic I'd really appreciate! Thanks for giving me your opinions! Klaus Tag: Strongly-typed DataSets Tag: 72354
  - 13
    - BeginEdit EndEdit slow when updating a large number of cells in temporary column I have a Windows Forms DataGrid bound to a DataView of a DataSet. I need to sort the rows in the DataGrid based off of a custom functions return value. To do this loop through all of the rows in the DataView and pass the required information from each row to my custom function and then I write the value returned by the function to an additional column which I added to the DataView. I can then and sort based off the the values in that column. The problem is that updating a whole column of cells in a DataView it is extremely slow (over 10,000 records). I noticed that if I call BeginEdit on each row before I change each of the cells it updates all of the values fairly quickly. The calculated values are displated in the DataGrid but when sorting it still uses the previous values (Because EndEdit was never called). The values I calcuate and add to this additional column do not need to be updated in the database, they are only used to sort the data for viewing purposes. Is there a faster or better way to do this? Is there a way to sort a column using the Proposed values before EndEdit is called? Is there some way to add a column to a DataView that can be freely written to without having the overhead of calling EndEdit? Thanks, Kurt Tag: Strongly-typed DataSets Tag: 72353
  - 14
    - DataView or foreach Hello, I would like to find DataRow from some table identified by IDENTITY column value: foreach (DataRow currentRow in DataTable1) { if (currentRow["identitycolumn"] == 100) { break; } --or-- new DataView(DataTable1, "identitycolumn = 100", null, ... What method is more efficient and how can one determine the efficiency of such different methods in other cases? Ondra. Tag: Strongly-typed DataSets Tag: 72339
  - 15
    - Converting from Sql server binary column to C++ int array I have tried to write a general procedure for reading a Sql server binary column into a C++ int array: void ReadDataTableIntArray( DataRow *prow, char *colname, int *iarr, int arrsize) { if ( !prow->IsNull( colname)) { SqlBinary *sb = dynamic_cast<SqlBinary *>(prow- >get_Item( colname)); // Generates exeption System::Byte b[] = sb->get_Value(); ConvertGCToIntArray( iarr, b, arrsize); } } How can this be done correctly? Tag: Strongly-typed DataSets Tag: 72336
  - 16
    - How to detect if a Sproc exists ? Hi, How can I detect if a stored procedure exists in my database with ado.net ? Stan Tag: Strongly-typed DataSets Tag: 72334
  - 17
    - Using DataSet from VB6 Hi I have an application in VB6 that works only locally but i would like to make it able to save, update and get records from a Database. The problem is that i want to use the .NET technology and realize a disconnected scenario. I Know how implement this type of application in .NET. I would like to know how to use a Dataset from VB6. The scenario is this: I download some record from a Database using a Web Service and then populate a DataSet that i want to read from VB6 Then, in the VB6 application , I use these records and change the values or create other records. I want so save these records in the Dataset and then, in a second moment, save all added and/or updated records to the Database using a WebService. The problem is how to store new value from the VB6 application to a .NET DataSet and then using this DataSet to consume the WebService. Thanks!! Tag: Strongly-typed DataSets Tag: 72325
  - 18
    - Mark DataTable dirty Hi; How can I mark a DataTable as dirty (has changes)? I need to do this because when I add a DataColumn to a DataTable, it does not set HasChanges() to true. thanks - dave Tag: Strongly-typed DataSets Tag: 72316
  - 19
    - how ASP.NET page gets user input from another ASP.NET page?? In ASP, if I have asppage.asp for GUI and aspprocess.asp for process requests from database. In asppage.asp code will be like: <form action="aspprocess.asp" method="POST"> GUI CODE </form> When the user clicks the submit button on asppage.asp, it will invoke aspprocess.asp page aspprocess.asp code can get the user input from asppage.asp by doing: Request.Form("Control_ID") In ASP.NET, if I want to achieve the same goal: if I have aspxpage.aspx for GUI and aspxprocess.aspx for process requests from database In aspxpage.aspx code will be like: <form id="Form1" method="post" action="aspxprocess.aspx" runat="server"> GUI CODE </form> However, when the user clicks the submit button on aspxpage.aspx, it didn't invoke aspxpage.aspx page at all, unless I do the the following: Private Sub Submit1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.ServerClick Response.Redirect("aspxprocess.aspx") End Sub But even now I am in aspxprocess.aspx page, how can I get the user input from aspxpage.aspx?? Request.Form("Control_ID") no longer works. Please advise! Thanks! Tag: Strongly-typed DataSets Tag: 72313
  - 20
    - Attn Miha Markic thanks for your help CobraDabs Tag: Strongly-typed DataSets Tag: 72309
  - 21
    - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. only from a remote computer ! Hi, I've a simple web page on a SERVERA which access an SQL Server on a SERVERB. the authenticatyion mode is Windows and the anonymous logon is disable. I received the Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. error from a remote computer, but locally on the server, there is no errors !!! my webpage works fine I've tried the clear text authentication mode, but the result is the same. what is the problem ??? I've created a second ASPX page where I just display the user name of the active user, and I can see my login name correctly. My web server is Windows 2003 and my SQL Server is a Win 2000 server. thanks for your help !!! Jerome. Tag: Strongly-typed DataSets Tag: 72307
  - 22
    - insert xml data into sql server? i need to insert data from an xml file into sql server table. the xml file contains only one record. how to insert the data? how to map the names of the fields in the xml file and the table? thank you in advance. Tag: Strongly-typed DataSets Tag: 72306
  - 23
    - Add Columns to a datagrid from a 2nd datatable (unbound) I have 2 data sources (1 - DB, 2 - unbound table). I want to be able to display all of the columns in a datagrid on a form. I can't seem to make the unbound table show up when I run the program. The data table for the 2nd unbound table starts with nothing in it but has 5 columns defined. I would like to see all of the columns from the DB and unbound table when the form loads instead I just get the DB column names and data from the DB. My data sources seem to be working correctly but I'm not able to get the DataGrid to work correctly. I use a button on the form to start/stop the async. data source and it does work, but I can't get the data to show up in the DataGrid. I have tried MissingMappingAction, MissingSchemaAction and doing a merge with the 2nd datatable. I decided to recode it and use an add but that isn't working either? What should I be doing to make to get the results I need. c# code for this.... da = new OleDbDataAdapter(strSQL, oCon); ds = new DataSet(); oCon.Open(); dt = new DataTable("unbound"); dc = new DataColumn(); // Last dc.AutoIncrement = false; dc.Caption = "Last"; dc.ReadOnly = false; dc.Unique = false; dt.Columns.Add("Last", typeof(Double)); // Bid dc = new DataColumn(); dc.AutoIncrement = false; dc.Caption = "Bid"; dc.ReadOnly = false; dc.Unique = false; dt.Columns.Add("Bid", typeof(Double)); // Ask dc = new DataColumn(); dc.AutoIncrement = false; dc.Caption = "Ask"; dc.ReadOnly = false; dc.Unique = false; dt.Columns.Add("Ask", typeof(Double)); // Volume dc = new DataColumn(); dc.AutoIncrement = false; dc.Caption = "Volume"; dc.ReadOnly = false; dc.Unique = false; dt.Columns.Add("Volume", typeof(Int32)); // Momentum dc = new DataColumn(); dc.AutoIncrement = false; dc.Caption = "Momentum"; dc.ReadOnly = false; dc.Unique = false; dt.Columns.Add("Momentum", typeof(Int32)); ds.Tables.Add(dt); //da.MissingMappingAction = MissingMappingAction.Ignore; //da.MissingSchemaAction = MissingSchemaAction.Ignore; numrows = da.Fill(ds); //ds.Merge(dt,false,System.Data.MissingSchemaAction.Add); Thanks.... Al Tag: Strongly-typed DataSets Tag: 72302
  - 24
    - SQL server database This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C3B07E.0840D3E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can I create a SQL server database in my VB.NET program? I've MSSQLServer installed and running. If a database is created, where is it stored? I used the following code, didn't get any errors, but cannot find a new = file: Dim con As SqlConnection =3D New = SqlConnection("server=3D(local);Integrated = Security=3DSSPI;database=3DSiteList") Dim cmdLijst As SqlDataAdapter =3D New SqlDataAdapter("CREATE DATABASE = ", con) 'here some code to create the table? 'here some code to put the info from a dataset into the sql = database? con.close Is with this code the database created? thanks Eric ------=_NextPart_000_000A_01C3B07E.0840D3E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>How can I create a SQL server database = in my VB.NET=20 program?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I've MSSQLServer installed and=20 running.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>If a database is created, where is it=20 stored?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I used the following code, didn't get = any errors,=20 but cannot find a new file:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Dim con As SqlConnection =3D New=20 SqlConnection("server=3D(local);Integrated=20 Security=3DSSPI;database=3DSiteList")</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Dim cmdLijst As SqlDataAdapter =3D New=20 SqlDataAdapter("CREATE DATABASE ", con)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    'here some code to = create the=20 table?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    'here some code to = put the info=20 from a dataset into the sql database?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>con.close</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Is with this code the database=20 created?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Eric</FONT></DIV></BODY></HTML> ------=_NextPart_000_000A_01C3B07E.0840D3E0-- Tag: Strongly-typed DataSets Tag: 72297
  - 25
    - Retrieving table column This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C3B031.CBF91290 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How do I retrieve a list of column names in a table using the = OleDbDataAdapter? Ian ------=_NextPart_000_000E_01C3B031.CBF91290 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>How do I retrieve a list of column = names in a table=20 using the </FONT><FONT face=3DArial = size=3D2>OleDbDataAdapter?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Ian</FONT></DIV></BODY></HTML> ------=_NextPart_000_000E_01C3B031.CBF91290-- Tag: Strongly-typed DataSets Tag: 72293
- Next
  - 1
    - Where/how to obtain fix for Q330126 Oracle Connection Leak Hi I have a problem that we have narrowed down to Q330126. How can I download this fix? We have MSDN Universal Subscription....but not have any kind of support services. please reply to vahidk"at"activetv.org Thank You Tag: Strongly-typed DataSets Tag: 72289
  - 2
    - Simple question -Dataset New to .net .... I now have a dataset with one table in it name "MYTABLE" 1.) How do I read the value in the 3rd row, 2nd column of the current rowstate? myVal = ????.value 2.) How do I replace that value with a new value? ????.value = myNewValue **** Just some rambling... I've read six books, and spent hours looking through the SDK help, looking through samples and another hour looking at the quick watch to try to figure this SIMPLE thing out. There are REAMS and REAMS of information, but a simple thing like this aught to be the FIRST thing that pops up in the help about a dataset. I now know how to XML it, REMOTE it, BIND it, TWIRL it, and SWIRL it (oh ya), but coming from another OO language, I just want to know how to READ and WRITE it! If I sound frustrated, I am. Is there a easy way to find things in the help system? For example, coming from other languages, you pretty well know some of the basic things you want to do, i.e format a string to a date, or find out if a file exist, read and write to a field, etc. When you search the SDK help, with something like "FORMAT STRING" you get a gazzillion things back, and little to do with what you are looking for. If you know the syntax... i.e. String.Format and type that in, then you find what you are looking for, but I don't know the syntax, that's why I'm looking in the help sys. Tag: Strongly-typed DataSets Tag: 72282
  - 3
    - Acessing mdb file from a network share!! Hello, Iam trying to access a mdb file from a shared drive \\mycomputer\files from ASP.NET and OLEDB. It works locally Computer A hosts IIS/ASP.Net. Files reside in ComputerB under a network share. Web.config has the following- 1. One which works- <add key="NEWVIP" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\inetpub\wwwroot\clients\newvip\database\vip.mdb;" /> 2. One which does not work- <add key="NEWVIP" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=\\computerA\\files\newvip\database\vip.mdb;" /> Thanks for your help. jay Tag: Strongly-typed DataSets Tag: 72279
  - 4
    - Forward Only In the MSDN seminar yesterday I thought I heard the presenter say something to the effect that unlike ADO, ADO.NET datasets are Forward Only or Static, disconnected recordsets - you can't go back, as with a dynaset. Is this correct? Tag: Strongly-typed DataSets Tag: 72278
  - 5
    - Acessing mdb file in a different computer!! Tag: Strongly-typed DataSets Tag: 72277
  - 6
    - requerying with Dataadapter and dataset Hi all , I wonder if you can help I run this code once Dim daEmpDet2 As OleDbDataAdapter defined globally strSQL1 = "select * From PREmpDet where Empcode='" & EmpCode & "'" Dim dsEmpDet2 = New OleDbDataAdapter(strSQL1, cn2) daEmpDet2.Fill(dsEmpDet2, "EmpDet2") I get the right record when run the code the first time . when I rerun the code with a different EmpCode I Still get the first record what am I doing WRONG. Thanks Tag: Strongly-typed DataSets Tag: 72272
  - 7
    - LoadDataRow Issues I have 2 datasets, each with a DataTable. Each table has the same primary key, and columns. I am trying to copy rows from one dataset to another, based on an event from my application. It all works fine when the row is not present in the destination DataTable. Now when the row is present in the destination file, the .NET documentation says use the LoadRowData method of the dataset to copy the row. When do this, I get a unique key violation problem (right at the EndLoadData point in the code below).. Here is my code below. Can anybody help?? Dim app As Application Dim xmlDestFile As String = app.StartupPath & "\" & "dest.xml" Dim xmlSourceFile As String = app.StartupPath & "\" & "source.xml" Dim dsDest As New DataSet Dim dsSource As New DataSet Dim rwDest As DataRow Dim rwSource As DataRow dsDest.ReadXml(xmlDestFile) dsSource.ReadXml(xmlDestFile) Try For Each rwSource In dsSource.Tables(0).Rows Dim copyRowPersent As Boolean For Each rwDest In dsDest.Tables(0).Rows If rwDest.Item("Name") = rwSource.Item("Name") Then copyRowPersent = True Exit For End If Next If copyRowPersent Then Dim newRow(rwSource.Table.Columns.Count - 1) As Object Dim column As DataColumn Dim intLoop As Int32 intLoop = 0 For Each column In rwSource.Table.Columns newRow(intLoop) = rwSource.Item(column) intLoop = intLoop + 1 Next dsDest.Tables(0).BeginLoadData() dsDest.Tables(0).LoadDataRow(newRow, False) dsDest.Tables(0).EndLoadData() ' I get a primary key voilation problem here..., I don't even go to accept changes else 'Import the new rows here using ImportRow ' This works fine... End If Next dsDest.AcceptChanges() dsDest.WriteXml(xmlDestFile, XmlWriteMode.WriteSchema) dsDest.Dispose() dsSource.Dispose() Catch myex As Exception MsgBox(myex.ToString, MsgBoxStyle.Information + MsgBoxStyle.OKOnly, "Test") End Try VJ Tag: Strongly-typed DataSets Tag: 72271
  - 8
    - Finer grained info on what led to a constraint exception Is there any way to provide a finer grained source of information on what led to a constraint exception? This is really a blunt tool right now. Tag: Strongly-typed DataSets Tag: 72268
  - 9
    - ExecuteNonQuery and events This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3B016.BBB07A60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I'm using the ExecuteNonQuery command to insert a row in a database. = How do I fire an event when the row has been added. I know how to do it = with an OleDbDataAdapter, but I want to use ExecuteNonQuery. Ideas? Ian ------=_NextPart_000_0008_01C3B016.BBB07A60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I'm using the ExecuteNonQuery command = to insert a=20 row in a database.  How do I fire an event when the row has been=20 added.  I know how to do it with an </FONT><FONT face=3DArial=20 size=3D2>OleDbDataAdapter, but I want to use ExecuteNonQuery.  = Ideas?</FONT> <P><FONT face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2>Ian</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P></DIV></BODY></HTML> ------=_NextPart_000_0008_01C3B016.BBB07A60-- Tag: Strongly-typed DataSets Tag: 72266
  - 10
    - Thread communication - events Is it possible to use events as a communication mechanism between threads? Tag: Strongly-typed DataSets Tag: 72265
  - 11
    - EASY ONE? looping and updating labels with each iteration This should be an easy one, but I'm not sure the best way to do it. I've got a form, and when I click a button it starts looping through an array. With each iteration of the array I want it to change the status of a label. I realise that it must complete the execution of the code-behind page before it can update the labels, so how do I do it? TIA, Bruce Tag: Strongly-typed DataSets Tag: 72255
  - 12
    - Master - Detail problem... Hi I have a typed dataset with a Master table (tblPersons) and a Detail table (tblRemarks). I have a Winform which shows person data (master data) I would like to have a datagrid showing the detail data. So I try to bind the datagrid like this: DataSource: MyDataSet And try to set DataMember to: tblPersontblRemarks But I get an error: "Invalid Property Value:" "DataBinding could not find a row in the list that is suitable for all bindings" And then when I press OK I receive another error: "Datasources of type System.DBNull are not supported. Parameter name: Datasource" If I rightclick on a dataadapter and select Preview Data... it works fine. Best regards Jan Tag: Strongly-typed DataSets Tag: 72251
  - 13
    - DataView.Find (SQL Server 2000) I need to be able to sort/search a datatable for 2 columns, both of type integer. Is this possible? Dim dv As New DataView(MyDataTable,...) Dim dr As DataRowView Dim iIndex As Integer Dim objSearch(1) As Object dv.Sort = ("Column1, Column2 ASC") objSearch(0) = 5 'Locate 5 in column 1 objSearch(1) = 6 'Locate 6 in column 2 iIndex = dv.Find(objSearch) Will this find rows in my view where Column1 = 5 AND Column2 = 6? Or will it find rows where Column1 = 5 or 6 AND rows where Column2 = 5 or 6? As an alternative, I could apply a filter upon the DataView when enstantiating it. However, wouldn't this be less efficient/concise than DataView.Find? -bgsd Tag: Strongly-typed DataSets Tag: 72242
  - 14
    - Udl File How to use it Hi, I have a quick question about the udl file. How to use it in a project ? I ve created one, but I don't know where to put it and how to replace my current connection string with it ? Thks Stan Tag: Strongly-typed DataSets Tag: 72238
  - 15
    - Oracle cursors not releasing with OracleClient Hi all, I'm having a problem with Oracle .net provider and Stored Procedures returning REF CURSOR vars. I'm using OracleClient v1.0.1012.0 with Framework 1.0 and when I fill a dataset with the stored procedure, the cursor is not released and I always end up with a ORA-01000 error (too much cursors opened). It's very frustrating and I've observed that if I change the OracleClient reference to the one from framework 1.1 it doesn't happen and the cursors are released when closing the connection. Unfortunately, I can't change the framework version I'm using so I'd like to know if there's something I could do to fix this behaviour with framework 1.0 Another strange thing I've noticed is that if I call the function (see code) in a pageload event of an aspnet application I don't get the ORA-01000 error but if I call it from the Console Application I can't. I'll put some code here to reproduce the behaviour, any help will be appreciated !! Thx in advance, ori using System; using System.Data.OracleClient; using System.Data; namespace ConsoleApplication2 { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { [STAThread] static void Main(string[] args) { Class1 c = new Class1(); for (int i=0; i<850; i++) { c.try(); } } public void prova() { try { OracleConnection conn = new OracleConnection(@"<connection string here>"); conn.Open(); OracleCommand comm = new OracleCommand(); comm.Connection = conn; comm.CommandType = System.Data.CommandType.StoredProcedure; comm.CommandText = "PKG.READ"; comm.Parameters.Add(new OracleParameter("P_CURSOR", OracleType.Cursor, 38, ParameterDirection.Output, true, 38, 0, "", System.Data.DataRowVersion.Current, null)); OracleDataAdapter adapter = new OracleDataAdapter(comm); DataSet dset = new DataSet(); adapter.Fill(dset); conn.Close(); } catch (System.Exception ex) { //ORA-01000 Error when default 300 cursors are opened } } public Class1() { } } } Stored procedure CREATE OR REPLACE PACKAGE PKG AS TYPE etrcur IS REF CURSOR; PROCEDURE READ ( p_CURSOR OUT etrcur ); END PKG; / CREATE OR REPLACE PACKAGE BODY PKG AS PROCEDURE READ ( p_CURSOR OUT etrcur ) IS BEGIN OPEN p_cursor FOR SELECT <ANY SELECT HERE>; END SGM_READ; END PKG; / Tag: Strongly-typed DataSets Tag: 72226
  - 16
    - BindingContext Hello i have a form bounded to a DataSet and i have several combobox's in the form. when i use Bc.Position = Bc.Position + 1 it moves to the next record in the DataSet, and all the combobox's that are bound to other tables in the dataset are updated too. problem is when the bc.position = 0 (first record) is selected the textbox's are updated correctly the combobox's are displaying the first record of the bonded table and not the value that is in in that record. is there i am missing? Thnaks Tag: Strongly-typed DataSets Tag: 72219
  - 17
    - Passing values error I'm using this piece of code on page one.aspx Context.Items("Parameter") = x Server.Transfer("two.aspx") And in opage two.aspx I put a value in a text box via button. To grab the data I use Dim x As Integer = CType(Context.Items("Parameter"), Integer) BUT when I click the button to insert that value in a text box I get 0 (zero) instead of a number from the previous page. Tag: Strongly-typed DataSets Tag: 72218
  - 18
    - how to create a notification? my sql is: CREATE EVENT NOTIFICATION mytestqueue ON DATABASE FOR DDL_DATABASE_LEVEL_EVENTS TO DATABASE northwind but error message is: Incorrect syntax near 'northwind'. how to do? thanks!!! Tag: Strongly-typed DataSets Tag: 72210
  - 19
    - MySQL & WebForm - Please Help Hello, I just started to learn ASP.NET, and I am using MySQL for database, I have a question I hope someone can answer for me though :) I want to create a simple form that can edit and create a row in a database, for example the fields Name and Lastname. How do I go about this, can I somehow link my TextBox's to a field in the MySql database? So when I press Create-Button it adds the row with the fields from TextBox's itself? Or must I make a Button_Click event and make the SQL myself there? If I must do it myself, in PHP I used to create forms so all TextBox's were part of an array, then I could easilly make a foreach and create the SQL statement on the fly. This way I could add another TextBox to the page (and in the database ofcause), and not have to go change my code for it to be saved. Im looking for the best solution to creating/updating on a webform... and for my example a webform with 2 TextBox's (Name and Lastname) and 2 Buttons (Update and Create) would be good example, so I can use that method on bigger forms. I hope someone can point me in the right direction. Thanks, Cederstrom Tag: Strongly-typed DataSets Tag: 72192
  - 20
    - Doing something like nested SQL in DataTable.Select method I have a table with fields the following fields ID INTEGER (Primary key) FLAG BOOL TIMESPAN DATETIME IMPORTANCE INTEGER say I want to find the an ID with flag set to true, highest importance and shortest timespan. so one way to write the SQL is this: SELECT ID FROM MyTable WHERE TIMESPAN = (SELECT MIN(TIMESPAN ) FROM MyTable WHERE FLAG=TRUE AND IMPORTANCE = (SELECT MAX(IMPORTANCE ) FROM MyTable WHERE FLAG=TRUE)); so. my problem is. the data is in a dataTable and the DataTable.Select method doesn't take SQL statements. So can something teach me how to find what I need from the DataTable? thxs in advance .Net newB Tag: Strongly-typed DataSets Tag: 72190
  - 21
    - Using the GetChildRows method C# I am new to .net. I am populating a dataset with a few tables using stored procedures successfully and then setting primary keys and relations between table columns. BUT when I go to use the GetChildRows method my relations arent returning any child rows. Is there a better way of assigning the source table's primary/foreign key relationships to the dataset? Help is much appreciated. Tag: Strongly-typed DataSets Tag: 72189
  - 22
    - use crystal report in ASP.NET datagrid search result page I am new to crystal report. I have ASP.NET pages that show the search result. Since the search result is represented by datagrid, it will be nice to put a button on that page, and allows the user to export the result to crystal report. Here's what I have done so far, and I dont know what to do next. 1) Add CrystalReportViewer web control to the search result page. 2) In my ASP.NET application, I added a new item crystal report (.rpt) In my case, can the crystal report just get the result from datagrid. Please advise! Thanks! Tag: Strongly-typed DataSets Tag: 72187
  - 23
    - Accessing Excel thru Jet gives data in scientific notation Hi, I m trying to access an excel spreadsheet to load a named cells in a dataset. For this, I m using Jet OLEDB provider with ADO.Net. String cnString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + fileName + "; Extended Properties=\"Excel 8.0;HDR=No;IMEX=1;\""; String sql = "select * from MyNamedCells"; Initially I was having problem with null values for certain cells where datatype appeared different to the provider. e.g. If a top cells of a column contain text data (say A13331123) and in the middle there was some numeric data (4509015284) .. the numeric data was being retrieved as null. This was fixed using IMEX switch. Now - althought the numeric data is being loaded, but it is coming in scientific notation (the above value converts to: 4.50902e+009). How can I get my text back with the right accuracy? Thanks. Tag: Strongly-typed DataSets Tag: 72186
  - 24
    - How to bind PictureBox.Image to database image or bin column? How to bind PictureBox.Image to database image or bin column? thanks Tag: Strongly-typed DataSets Tag: 72182
  - 25
    - FoxPro, dBase III, and ADO.NET I have a newbie question about different database formats as they apply to ADO.NET. I need to get access to a .dbf file using ADO.NET. The files are in dBase III format. Does that mean I need to use the FoxPro Data Provider or that I only need to specify "Extended Properties=dBase III" in the connection string to connect to dBase III files? It's my understanding that FoxPro is just one of many programs that can read dBase III files (just like many text editors can read .txt files or html files). Is this the case? If so, why would someone be interested in using the FoxPro data provider? Thanks, Dave Tag: Strongly-typed DataSets Tag: 72172

Hello! I´m currently working with C# (absolutely a state-of-the-art
language, I think) and my question is if it´s really recommendable to use
Strongly-typed DataSets.
It seems to be that the way .NET creates them using XSD is excellent, but I
want to know your opinions about using them in a production environment.

Thank you.

Top

Re: Strongly-typed DataSets by Miha

Miha
Sun Nov 23 13:51:39 CST 2003

Hi Neo,

Personally, I like them.
They simplify data handling a lot, not to mention that they solve many run
time errors because of typos.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

"Neo" <neo@thematrix.com> wrote in message
news:OSmWjafsDHA.536@tk2msftngp13.phx.gbl...
> Hello! I´m currently working with C# (absolutely a state-of-the-art
> language, I think) and my question is if it´s really recommendable to use
> Strongly-typed DataSets.
> It seems to be that the way .NET creates them using XSD is excellent, but
I
> want to know your opinions about using them in a production environment.
>
> Thank you.
>
>

Top