How to use Like in free text search on Datadview.Rowfilter or DataTable.Select()

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
    - Bug of SqlClient?! Problem with output parameter/SQL Server 2000! Here is the simple test stored procedure: <code> CREATE PROCEDURE pr_test ( @xParam1 nvarchar(200) = null output ) as --set @xParam1 = newid() select result = @xParam1 set @xParam1 = newid() </code> If I run the following test SQL script in Query Analyzer, I get expected result: declare @x nvarchar(500) <code> set @x = '1234' exec pr_test @x output select result = @x </code> <output> result -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1234 (1 row(s) affected) after ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 92CBE528-6097-48C6-A0C4-C152425D180A (1 row(s) affected) </output> However, in Visual Studio .NET 2002/2003, the following code does not get expected result: <code> DataSet ds = new DataSet(); this.sqlDataAdapter1.SelectCommand.Parameters["@xParam1"].Value = "1234"; this.sqlDataAdapter1.Fill(ds); this.dataGrid1.DataSource = ds.Tables[0]; this.Text = this.sqlDataAdapter1.SelectCommand.Parameters["@xParam1"].Value.ToString(); </code> The output paramter @xParam1 has been setup correctly. The datagrid always shows the value of 'result' column as 'null'. Do I have misunderstanding of ADO.NET/SqlClient or this is simply a bug? Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108028
  - 2
    - Using Transactions in C# Hi, i have some wired behaviour using c#, ado and sql server. There are two tables on sql server: Order and Orderdetails. (Order_ID is primary key on Table Order and foreign Key on Orderdetails.) I have two c# Classes calles Order and Orderdetails. They contain two Methods for inserting Orders or Orderdetails on Database. (Parameterized with an sql connection an an transaction.) On the main programm a transaction is started an calling Order.Insert(...) Then, i do serveral Orderdetails.Insert(...) before committing the transaction. This works as supposed, but there is one big issue i cant figure out: I start debugging the app and opend query-analyzer. After calling Order.Insert(...)-but not yet committed the transaction - i am able to do a "select * from order where order_id = 1". BUT: After calling Orderdetail.Insert(...)in the code -but not yet committing the transaction- i cant do a "select * from orderdetail where order_id = 1), because Query Analyzer is waiting until the transaction is commited. Why that? I mean it did work for Order.Insert; why not for Orderdetail.Insert??? When i use the command "select * from orderdetail with (readpast) where order_id = 1" it asap returns data. (There are about 1000 Datarows in the Tables; that with order_id = 1 has been already inserted. The isolationlevel is set to IsolationLevel.ReadUncommitted) Can anyone help? Thanks, bye DS Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108027
  - 3
    - DeriveParameters and Jet OLEDB Provider Hi I've just discovered that the Jet OLEDB Provider does not support OleDbCommandBuilder.DeriveParameters, to discover the number and type of parameters expected by a Microsoft Access query. I'm a little surprised, as it was always possible to use the ADO Refresh method with this provider to populate a Paramters collection. Is there a reason for this? Is there a workaround? I know that it's an expensive operation which should be avoided anyway, but it's sometimes useful, and I'd like to use the same code against both Access and SQL Server. Thanks in advance. -- Doug Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108024
  - 4
    - ADO.NET 2.0 - Question for Microsoft Employees Okay, so we have a new Isolationlevel for transactions in ADO.NET - the snapshot isolation. That exists at System.Data - which leads me to believe that nothing really stops me from setting that isolation level on Oracle. So my question is - by setting that on Oracle, does it mean the same as SET TRANSACTION READ ONLY Or does Isolationlevel.Snapshot not work on Oracle? (Frankly my opinion, IsolationLevel.Snapshot not working on Oracle is not a good answer, but if that is what it does, then that is what it does ..) Can anyone advise? :) - Sahil Malik [MVP] http://codebetter.com/blogs/sahil.malik/ Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108021
  - 5
    - Casting IntPtr/Byte etc... Trying to get HP's Biometric API for the .NetCF to work by storing fingerprint data in a DB and then retrieving it. First problem: casting to the right types to store in the DB. Right now I'm casting each fingerprint property to OleDbType.Variant prior to inserting in the DB and then in a stored procedure casting each property to either Int, Binary or smallint before storing it in a table. I get a problem when retrieving though - exceptions on pretty much each data type. System.UInt32 Length; System.Byte HeaderVersion; BioAPI_BIR_DATA_TYPE Type; System.UInt16 FormatOwner; System.UInt16 FormatID; SYstem.Byte Quality; BioAPI_BIR_PURPOSE Purpose; BioAPI_BIR_AUTH_FACTORS FactorsMask; System.IntPtr BiometricData; System.IntPtr Signature; The 3 custom datatypes are either of type UInt8 or type UInt32. I'm even having problems with re-casting (i.e. after retrieving info back from the DB) type Byte (ex: HeaderVersion, "An unhandled exception of type 'System.InvalidCastException' occured"). Could anyone point me out as to what I should do. And also how I can cast, or import, data that has type System.IntPtr. Thanks so much! Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108019
  - 6
    - Datarepeater Hi, NG! Is there any updated version (.Net) of the Datarepeater control or do I have to use the old (VS6.0) version? Thanks. pax Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108014
  - 7
    - Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraint We've moved a database from one SQL server to another using a backup and restore, we had some problems because the location was slightly different when we moved the database, then we had to create all the users again. We're now receiving an error when opening the client utility - which is "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraint" Any suggestions? database was working beforehand so i can't see why it would be an error in the code Regards Paul PS SQL2000 with SP3 Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108004
  - 8
    - ExecuteNonQuery returns ORA-01036 illegal variable name/number I have used ExecuteNonQuery with no trouble for inserts, updates and deletes. The best practices book I have says this is also the most efficient way to return multiple column values from a single row. The requested fields can be changed by users adding/removing fields from the form, so a stored proc will not work - variable number of return values. I tried: Select name, rank into ( :V1, :V2 ) from mytable where keyvalue = :V3 and get ORA-01036. The bound parameters are named to match the sql statement. IN params work fine, but I cannot make it happy with the OUT params. Any help would be appreciated. Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108002
  - 9
    - how to connect Access database I was using the following classes to get data from. Now I would like to know which class shall I use from Windows Forms VC++ 2005. CDaoDatabase m_Dao; // Variables in String Table // m_file = "C:\\Program Files\\Onair\\InVer.mdb" // m_upass = "password" m_Dao.Open(m_file ,FALSE, FALSE, m_upass); CDaoRecordset m_Set; COleVariant m_varprofile; COleVariant m_varsection; m_Set.GetFieldValue ("Profile", m_varprofile); etc.., Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 108001
  - 10
    - Case-sensitivity in a stored procedure Hi there! How can I toggle case-sensitivity within a stored procedure? I'd like to compare 2 passed in parameters against fields in a table. The first comparison is case-sensitive, the second is not. How can I do that? By default it seems they're not case-sensitive. Thanks in advance. -- /Matthias Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107999
  - 11
    - To Insert Multiple Rows in Oracle using oledbCommand I need to know how to Insert Multiple Rows in Oracle using oledbCommand -------------------------------- From: Mose Joseph ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>wLuDr7c3DU+/lMo6w74RrQ==</Id> Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107991
  - 12
    - (Q for David Sceppa!) Problems submitting hierarchical changes to DB Hello, On page 786 of the ADO.NET Core Reference (chapter 11 - Advanced Updating Scenarios), David Sceppa gives the basic steps for submitting hierarchical changes (paraphrased): 1. Submit new master rows 2. Submit new detail rows 3. Submit modified master rows 4. Submit modified detail rows 5. Submit deleted detail rows 6. Submit deleted master rows I took this process and applied it to a rather large, normalized data structure. However, the modified detail row changes would never make it to the database. I stepped through the code and found that after updating the modified master rows (step 3), the related detail rows' RowState would change from Modified to Unchanged. This, of course, keeps the detail rows from being sent to the database. After swapping steps 3 and 4, the database was successfully updated. My questions...why does that happen in the first place? Will swapping steps 3 and 4 have some other adverse effect? Thank you! Eric Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107989
  - 13
    - Get the name of the primary key Working with a Microsoft Access database, what is the best way to get the name of the primary key field? I know the table name. Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107988
  - 14
    - Parameter expected? It keeps saying the stored procedure expects the parameter '@entity' which was not suppplied, but I'm supplying it: OdbcConnection cn = new OdbcConnection(CNSTR); OdbcCommand cmd = new OdbcCommand("GetMyList", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@entity", OdbcType.VarChar, 4); cmd.Parameters.Add("@type", OdbcType.VarChar, 4); cmd.Parameters["@entity"].Value = "PRAC"; cmd.Parameters["@type"].Value = "TYPE"; cn.Open(); OdbcDataReader reader = cmd.ExecuteReader(); cn.Close(); If I substitute a SQL statement (no parameters) all is good. What I am I doing wrong on the parameter creation/adding? Thanks in advance. Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107986
  - 15
    - Generic error in GDI+ I'm loading thousands of images into a SQL Server 2000 database. I have a .NET windows application that I'm working on written in C# that retrieves the fileinfo of the directory and then loads all of the images into an image field in the database. The problem I'm having is that I get an unhandled exception after loading about 900 images that says "A generic error occured in GDI+". I've determined that it has something to do with loading the images. If I do everything but actually retrieve and load the images it runs fine. Here is the code that retrieves and loads the images to the database: string strSQL = @"INSERT INTO page(page_image) VALUES (@page_image)"; SqlCommand sqlCommand_page = new SqlCommand(strSQL, sqlConnection_DocImage); SqlParameterCollection pc_page = sqlCommand_page.Parameters; pc_page.Add(new System.Data.SqlClient.SqlParameter("@page_image", System.Data.SqlDbType.VarBinary, 2147483647, "page_image")); Image img; sqlConnection_DocImage.Open(); foreach(FileInfo row in jpgFileInfo) { using(MemoryStream imageMS = new MemoryStream()) { img = Image.FromFile(row["fullname"].ToString()); img.Save(imageMS, ImageFormat.Jpeg); pc_page["@page_image"].Value = imageMS.ToArray(); } sqlCommand_page.ExecuteNonQuery(); } sqlConnection_DocImage.Close(); The error message gives me no clue to diagnose what's happening. It sounds like a resource isn't being disposed of. Thanks in advance for any help. HArlan Marshall Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107983
  - 16
    - Errors connecting with Microsoft.Jet.OLEDB.4.0 Hi, I install Crystal Reports 8, and some permissions for the= registry subkeys and their lower-level subkeys are modified=2E I= used a Crystal restoration utility, and everything come back= fine again, all except for the OLEDB connections using= Microsoft=2EJet=2EOLEDB=2E4=2E0 provider, I can't connect to excel files anymore, I guess is= something about the registry subkeys=2E Thanks=2E -------------------------------- From: Javier Villarreal ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>scAM4u3dcUKg/FQYxOGZeQ=3D=3D</Id> Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107980
  - 17
    - VB.Net Joining Paradox and SQL Server Table? Has anyone done this yet? I know it is easily done in Paradox, but I would like to do it in VB.Net. Can anyone point me in the right direction? Thanks, Rog Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107972
  - 18
    - dataadapter and component I'm creating a component that contains a function. This function is to return a data set of state values (AL,IL,TN,CA,...). I'm new to dataadapters this is my first, but something just doesn't seem right. the function return a dataset, but do it need to define a dataset in the body of the function as well as in the calling routine? 2. can i bind this dataset to two different drop down lists? here is my function. Public Class states Inherits System.ComponentModel.Component Public Function GetStates() As DataSet Dim ddlStates As DataSet = New DataSet Dim strcon As String = "DSN=SE;" Dim conSE As New OdbcConnection(strcon) Dim strSQL As String = "select staStateName, staLongName from sta where 1=1 order by staStateName" Dim daStates As OdbcDataAdapter daStates = New OdbcDataAdapter(strSQL, conSE) 'Fill dataset conSE.Open() daStates.Fill(ddlStates, "states") conSE.Close() Return ddlStates End Function Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107970
  - 19
    - Filter Dataset Correct me if I'm wrong, but once I have my data returned from a stored procedure, in a dataset and displayed in a DataGrid (ASP.Net)...I can filter the data correct, without making a return trip to the server? Anyone have an example of how this works? Thanks Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107962
  - 20
    - No cursor when compared with ADO After a dataset has been populated, it no longer reflects changes in database. It is the shortcoming I found in ADO.NET. In ADO, we have dynamic recordset, keyset recordset which can reflect the changes to database done by other users immediately. Why can't I find these useful stuff in ADO.NET? Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107961
  - 21
    - Memory leak in OleDbCommand.ExecuteNonQuery()? Maybe there's something I'm doing wrong here. I'm open to any suggestions. I'll see if I can explain this clearly... I have a C# application that runs 24x7 collecting data from some source and storing the data in a Microsoft Access database. The problem is, every time it stores the data using a call to OleDbCommand.ExecuteNonQuery(), the applications memory usage grows. After a few days, the application has consumed most of the systems' virtual memory and grows more and more sluggish and unresponsive. The only solution right now is to restart the application every couple of days. Since the app uses one database and stores the same database fields with only the data changing, I set up everything at the start of the program. After that, as data comes in, only the stored data parameter values change. The first thing I do is open the MS Access database using an OleDbConnection with a Microsoft.Jet.OLEDB.4.0 provider. I then create a OleDbCommand with a command string that basically consists of "INSERT INTO table (field1, field2...) VALUES (?,?...)". Next I use OleDbCommand.Parameters.Add to add OleDbParameter data parameters that correspond to each field to the OleDbCommand, with the proper datatype for each field. Lastly I set the OleDbConnection in the OleDbCommand. As the data is collected I go through each OleDbParameter and set its Value to either the data collected or DBNull.Value if the data is missing. Then I call OleDbCommand.ExecuteNonQuery to actually store the data. That occurs successfully, but the virtual memory alllocation goes up and up each time the data is stored. I monitor the memory usage with Sysinternals ProcExp, and if I comment out the call to actually store the data, the memory usage remains constant. So am I doing something wrong, or is there a memory leak in OleDbCommand.ExecuteNonQuery? Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107957
  - 22
    - SQLConnection connection pool issue I have a similar problem to several other people who have posted= here - I can only open up to <Max Pool Size> connections=2E After= that I get a timeout expired exception=2E Looking at the open / pooled connections in perfmon (in both SQL= Server stats, and the CLR runtime), there are never more than 5= / 6 connections open, but without fail, I cannot open more than= <Max Pool Size> connections, even when I change this value or= don't specify it=2E I have already tried several suggested solutions - disabling SQL= Server debugging in VS=2Enet, running in release mode, connecting= to several other databases on several other computers, but= nothing seems to have any effect=2E I have gone through the code= with a fine tooth-comb, and put "open connection" counters into= my database class (all the connections are opened and closed by= a single pair of shared functions - and yes, the connection= object is passed by ref=2E), and ensured that the connections are= actually reporting they are closed (via SqlConnection=2EState)= both inside and outside the function that closes them=2E I'm all out of ideas now=2E Any suggestions would be greatly= appreciated=2E -------------------------------- From: Rory Smith ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>gdTZqEcYx0eoUbAQReEUNQ=3D=3D</Id> Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107956
  - 23
    - XML Schema (XSD) and ADO.net DataSet - limitations mapping between them The following valid XSD schema can NOT be successfully read by the ReadXMLSchema method of the DataSet object - it errors out with a "NonEmptyString not defined" error. This schema is more complex than a plain vanilla schema, but doesn't strike me as obscenely complex. Are there general rules for what can an can not be mapped between any XSD schema & a .net DataSet? Thanks <?xml version="1.0" encoding="UTF-8" standalone="yes"?> -- edited with XMLSpy v2005 rel. 3 U (http://www.altova.com) by Wheels Inc (Wheels Inc) -->  <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xs:element name="CollisionTemplateA1"> <xs:complexType> <xs:sequence> <xs:element ref="FullName"/> <xs:element ref="Hometown"/> <xs:element ref="Province"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="FullName"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" fixed="/LR/Deeper/IsDriverInsane"/> <xs:attribute name="conditional" fixed="yes"/> <xs:attribute name="source1" fixed="/LR/Deeper/Name"/> <xs:attribute name="source2" fixed="/LR/Name"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:element name="Hometown"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" type="xs:string" fixed="/LR/City"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:element name="Province"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" type="xs:string" fixed="/LR/State"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:simpleType name="NonEmptyString"> <xs:restriction base="xs:string"> <xs:minLength value="1"/> </xs:restriction> </xs:simpleType> </xs:schema> Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107953
  - 24
    - Extracting enum from table Hi, I'm reading the result of a query using MySqlDataReader. I'd like to extract information about the row datatypes that are returned. For example, myDataReader.GetFieldType(1).TosTring() will easily return values such as "System.UInt32" or "System.Byte". My problem is that i'd like to retrieve information about enum types. My datatype in the MySQL db is defined as: ENUM('red','blue','orange') but the above code will return "System.String". I'm interested in retrieving something that will give me all valid input types for an enum field in the database. I've also tried looking at the System.Data.DataTable object but didn't find any clues on how to solve this. Any help is greatly appreciated. -------------------------------- From: Morten Skov ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>ltesbJ0arEScu0cv8VUUKQ==</Id> Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107952
  - 25
    - Broken Web Links Within Microsoft Access I have built a database in Microsoft Access 2003 that has a number of links that go out to the web. Does anyone know of a way I could set up my database to check which links are active and which ones are inactive? Because the links are added and removed, I would need to run this once a day, so any automation would be nice. While researching this, I came across (is broken) and (ConectionState) am I on the right track. Thank you for any help Corey -- Message posted via http://www.dotnetmonster.com Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107951
