WQL DataProvider for ADO.Net

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
    - KB article 830118 "Timeout Expired" - Cause? Hello, I have just had a bad experience upgrading a Windows Forms app from vb.net 2002 -> vb.net 2003. I experienced the problem as detailed in KB article 830118. According to the article, this behaviour is by design. Can someone please explain to me what the design goal was, and what is going on "under the hood" to cause this? Will it be resolved in future service packs and/or .net versions? Thanks. Tag: WQL DataProvider for ADO.Net Tag: 93826
  - 2
    - Renumbering MS db ID? I have a small MS db which I update daily with new info. I've noticed that the ID numbers are increasing sequentially. How can I reset them back to 1 when I purge my data prior to adding in the new stuff? Here is how I'm currently deleting the info from my db (TSUpdate): Private Sub ClearMyData() ' Open Connection and Clear Data OleDbConnection1.Open() Dim MyCommand As New OleDbCommand("DELETE FROM TSUpdate", OleDbConnection1) MyCommand.ExecuteNonQuery() OleDbConnection1.Close() MyCommand.Dispose() End Sub Thanks in advance! Bruce Tag: WQL DataProvider for ADO.Net Tag: 93824
  - 3
    - number of connection Hi How can I know how many connections is estabilished with database in SQL Server? Thanks Konrad Tag: WQL DataProvider for ADO.Net Tag: 93820
  - 4
    - Problems in reading excel data Hello All I'm having some problems in reading excel data. The connection string is like this connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=" connectionString += "\"Excel 8.0;HDR={1};IMEX=1;ReadOnly=0;\""; It's not reading data which has an F appended to it (with any Alpohabet as suffix), like in 49844F or 32535X which is in coln called STOCK_NO. Any other numeric data, like 49929 is being read fine. This coln is being read into a column of type string and it's coming in as empty string since the resultant DataSet's xml is looking like this <MASTER> <RECD_DTE>2004-07-06T00:00:00.0000000-05:00</RECD_DTE> <STOCK_NO /> <MANUF_PRICE>42565</MANUF_PRICE> <INV_AMT>29960</INV_AMT> <LOW_PRICE>29661</LOW_PRICE> <SAVINGS>12904</SAVINGS> </MASTER> <MASTER> <RECD_DTE>2004-07-02T00:00:00.0000000-05:00</RECD_DTE> <STOCK_NO>49929</STOCK_NO> <MANUF_PRICE>47140</MANUF_PRICE> <INV_AMT>40212</INV_AMT> <LOW_PRICE>37810</LOW_PRICE> <SAVINGS>9330</SAVINGS> </MASTER> Any help is greatly appreciated. thanks Sunit Tag: WQL DataProvider for ADO.Net Tag: 93815
  - 5
    - ADO.net update problem with VB and MS Access Greetings all, This is a repost. I had to put this down for a while, but now I have to get it running. I am using an Access Database to store question information for a questionnaire application. I am using VB.net as the front end, and ADO.net to retrieve the information from the database. My data is bring displayed in a DataGrid bound to a dataset. All of my calls to the database are to parameter queries. The problem that I am having is with the update command. When I call the update method for my data adapter, and pass a dataset containing just the changed records, only one record shows the change. I know that parameter queries work because data is being returned and update, just not in the quantities that I want. From what I have read, the update method in ADO.NET should be able to process a batch change, but the only specific information I have been able to find concerns SQL Server and not MS Access. The only information I have been able to find regarding the update method and MS Access were for single records. Does ADO.net send each update request separately, waiting for conformations between requests, or does it send all of the changes at once? I know, if you write the queries properly, SQL server can process the data in a lump sum, but I do not believe Access has that ability. Below is a copy of the offending code. Any help on this would be greatly appreciated. Thanks in advance, Edison Private Sub SaveData() Dim lRetVal As Long Dim oQuestions As Questions = New Questions Dim oDS_Changes As DataSet = New DataSet Dim sMsg As String 'Stop current edits 'Me.BindingContext(m_oDS).EndCurrentEdit() 'Grab all changed rows oDS_Changes = m_oDS.GetChanges 'Check to see if any changes have been made If (Not (oDS_Changes) Is Nothing) Then sMsg = "Are you sure you want to save these " & _ oDS_Changes.Tables(0).Rows.Count() & " rows to the database?" _ lRetVal = MsgBox(sMsg, Microsoft.VisualBasic.MsgBoxStyle.Question + _ Microsoft.VisualBasic.MsgBoxStyle.YesNo, "Save Records") Select Case lRetVal Case vbYes Try ' Save all changes oQuestions.SaveData(oDS_Changes) m_oDS.AcceptChanges() Catch updateException As System.Exception Throw updateException Catch e As Exception Throw e End Try Case vbNo 'Do nothing End Select End If End Sub Public Function SaveData(ByVal oDS As DataSet) As String Dim strMsg As String Dim lngRecsAffected As Long Try If (Not (oDS) Is Nothing) Then 'open connection to Database m_oCn.Open() 'attempt to update the data source da.Update(oDS, strClassName) End If Catch updateException As System.Exception Throw updateException Finally 'Close the Database Connection m_oCn.Close() End Try End Function Dim cmdSel As OleDbCommand Dim cmdIns As OleDbCommand Dim cmdUpd As OleDbCommand Dim cmdDel As OleDbCommand Dim strSQL As String 'Setup Select Command strSQL = "QryQuestion" cmdSel = New OleDbCommand(strSQL, m_oCn) cmdSel.CommandType = CommandType.StoredProcedure 'Setup Insert Command strSQL = "addqryQuestion" cmdIns = New OleDbCommand(strSQL, m_oCn) cmdIns.CommandType = CommandType.StoredProcedure cmdIns.Parameters.Add("QuestionText", OleDbType.LongVarWChar, 255, "Question_Text") cmdIns.Parameters.Add("CorrectAnswer", OleDbType.BigInt, 1, "Correct_Answer") cmdIns.Parameters.Add("QuestionNumber", OleDbType.BigInt, 1, "Question_Number") 'Setup Update Command strSQL = "updqryQuestion" cmdUpd = New OleDbCommand(strSQL, m_oCn) cmdUpd.CommandType = CommandType.StoredProcedure cmdUpd.Parameters.Add(New OleDbParameter("@QuestionNumber", OleDbType.BigInt, 50, "Question_Number")) cmdUpd.Parameters.Add(New OleDbParameter("@QuestionText", OleDbType.LongVarWChar, 255, "Question_Text")) cmdUpd.Parameters.Add(New OleDbParameter("@CorrectAnswer", OleDbType.BigInt, 50, "Correct_Answer")) cmdUpd.Parameters.Add(New OleDbParameter("@QuestionID", OleDbType.BigInt, 50, "Question_ID")).SourceVersion = DataRowVersion.Original 'Setup Delete Command strSQL = "delqryQuestion" cmdDel = New OleDbCommand(strSQL, m_oCn) cmdDel.CommandType = CommandType.StoredProcedure cmdDel.Parameters.Add("QuestionID", OleDbType.BigInt, 50, "Question_ID") initalizeDataAdapter(cmdSel, cmdIns, cmdUpd, cmdDel) End Sub Protected Sub initalizeDataAdapter(ByVal cmdSel As OleDbCommand, ByVal cmdIns As OleDbCommand, ByVal cmdUpd As OleDbCommand, ByVal cmdDel As OleDbCommand) 'Create and Setup Data Adapter da = New OleDbDataAdapter 'Setup Select Command da.SelectCommand = cmdSel 'Setup Insert Command da.InsertCommand = cmdIns 'Setup Update Command da.UpdateCommand = cmdUpd 'Setup Delete Command da.DeleteCommand = cmdDel 'Destroy connection object ' m_oCn.Close() End Sub Tag: WQL DataProvider for ADO.Net Tag: 93812
  - 6
    - sp_setapprole encryption and .NET If I run exec sp_setapprole @rolename='app',@password={Encrypt N'app'},@encrypt='odbc' from MS query analyzer it sets up okay. I have a guest account in the public role in the database I connect to run this. If I am my .Net program and try to run it as follows strConn="Initial Catalog=MyDB;Data Source=MyServer;user id=guest"; SqlConnection oConn=new SqlConnection(strConn); oConn.Open(); SqlCommand oCmd=new System.Data.SqlClient.SqlCommand("exec sp_setapprole @rolename='app',@password={Encrypt N'app'},@encrypt='odbc'",oConn); iResult=(int)oCmd.ExecuteNonQuery(); It throws an error 'Encrypt' is not a recognized ODBC date/time extension option. If I take out the Encrypt part, as shown below, it works fine. SqlCommand oCmd=new System.Data.SqlClient.SqlCommand("exec sp_setapprole @rolename='app',@password='app',@encrypt='odbc'",oConn); Any ideas on the error? Tag: WQL DataProvider for ADO.Net Tag: 93810
  - 7
    - SqlDataAdapter and Update grams Does anyone know if theres ever been any development effort of writing an extended version of SqlDataAdapter that uses updategrams to update a dataset. I'm curious if the reduced network round trips would be a sizable performance gain. An entire dataset worth of updates/inserts/deletes could be sent in one request, instead of many. If so, please point me at a link, if not please provide feedback on why you think this would or would not be a good idea to do. Thank you. Tag: WQL DataProvider for ADO.Net Tag: 93808
  - 8
    - CrystalReports.Engine.LogOnException with DataSet Hello! I have a problem: a created a crystal report based on a DataSet in the project (chosen in the first step of the CrystalReports wizard). When I try to access the report (for ex. by the report viewer9 I get crystalDecisions.Engine.LogOnException with additional information: Logon failed. It seems I have to logon to the DataSet!? How can I solve this problem?? Thanks! Tag: WQL DataProvider for ADO.Net Tag: 93807
  - 9
    - How to Use Openschema ? Hi, I would like to read all the tabs stored in a Excel sheet. How can I do this with Ado.net (vb.net). I suppose I have to use the OpenSchema method, but I can't see how (I used to do it with ado). Thanks for your help Stan Tag: WQL DataProvider for ADO.Net Tag: 93797
  - 10
    - select top and next Hi I'am using select top 10 clause to load DataSet Ho to get next 10 rows (from 11 to 20) to DataSet? Thanks Konrad Tag: WQL DataProvider for ADO.Net Tag: 93795
  - 11
    - Know the DataReader associated with a Connection Hi, Is it possible to know the associated DataReader of a Connection? I know that there can only be a single open DataReader linked to a Connection; my question is: how do I get a pointer to that instance (if there is one) just knowing the Connection? Thank you, Peter. Tag: WQL DataProvider for ADO.Net Tag: 93783
  - 12
    - a simple question I have a simple question here, ConnectToDB(); string queryString = "SELECT Owner,Description FROM Groups WHERE Title = 'BOSS'"; MySqlCommand myCmd = new MySqlCommand(queryString,mycon); try { lblOwner.Text = (string)myCmd.ExecuteScalar(); } finally { myCmd.Dispose(); mycon.Dispose(); } it's only get one(Owner) value back, so what I need to do so I can pull both Owner and Description from database? Thansk in advance. Tag: WQL DataProvider for ADO.Net Tag: 93780
  - 13
    - Updating from active record Hello All! I have a DataTable connected to Windows Forms controls thru databinding. The DataTable gets its data from the controls if the user moves te cursor, e.g. in a binded list. Is there a simple method to pass the fresh data to the DataTable without moving the cursor in the list? Thanks, Sztyopi Tag: WQL DataProvider for ADO.Net Tag: 93777
  - 14
    - Dataview Rowfilter misbehaving Hi, I have a dataview with a rowfilter of: "Column <= '~'". The strange thing is that if I run the code using Visual Studio debugger then I get the expected rows. However when I build the code into its assemblys and run it outside of visual studio then I do not get the expected rows. The underlying Datatable and Dataset are set for CaseSensitive=True. Following is a snippet of the code and some console output: CONTACTS(LOAD): UA: w DataviewRowCount: 1 CONTACT_TYPE_PL <= 'w' R True 1 Dim privchar As String If "~()#\/=><+-*%&|^'""[]".IndexOf(Me._synonyms.UserPriv) >= 0 Then privchar = "\" + Me._synonyms.UserPriv Else privchar = Me._synonyms.UserPriv End If ContactDataView = New DataView(Me._stuadrk, _ "CONTACT_TYPE_PL <= '" + privchar + "'", _ "SEQUENCE_NO", _ DataViewRowState.CurrentRows) Console.WriteLine("CONTACTS(LOAD): UA: " + Me._synonyms.UserPriv + " DataviewRowCount: " + ContactDataView.Count.ToString) Console.WriteLine(Chr(9) + ContactDataView.RowFilter) For Each DR As DataRow In Me._stuadrk.Rows Console.WriteLine(Chr(9) + DR.Item("CONTACT_TYPE_PL") + Chr(9) + (CType(DR.Item("CONTACT_TYPE_PL"), String) <= Me._synonyms.UserPriv).ToString + Chr(9) + CType(DR.Item("SEQUENCE_NO"), Integer).ToString) Next This is the console output: CONTACTS(LOAD): UA: ~ DataviewRowCount: 0 CONTACT_TYPE_PL <= '\~' R True 1 As I said if I run this code in Visual Studio it returns the following output: Tag: WQL DataProvider for ADO.Net Tag: 93776
  - 15
    - Drowning in the connection pool This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C48124.05EA6670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable First let me state for the record I have searched and tried all = suggestions I have found, and nothing seems to have helped so far.=20 I have 2 threads created to update a UI w/data from the database. The = connection/command/reader object are all declared outside of the try = statement, and then closed/disposed in the finally portion. The = connections are not left open for any length of time greater than what = is needed.=20 I get "Timeout expired. The timeout period elapsed prior to obtaining a = connection from the pool." when.. 1) I am connection to the database remotely via VPN over cable modem -and- 2) using this connection string (note the integrated security) public const string sConnect =3D "persist security info =3D False;packet = size =3D 8192;data source=3DMYSERVER;Integrated Security =3D = true;initial catalog=3DMYDB"; I don't get that error when.. 1) I am NOT trying to connect over VPN -OR- 2) When I use this connection string (NOT using integrated security) public const string sConnect =3D "uid=3Dsa;pwd=3Dxxxxx;packet size =3D = 8192;data source=3DMYSERVER;persist security info =3D False;initial = catalog=3DMYDB"; This issue pretty much started when I tried to switch over to my final = settings of not using the sa account and using Windows security for the = users. Am I missing a setting on the server or client? Turning = pooling off isn't overly viable since it slows to a dead crawl. ------=_NextPart_000_000B_01C48124.05EA6670 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> <DIV><FONT face=3DArial size=3D2>First let me state for the record I = have searched=20 and tried all suggestions I have found, and nothing seems to have helped = so far.=20 </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have 2 threads created to update a UI = w/data from=20 the database.  The connection/command/reader object are all = declared=20 outside of the try statement, and then closed/disposed in the finally=20 portion.  The connections are not left open for any length of time = greater=20 than what is needed. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I get "Timeout expired.  The = timeout period=20 elapsed prior to obtaining a connection from the pool."</FONT></DIV> <DIV><FONT face=3DArial size=3D2>when..</FONT></DIV> <DIV><FONT face=3DArial size=3D2>1) I am connection to the database = remotely via VPN=20 over cable modem</FONT></DIV> <DIV><FONT face=3DArial size=3D2>-and-</FONT></DIV> <DIV><FONT face=3DArial size=3D2>2) using this connection string (note = the=20 integrated security)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>public const string sConnect =3D = "persist security=20 info =3D False;packet size =3D 8192;data source=3DMYSERVER;Integrated = Security =3D=20 true;initial catalog=3DMYDB";</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV>I don't get that error when..</DIV> <DIV>1) I am NOT trying to connect over VPN</DIV> <DIV>-OR-</DIV> <DIV>2) When I use this connection string (NOT using integrated = security)</DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>public const string sConnect =3D=20 "uid=3Dsa;pwd=3Dxxxxx;packet size =3D 8192;data = source=3DMYSERVER;persist security info=20 =3D False;initial catalog=3DMYDB";</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>This issue pretty much started when I = tried to=20 switch over to my final settings of not using the sa account and using = Windows=20 security for the users.  Am  I missing a setting on the server = or=20 client?  Turning pooling off isn't overly viable since it slows to = a dead=20 crawl. </FONT></DIV></BODY></HTML> ------=_NextPart_000_000B_01C48124.05EA6670-- Tag: WQL DataProvider for ADO.Net Tag: 93772
  - 16
    - Bug on DataRow object´s GetColumnsInError method According to .NET Framework v1.1 Documentation, the DataRow object´s GetColumnsInError method gets an array of columns that have errors. This description made me think, develop and test a .NET Windows Application in a disconnected scenario. This application has a WindowsForm with a SqlDataAdapter object that fills a DataSet object. The resultant relational data is then displayed on a DataGrid control. At this time, the data can be modified. In this situation, various instances of the same .NET Windows Application running simultaneously can generate a System.Data.DBConcurrencyException when the SqlDataAdapter object´s Update method is called. Note that the SqlDataAdapter object is configured to use optimistic concurrency. If this exception occurs, the exception-handling structure´s Catch block can implement code to show, for example, a friendly message to the user detailing the accurate cells that had caused the errors. DataSet, DataTable and DataRow objects have the boolean property HasError that help developers to find rows with errors. The only information missing to show in the friendly message is the columns with these errors. To discriminate only the rows is not enough. To get these columns, the perfect method would be GetColumnsInError of the DataRow object. But concurrency exceptions do not set errors in DataColumns objects. In other words, the GetColumnsInError method do not return any columns. I assume that this behavior is a bug. Is there another way to reach this goal? Thank´s, Otávio F. Ferreira Filho [Microsoft Certified Professional] Tag: WQL DataProvider for ADO.Net Tag: 93770
  - 17
    - Execute Multiple Scripts from one directory I got tired of having to execute multiple scripts one at a time from my testing server to my production server. So I decided to create a batch routine that utilizes the command line routine OSQL. All you have to do to use it is place the batch file in a directory containing your SQL scripts and execute the batch file. I have placed in the command the argument to print a result file for each sql script. If you need your SQL scripts run in a particular order simply rename them accordingly. i.e. 001_updatecustomer.sql, 002_update_sp.sql enjoy REM ############################################# REM Author: Joe Ocampo REM Date: 04/17/2004 REM Version: 1.0.1 REM ############################################# REM You must execute the script from the SQL server itself REM and you must use the SA login or the DBO login of the REM target database. REM ############################################# SET login=sa SET password=password SET server=local SET database=pubs for %%a in (*.sql) do osql -d %database% -U %login% -P %password% -i %%a -o %%a_result.txt Tag: WQL DataProvider for ADO.Net Tag: 93767
  - 18
    - Datareader type conversion I have some data stored in a column of Int16 type (for compactness and convenience) in a Jet 4 database. I'd like to retrieve it into a datareader converted to double type and divided by 10 to restore its true value. Is this possible please (using VB.Net)? So what I'd like to do is have a select string along the lines of: SELECT CDbl(Col_A/10) SomeName, Col_B ...etc FROM etc But if indeed this is a permitted process I can't find what the correct syntax should be. Using the sort of example above just gives me a missing operator error. TIA JGD Tag: WQL DataProvider for ADO.Net Tag: 93765
  - 19
    - Array to Database I'm using OLEDB in .NET to get my data into a database. The data starts off in an 2-D array of singles where the first dimension represents columns in a database table and the second dimension represents rows in the same table. At the moment I have a single connection & transaction and I am loading the data into the database by iterating through the array and creating an INSERT OLEDBCommand for each row in the array and then executing the command. This works but is very slow. Is there a quicker way to get an array such as mine into the database? -- Cheers, elziko Tag: WQL DataProvider for ADO.Net Tag: 93761
  - 20
    - Adding columns to a datareader Is there a way of adding a derived column to a datareader once the data reader has been populated or do I need to use a dataset/datatable for this? (I need to apply a function to one of the columns in a way that can't be done within a Select expression and so the only way I can see of doing this is - in theory at least - to add a column to the dr and then to populate that added column.) Presumably if I do add a column to either dr or ds/dt I'll need to iterate through every row to create the new value. Or is there a way of applying a function to a column in a single operation? TIA JGD Tag: WQL DataProvider for ADO.Net Tag: 93753
  - 21
    - [ANN] Firebird ADO.NET Data Provider 1.6.1 released Hello: The Firebird ADO.NET Data Provider 1.6.1 is available for download. Release notes can be found here: http://www.firebirdsql.org/index.php?action=view_item&topic=1092389058 Download information can be found here: http://www.firebirdsql.org/index.php?op=files&id=netprovider Release notes: 1.6.1 ( 2004-08-13 ) ----- - ---- -- -- - * Bug Fixes (Please review the changelog for details) - Fixed bug #1007104 - Fixed bug #995178 - Fixed bug #998002 - Fixed bug #1000160 - Fixed bug #1003519 * Removed the limitation of one DataReader per connection. (Now you can have many DataReader's per connection and only one per command). * Changes on Database schema support: * All source files has been renamed to remove the Schema suffix (FbTablesSchema.cs -> FbTables.cs) The same for the class names. * There are a new 'Restrictions' schema that will return the restriction columns for each schema. * There are new columns in some schemas: XXXX_CATALOG XXXX_SCHEMA That will make the returned schemas more general and compatible with other databases (what will be nice for .net 2.0 as the schema support is in the System.Data.Common.DbConnection class) These new columns are restriction columns as well (the value will be null always) * New schemas. - DataTypes. Returns the data types information. - MetaDataCollections. Returns all the supported schemas, and the number of restrictions of each one - Restrictions. Returns the restriction columns of each schema. * New FbConnection methods. - GetChema() - GetSchema(string) - GetSchema(string[]) * Changes on the names of the FbDbSchemaType elements to remove the underscore. ** Some of the changes in the Schema Results are: ** * Columns Schema. - The COLUMN_DATA_TYPE now holds the datatype name. - Added new IS_ARRAY column. - Removed PROVIDER_TYPE, PRIMARY_KEY and UNIQUE_KEY columns. (The reason is that the query with that columsn gets a lot time to be executed in databases with complex metadata) * Tables schema. - The IS_SYSTEM_TABLE column now will have aloways 0/1 as values. - Not it's no possible to filter by the IS_SYSTEM_TABLE column, instead filter by TABLE_TYPE can be done using: a. TABLE b. VIEW c. SYSTEM TABLE * Domains Schema. - The COLUMN_DATA_TYPE now holds the datatype name. * ProcedureParameters Schema. - The COLUMN_DATA_TYPE now holds the datatype name. * ViewColumnUsage Schema. - The COLUMN_DATA_TYPE now holds the datatype name. * Generators schema. * The IS_SYSTEM_GENERATOR column now will have always 0/1 as values. * Functions schema. * The IS_SYSTEM_FUNCTION column now will have always 0/1 as values. * Triggers schema. * The IS_SYSTEM_TRIGGER column now will have always 0/1 as values. * ForeignKeys schema: * The order of the restriction columns is changed: 1. PK_TABLE_CATALOG 2. PK_TABLE_SCHEMA 3. PK_TABLE_NAME 4. FK_TABLE_CATALOG 5. FK_TABLE_SCHEMA 6. FK_TABLE_NAME CVS Tag: NP_1_6_1 -- Best regards Carlos Guzmán Álvarez Vigo-Spain Tag: WQL DataProvider for ADO.Net Tag: 93752
  - 22
    - Refreshing dataset in Visual Studio. Hi, I have growed tired of deleting and then recreating a dataset every time I need to refresh it's column information. Is there some way to "refresh" a dataset? If not, this must be one of the most cumbersome issues with ADO.NET I have experienced so far... Thanks in advance for any suggestions, Trygve Tag: WQL DataProvider for ADO.Net Tag: 93750
  - 23
    - Oracle distributed transaction I'm using the System.Data.OracleClient namaspace and I get he following problem. In the main thread I open a connection to the database, I query the DB retrieving all the available stored procedure, allowing the user through a GUI to pick a stored procedure a execute it in parallele in different thread. Every thread open a new connection to the DB ! But if the stored procedure issue a rollback statement I get an error from oracle: i can't rollback in a distributed transaction ! But I really don't need a distributed transaction ! I would that any thread session had its ownn transaction ! Any suggestion ? Tag: WQL DataProvider for ADO.Net Tag: 93747
  - 24
    - How To read tab delimited file using ADO, Connect to text driver? Hi, I can connect to text file driver with coma delimited file, how not Tab delimited? if I use the following : conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & _ "DBQ=" & sFilePath & ";FMT=TabDelimited;", "", "" it does not work. Thanks Jessie Tag: WQL DataProvider for ADO.Net Tag: 93742
  - 25
    - ASP v2 & 3-tier or 2-tier Dear All, ASP 2 introduces a lot of controls that bind directly to a database. Obviously, this does not work for everything so it seems to me that one ends up with a mixture of 2-tier and 3-tier model. This in my opinion is quite bad as I really would like to see the same structure for the whole app. Can somebody with experience in asp 2 comment on that? How are you handling this? Regards, Rob Tag: WQL DataProvider for ADO.Net Tag: 93741
- Next
  - 1
    - Excel to Dataset? Hi All, How to import data from Excel to dataset? Code please,if Possible. -- Cheers, Akhil Tag: WQL DataProvider for ADO.Net Tag: 93735
  - 2
    - How to query a DBF with index by OLEDB? Hi all, Is there any way to connect the dbf with oledb and using .idx index file? Because i find that it is very slow when the dbf is large. Thanks Tag: WQL DataProvider for ADO.Net Tag: 93733
  - 3
    - DB connection problem I have a SqlServer database which I try to access from the CompactFramework/PocketPC. In my connection string I haven't specifyed the database as I want to query them throught the sp_databases stored procedure. But I have specifyed and administrator user/password. When I try to connect to the server it returns the following SQL error: "not associated with a trusted SQL Server connection" What could it be? All I found on the net was some NTLM authentification problem, but I guess my problem is different, it's not a web browser issue! -- Lloyd Dupont, Software Architect Get Your Data Mobile http://www.ihookdb.com Tag: WQL DataProvider for ADO.Net Tag: 93723
  - 4
    - weird connection error Hi guys, I have 2 data adapters da1 and da2, 1 connection con1, and one data set ds1. I use the same connection for all this data adapters. when I change from one record to other on the table JOBS under da1 it trigger one event. In this event, I have a code like System.Windows.Forms.BindingManagerBase bc; bc = this.BindingContext[this.ds1, "jobs"]; this.ds1.WorkEmp.Clear(); if (bc.Count>0) { System.Data.DataRow drv; drv = this.ds1.jobs.Rows[bc.Position]; this.daWorkEmp.SelectCommand.Parameters["njob"].Value=Convert.ToInt16(drv["njob"]); try { this.daWorkEmp.Fill(this.ds1.WorkEmp); // ERROR HAPPENS HERE } catch (Exception e3) { MessageBox.Show(e3.ToString()); return ; } } I got this error message "System.invalidOperationException: there is already an open DataReader associated with this connection which must closed first" WorkEmp.SelectCommand is a like SELECT b.firstname, b.lastname, a.empid, a.njob, b.empid AS Expr1 FROM WorkOn a INNER JOIN employee b ON a.empid = b.empid WHERE (a.njob = ?) I'm missing something??? I use the same logic in other modules with other tables and it works. I appreciate any help, thanks Tag: WQL DataProvider for ADO.Net Tag: 93721
  - 5
    - How to query a dataset more easier Is there an easier way to query a dataset other than doing the following code: I just want to set a variable based on the value of a input paramenter. foreach(DataRow currentRow in dsAllData.Tables["WorkSheet"].Rows) { if (currentRow["WRKBK_CD"] == WorkSheet_Code) { WorkSheet_Name = currentRow["WS_NM"].ToString(); } } Tag: WQL DataProvider for ADO.Net Tag: 93720
  - 6
    - Bill Vaughn's "Identity Crisis" article I've read the article on using Identity in disconnected scenarios, http://www.ftponline.com/reports/vsliveor/2002/09_17_02/vaughn/default.asp, and while I got much out of it, one thing wasn't so obvious. Once you do an Insert, and retrieve the identity IDs with the output parameters (so far, so good), how does the row receive that ID? I have a scenario where I try to delete from a datagrid immediately after Inserting a row. I've not resolved how to stop the concurrency error, despite retrieval of the identity ID as an output parameter in the stored procedure. Running the delete code when I have not inserted a row works fine. Tag: WQL DataProvider for ADO.Net Tag: 93717
  - 7
    - invalid object name SqlClientException !!! Hi All, I am very new to this ADO.net. I installed MSDE,VS.NET on WIN2000 and I passed the database connectivity hurdles. When I run a simple select statement I am getting an error as "invalid object name SqlClientException !!!", and when I do a count(*)on the table or @@SERVERNAME/db_name(), I am getting the +ve result whereas the table is existing in the database. Can some one help me with this ::: my Sql Statement is like this " Select Name,Email,Address from Employee " and even i tried " Select Name,Email,Address from [Employee] " Any help is greatly appreciated in advance. Thanks, bulbul --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: WQL DataProvider for ADO.Net Tag: 93714
  - 8
    - System.Data.SqlClient "Timeout expired" causing ASP.net web application to automatically restart. I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server that is experiencing strange shutdown problems. We are using ASP.NET v1.1 and our application is written in VB.NET Here's the scenario: 1. .NET Windows Client on a remote machine makes a web service call to update tables on a Web Server running SQL Server 2000. 2. The Update is updating about 1000 - 3000 records doing simple update statements like "Update transactions Set UpdateTime = '08/12/2003 04:30:00 PM' " 3. The SqlClient code is receiving the error message below: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec t stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HorizonBoss.Framework.DataAccess.HZSqlFactory.ExecuteNonQuery(HZRequest request) in C:\projects\dotnet\Fish.NET\HorizonBoss\Framework\DataAccess\HZSqlFactory.vb :line 359 2004-08-12 16:36:13.70 [Thread 9] {Error} HorizonBoss.MealPayLive.BusinessObjects.Patrons.Patron.UpdateLatestBalanceIn formation( DataSet currentBalances ): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. 4. I have all my code wrapped in Try/Catch blocks so I see where I catch the Exception and write this out to a log file. 5. I have code in the Application_End section of the Global.asax and I see where a different Thread ID comes along and ends my running application. 2004-08-12 16:35:33.70 [Thread 9] {Verbose} HorizonBoss.MealPayLive.BusinessObjects.Patrons.Patron.UpdateLatestBalanceIn formation( DataSet currentBalances ): SQL to execute: UPDATE mplPatronBalanceUpdate SET DateBalanceLastUpdated = '8/12/2004 4:35:33 PM' WHERE PatronID = '0857' 2004-08-12 16:36:13.70 [Thread 9] {Error} HorizonBoss.Framework.DataAccess.HZSqlFactory.ExecuteNonQuery( HZRequest request ): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec t stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HorizonBoss.Framework.DataAccess.HZSqlFactory.ExecuteNonQuery(HZRequest request) in C:\projects\dotnet\Fish.NET\HorizonBoss\Framework\DataAccess\HZSqlFactory.vb :line 359 2004-08-12 16:36:13.70 [Thread 9] {Error} HorizonBoss.MealPayLive.BusinessObjects.Patrons.Patron.UpdateLatestBalanceIn formation( DataSet currentBalances ): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. 2004-08-12 16:36:14.09 [Thread 9] {Verbose} HorizonBoss.MealPayLive.BusinessObjects.Patrons.Patron.UpdateLatestBalanceIn formation( DataSet currentBalances ): Closing Database connection. 2004-08-12 16:36:14.09 [Thread 9] {Info} HorizonBoss.MealPayLive.BusinessObjects.Patrons.Patron.UpdateLatestBalanceIn formation( DataSet currentBalances ): FINISH: 2004-08-12 16:36:14.09 [Thread 9] {Info} HorizonBoss.MealPayLive.WebServices.MealPayCentralWS.SendBalances( DataSet currentBalances ): Successfully updated latest Real-Time Balance Information. 2004-08-12 16:36:14.09 [Thread 9] {Info} HorizonBoss.MealPayLive.WebServices.MealPayCentralWS.SendBalances( DataSet currentBalances ): Finish: 2004-08-12 16:36:14.09 [Thread 9] {Verbose} HorizonBoss.MealPayLive.WebServices.MealPayCentralWS.SendBalances( DataSet currentBalances ): Results = True 2004-08-12 16:36:14.29 [Thread 6] {Warning} HorizonBoss.MealPayLive.WebServices.Global.Application_End( Object sender, EventArgs e ): Web Service application is ending. 2004-08-12 16:36:14.29 [Thread 6] {Warning} HorizonBoss.MealPayLive.WebServices.Global.Application_End( Object sender, EventArgs e ): No Errors caused the shutdown. You can see from the Above log file where the Application_Ends on a different Thread. 6. I also have code in the Application_Error section of the global.asax, but this section of the code never gets hit. 7.. When the next Web Request comes in, I write out a History of all the reasons why the Web Server last shutdown. 2004-08-12 16:14:30.40 [Thread 9] {Info} HorizonBoss.MealPayLive.WebServices.Global.WriteProcessInformation( ProcessInfo currentInfo ): ProcessID: 3836StartTime: 8/9/2004 1:51:25 PMStatus: 1ShutdownReason: 0RequestCount: 0PeakMemoryUsage: 54596Millseconds the Worker process has been running: 152Minutes the Worker process has been running: 23Hours the Worker process has been running: 2 2004-08-12 16:14:30.40 [Thread 9] {Verbose} HorizonBoss.MealPayLive.WebServices.Global.WriteProcessInformationHistory( ): START: 2004-08-12 16:14:30.40 [Thread 9] {Info} HorizonBoss.MealPayLive.WebServices.Global.WriteProcessInformation( ProcessInfo currentInfo ): ProcessID: 3836StartTime: 8/9/2004 1:51:25 PMStatus: 1ShutdownReason: 0RequestCount: 38PeakMemoryUsage: 54596Millseconds the Worker process has been running: 167Minutes the Worker process has been running: 23Hours the Worker process has been running: 2 2004-08-12 16:14:30.40 [Thread 9] {Verbose} HorizonBoss.MealPayLive.WebServices.Global.WriteProcessInformationHistory( ): FINISH: I write down the Shutdown Reason as 0. Which means unknown reason why the web server shut itself down. 8. My database connection string looks as follows: server=localhost;UID=MyUser;PWD=secret;database=DatabaseName;pooling=false;c onnection reset=false;connection lifetime=5;min pool size=1;max pool size=10;connection timeout=120 I'm completely stumped as to what can be terminating my web application. I have verified that I'm not touching the \bin folder of the web application as I know that this causing web servers to restart themselves. Any help is greatly appreciated. Tag: WQL DataProvider for ADO.Net Tag: 93710
  - 9
    - Which is best .Net v1.0/1.1 Provider for Oracle 8i and/or 9i ? Hi how does System.Data.OracleClient differ thab System.Data.Odbc or OraOLEDB.Oracle when it's used for Oracle 8i? What about 9i, is it the same thing? Anything different while being used with .Net Framework 1.0 or 1.1? Thanks Tag: WQL DataProvider for ADO.Net Tag: 93704
  - 10
    - Add child rows to a datatable that have a data relation I've been struggling with this data relation issue for awhile now. I've found the source of the problem, but am unsure how to resolve this so I can get the functionality I need. This would seem to be very common functionality, but I do not see how it is done. Yes, I could just populate the datagrid using an additional call back to the server with a JOIN, but surely two trips to the server for the same data is not how the disconnected motif of .Net is supposed to be implemented! Fundamentally, it appears that what I'm trying to do is add rows to a table where 3 of the columns are read-only, since they were added from the Parent table to the child table. Thus an exception is raised on Update. Here I add the 3 columns from the parent table to the child table and then later try to Update the suppliers table. I think my distilled question becomes: do I need to drop these columns from the supplier table before doing the Update? If so, how? Is there a different syntax for applying the Update to the child table? Or is there a way to make those columns not read-only so it will accept the Update? relSuppliers = New DataRelation("CityStateZipSupplier", _ dsWinMatrix.Tables("dtSupplierZips").Columns("ZipCityStateID"), _ dsWinMatrix.Tables("dtSuppliers").Columns("SupplierZipCityID"), False) dsWinMatrix.Relations.Add(relSuppliers) dsWinMatrix.Tables("dtSuppliers").Columns.Add("City", GetType(String), "Parent(CityStateZipSupplier).City") dsWinMatrix.Tables("dtSuppliers").Columns.Add("State", GetType(String), "Parent(CityStateZipSupplier).State") dsWinMatrix.Tables("dtSuppliers").Columns.Add("Zip", GetType(String), "Parent(CityStateZipSupplier).Zip") .... da.Update(dsChanges, "dtSuppliers") Tag: WQL DataProvider for ADO.Net Tag: 93702
  - 11
    - DataGrid Updates Hi, My progy for a book shop shows stock, it has a tabcontrol with 3 tabs, on each page thers a DataGrid (dg). For each DataGrid thers a oleDbDataAdapter (da) and a DataSet (ds). All 3 datasets pull data from the same table through their DataAdapters - each with a different query; so da1 fills ds1 wiv all the records (select * from books), da2 fills ds2 wiv low stock (select * from books where stock<wotever) and da3 fills ds3 wiv no stock (select * from books where stock = 0). When user edits the records another form (dialog) pops up, upon completion user clicks "Save Data" and the changes are put into ds1. It then calls "da1.Update(ds1)" to save all the changes. The problem: When changes are saved from ds1 to the database I then try and update the other DataSets by refilling them and redrawing the DataGrids like so: //////////////////////////////////////////////////////////////////////////// ////////////////////////////////////// private void updateStuff() { oleDbDataAdapter1.Fill(ds1,"Books"); oleDbDataAdapter2.Fill(ds2,"Books"); oleDbDataAdapter3.Fill(ds3,"Books"); dataGrid1.Update(); dataGrid2.Update(); dataGrid3.Update(); } //////////////////////////////////////////////////////////////////////////// ////////////////////////////////////// BUT! Only DataGrid1 (dg1) updates correctly, the other 2 usually stay the same, but sometimes do work. I was braking my head for ages now and still cant figure out why. I tried Refresh instead of Update to redraw DataGrids, but that didn't do anything different. Thanks everyone! Tag: WQL DataProvider for ADO.Net Tag: 93700
  - 12
    - SqlHelper Bug - Stored Procedures I'm getting the error "The stored procedure 'sp_tables' doesn't exist." when I run the following code: **snip** Dim ds As DataSet = New DataSet() Dim str As String = CStr(Session("ConnectionString")) If Session("ConnectionString") Is Nothing OrElse _ Session("Database") Is Nothing Response.Redirect(Request.ApplicationPath) Return End If str = str.Replace("DATABASE=;", "DATABASE=" & Session("Database") & ";") SqlHelper.FillDataset( _ str, _ "sp_tables", _ ds, _ New String() { "tblTables" }, _ New SqlClient.SqlParameter("@table_name", Nothing), _ New SqlClient.SqlParameter("@table_owner", Nothing), _ New SqlClient.SqlParameter("@table_qualifier", Nothing), _ New SqlClient.SqlParameter("@table_type", "'TABLE'") _ ) **end of snip** Now, if I connect to the database with the following code, it works: In place of the SqlHelper.FillDataset() call, I place the following: **snip** ds = GetTables(str) **end of snip** And GetTables() is defined as: **snip** Private Function GetTables(ByVal ConnectionString As String) As DataSet Dim conn As SqlClient.SqlConnection Dim da As SqlClient.SqlDataAdapter Dim cmd As SqlClient.SqlCommand Dim ds As DataSet = New DataSet() conn = New SqlClient.SqlConnection(ConnectionString) cmd = New SqlClient.SqlCommand("sp_tables", conn) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.Add("@table_type", "'TABLE'") da = New SqlClient.SqlDataAdapter(cmd) da.Fill(ds, "tblTables") ' Close the connection. conn.Dispose() Return ds End Function **end of snip** Amazingly, the GetTables function that I wrote works fine but the SqlHelper.FillDataset() function does not. The following is some of the trace: System.Data.SqlClient.SqlCommand.DeriveParameters() +1268 System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +41 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(S qlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +88 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInterna l(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +160 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(SqlCon nection connection, String spName, Boolean includeReturnValueParameter) +69 As I can see, DeriveParameters() method of the SqlCommand object can't seem to find the sp_tables stored procedure. I just can't see why not :( Anywho, any help as to a fix or work around where I don't need to do all the database routines myself (hence, why I'm using the SqlHelper object), is much appreciated. Mythran P.S. Namespace: Microsoft.ApplicationBlocks.Data for the SqlHelper. Tag: WQL DataProvider for ADO.Net Tag: 93698
  - 13
    - Losing DataTableMappings -- A tough one for you MVPs ;-) Hello, (NOTE: Another guy is having the exact same problem, but there aren't responses: http://tinyurl.com/3w95n.) SYMPTOMS In VB ASP.NET application, I have the following error in the Task List when I open the form in the designer: "The DataTableMappingCollection only accepts non-null DataTableMapping type objects. Parameter name: value" The data adapter is configured using only a Select command, which is set to "cmd", a separate command object. This command references a SQL stored procedure that returns 3 separate result sets, which corresponds to the 3 identical error messages in the Task List: "Exception has been thrown by the target of an invocation." Furthermore, when I select the data adapter in the component tray and select TableMappings in the Properties pane, I get the following error message: "Unable to retrieve the schema from the database table. Source column mapping information will not be available. Would you like to continue?" TEMPORARY FIX I found that when you select the data adapter in the component tray, select Generate Dataset from the Data menu, and Click OK (without making changes), then TableMappings property in the Property pane is then made available. Of course, this results in a loss of all your table mappings, but they can be manually entered. REOCCURRANCE This sad saga happens every time I open that page in the designer, and I have to remap everything. Is there maybe a way to "name" the result sets coming in from SQL Server, so that VS.NET might automagically recognize them? Any ideas are greatly appreciated. Thank you, Eric Tag: WQL DataProvider for ADO.Net Tag: 93694
  - 14
    - Re: DataGrid column formatting to display Time values Yes, I've actually tried this as well and had no success. I get the same result even when specifying the child table only. Is there some way that I can get a DataView or something to bind to the child table but still be able to maintain the relation structure such that if I navigate through the master (parent) tables, the child changes accordingly? Tag: WQL DataProvider for ADO.Net Tag: 93689
  - 15
    - Size of IDataParameter for OUTPUT sp parameter Hi there, idataparameter does not have a size property (for string/varchar parameters), and without setting it it will not return a value. If I temporarily cast 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: WQL DataProvider for ADO.Net Tag: 93688
  - 16
    - Help: Cant delete Access LDB file! I have an ASP.NET website that uses Access. I want to replace the Access file but the LDB (locking) file will NOT go away so I can't replace it. (I think maybe in one of my previous pages I opened a db connection without closing it maybe???) How can I delete the LDB file so that I can replace the MDB file? Any suggestions? I don't think restarting the webserver is an option. Thanks! Tag: WQL DataProvider for ADO.Net Tag: 93684
  - 17
    - Any difference between dataset Reset and Clear? I've used both Reset and Clear, but I'm not sure how they differ. In particular, the Help says that Reset, "Resets the DataSet to its original state." Ummmmm, ok. Does this mean before the dataset existed? Before you added a table or tables? What would be the "original state"? Maybe in other words, Clear(ed) "by removing all rows in all tables"? Tag: WQL DataProvider for ADO.Net Tag: 93682
  - 18
    - Benefits of Typed Dataset? Hi, The only benefit of typed dataset is that we can check for type mismatch of any values within dataset at compile time and not at runtime. Is there any other benefit?,if yes please drop pointers to it. -- Cheers, Akhil Tag: WQL DataProvider for ADO.Net Tag: 93677
  - 19
    - Complicated related table problem I have a topic table that contains many columns. Among them are the ID key column and the topictext column. The later may be a news itm, a magazine or newspaper article, a Palestinian or Israeli government, ministrial or committee document, among other things. A 'concept' is one way I classify a topictext. A concept refers to a portion of the text. The concept table includes an ID key, concept(string), Active(Boolean), and ParentID. Kevin Yu was helpful in putting concepts into listboxes according to the relation between the selected value and the relationship between the ID of one level and the ParentID of its children. An example might be: Palestinian intercine conflict while its children include militant groups against Palestinian forces, Palestinian forces against one another, kidnapping of PA officials and so on. These too have children. When I save a concept I'm actually inserting a row into the ConceptAssignmentInstances table. Key columns are TopicID, ConceptID and BeginText. BeginText because, say within the topictext, we click IDF Actions against Palestinian Militants. This may include 1) Arrest 3 fugitives 2)Shoot two militants on the way to a homicide bombing. and so on. Two more columns, ReportType(opinion, report, statement, document, quote, etc.), and PointOfView. The complication comes with quotes. My database includes a table called KeywordSets, and another called KeywordSetGroups. Each KeywordSet can be assigned to any number of groups, including persons. If the ReportType is a quote I fill two listboxes with the rows of KeywordSetGroups Persons Group. One reflects the speaker, the person who makes the quote, while the second are the one or more targets of the quote. Say, Palestinian Prime Minister Qurei is the speaker and both PM Ariel Sharon and Finance Minister Bibi Netanyahu and the targets. The table is called QuoteAsssignments and I'm unsure of what columns it must have to connect it to the ConceptAssignmentInstances when its report type is Quote. Do I really have to use all three keyfields (topicID, ConceptID and BeginText)? Or is it more efficient to add an ID field to ConceptAssignmentInstances and use that as the foreign key is QuoteAssignments, say CAI_ID? Dennis Tag: WQL DataProvider for ADO.Net Tag: 93667
  - 20
    - SQLClient and SecurityException Hi, I'm getting boring and boring with my ado.net code. I want to write a little vb.net console application that connect to a remote SQL Server. I'm using the following code : Dim cObjConn As SqlClient.SqlConnection cObjConn = New SqlClient.SqlConnection("Initial Catalog=myCatalog;UID=mySQLUser;Password=****;Data Source=myServer") cObjConn.Open() And every time I run this code, I got the following error on the .open() : System.Security.SecurityException: Request for the permission of type System.Dat a.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutra l, PublicKeyToken=b77a5c561934e089 failed. at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet granted Set, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permT oken) at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32 unrestrictedOverride) at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S tackCrawlMark& stackMark) at System.Security.CodeAccessPermission.Demand() at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString const r) at System.Data.SqlClient.SqlConnection.Open() I've found a very little example in the VB.Net reskit to connet to SQLServer. I've updated connection string to connect to my server and it's works. I really don't know where I'm wrong. Please help me before I or my computer go throw the window of my office. Regards Cyril Tag: WQL DataProvider for ADO.Net Tag: 93666
  - 21
    - SQLConnection and Pooling Hi All, I'm currently working on my first major project using ASP.NET using VB. Everything seemed fine when i was initially testing but now I'm running into issues with too many connections being created and taking over the pool. I've gone through the entire application and verified that I'm calling a Conn.Close and a Conn.Dispose anywhere that I create and use a SQLConnection object. However, i'm still running out of connections. I'm the only one in the application at this time so I figured that the 100 connection pool limit would suffice. I guess I was wrong! It's almost as if pooling isn't working. I've read all of the stuff about the connection string being constant (and it is). All of the connections share the same connection string (listed below). Since I haven't specified any values, all pooling parameters are using default values (per Microsoft documentation). Therefore, my connections should be reused when I execute this page. . By executing the same page multiple times I see my the number of my connections increase by a count of 3 for each iteration. My questions are as follows: 1. Does my connection string matter in its current format - are there any parameters that i'm missing that will assist in getting the pool to work efficiently? 2. I'm using the Microsoft Data Access Application block version 2.0 to save some coding time. I've looked through the code and it seems to be disposing of the conneciton objects appropriately -- Nothing is really left hanging there. Has anyone else had a problem with these before? I've attached a copy of the code which I believe is a problem.-- why would this code create 3 connections for every call? Thanks for all of your help. Farid '/****** CODE *******/ ConnString = "data source=MyServer;Trusted_Connection=no;Initial Catalog=MyDB;User ID=MyUser;Password=MyPwd;" Private Sub PopulateGrid() Dim conn As New SqlConnection(ConfigurationSettings.AppSettings("DBConnString").ToString) Dim sh As SqlHelper Dim ds As New DataSet Try PrimarySQL = DirectCast(Session("PrimarySQL"), String) conn.Open() Dim da As New SqlDataAdapter(PrimarySQL, conn) da.Fill(ds) conn.Close() If ds.Tables(0).Rows.Count <= 0 Then lblNoRecs.Visible = True RowCount.Visible = False DataGrid1.Visible = False Exit Sub Else lblNoRecs.Visible = False End If SetRowCount(ds.Tables(0).Rows.Count) DataGrid1.DataSource = ds DataGrid1.DataBind() ds = Nothing sh = Nothing Finally conn.Close() conn.Dispose() End Try Tag: WQL DataProvider for ADO.Net Tag: 93663
  - 22
    - System.Data.OleDb Oracle Ref Cursor into Dataset Hello, Can someone please provide me with a working code sample (PL/SQL, VB.NET or C#) on how to retrieve a out ref cursor from an Oracle 8 database to an ASP.NET DataSet. Thank you in advance. Henry Yeng Tag: WQL DataProvider for ADO.Net Tag: 93661
  - 23
    - Events Exist Check? I have a DataTable that sometimes has the RowChanged event wired up. Later in code, how can I determine if the DataTable has had the RowChanged event added already - I don't want to add it twice. Thanks. Tag: WQL DataProvider for ADO.Net Tag: 93659
  - 24
    - Retrieving a subset of rows Hi, Suppose you had a web form that uses a DataSet object. The form contains a Repeater control that is bound to the DataSet and a navigation button. When you press the navigation button, you want to retrieve only 10 rows at a time. The question is, how do you get 10 rows each time you press the button? What must the code look like to accomplish this? Thanks, Roshawn Tag: WQL DataProvider for ADO.Net Tag: 93658
  - 25
    - DataSet Paging Hi, Is it possible to page through a cached DataSet without the use of a DataGrid? I'm getting sick and tired of seeing this done only with the DataGrid. Thanks, Roshawn Tag: WQL DataProvider for ADO.Net Tag: 93657

Hi,

WQL DataProvider is an ADO.Net data provider, so you can use it just like
usual MS SQL DataProvider, but for WQL (WMI + SQL = WQL). This DataProvider
supports SELECT, ASSOCIATORS and REFERENCES queries. Doesn't support event
queries.

http://www.yogageneration.com/~mvkazit/demo/WQLDataProvider/index.html

--
Thanks,

Top

Re: WQL DataProvider for ADO.Net by Maxim

Maxim
Mon Aug 16 12:07:24 CDT 2004

Download link was broken, but it's fixed now.

"Maxim Kazitov" <mvkazit@tut.by> wrote in message
news:uGYSYI0gEHA.592@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> WQL DataProvider is an ADO.Net data provider, so you can use it just like
> usual MS SQL DataProvider, but for WQL (WMI + SQL = WQL). This
DataProvider
> supports SELECT, ASSOCIATORS and REFERENCES queries. Doesn't support event
> queries.
>
> http://www.yogageneration.com/~mvkazit/demo/WQLDataProvider/index.html
>
> --
> Thanks,
>
>

Top