Help with DataSet.Table.Rows.Find method

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
    - Is MDAC required on client for Windows app on shared drive? I've looked on the MSDN site and in all of the news groups and can't find the specific issue so I'm posting it to try to find an answer. I have a Windows .NET 1.1 application that accesses data from a SQL Server 2000 database on a network server. The application is installed on a network drive and clients access the application by either mapping directly to the server drive or by referencing it as \\servername\sharename\....myApp.exe in a desktop icon. Under this circumstance, our clients are installing the .NET Framework 1.1 redistributable on each user's machine so that they can run the application "locally" from the network drive. However, one of the prerequisites for our installation is MDAC 2.7 SP1 since that is what we are developing with and we reference the .NET Framework 1.1 System.Data namespace. The question has come up from our clients as to whether or not MDAC is required to be installed at all "on each user's machine" since the application is "running" off of a shared drive and accessing the SQL 2000 server. Our answer is "yes", since it doesn't matter where the application is "installed" or being run from since the app is actually running in each user's machine environment. The question is: Is our understanding correct? In looking at the .NET Framework 1.1 Requirements page, it "qualifies" the MDAC requirement for the "Client" in that it is only "required for data access" AND we assume that it means the machine "where the application is being run" -- even if run from a shared or network drive. I know that this should be clear and really simple, but it wouldn't be the first time that I've thought that I understood something correctly and later found out that I was wrong ... please consider this a sanity check. Thanks... Ron Tag: Help with DataSet.Table.Rows.Find method Tag: 81605
  - 2
    - JavaScript file I have a JS file, where I have show_clock function to call. I calling her like this<body onload="show_clock()">, but nothing happens. The clock don't appear. In your opinion what should I do? Use "RegisterClientScriptBlock" and/or "RegisterStartupScript".? If yes, how can I use them? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: Help with DataSet.Table.Rows.Find method Tag: 81597
  - 3
    - sorting a dataset hello. how can i sort data in a dataset? all the examples i have seen on msdn, etc are sorting a dataview. this works fine, but i want to return the results in xml and the dataview doesn't have a .getxml method (unlike the dataset). any ideas? thanks. Tag: Help with DataSet.Table.Rows.Find method Tag: 81595
  - 4
    - Creating your own INSERT, DELETE and UPDATE commands I need a bit of guidance if someone has a second. If I have a dataset with a lot of records, and I have a form that allows users to edit and/or add a lot of records at once, what do my insert and update statements need to look like? For instance, assume that I'm using Northwind and I use the query "select supplierID, companyname, contactname from suppliers" as my select query. Assume I have a form that lets the user edit a bunch of contactnames all at once and then click a submit button. What would the insert and update statements look like? I guess the real question is whether the dataset fires the insert, delete and update commands *per row* or whether it somehow does it for the whole dataset. Any help is greatly appreciated; I hope this isn't too vague! Lerch Tag: Help with DataSet.Table.Rows.Find method Tag: 81586
  - 5
    - DateTime Picker How can I use DateTime Picker control in my ASPX page? I already add the component to my project. I put one control in my page and give him an id and name. But when I try to use it in the code, gives an error saying that the variable dtpMyDate (it's the id that I choose) is not declared. What do I have to do? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: Help with DataSet.Table.Rows.Find method Tag: 81584
  - 6
    - Changing DataRow Rowstate progamatically I want to pass a few thousand records to a SQLce database and then insert them in a table Seems like the fastest way to do it (sql server replication not an option) is to pass a recordset that has all the records marked as DataRowState.Added, then use a dataadapter.update on the recordset Walking through the dataset and using insert commands was slower Is there a way quickly change all the rows in a dataset to "added" or to have them marked as added (rather than unchanged) when the dataset is first filled thanks Tag: Help with DataSet.Table.Rows.Find method Tag: 81577
  - 7
    - Sending a DataSet back to the database (C#) Hello, Let's say I first fill a DataTable in a DataSet by using some SQL command "SELECT * FROM SomeTable" Now I have another database, and it has another table. Now I want to send the DataSet I created from the first database to this second database, but the table in the second database does not have all the fields the first one does. So I would like to send only a few fields from the DataTable in my DataSet to the second table Example TABLE1 id name street number securityId groupId transactionId TABLE2 id name transactionId Of course the real example has a lot more fields. I do SELECT * FROM TABLE1 put that in a DataTable and now I want to send the rows in that DataTable to Table2 without the fields TABLE2 doesn't have. How can I do this ? Tag: Help with DataSet.Table.Rows.Find method Tag: 81575
  - 8
    - How to use JavaScript? How can I use JavaScript with my ASPX page wicth is using VB programming? I have a javascript clock that want ot use in my page, but don't -- Thank's (if you try to help me) Hope this help you (if I try to help you) rucawork. Tag: Help with DataSet.Table.Rows.Find method Tag: 81572
  - 9
    - Oracle REF Cursors and OracleDataAdapter - data not populating Hello All, I have a simple stored procedure that returns a REF CURSOR. The query retrieves 190 rows from the database (see query below). Following the example laid out in the web page http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontheadonetdatareader.asp (I'm using the last example - OracleDataAapter to fill a DataSet), the procedure does not return any data unless I specify in the where clause that the rownum be less than about 500 (don't know the exact number). I have verified that the stored procedure does in fact return the REF CURSOR appropriately by calling the procedure and iterating through the results in a Java class (this is without the rownum constraint). Is there something I'm missing here - perhaps a setting on the connection/command/parameter? Any help would be greatly appreciated. Thanks in advance. [CODE SNIPPETS] ------- C# Code ------- // Get connection con = GetConnection(); // Create command OracleCommand cmd = new OracleCommand("icrv_variance.load_deltas", con); cmd.CommandType = CommandType.StoredProcedure; // Setup parameters // Year OracleParameter parm = new OracleParameter("p_year", OracleType.Number); parm.Value = year; parm.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm); // Cursor parm = new OracleParameter("p_delta_cursor", OracleType.Cursor); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); // Execute logger.Debug("Executing stored procedure icrv_variance.load_deltas"); OracleDataAdapter da = new OracleDataAdapter(cmd); da.TableMappings.Add("Table", "Deltas"); da.Fill(ds); logger.Debug("Deltas retrieved: " + ds.GetXml()); // Close logger.Debug("Closing connection"); con.Close(); con.Dispose(); ----------- PL/SQL Code ----------- PROCEDURE load_deltas(p_year IN ICRV_VARIANCE_DELTA.YEAR%TYPE, p_delta_cursor OUT CUR_DELTA) IS -- Variable declarations -- Code location for logging error messages codeLocation varchar2(255); BEGIN -- Create cursor codeLocation := 'Opening cursor'; OPEN p_delta_cursor FOR select delta.year ,delta.org_code ,org.org_name ,delta.status ,sum(decode(delta.month, 1, delta.month, 0)) jan ,sum(decode(delta.month, 1, delta.delta_id, 0)) jan_id ,sum(decode(delta.month, 1, delta.delta_value, 0)) jan_value ,sum(decode(delta.month, 2, delta.month, 0)) feb ,sum(decode(delta.month, 2, delta.delta_id, 0)) feb_id ,sum(decode(delta.month, 2, delta.delta_value, 0)) feb_value [... etc ...] ,sum(decode(delta.month, 12, delta.month, 0)) dec ,sum(decode(delta.month, 12, delta.delta_id, 0)) dec_id ,sum(decode(delta.month, 12, delta.delta_value, 0)) dec_value from icrv_variance_delta delta ,organization_master org where delta.org_code = org.org_code and year = p_year group by delta.year ,delta.org_code ,org.org_name ,delta.status order by org.org_name; EXCEPTION -- Handle all exceptions WHEN OTHERS THEN -- Raise an application error RAISE_APPLICATION_ERROR(-20001, 'Unexpected Error ' || codeLocation || ': ' || TO_CHAR(SQLCODE) || ', ' || SQLERRM); END load_deltas; Tag: Help with DataSet.Table.Rows.Find method Tag: 81570
  - 10
    - How to create unique identity columns? Hallo, With IDENTITY(1,1) I can create an AutoIncrement Column. I however need a column with a uniqueidentifier that is created whenever a new datarow is created. This is possible with access, but how can I create such a column via SQL? Thorsten Tag: Help with DataSet.Table.Rows.Find method Tag: 81569
  - 11
    - Questions about the DataSet/DataTable Hello, I have a DataSet with lots of data in it, there is no database just the DataSet. In the DataTable contained by the DataSet there is a field Category. I would like to get the different Categories out of that DataSet, so no duplicates. With SQL this would be very easy, SELECT DISTINCT or Group By should do the job, but I don't suppose you can run SQL against a dataset can you ? Is there another way to select distinct values from a column in a DataTable ? If it held A B B A C E F A G F G H I would only like to get A B C E F G H back. Thnx. Tag: Help with DataSet.Table.Rows.Find method Tag: 81567
  - 12
    - [ANN] Firebird .NET Data Provider 1.6 Alpha 1 released Hello: Firebird .NET Data Provider 1.6 Alpha 1 available for download. Note about the Firebird RDBMS ( http://www.firebirdsql.org/ ) "Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981." Changes in this release (Review the changelog for details): Alpha 1 ( 2004-02-04 ) ----- - - ---- -- -- - - Initial support for the Firebird Embedded server. - Improved Connection Pooling implementation, now there will be different polls by connection string (like in SqlClient), each pool can have a min and max size, these can be specified in the Connection string using elements: Min Pool Size Max Pool Size - New FbScript implementation. - Improved array datatype support. - Removed Firebird Events API implementation. - New build option ( in 4 assemblys ) : (1) FirebirdSql.Data.Firebird.dll With ADO.NET classes. (2) FirebirdSql.Data.Common.dll With common classes for all GDS implementations (3) FirebirdSql.Data.Gds.dll With classes for the native C# GDS implementation. (4) FirebirdSql.Data.FbClient.dll With classes for the PInvoke GDS implementation. --------------------------------------------------- You can read the Changelog at: http://sourceforge.net/project/shownotes.php?release_id=221426 You can download binarys for .NET 1.0 at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Alpha1-NET1.0.exe?download You can download binarys for .NET 1.1 at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Alpha1-NET1.1.exe?download You can download sources at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Alpha1-Src.zip?download You can download documentation at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Alpha1-Doc.zip?download CVS Tag: NP_1_6_ALPHA1 -- Best regards Carlos Guzmán Álvarez Vigo-Spain Tag: Help with DataSet.Table.Rows.Find method Tag: 81566
  - 13
    - Master/Detail dataset fill I hava a typed dataset with 2 tables and a relation (master/detail). I have an dataadapter to fill the master table (with a select and a parameter) and now I want fill the second table with another dataadapter, but I don't know how I have to define the select sentence to populate it only with the records that have relation with the master table. How can I do this? After filling the dataset, I insert a new row in the master table (it has an autonumeric Key field simulate with sequences in Oracle), and then I insert new rows in the detail table. How can I controll the update to insert the autonumeric key genereted in the master table in the detail table? A lot of thanks, Alex B. Tag: Help with DataSet.Table.Rows.Find method Tag: 81564
  - 14
    - SQL to ACCESS via VB.NET/ADO.NET I have populated a data table (dtHeader) from a SQL database using a SQL Data Adapter. I have an Access table (header) with the same fields as the SQL table. I want to populate the Access table with the data in the data table. The data table contains information from multiple SQL tables with teh same schema. I am currently attempting to run an InsertCommand from an OleDB DataAdapter for each row of the data table to get teh data into Access 1 row at a time. I ahve to do this for 5 tables andit is going to be a lot of code to create and assign values to all of the parameters. Is there an easier way to populate the Access table, with all of the data tables rows at once even? ---------------------------------------- Dim sdaROW as new SqlClient.SqlDataAdapter, cmdSQL as New SqlClient.SqlCommand Dim conOLE as new Data.OleDb.OleDbConnection, cmdOLE as new OleDb.OleDbCommand Dim odaROW as new OleDb.OleDbDataAdapter, odrROW as OleDb.OleDbDataReader conOLE.ConnectionString = sConString conOLE.Open() ' Populate the data table with the SQL data sdaROW.SelectCommand = new SqlClient.SqlCommand with sdaROW .SelectCommand.Connection = scnFD .SelectCommand.CommandText = "SELECT * FROM " & sSelectSQL .Fill(dtHeader) .SelectCommand = nothing end with sdaROW = nothing odaROW.InsertCommand = new OleDb.OleDbCommand odaROW.InsertCommand.Connection = conOLE odaROW.InsertCommand.CommandText = "INSERT INTO header (guid, parentguid) VALUES (?,?)" odaROW.InsertCommand.Parameters.Add("guid",OleDb.OleDbType.Guid,64,"guid") odaROW.InsertCommand.Parameters.Add("parentguid",OleDb.OleDbType.Guid,64,"pa rentguid") for iCounter = 0 to dtHeader.Rows.Count - 1 odaROW.InsertCommand.Parameters.Item("guid") = dtHeader.Rows(iCounter).Item("guid") odaROW.InsertCommand.Parameters.Item("parentguid") = dtHeader.Rows(iCounter).Item("parentguid") odaROW.InsertCommand.ExecuteNonQuery() next iCounter Tag: Help with DataSet.Table.Rows.Find method Tag: 81560
  - 15
    - very simple question, but i cant find the answer Hello, I am trying to write a generic tool that accesses a SQL server and reads/updates/deletes/creates records. I want to reference this tool from my asp.net pages to talk to my db. by the way, i want the results of any read, update and create to be returned in xml. when reading data, i populate a dataset with data and then use the dataset.getxml method to return xml. is this a neat way of reading data? how does it compare to the FOR XML EXPLICIT command in sql server? when creating/updating data i was thinking of using a data adapter but this seems a bit over the top, maybe i am wrong? should a data adapter be used when doing bulk updates? For example, when editing a data grid there may be many rows that have been updated, so the data adapter can be used to filter out the rows that have changed and update the db. For my scenario i will probably only be updating a single row at a time, so should i just use a simple command object to build a query and update the db like that? i hope i have made myself clear in what i am trying to acheive and what my concerns are. i am new to ado.net so i am just trying to find out the best way of doing things. many thanks. Tag: Help with DataSet.Table.Rows.Find method Tag: 81559
  - 16
    - Resize datagrid rows There is anyway to resize dinamically datagrid rows? I have a datagrid with 5 rows for each page. What happens is if in the 3rd page there is only one row to show, that row stays to large in comparation with rows of before pages. How can I set the row space always the same, no matter if there is 5 or 1 row(s) in datagrid pages?? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: Help with DataSet.Table.Rows.Find method Tag: 81555
  - 17
    - JavaScript block I have a file with javascript programming (in this case is a run time clock, that display hours and date at real time). In my old application I have this clock displying where I want, but now in .NET the clock don't appear. In old ASP I have define onLoad event in body calling show_clock function like this <body onload="show_clock()" > <table> <tr> <td valign="center" align="right"> <font face="cursive" color="white" size="3">Hora + Data: </font></td> <td valign="center" align="left"> //HERE IS THE BLOCK TO PERMIT SHOW RUN TIME CLOCK <script language="javascript" src="Externo\liveclock.js"></script> </td> </tr> <tr> <td valign="center" align="right"> <font face="cursive" color="white" size="3">User: </font></td> <td valign="center" align="left"> <input id="pass" type="text" > </td> </tr> <tr> <td valign="center" align="right"> <font face="cursive" color="white" size="3">PIN: </font></td> <td valign="center" align="left"> <input id="pass" type="password"> </td> </tr> </table> </body> I try to do the same thing in .NET but I'm not having success. Any sugestions??????? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: Help with DataSet.Table.Rows.Find method Tag: 81554
  - 18
    - Le MSDN comme vous ne l'avez jamais vu... Salut J'ai à peu près fini le site... l'essentiel fonctionne... vous pouvez le mettre en fenêtre dans le fond d'écran de windows... c'est très pratique vous verrez... http://www.eztree-msdn.com @+ LJ Tag: Help with DataSet.Table.Rows.Find method Tag: 81549
  - 19
    - Dataset mapping Hi all, Is it possible to read data from one database table into a dataset, apply a sort of mapping scheme to the dataset and update two other database tables with the data from the source table? If yes, how can this be achieved? Thanx, Klaas Tag: Help with DataSet.Table.Rows.Find method Tag: 81547
  - 20
    - Use a DataTable in place of a HashTable I have been using a HashTable to store name/value pairs, but now I need to add a third element (name/value/flag). I still need to be able to index by ["Name"], and I'd like to keep lookup speed as high as possible. I'm considering using a DataTable instead of the HashTable since I have to store the values to a database eventually anyway. It seems like the DataTable can do what the HashTable is doing in this case, but I'm concerned about efficiency. Does anyone happen to know the tradeoffs in using the DataTable instead? I was originally considering building both tables at the same time, but that seems unnecessary. Tag: Help with DataSet.Table.Rows.Find method Tag: 81541
  - 21
    - View data in DataGrid I have this code to read a text file (.txt) and fill a dataset and then filter, using DataView, by user. The final result I want to put into a datagrig, but this last part is not happen and I don't know why. the code is below ------------------------------------------------------------------------ LerLinha = New StreamReader(LerPath) dsMrc = New DataSet dtMrc = New DataTable("Mrc") dcMrc = New DataColumn("Cod", System.Type.GetType("System.String")) dcMrc = New DataColumn("Data", System.Type.GetType("System.String")) dcMrc = New DataColumn("Hora", System.Type.GetType("System.String")) dtMrc.Columns.Add("Cod") dtMrc.Columns.Add("Data") dtMrc.Columns.Add("Hora") Do txtLine = LerLinha.ReadLine() If Not txtLine Is Nothing Then Cd = ProcessCod(txtLine) dtData = ProcessData(txtLine) dtHora = ProcessHora(txtLine) drMrc = dtMrc.NewRow() drMrc("Cod") = Cd drMrc("Data") = dtData drMrc("Hora") = dtHora dtMrc.Rows.Add(drMrc) End If 'dsMrc.Tables("Mrc").Rows.Add(drMrc) Loop Until txtLine Is Nothing dsMrc.Tables.Add(dtMrc) 'dsMrc.Tables("Mrc").Select("Cod='" & FindUser & "'") Dim strFilter As String Dim findRows() As DataRow Dim dtAux As DataTable Dim v As New DataView v.Table = dtMrc v.RowFilter = "Cod=" & FindUser v.Sort = "Data ASC" //this is my datagrid dgMarcacoes.DataSource = v LerLinha.Close() LerLinha = Nothing ------------------------------------------------------------------------ Could you help me???? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: Help with DataSet.Table.Rows.Find method Tag: 81538
  - 22
    - Problem with SqlCommandBuilder.DeriveParameters H I have the following code sqlConnection1.Open() System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("[SOMEUSER].[PAK_TEST.P_OPEN]", sqlConnection1) cmd.CommandType = CommandType.StoredProcedure System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(cmd) Since I don't know the parameternames in advance I need to call DeriveParameters to fill the Parameters collection on the SqlCommand object. Previously this has not been a problem since the OleDbCommand object does not need to know the name of the parameters. Iâ??m not very happy doing the extra roundtrip to the server getting the parameters, and it does not make it better that DeriveParameters bombs out when the stored procedure name contains periods. As you see in the code I try to derive parameters from [SOMEUSER].[PAK_TEST.P_OPEN] This is a perfectly valid Procedurename. When I call DeriveParameters it throws a System.Data.SqlClient.SqlException with the following message: "Could not find stored procedure ''. When doing a quick watch on the SqlCommand object after the exception I found that CommandText was changed to "[[SomeUser]]..sp_procedure_params_rowset". The same also happens if I try to set the commandtext of the sqlcommand object in designmode. It also magically changes the commandtext from [SOMEUSER].[PAK_TEST.P_OPEN] to [SOMEUSER].[PAK_TEST.[P_OPEN]], which of course is terrible wrong My conclusion is that DeriveParameters totally ignores all delimiters and will therefore never work correctly on stored procedurenames containing periods I guess this is a known problemâ?¦ Do you have a workaround or fix? Btw: Changing the procedure names is not an option Thank Xandu Tag: Help with DataSet.Table.Rows.Find method Tag: 81534
  - 23
    - How to make a backup from vb.net Hi, I would like to add a backup function in my winform app. I use MSDE. My idea was to : Detach the database Copy the mdf and ldf file to the destination support Attach the database But I don't know how to detach and attach the database from vb.net Any idea ? Stan Tag: Help with DataSet.Table.Rows.Find method Tag: 81531
  - 24
    - ReadOnly ComboBox Hi to all How can I make a ComboBox readonly ? Enabled = false and DropDownStyle = DropDwnList are not solutions for me. Thank you Dan Tag: Help with DataSet.Table.Rows.Find method Tag: 81520
  - 25
    - ODBC Data Reader? Is the DataReader only for SQLServer or can it be used with ODBC? If so, is anyone aware of a sample out there? Tag: Help with DataSet.Table.Rows.Find method Tag: 81519
- Next
  - 1
    - Help in calling Oracle Package from aspx page This is a multi-part message in MIME format. ------=_NextPart_000_001D_01C401B9.CFCC3260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm, trying to call a package from my page to populate a datagrid. I'm = using an example from the web, but I can't get it to work. Here is my code: code in the aspx page: ... OracleConnection cnnOracle =3D new = OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]); = cnnOracle.Open(); OracleCommand oraCmd =3D new OracleCommand("{call = PACKPERSON.AllPerson({resultset 10,ssn,fname,lname})}",cnnOracle);=20 oraCmd.CommandType =3D CommandType.StoredProcedure; DataSet dstPerson =3D new DataSet(); OracleDataAdapter adpPerson =3D new OracleDataAdapter(oraCmd); adpPerson.Fill(dstPerson); this.DataGrid1.DataSource=3D dstPerson; this.DataGrid1.DataBind(); ... When I run my application I get the following error: ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol "{" when = expecting one of the following: begin case declare exit for goto if loop mod null = pragma raise return select update while with <an identifier>=20 <a double-quoted delimited-identifier> <a bind variable>=20 << close current delete fetch lock insert open rollback savepoint set = sql=20 execute commit forall merge <a single-quoted SQL string> pipe=20 Any suggestion are welcome. Thanks Garfield ------=_NextPart_000_001D_01C401B9.CFCC3260 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2> <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, trying to call a package from my = page to=20 populate a datagrid. I'm using an example from the web, but I can't = get it=20 to work.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Here is my code:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>code in the aspx = page:<BR>...<BR>  =20 OracleConnection cnnOracle =3D new=20 OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]);&= nbsp;</FONT></DIV> <DIV> <P><FONT face=3DArial size=3D2>   = cnnOracle.Open();<BR>  =20 OracleCommand oraCmd =3D new OracleCommand("{call = PACKPERSON.AllPerson({resultset=20 10,ssn,fname,lname})}",cnnOracle); <BR>   = oraCmd.CommandType =3D=20 CommandType.StoredProcedure;<BR>   DataSet dstPerson =3D new=20 DataSet();<BR>   OracleDataAdapter adpPerson =3D new=20 OracleDataAdapter(oraCmd);<BR>  =20 adpPerson.Fill(dstPerson);<BR>   this.DataGrid1.DataSource=3D=20 dstPerson;<BR>   this.DataGrid1.DataBind();<BR>...</FONT></P> <P><FONT face=3DArial size=3D2>When I run my application I get the = following=20 error:</FONT></P> <P><FONT face=3DArial size=3D2>ORA-06550: line 1, column 7: PLS-00103: = Encountered=20 the symbol "{" when expecting<BR> one of the following: begin case = declare=20 exit for goto if loop mod null <BR>pragma raise return select update = while with=20 <an identifier> <BR><a double-quoted delimited-identifier> = <a=20 bind variable> <BR><< close current delete fetch lock insert = open=20 rollback savepoint set sql <BR>execute commit forall merge <a = single-quoted=20 SQL string> pipe </FONT></P></DIV> <DIV><FONT face=3DArial size=3D2>Any suggestion are = welcome.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>Garfield</FONT></DIV></FONT></DIV></BODY></HTML> ------=_NextPart_000_001D_01C401B9.CFCC3260-- Tag: Help with DataSet.Table.Rows.Find method Tag: 81518
  - 2
    - ReadXmlSchema into an existing DataTable Hi. I'm trying to read xml schema to a dataset that already contains datatable with the same name as the one in schema file and ReadXmlSchema has no effect. This console application in VB.Net demonstrates it: Module Module1 Sub Main() WriteSchemaFromNW() End Sub Private Sub WriteSchemaFromNW() Dim connection As SqlClient.SqlConnection Try Dim connectionString As String = "integrated security=SSPI;data source=localhost;persist security info=False;initial catalog=Northwind" connection = New SqlClient.SqlConnection(connectionString) Dim command As New SqlClient.SqlCommand("Select * from Orders", connection) Dim da As New SqlClient.SqlDataAdapter(command) Dim ds As New DataSet Dim dt As New DataTable("Orders") ds.Tables.Add(dt) da.Fill(dt) ds.WriteXmlSchema("c:\Orders.xml") dt = Nothing Dim ds1 As New DataSet, ds2 As New DataSet Dim dt1 As New DataTable("Orders") ds1.Tables.Add(dt1) ds1.ReadXmlSchema("c:\Orders.xml") ds2.ReadXmlSchema("c:\Orders.xml") Console.WriteLine("Reading schema into dataset with existing table") For Each tbl As DataTable In ds1.Tables Console.WriteLine(String.Format("Table {0} - number of rows = {1}, number of columns = {2}", tbl.TableName, tbl.Rows.Count, tbl.Columns.Count)) Next Console.WriteLine("Reading schema into an empty dataset") For Each tbl As DataTable In ds2.Tables Console.WriteLine(String.Format("Table {0} - number of rows = {1}, number of columns = {2}", tbl.TableName, tbl.Rows.Count, tbl.Columns.Count)) Next Catch ex As Exception Console.WriteLine(ex.Message) Finally If Not connection Is Nothing Then connection.Dispose() End If End Try End Sub End Module Any help is very appreciated. Thanks a lot - Predrag. Tag: Help with DataSet.Table.Rows.Find method Tag: 81515
  - 3
    - Access to SQL 2000 I would like to write a program to convert Access tables to SQL 2000 tables. I could certainly write a program which collects each field in the access table and creates a similar field in SQL 2000 and then populates the file, however I am assuming that XML may offer a solution which would require only a few statements. Does anyone with XML expertise have an idea of this? Regards Tag: Help with DataSet.Table.Rows.Find method Tag: 81513
  - 4
    - storing data locally? Hi, in a nutshell, is there a quick and efficient way of storing data from a database on each user's machine so that a WinForm application can query/analyze/do whatever it wishes to this local data? the winform app will never need to interact with the original database except the first time it is run - to create the local data files on each user's computer. From then on, each time a user runs the application, the app would be using the local data. I thought of saving the data as XML files... but I am concerned about efficiency. As well, I do not need the files to be viewed through other mediums (web, excel, etc.). Actually, I would prefer it if the local files are NOT viewable in other mediums... only the WinForm application would use the files. If I am able to query data in these local files using SQL (like "select myCol From file1.dat") that would be also be a huge plus.... I also thought of loading a DataSet object then serializing it to a file... any links/advice/help on this? I couldnt really find any specific examples/white papers on serializing data, but I am still looking. Any other suggestions? Thank you. Tag: Help with DataSet.Table.Rows.Find method Tag: 81512
  - 5
    - Adding a datarow to datatable bounded to listbox. Please help! Hi, I have a problem with adding a datarow to datatable that is bounded to listbox. Here is what I am trying to accomplish: 1) Connect to access database and select table into dataset (works fine) 2) Create dataview of that table and bind it to listbox (works fine) 3) Add datarow to datatable containing information from some other source and the added datarow should automatically be displayed in listbox (having problem) 4) Update access table with new information... Here is how I add datarow to my datatable. drTo = dsStudents.Tables("ToStudents").NewRow() drTo("SomeColumn") = ... drTo("SomeColumn2") = ... dsStudents.Tables("ToStudents").Rows.Add(drTo) The thing is that datarow is actually gets added to the datatable but in the listbox it is appears as "blank". Now, if I add a second row after that, the first row now changes from "blank" to the one with information (Student's Name). But, now the second row is displayed as "blank". In other words the number of items that are in listbox are n-1 (1 is blank so total is n) and the number in datatable is n. So what do I need to do to get new added row to be displayed properly? I found a solution, to use this line of code: dsStudents.Tables("ToStudents").AcceptChanges() Now this works fine, however, the RowState changes from added to unmodified and calling Update method of DataAdapter would cause no rows to be updated since all rows are marked as unmodified. Is there another way I can get result that I want without using AcceptChanges() I appreciate your help! Tag: Help with DataSet.Table.Rows.Find method Tag: 81511
  - 6
    - Common database code for Oracle, SQL Server, MS Access I am writting an application in VB.Net, as part of programming I realize that depending on what database I connect to Access, SQL Server or Oracle, I have to use a different SQL Query Syntax... and include different type of database libraries in my code In phase one we want to develop the app on MS Access and later on wants to migrate to Oracle or SQL Server. >>What do I need to do to write the code in such a way that I don't have to rewrite any code when I migrate the app from MS Access to SQL Server or Oracle? Can I just use ODBC connection all across? Will ODBC work on ACCESS from VB.Net? Thanks in advance -Raj Tag: Help with DataSet.Table.Rows.Find method Tag: 81510
  - 7
    - Performance considerations Hi all I am currently designing a program that uses the ado.net. I have a question.. Which is better? To have your data constraints implemented on the dataset or constraints on the database? Or both Thanks a million Tag: Help with DataSet.Table.Rows.Find method Tag: 81509
  - 8
    - ExecuteScalar return decimal instead of int? Hi When I use the ExecuteScalar and the sql looks like this "Insert ...; Select SCOPE_IDENTITY()" I get the return value as decimal - how can I cast it so it will return an integer? I use .net c# Thanks Tag: Help with DataSet.Table.Rows.Find method Tag: 81505
  - 9
    - Looking for asp.net + mssql hosting Hi, I have several days looking for good alternatives to host asp.net sites that uses MsSQL Server. I found here several good comments about this site : http://www.webhost4life.com/, and seems very good. However I found this other, which really overpass the first one, regarding space and traffic allowance : http://www.securemate.com Also, the connection is very fast. The only things I see webhost is better than securemate is because they have more components included. Please, tell me where's the trick ? Could somebody compare their current hosting provider to this company and tell what are they missing ? Thanks in advance, Tag: Help with DataSet.Table.Rows.Find method Tag: 81502
  - 10
    - Not Enough Storage We are receiving the following exception quite frequently in our application and was wondering if anyone could shed some light on this. Error Description: Not enough storage is available to process this command. Source: System.Data Stack Trace: at System.Data.SqlClient.SqlConnection.Open() This is ASP.NET corporate intranet website connecting to SQL Server using the Microsoft Data Application Block component. What causes Open() to issue this exception? Scott Lorenz Tag: Help with DataSet.Table.Rows.Find method Tag: 81499
  - 11
    - Installable ISAM error message This code produces the "Could not find Installable ISAM" error message. Anybody have any suggestions? strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFilePath strConnectString += "Extended Properties=text;HDR=Yes;FMT=Delimited" Dim ds As New DataSet Dim da As New OleDbDataAdapter("SELECT * FROM " & strFileName, strConnectString) da.Fill(ds) I need to fill a dataset from a text file. Tag: Help with DataSet.Table.Rows.Find method Tag: 81493
  - 12
    - Insert to SQL Server from a text file I am using vb.net and want to insert data from a .csv file into a table. I am looking everywhere but am coming up empty. Can someone be so kind as to post some sample code for me? Thank you. Mike B Tag: Help with DataSet.Table.Rows.Find method Tag: 81488
  - 13
    - textbox databind problem I have DataSet with two DataTable and DataRelation between them. I have two DataGrids with master / detail style and additional textbox which are bind to detail table. ds.Tables.Add(tableCompany); ds.Tables.Add(tableBranch); ds.Relations.Add("Branch", ds.Tables["Company"].Columns["CompanyID"], ds.Tables["Branch"].Columns["CompanyID"]); this.gridCompany.SetDataBinding(ds.Tables["Company"], ""); this.gridBranch.SetDataBinding(ds.Tables["Company"], "Branch"); this.tbCode.DataBindings.Add("Text", ds.Tables["Company"], "Branch.Code"); this.tbStreet.DataBindings.Add("Text", ds.Tables["Company"], "Branch.Street"); Now if I update textbox tbCode of tbStreet and then click the update button which updates DT changes back to database nothing happens BUT if I after updating TextBox click the DG then it will update changes back to DB. How do I make so that the TextBox will update the DT immediately it loses focus? Do I need to use some refreshing code on TextBox.Leave event? Or some additional code on my Update button? Thanks, Oka Morikawa Tag: Help with DataSet.Table.Rows.Find method Tag: 81486
  - 14
    - How to return SCOPE_IDENTITY as integer? Thanks Tag: Help with DataSet.Table.Rows.Find method Tag: 81483
  - 15
    - Object reference not set to an instance of an object Hi All, I have an intermittent problem with an SQLDataAdapter.Fill command. Every now and then the system returns an "Object reference not set to an instance of an object" right after filling the Address table. Public Sub GetProfileTables(ByVal strSQL As String) Dim cnn As New SqlConnection("Server=localhost; Database=myDatabase; UID=user; PWD=password;") _profileSet = New DataSet("Profile") cnn.Open() 'Get the profile tables information ' The SQL statement would be something like SELECT * FROM vwProfile WHERE profile_key = 1110201 ' where the profile key basically is different depending on the record being viewed. Dim daProfile As New SqlDataAdapter(strSQL, cnn) daProfile.Fill(_profileSet, "Profile") _profileView = _profileSet.Tables("Profile").DefaultView 'Get the profile addresses strSQL = "select * from address where profile_key = " & _profileView(0)("profile_key") daProfile.SelectCommand = New SqlCommand(strSQL, cnn) daProfile.Fill(_profileSet, "Address") 'Define the parent and child columns Dim parentCol, childCol As DataColumn parentCol = _profileSet.Tables("Profile").Columns("profile_key") childCol = _profileSet.Tables("Address").Columns("profile_key") ' **THIS IS WHERE THE ERROR OCCURS** 'Define the relationship of the data Dim drProfile As DataRelation drProfile = New DataRelation("ProfileAddress", parentCol, childCol) _profileSet.Relations.Add(drProfile) cnnITT.Close() End Sub Any suggestions? Thanks Ryan Tag: Help with DataSet.Table.Rows.Find method Tag: 81482
  - 16
    - Timeout Expired exception Hi, I have a question regarding the "Timeout Expired" excetpion. We have a database server running SQL 2000, and another computer accessing the database server using ADO.NET (via a CAT 5 cable directly). Occationally, I get a "Timeout Expired" exception tring to access database server. I do notice that the clock on the two computers may be drifted as far away as 6 minutes. Can this contribute to the timeout exception? In the sense of robust programming, what should I do in my code to survive these kind of exceptions? Thanks, Guogang Tag: Help with DataSet.Table.Rows.Find method Tag: 81479
  - 17
    - using xsd and datasets with XmlDataDocument I have the following xml: <message> <envelope> <body key="" value="" /> </envelope> </message> I have associated an xsd to this xml in order to use the XmlDataDocument and give me the possibility to access the data through a dataset in the manner below specified: DataSet ds = XmlDataDocument.DataSet; When I try to add an element of type "body" to this xml file, this tag is added to the node "message" while I want to add it to the node "envelope". Here is the code which I use to do this task: DataRow dr = ds.Tables["body"].NewRow(); dr["key"]=126; dr["value"]="example"; ds.Tables["body"].Rows.Add(dr); and here is the resulting xml: <message> <envelope> <body key="" value="" /> </envelope> <body key="126" value="example" /> </message> while I want the following result: <message> <envelope> <body key="" value="" /> <body key="126" value="example" /> </envelope> </message> Last but not least when I try to get the attribute values of the node inserted in the xml by the previous code I don't have any problem even if the xsd doesn't allow a "body" tag out of the "envelope" tag. For example: foreach(DataRow row in ds.Tables["body"].Rows ) { if (row[0].ToString() == "126") { myVariable = row[1].ToString(); break; } } How can I avoid to append the node inserted by code to the root node using the dataset and its related classes ? How can I insert the new node correctly inside the envelope element (always using datasets) ? Every suggestion will be appreciate, thanks in advance Tag: Help with DataSet.Table.Rows.Find method Tag: 81478
  - 18
    - How Deadlock are handled in ADO.NET Hello everyone, I want to know how it work in ADO.NET when a DEADLOCK occur and a victim is choosen? Is an exception raised? Thank's Carl Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Help with DataSet.Table.Rows.Find method Tag: 81476
  - 19
    - How to access .edb files I need to access the data in a .edb file, which is the type of database used by the Windows System Resource Manager, natively in my C# application. I can't seem to find a data provider that will connect to it, though. Although the WSRM stores the .edb file in a folder called "Jet DB", none of the existing Jet providers will connect to it (the usual Jet extension is .mdb) Does anyone know how I can access this data? Right now I have to open up the WSRM, manually export the data to a text file, and then work with it from there. It's not a very good permanent solution Thanks Jeff Tag: Help with DataSet.Table.Rows.Find method Tag: 81467
  - 20
    - timout error on server running vb .net routine I'm getting the following error - not always, only randomly - when I run a certain routine (the routine is a simple executenonquery and it appears to complete despite the message) against sql server 2000: "timout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" Anyone have any idea what causes this and how to avoid it? Thanks for any help. Bernie Yaeger Tag: Help with DataSet.Table.Rows.Find method Tag: 81460
  - 21
    - Help with Net Provide for Oracle... Hello All I am using the 1.1 framework, and the Microsoft Oracle Provider for .net, and have oracle Client (8.1.7) installed The problem I am having is that I am querying an Oracle 7.3 Database, which does not support double-bit characters, but upon querying the database, it appears that all varchar2 fields are coming back as kanji or something, whereas dates and ints are returning correctly I have tried changing the connection string from unicode=true, even unicode=false, and not having it all all, but I still get the same results Also, I have connected using the typical OLEDB connection, which returns the data correctly, but would prefer the Oracle Provider for .net Any help would be great. Tag: Help with DataSet.Table.Rows.Find method Tag: 81459
  - 22
    - ASP update to database, need sample or tutorial In preparation for an app that will be a simple ASP.NET page with about 40 text boxes I need sample to do the following: 1. Select the current data (done) 2. Bind to the textboxes (done) 3. When user clicks the update button the page will update the data in the database. Existing code: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here If Not Page.IsPostBack Then Me.SqlConnection1.Open() Me.SqlDataAdapter1.Fill(Me.TerrDataSet) Me.DataBind() Me.SqlConnection1.Close() End If End Sub The above works and shows the value of the fields in the text boxes. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim picnt As Integer Me.SqlConnection1.Open() Try picnt = Me.SqlDataAdapter1.Update(Me.TerrDataSet) Catch ex As Exception Dim s As String = ex.Message End Try Me.SqlConnection1.Close() End Sub This code shows a count of 0 for the Update??? Tag: Help with DataSet.Table.Rows.Find method Tag: 81458
  - 23
    - Thanks for everyone's feedback Looks like I've got a lot of reading to do : As I understand the concept of Singleton objects, they can only be instantiated once. Then, all other calls to that object rely on that previously created instance. If you have 300 hundred users, and each of them are doing multiple things (i.e. pulling data, executing stored procedures, etc..), and each time some communication to the data layer takes place, it must filter through that ONE instance (the Singleton obj) because IT is set up to be your data access object, then how does this architecture benefit you? Would it not become a bottle-neck due to their being only the one instance of it Tag: Help with DataSet.Table.Rows.Find method Tag: 81455
  - 24
    - Dataset persistence Hi I'm relatively new to .NET technologies and basically I need this information. We would like to persist the data returned from a database and present the user in Excel/?/Customized GUI Application in order to make him to change the data. Finally all the data updated are to committed back in Database. I know data persistence is possible using dataset but can guide some kind of examples/cod Is it possible to present the persisted data in Excel or I have to build a customized application? Please some links/examples/samples please I appreciate your assistance TIA Holy Tag: Help with DataSet.Table.Rows.Find method Tag: 81451
  - 25
    - passing comma delimited string in parameterized query Hello, I am having a problem with passing a comma delimited string as a parameter to be used in the IN() clause for a record selection. What I want to do is select all customer who have a surname that matches one in a specified list, which I pass in as a parameter to the query. I am working in VS.Net and through the designer set up a Sql Command object, the following is generated 'SqlCommand1 Me.SqlCommand1.CommandText = "SELECT * FROM Customer WHERE (SurName IN (@SurNameList))" Me.SqlCommand1.Connection = Me.SqlConnection1 Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SurNameList", System.Data.SqlDbType.VarChar)). In my code I set SqlCommand1.Parameters("@SurNameList").Value = "Murphy,Sullivan,Lyons" I know there are customers with these surnames in the DB but my datareader is empty. I also have tried "'Murphy','Sullivan','Lyons'" but no good. Any suggestions very much appreciated, Thanks, Kay. Tag: Help with DataSet.Table.Rows.Find method Tag: 81444

Find method can search a row according to tables PrimaryKey, my question
here is, if the primary key contains multiple fields (columns) with
different data types. how should I use Find method in this case?

Thanks!

Top

Re: Help with DataSet.Table.Rows.Find method by Miha

Miha
Thu Mar 04 14:40:33 CST 2004

Hi X-Man

There is an overload that acceps an object array.
Pass values in the same order as columns in pk.

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

"X-Men" <xtan@arbin.com> wrote in message
news:eQWpkSiAEHA.2804@tk2msftngp13.phx.gbl...
> Find method can search a row according to tables PrimaryKey, my question
> here is, if the primary key contains multiple fields (columns) with
> different data types. how should I use Find method in this case?
>
> Thanks!
>
>

Top