- Next
  - 1
    - Dataset: expression columns recalculation Hi there I'm having a typed dataset, where a datatable has some columns which are expressions. After doing a Merge, i was expected that my expression columns were calculated, but they were not. Although, if i do this foreach(System.Data.DataColumn column in dataset.myDataTable.Columns) { if (column.Expression!=null && column.Expression.Length>0) column.Expression =column.Expression; } they are calculated... is this by design ? thanks! www.dotnetx.org Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107949
  - 2
    - C# and ADO.Net - Cheap Question! Hi, I'd like to INSERT a string into a database using C#. The way I've tried it is the following: sQuery = string.Format("INSERT INTO myTable (Header, Body) VALUES ('{0}','{1}')", sHeader, sBody); It works fine until I have an occurence of ' (an apostrophy) in either the string-variables sHeader or sBody. How can I circumvent this? Thanks in advance! -- /Matthias Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107932
  - 3
    - Problem with RowChanged event and bindingcontext Hello all, IÂ´m experiencing a problem ( maybe a bug ...), with the rowchanged event. When i change the position in a table after alter a field the datarowchanged event starts only if the navigation path of the databinding is not a relationship: Ej... ds.Tables["house"].RowChanged +=...; texto.DataBindings.Add("Text", "house.doors"); this.BindingContext(ds,"house").Position++; in this case the event starts correctly Ej... ds.Tables["requirements"]..RowChanged +=...; // requirements is the relations between "house" and "requirements" tables texto.DataBindings.Add("Text", "house.requirements.pay"); this.BindingContext(ds,"house").Position++; in this case the event doesnt starts, but the DataRow of the relation table is altered. Does anyone know something about this? is a bug? it is its normal way of working? Greetings and excuse my poor english Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107927
  - 4
    - sqlcommand parameters with null Is there an easier \ shorter way of doing this? If txtreason.Text = "" Then NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value = vbNull Else NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value = txtreason.Text End If thanks gv Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107926
  - 5
    - Strange slow down with imbricated DataReader (Oracle, c#) This is my first c# windows app. I create a data reader on an Oracle table. Returns 552 rows. I iterate thru them, goes like light speed. Next, for each row returned, I need to fetch from another table to get some other information. When I do that, my program takes 20s instead of 1s. I even downgraded my inner SQL to become "select 1 from dual", same performance hit! Is there a problem with Oracle under c# using two DataReader at the same time? Here's the code: con = new System.Data.OracleClient.OracleConnection(); con.ConnectionString = "user id=xx;data source=xx;password=xx"; public void Process(ProgressBar progBar) { OracleDataReader dr; OracleCommand cmd; dr = GetMainDR() while (dr.Read()) { // get some columns ... cmd = new OracleCommand("select 1 from dual", con); Decimal i = (Decimal) cmd.ExecuteScalar(); <----- slows down everything cmd.Dispose(); ... } } public OracleDataReader GetMainDR() { OracleDataReader dr; OracleCommand cmd; cmd = new OracleCommand("select * from TABLE_OF_552_ROWS", con); // change dr = cmd.ExecuteReader(); return dr; } Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107924
  - 6
    - first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Hi all, I thought I would help out on a Error that comes up for a lot of people when calling a stored procedure from your application using sqlcommand object and passing parameters. this error comes up in VB.NET "first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll" this took me awhile but figured it out. Make sure in the stored procedure you declare the variable like this for variables that might not have any data: Make it equal nothing or null @mainnotes TEXT = '', or @mainnotes TEXT = null This fixed my problem, and I'm sure there are more solutions but, I hope this helps. The error could also come up if SQL permissions are not correct. Gerry Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107923
  - 7
    - Architecture: One Producer, Many Consumers Hi all, This sounded like a really easy R&D challenge but .NET is leaving me with too many options and I don't have six months to experiment and find the best one. Hence I would like to lean on this board's expertise. Environment is C#/.NET/SQLServer2k/VisStudio .NET. I have several remote applications that are delivering data to a central server. This server process is archiving the data in an SQL 2000 db. Now I also have one to about a dozen fixed clients on a WAN, which need to be notified when a change takes place to the central database so they can update their UI to reflect the changes. What is everyone's suggestion for doing this? Any resources out there you can point me at? I've run the gamut from remoting, to serialising the DataSets (which scares me due to the amount of data that may start going over the channel), to considering whether the remote clients should be writing directly to the db (although bandwidth limitations tend to prohibit TCP-like connections), to wondering why there doesn't seem to be any way for a client to simply connect to an SQL database and be told when changes occur... and so on. Is there something I've missed? This seems like a straightforward client-server requirement. Any help gratefully appreciated, and thanks in advance. Neil B Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107919
  - 8
    - Trouble with creating DataRelations - Need Help I am building an App that takes an Excel file and populates 3 DataTable's in a Dataset. I then was to create a relationship between these 3 DataTables. After dong so I want to run some code to process / modify the data in the tables and then return the result back into an Excel file. I am a beginner at VB and i chose this as a starter project. I get the following exception when i try to create the DataRelation: An unhandled exception of type 'System.ArgumentNullException' occurred in system.data.dll Additional information: 'column' argument cannot be null. Am i coding this correctly? When i run the fill command, will the table automatically pick the column header and other schema info? Once this is done I would like to create some DataRelationships between the three tables. Will there be an error because the table schema was not detected? I am curious about the concepts themselves rather than my code. I have already tried to read up on all the info online, but nothing addresses my situation. Listed below is the code I have. All help would be appreciated Thank You Private Sub cbConvert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbConvert.Click 'Convert button click event Dim filename As String filename = tbInputFileBrowser.Text() Dim XLFileConn As New OleDbConnection XLFileConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & _ ";Extended Properties=""Excel 8.0;HDR=YES""" Try XLFileConn.Open() Dim XLFileCmd1 As New OleDbCommand XLFileCmd1.Connection = XLFileConn Dim XLFileDA As OleDbDataAdapter = New OleDbDataAdapter XLFileDA.SelectCommand = XLFileCmd1 Dim XLFileMainDS = New DataSet("MainDataSet") Dim TableMain As DataTable = XLFileMainDS.Tables.Add("TableWithMain") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify <> 'TC' OR '26'" XLFileDA.Fill(XLFileMainDS, "Sheet1") Dim TableTC As DataTable = XLFileMainDS.Tables.Add("TableWithModTC") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify = 'TC'" XLFileDA.Fill(XLFileMainDS, "Sheet1") Dim Table26 As DataTable = XLFileMainDS.Tables.Add("TableWithMod26") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify = '26'" XLFileDA.Fill(XLFileMainDS, "Sheet1") 'XLFileDA.FillSchema(XLFileMainDS, SchemaType.Source, "Sheet1$") Dim ParentCol As DataColumn Dim Child1Col As DataColumn Dim Child2Col As DataColumn ParentCol = XLFileMainDS.Tables("TableWithMain").Columns("Proc Code") Child1Col = XLFileMainDS.Tables("TableWithModTC").Columns("Proc Code") Child2Col = XLFileMainDS.Tables("TableWithMod26").Columns("Proc Code") Dim RelProcCode As DataRelation Dim RelProcCode1 As DataRelation RelProcCode = New DataRelation("ProcCodeTC", ParentCol, Child1Col) 'Get an Exception Here RelProcCode1 = New DataRelation("ProcCode26", ParentCol, Child2Col) 'Add the relation to the DataSet. XLFileMainDS.Relations.Add(RelProcCode) XLFileMainDS.Relations.Add(RelProcCode1) Finally XLFileConn.Close() End Try Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107916
  - 9
    - DataTable.Row[i].EndEdit() Hi, How can I know which row is currently being editing when I have some controls bound to a DataSet.DataTable in order to call the EndEdit method prior to update data to the database? Is there any CurrentRecord indexer? When I call Rows.Add metod, the row I am adding will be put at the end? Sorry for these stupid questions but I am newer on .net and ado. Thanks Antonio Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107915
  - 10
    - Decimals truncated in dataset I'm airly new to .net and I can't seem to figure out this problem, I hope you can help... I'm filling a dataset from an Access database with columns of type = Decimal. When I load a datagrid with the dataset, the numbers are truncated, i.e. in Access I see 0.87224505043, in my datagrid i see 0. Why is this happening? Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107914
  - 11
    - closing connection not by design Hi, i wanted to get this groups opinions on a design issue ive run into: a programmer has coded a common data access class which is supposed to be inherited by all data access layers at my firm. This class instantiates a connection in the constructor, relies heavily on OleDb objects by necessity, and does stuff like returns DataReaders and creates DataSets and Command objects. Before using this class i looked thru the methods and noticed that there is no exception handling, so whenever error occurs, open connections and OleDb DataReaders and command objects never get closed/disposed. Being a helpful fool, i suggested to this programmer that it would be good idea to ensure that these methods clean up unmanaged resources that they create per best practice. The response i got is that "you dont understand the design", this decision was intentional... all code that calls this classes methods must write their own code to cleanup these resources in event of an error. He did not want to "restrict users of the class from flexibility in how they handle errors". Given that: 1. No other programmers who use this class were aware of this necessity 2. the programmer who wrote this class himself never checks for errors from code that calls these methods 3. its not possible for others to cleanup resources created within those methods 4. you can still pass exceptions to the caller and still dispose resources you create. 5. there are numerous problems with applications in production which use this data access class. my impression is that instead of accepting that a (fairly common) mistake/oversight was made and quickly taking basic steps to correct it, this programmer has decided to defend the indefensible. What do you think? Premier JiangZemin Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107901
  - 12
    - Vb.net ADO connecting SQL Server and Paradox table to create a query. All, I want to run a query in my vb.net application that will join a table in Paradox and a SQL Server table? The paradox table will be dynamic, meaning based on user input I may point to different folders but same file to get data. Thanks, Roger Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107900
  - 13
    - How does ADO.NET handle transactions when the connection is broken Hi, We are thinking of using ADO.NET to implement transactions on our SqlConnections, but would like to know how ADO.NET and SqlServer handle the situation when the connection gets broken. We have a client application in one location and a SqlServer DB in another location. We have tested the commit and rollback actions on a good connection and everything works great! When the connection gets dropped after the BeginTransaction method gets called however SqlServer seems to take a while before realising the connection has been dropped and rolling back the transaction (5 minutes). This means that the records updated inside the transaction before the connection was dropped remain locked for 5 minutes before being rolled back. Is there any way we can configure or control the timeout period? Here is a basic code snippet: try { db.OpenConnectionAndBeginTransaction(); db.ExecuteSomeSQL(); db.CommitTransaction(); } catch(Exception) { db.RollbackTransaction(); throw; } Any help would be greatly appreciated. Thanks, Rob Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107889
  - 14
    - REGISTERED AND CRACKED CAD/CAM/CAE SOFTWARES 2005! Hello architectural, engineer and technical users! We can offer you new regi stered CAD/CAM/CAE softwares: Survey , GIS , Rock , Soil and Water, Industri al and Control Project, Mathematics , Statistics and Accounting, Engineering and Technical Standards and Databank Such as ISO , DIN , BSI ,ASME , ASTM a nd etc. This softwares we can obtain for you with CDs or DVDs. Sorry for not downloa d available. May be in future it will be possible if we will have more secur y server. Our principle of work is next: 1.You order from us some softwares. In 1-2 days we inform you the cost of y our order, including price of delivery. 2.Usually by delivery we use TNT, DHL, UPS mail services. But for security of delivery and for quaranties for you and for us we often use TNT mail serv ice. We have agreement with them and they have become the intermediary of ou r deals. They controls the payment from you and delivery from us. By any rea sons If you will not receive packages or will disagree with contents you wil l be full refund. 3.All transactions would under control by TNT. But if you will be agreed to do deal thru TNT, price of you order will increase to 30%. 4.For every next order from you we will give you good discounts. It is a general think – secury and guaranties of parties of deal in in ternet. My e-mail: cadsoftwares@europe.com Now we can offer you some positions of our list softwares: Registered softwares by cadsoftwares@europe.com ==================== CAE & FEA Softwares ==================== AEA.Technology.HyproTech.DISTIL.v5.0 AEA.Technology.HyproTech.HX-Net.v5.0.1 AEA.TECHNOLOGY.HYPROTECH.HYSYS.V3.1 ALGOR softwares ALTAIR softwares AMESim.v4.0 for WinNT/2000/XP Amtec.Tecplot.v10.0 ANSA_V11.2 ANSYS softwares Ansys.ParaMesh v2.2 ANSYS.WORKBENCH.SUITE.V8.0 Applied.Flow.Technology.softwares Artas.SAM.v5.0.192 aspen.content.development.server.v7 AspenTech.softwares Autoform V2.1 AUTOMATION_STUDIO_V5.0_PRO AVL.FIRE.V8.2 AVL.SWIFT.V3.1.1 AVL.Workspace.Suite.v3.1.1 AVS/Express V6.0 CADFIX V5.2 CADFIX_V5.2 FOR LINUX CADISON PIPES V4.12 Cadpipe.2002.3D.Design.v7.0.for.AutoCAD Cadpipe.2002.Building.Services.v7.0.for.AutoCAD Cadpipe.2002.Commercial.PIPE.v7.0.for.AutoCAD Cadpipe.2002.HVAC.v7.0.for.AutoCAD CADPIPE.2002.Industrial_v6.6.for.AutoCAD Cadpipe.2002.ISO.v7.0.for.AutoCAD Cadpipe.2002.Ortho.v7.0.for.AutoCAD Cadpipe.2002.PID.v7.0.for.AutoCAD CAE.PowerTools.FEvis.Publisher.v1.0.0.28 CAEFEM.v8.12 CD.adapco.Star-CD.v3.150A.FOR.LINUX CD.adapco.Star-CD.v3.150A.FOR.WIN2000 CFD softwares CFDESIGN.V6.0 CFDlab.v2.2 CFDRC.V2003 CFX.softwares Chemical & Process Simulation Softwares CHEMPOINT.PROFESSIONAL.V6.0.ANSI CHEMPOINT.PROFESSIONAL.V6.0.UNICODE ChemPoint.v4.0 CHEMSTAT.V4.1.ANSI CHEMSTAT.V4.1.UNICODE ChemStations.ChemCAD.v5.2.Pro Citect v5.40 CITECT.SCADA.V5.42 Coretechnologie.3D.Evolution.v1.0 DDS.FEMTools.v2.1 Deform.2D V8.0 Deform.3D V5.0 Dlubal.RFEM.v1.12 DYNASIM.DYMOLA.V5.0A EDS.FEMAP.V8.3 EDSL.Tas v8.5 EDSL.Tas.v8.5 ENGINE.ANALYZER.PRO.v3.3 Engineous.Software.iSIGHT.v8.0 EPCON_API_TECH_DATABASE_v3.0 EPCON_CHEMPRO_v6.31 EPCON_ENVIRON_v2.0 EPCON_SINET_v6.11 EPLAN_PROFESSIONAL_V5.5 ESI.PAM-STAMP.2G.V2003 for AIX Expertsoft.PiSystems.XTE.v6.2.1.17 FEACrack v1.1.020 Fedem.Simulation.Software.v3.1 FE-DESIGN_TOSCA_VM_V4.51 FemScope.ED-Elas2D_v2.20.1 FET.Lisa.v4.0.0 FIRE_v6.0 Flexsim 4.0 FLOMERICS_FLOTHERM_V4.1 FLOWPHASE.POWER.SUITE.V1.02 FLOWSCIENCE.FLOW.3D.V8.1 Fluent PakSi-TM v1.4.7 FLUENT Post 1.2.6 FLUENT V4.5.6 [2CD] Fluent.Airpak v2.0.6 Fluent.Fidap.v8.7.2.FOR.LiNUX FLUENT.FIDAP.v8.7.2.FOR.WINDOWS FLUENT.GAMBIT V2.1.6 FOR LINUX FLUENT.GAMBIT V2.1.6 FOR WINDOWS FLUENT.ICEPAK.V4.0 FOR WINDOWS Gaussian.03.vB.02 Gaussian.03.vB.02.Linux GaussView.v3.0 GiD.Professional.v7.2 HAESTAD.METHODS.WATERCAD.V4.5 HKS.ABAQUS.V6.3-1 DOCUMENTATION HKS.ABAQUS.V6.3-1 for WINDOWS HKS.ABAQUS.V6.4-1 DOCUMENTATION HKS.ABAQUS.V6.4-1 for Linux HKS.ABAQUS.V6.4-1 for WINDOWS HSYM_v2.048 HyperChem.Professional.v7.02 ICEM.CFD.V4.2.FOR.LINUX ICEM.CFD.V4.3.1 Ilight Fieldview v9.1 for Linux Ilight Fieldview v9.1 for SOLARiS Ilight Fieldview v9.1 for Windows INFOLYTICA.MAGNET.V6.11.2 Intec.Simpack v8.6.07 for SOLARIS Intec.Simpack v8.6.07 for Windows IV>Reaction.Design.CHEMKIN.Collection.v3.7.1.for.Linux LMS.Falancs.v2.1 Ls-Dyna V960 LUSAS_FEA_V13.55 MI.NASTRAN V2.0 MSC softwares NAG.FASTFLO.V3.0 NCode.NSoft.v5.3.1 NE.NASTRAN V8.16 NI-488.2.V2.01 NUMECA.FINE.TURBO.DESIGN.3D.V6.13 for LiNUX NUMECA.FINE.TURBO.DESIGN.3D.V6.13 for Windows OidView.Professional.v2.1.74 PAM-Crash.v2001 PDESolutions.FlexPDE.v2.20e Perrys.Chemical.Engineers.Handbook PHOENICS 3.4 PhysProps.v1.6.1 PipeDrop.v1.2.3 PIPEFLOW.3D.V1.037 Pipeworks.v3.0 Piping.Systems.FluidFlow.v2.31 Pointwise.Gridgen.v15.0.LiNUX Pointwise.Gridgen.v15.0.Windows ProCAST.V3.2.0 for WinNT PROFILI_V2.13B Psim V4.1 QFin v2.1 QuikGrid.v4.5.WinAll RAHADNAK.AERODYNAMICS.TAERG.SI.HALLA.V5.1 RAMINT_RAM_ADVANSE_V5.1 Reaction.Design.CHEMKIN.Collection.v3.7.1.for.Windows Rebis AutoPlant v1.5 Rebis AutoPlant v2.01 REBIS.AUTOPIPE.V6.2.FOR.WINDOWS RICARDO_SOFTWARE_VALDYN_V2.8.1 RICARDO_SOFTWARE_WAVE_V5.1 SAFE.TECHNOLOGY.FE-SAFE.V5.0 Simaris deSign v1.30.26 SimSci.DataCon.v3.13 SimSci.HexTran.v8.11 SimSci.InPlant.v3.03 SIMSCI.PIPEPHASE.V8.1 SIMSCI.PRO.II.V6.0 SimSci.Process.Engineering.Suite.2002 SimSci.Visual.Flow.v4.1 Simulog.TetMesh-GHS3D.v3.1 SINAPSPLUS.v4.5 SINDA.FLUINT.v4.4L SINDA-FLUINT.V4.4.BUILT-IN.COMPILER SINDA-FLUINT.V4.4.FOR.COMPAQ.FORTRAN SINDA-FLUINT.V4.4.FOR.WATCOM.FORTRAN SRAC.COSMOS.DESIGNSTAR V4.0 SRAC.COSMOS.EDGE V4.1 SRAC.COSMOS.EMS V2003 SRAC.Cosmos.FloWorks.v2003 SRAC.Cosmos.M.V2003 SRAC.Cosmos.Motion.v2003 SRAC.COSMOS.Suite.V2003 SRAC.Cosmos.Works.v2003 SRAC_COSMOS_FLOWORKS_V2004_FOR_NT SRAC_COSMOS_FLOWORKS_V2004_FOR_WINME SRAC_COSMOS_M_V2.85 SRAC_COSMOS_MOTION_V2004_FOR_NT SRAC_COSMOS_MOTION_V2004_FOR_WINME SRAC_COSMOSWORKS_V2004_FOR_NT STAR.ANALYST.V5.1.0.3226 SuperPro.Designer v4.53 Tecnomatix.eM-Plant.v6.0.9 TECPLOT.V9.0 With CFD Analyzer 2.0 THERMAL.ANALYSIS.SYSTEM.V6.1 THERMAL.DESKTOP.V4.4.5.WITH.FLOCAD.AND.RADCAD THERMO.CALC.V2003P.for LiNUX THERMO.CALC.V2003P.for SGI THERMO.CALC.V2003P.for SOLARIS THERMO.CALC.V2003P.for Windows Ullmanns.Encyclopedia.Of.Industrial.Chemistry.2002.6th.Edition UTS.ADVANCED.SPRING.DESIGN.V6.0 VANDERPLAATS.GENESIS v6.0 VisSim.ECD.for.TI.C2000.v5.0f WATERCOM.DRAINS.v2004 WATERCOM.PIPES.PLUS.PLUS.V2003.7 WatPro.v2.30 wavefun.spartan.02.v1.0.1 wavefun.spartan.02.v1.0.2b WaveFun.Spartan.04.v2.0 WINSIM.DESIGN.II.FOR.WINDOWS.V9.0.5 XYZ.Scientific.Truegrid.v2.1 Contact with us thru e-mail: cadsoftwares@europe.com ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107888
  - 15
    - Datatable.Select method - Difference Between %AE% and *AE* Hi, Keyvalue :AETHAE Keyvalue : AETH The problem is that I am using the Datatable .select method and Filter expression is %AE%.This Pattern is searchs only mid string not with starting point. Output: AETHAE IF i use the *AE* , then searches from the starting point Output: AETHAE and AETH Pls. clarify... Thanks Palani Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107885
  - 16
    - How to synchronize Dataset to database In our project we fetched data into dataset from the database. Now we are storing the data in a XML File from the dataset. The modified DataSet is kept in the XML File And dataset is closed. Later at the time of saving we are building the dataset from the XML file and then want to save the dataset into database. We are not able to save the dataset being populated from an xml file into database. Kindly suggest a remedy for our problem Thanks in advance Regards Arnab Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107884
  - 17
    - DataSet and Table join Is there a way to join DataTables, kind of like how you do join in SQL? Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107878
  - 18
    - Having problem with SQLConnection.ChangeDatabase() method. I have multiple databases in which I want to traverse. Each database is secured using Applicaiton Roles. I use the SQLConnection object to connect to the first database. I run the sp_setapprole procedure and I can access the tables with no problem. However, when I try to call the ChangeDatabase method on my connection object, I get an exception thrown stating that my application role user is not a valid user in the database. If I connect to the same database using Open, it works fine. I don't quite understand what is going on here. Can anyone help? -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107873
  - 19
    - DataTable Select method I want to know what kind of queries can i execute on datatable select method. The one i am interested in is between query for eg:- this is my sample query Select max(resultan) from TblseasResult Where SeasId='15.3.13.3302005' And Countno between 4801 and 4806 where Countno is numerical field now this is what i want to do DataTable1.select("Countno between 4801 and 4806") so it should return all the rows as Datarow array Thanks -------------------------------- From: Mandar Patankar MCP ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>yuriN1lzc0ydMcoRYJ+RYw==</Id> Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107871
  - 20
    - Problems inserting data into Access database Hi, I'm trying to insert new rows into a table in an Access database. Here's my code: Dim cn As OleDbConnection Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cn = New OleDbConnection(ConfigurationSettings.AppSettings("cnstr")) Dim TStart, TEnd As Date Dim duration As TimeSpan TStart = Now() Dim table as DataTable = GetData() TEnd = Now() duration = TEnd.Subtract(TStart) Label1.Text = tbl.Rows.Count Label2.Text = "Operation took " & Round(duration.TotalSeconds, 0) & " seconds to execute." End Sub Private Function GetData() As DataTable Dim AWS As New EEC.BookStore.Books() Dim tbl As DataTable = MakeTable() Dim books As EEC.BookResponse Dim i As Integer For i = 1 To 10 'would be to the max number of pages available 'Call the web service and format data as desired; this works Call Me.AddToTable(books)'custom function that adds rows to the table Next cn.Open() Call Me.SubmitInsertViaAdapter() cn.Close() AWS = Nothing Return tbl End Function Private Function MakeTable() As DataTable Dim tbl As New DataTable("Books") Dim col As DataColumn With tbl col = .Columns.Add("ISBN", GetType(String)) col = .Columns.Add("Title", GetType(String)) col = .Columns.Add("Category", GetType(String)) col = .Columns.Add("Authors", GetType(String)) col = .Columns.Add("SImg", GetType(String)) col = .Columns.Add("MImg", GetType(String)) col = .Columns.Add("LImg", GetType(String)) col = .Columns.Add("Pub", GetType(String)) col = .Columns.Add("PubDate", GetType(String)) col = .Columns.Add("Binding", GetType(String)) col = .Columns.Add("NumItems", GetType(String)) col = .Columns.Add("NumPages", GetType(String)) col = .Columns.Add("EAN", GetType(String)) col = .Columns.Add("Keywords", GetType(String)) End With Return tbl End Function Private Function UpdateTable() As OleDbCommand Dim str As String str = "INSERT INTO Books (ISBN, Title, Category, Authors, SImg, MImg, LImg, Pub, PubDate, Binding, NumItems, NumPages, EAN, Keywords) VALUES ([?], [?], [?], [?], [?], [?], [?], [?], [?], [?], [?], [?], [?],[?])" Dim cmd As New OleDbCommand(str, cn) cmd.CommandType = CommandType.StoredProcedure Dim col As DataColumn For Each col In tbl.Columns Dim param As New OleDbParameter(col.ColumnName, OleDbType.VarChar, 255, col.ColumnName) cmd.Parameters.Add(param) Next Return cmd End Function Private Sub SubmitInsertViaAdapter() Dim daBooks As New OleDbDataAdapter() daBooks.ContinueUpdateOnError = True 'daBooks.SelectCommand = Nothing 'daBooks.UpdateCommand = Nothing 'daBooks.DeleteCommand = Nothing daBooks.InsertCommand = UpdateTable() Label3.Text = CStr(daBooks.Update(tbl)) End Sub When all is done, there are rows in the datatable but none of them were submitted to the database. What am I doing wrong? Please help, I have only a few hairs left on my head!! Thanks, Roshawn Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107866
  - 21
    - Can't find stored procedure On Sql Server 2000, my program can't seem to find the Stored Procedure: AddNewResumeTemplate. The error it shows is: Could not find stored procedure 'AddNewResumeTemplate '1234',1001,'This is a test','This is our resume',5'. The problem is that it is there. I even have Sql Profiler running which shows it trying to execute: exec AddNewResumeTemplate '1234',1001,'This is a test','This is our resume',5 Which is correct and when I copy and paste it into Sql Query Analyser, it works. My code is the same as I have been running for a long time, so I can't seem to see what is missing. Here is what it looks like: ********************************************************************************* Dim ConnectionString as String =System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_ftsolutions") Dim objConn as New SqlConnection (ConnectionString) Dim CommandText as String = "AddNewResumeTemplate '1234',1001,'This is a test','This is our resume',5" Dim objCmd as New SqlCommand(CommandText,objConn) objCmd.CommandType = 4 trace.warn("objConn.ConnectionString = " & objConn.ConnectionString) objConn.Open() objCmd.ExecuteNonQuery ************************************************************************************* The trace.warn shows that it is accessing the correct database on the server, so I don't know why it can't find it. Tom Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107862
  - 22
    - using ReadXML with disparate XML data I want to load data from two related but different XML files into a two different DataTables in a single DataSet, then create relations, and finally filter and select specific data. I can't figure out how to load the two different sets of data into one DataSet. For example, the following results in just one table, and no detail data: XmlDataDocument datadoc = new XmlDataDocument(); datadoc.DataSet.ReadXml(new StreamReader(@"C:\temp\header.xml"), XmlReadMode.Auto); datadoc.DataSet.ReadXml(new StreamReader(@"C:\temp\detail.xml"), XmlReadMode.Auto); Trying a few variations of this code didn't get me any further. Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107854
  - 23
    - A question about closing the SqlDataReader Hi all, I have code like: SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { // do something here } else { reader.Close(); // this is the line I'm not sure about Response.Redirect("to_some_other_page.aspx"); } reader.Close(); My question is: Is reader.Close() in the else part really needed? If reader.Read() returns nothing, then is the reader actually open or not? The code above does not crash, but maybe the Close() is redundant... Thanks. Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107853
  - 24
    - List SQL Servers instaled on the system and the ODBC drivers Hi! I am trying to find a way for listing the SQL servers installed on a machine, for example MS SQL, Oracle, My SQL, Transact SQL. And also the ODBC drivers that exists on a system, including ODBC drivers for sql servers previosly listed, and the ODBC drivers for flat files (for example foxPro dbf files, dBase files, Microsft Office Excel, other ISAMs) In a word, all the posible information existing on a machine for creating datasources . Very much need for this! Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107845
  - 25
    - Can I execute sql drop database cmd w/a SqlParameter Hi, I'm wondering if it is possible to execute a sql command to drop a database with a SqlParameter containing the name of the db to drop. I've tried the following and I get an error SqlCommand dropDbSqlCmd = _masterDbConn.CreateCommand (); dropDbSqlCmd.CommandType = CommandType.Text; dropDbSqlCmd.CommandText = "DROP DATABASE @dbToDrop"; SqlParameter dbNameParam = dropDbSqlCmd.Parameters.Add ( @dbToDrop, SqlDbType.NVarChar, 128 ); dbNameParam.Value = dbName; Error is System.Data.SqlClient.SqlException : Line 1: Incorrect syntax near '@dbToDrop'. Thanx jra Tag: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Tag: 107844

Hello,

I need to implement a free text search on an asp.net page.
I need to search two columns based on a text entered in a tex box.

it should be possible to search any subsrting included in one of the two
columns.

I did the following:

DataView dv=MyOriginaleDataTable .DefaultView;

dv.RowFilter=" column1 Like ' "+srearchstring.text +" ' or column2 Like '
"+ srearchstring.text+ " ' ";

.....
MydataList.DataSource =dv.

.........

This is not working.

Can someone tel me what i'm doing wrong?

Many thanks
JB

Top

Re: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() by Stephany

Stephany
Mon Apr 04 18:58:41 CDT 2005

... Like '%"+srearchstring.text +"%' ...

What you have written will only find it if the column contains the exact
string plus an explicit leading apsace and an explicit trailing space.

The power of 'Like' is provided by it's wildcard characters.

"Jensen bredal" <jensen.bredahl@yahoo.com> wrote in message
news:%23871iOROFHA.604@TK2MSFTNGP10.phx.gbl...
>
> Hello,
>
> I need to implement a free text search on an asp.net page.
> I need to search two columns based on a text entered in a tex box.
>
> it should be possible to search any subsrting included in one of the two
> columns.
>
>
> I did the following:
>
>
> DataView dv=MyOriginaleDataTable .DefaultView;
>
> dv.RowFilter=" column1 Like ' "+srearchstring.text +" ' or column2 Like
> ' "+ srearchstring.text+ " ' ";
>
>
> .....
> MydataList.DataSource =dv.
>
> .........
>
> This is not working.
>
> Can someone tel me what i'm doing wrong?
>
> Many thanks
> JB
>

Top

Re: How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() by Jensen

Jensen
Tue Apr 05 00:44:36 CDT 2005

great, many thanks

Top