Hi, I search some record(s) according to specific date which is took from datetimepicker, but a dataset.table(tbname).count is zero. here is my code. I use ODBC.net and Option strict On dim seaSql as string seaSql = "Select * from Orders where JobDate = @tmpJdate " DBCom.CommandText =...more >>

I have some ADO.NET code that uses the Jet OLE DB Provider to read Excel files. The reading of the files works okay. However, I get strange behavious when I have Excel running and run the program that reads the file that Excel currently has loaded. Excel will pop-up messages such as "File is ...more >>

Where can I find a reference for all the parameters that you can put in a connection string for the OLE DB Jet 4.0 provider? I've been looking all over and can't seem to find it. Thanks. - Kevin ...more >>

I am using the DataSet and I have problems, when --> used a SqlDataReader dr ----> while(dr.Read()). With dataset ds ---> while(ds.?????). Thanks ...more >>

Hi Is there a reliable way to place a 'number of concurrent users' limit in vb.net applications? Thanks Regards ...more >>

I have a question about what the SqlDataReader index value returns exactly (in VB SqlDataReader.Item("Value")). According to the .Net SDK this property returns: Overloaded. Gets the value of a column in its native format. I translated this as this property returns the value as it's type, so ...more >>

I've been working with two of my co-workers on developing a .NET content site. Anyway, writing an article is a little more difficult than I thought. How do you make sure you have the important info without boring non-beginners. How do you write important stuff without turning off beginners? ...more >>

I have data field MyTime of type Date/Time in MS Access table Test. I want to add record into this table with value passed as parameter. I do the following in C#: OleDbCommand cmd = new OleDbCommand(); cmd.Connection = MyConnection; cmd.CommandText = "INSERT INTO Test (MyTime) VALUES(?);"; ...more >>

I'm writing a web-based "Query analyser" tool for our company intranet. It allows a user to type any SQL statement in a form, and execute it over the Web. The SQL can be a query that returns results (e.g: SELECT * FROM members) or it can be a T-SQL (e.g: UPDATE/DELETE/INSERT). What I want t...more >>

Hi, Working with ADO.Net/OleDb and Access2000. Using dataAdapter1 to update Access table field and dataAdapter2 to display the value from the same Access data source. Problem is, although dataAdapter1 is updating the Access table (verified in Access), subsequent calls to the dataAdap...more >>

Hi How to include MSDE into install and during install create some tables so program and database server are ready to work? Thanks Konrad ...more >>

Hello, I need to download files from the web server to the PCs without the "Save As" Dialog Box using ASP.NET . Pls advise if there are any components available for any help is appreciated. Thank You EJ ...more >>

Every application uses data. Come and ask members of the Visual Studio and SQL teams about the best approaches for working with data in your applications. Date: September 2, 2003 Time: 1:00 - 2:00 P.M. Pacific time 4:00 - 5:00 P.M. Eastern time 20:00 - 21:00 GMT 21:00 - 22:00 BST (For ...more >>

Hey all, I'm getting the following error when calling an Oracle9i proc from a .net 1.1 app, passing a clob parameter that is larger than ~32,000 characters: ORA-01460: unimplemented or unreasonable conversion requested. Is there a parameter size restriction for oracle procs? How do I pass ...more >>

Hi, I have ASP.NET page that would like to download a list (many) pdf files. I intend to down the file into the browser C:\ root drive without prompting the user to "SAVE AS" dialog box. Would appreciate some help on this (maybe a code snipnet). Thanks EJ Chew ...more >>

I have written a DataRowChangeEventHandler to act as a "security" filter based on the current users "role". The event handler needs to be able to reject/cancel Inserts to the ADO.NET DataTable (these inserts are the results of a Select against the dataSource using the Fill method on a SqlD...more >>

I've been stuck with this stupid problem for the past two days.. I give up now, please help me? Here's the code : OleDbCommand updatedb = conn.CreateCommand(); updatedb.CommandText = "INSERT INTO maintable (name, number) VALUES ('John Smith', '01215489746')"; updatedb.ExecuteNonQuery(); ...more >>

I had an experience this morning that I don't quite understand with VS 2003. I have a Winform with the underlying data coming from three different tables. This data for the Winform is obtained by use of a dataset. The form has tabs. Data in the Contracts table goes to the Contracts tab, data ...more >>

Has anyone tried implementing Rockford Lhotka's CSLA framework from his book Expert One on One Visual Basic .Net Business Objects? The reason I pose this question here is 2-fold. 1. He basically does away with most of ADO.net, other than the DataReader to read a row in order to stuff the ...more >>

I am using Excel as a small database to store settings of a comm program I am writing. While I can read from excel fine, I am stuck on how to write any changes back to the database. I have been trying to use an INSERT INTO but I get the following error: Operation must use an updateable query ...more >>

The following code returns an InvalidOperationException syntax error when stepping over the da.FillSchema statement : Syntax Error: Expecting ',' or 'FROM' after column alias or '*'. The same code works fine using either the MS OleDb data provider or Oracle's native provider. If I add ...more >>

Hello, Can anyone tell me how to retrieve a boolean return value from an Oracle Function, using MS .Net Framework Data Provider for Oracle? In the documentation there's a "Mapping Data Types" table that shows which Oracle data types correspond to which .Net types (OracleType.xxx), but Bool...more >>

Hi, I've sen that VB6 has a datarepeater and that ASP.NET has something like that. But is there something like that for windows forms, or has someone something like that? Thanks Filip...more >>

Is this statement true? "ADO.NET doesn't have it's own engine to connect to a data source, it uses ADO internally. It's another layer on top of ADO. It's pretty much the same as doing an interop with the ADO components... " ...more >>

I have a question regarding indexes. This may be a SQL newsgroup question. If it is I apologize. I actually posted it on both just in case. If I create an index on a table. Will this index be checked through when I execute a select statement from VB.NET or is this index only used through st...more >>

I'm trying to save a time (08:01 for example) to a Data/Time field (formatted Short Time) in an Access table using VB.NET. The problem is that even when I write this time to a dataset, it winds up saving as #08/28/2003 08:01 AM# in the database, where the date is today's date. In plain ol' VB...more >>

Hi! I was wondering if there is a "better" way to use dataset's instead of using "someset.Tables["sometable"].Rows[index][index]" in order to get the content out of the datatables. I think "collections" is what I'm looking for, though I'm really not sure. I have a dataset that has 8 tables ...more >>

Using an ODBCConnection and ODBCDataAdapter object, I am able to connect to a CSV file. However, my data tables are all comeing back with the first line of the CSV file used as a column header line. How do i disable this? TIA// ...more >>

If I do the following code I get nothing returned. Dim i As Integer For i = 0 To ds.Tables(0).Columns.Count - 1 If ds.Tables(0).Rows(0).HasErrors Then MsgBox(ds.Tables(0).Rows(0).GetColumnError(i)) End If Next I get a message box for every column and message boxes are alwa...more >>

I'm trying to populate a treeview from a SQL tables in C#. i've written the SQL procedures (i.e. database wise is sorted). However, I would like to see an example of how to retrieve the data from the tables (recrusive method). I finally worked out how to retrieve the data. it was just a matter...more >>

I cannot get my recordcount to show up properly (using ADO 2.5). It keeps showing -1! Here's a snippet: Dim dbMyDb As New ADODB.Connection Dim rsWebData As New ADODB.Recordset dbMyDb.Open gConnectionString rsWebData.Open "SELECT * FROM WebDataLogAc;", dbMyDb, adOpenKeyset...more >>

I have a sql string that I put through a connection object to fetch my data out of vfp tables using the oledb driver, and then bind it to a datagrid in vs.net 2003. The sql contains a left join between 2 numeric fields, and every time the table on the right side of it has no matching record for...more >>

Here is the scenario: I have a hierarchical data grid. I click on expansion sign on row (this row is not the currently selected row) and then navigate to show the detals of that row. Now is there a way to get the row on which I clicked to navigate to the child-rows?...more >>

I am using OracleDataAdapter.FillSchema() to get the primary key information for the table used in the query string assigned to the command. If the table is referenced directly (such as SELECT * FROM SCHEMA.TABLE) I get the array of DataColumns in the primary key. If the table is referenced th...more >>

Hi, I'm binding a DataTable to several controls and everything seems to be reflected okay. When comes to updating the database, I'm calling DataTable's Select(string.Empty, string.Empty, DataViewRowState.ModifiedCurrent) and passing this DataRow[] into SqlDataAdapter's Update() method....more >>

I'm currently debugging an application. Unfortunately, it is one of those problems that happens sporadically, and I haven't found a reliable way to reproduce it. The basic structure of my code is: try { // execute some update stored procedures sqlTransaction.Commit(); } catch ...more >>

Is it possible to get a handle on the OleDbDataAdapter that was used to populate a DataSet? Alternatively, is it possible to get the OleDbCommand and OleDbConnection used to populate a DataSet - I can use these to create a new DataAdapter and re-populate the DataSet. I can a handle to the DataT...more >>

I am using ADO.NET to create a gazetteer from use by a=20 team of botanists requiring to map species distributions=20 world wide. The intention is to place the common Atlas=20 database under MSDE 2000 on a server which will initially=20 be shared by a group on a LAN. We are using VB.NET 2003=20 ...more >>

I'm a bit confused as to how the sqldatareader oughta be used... so far, I've just assumed that it was only used with SELECT statements and "Provides a means of reading a forward-only stream of rows from a SQL Server database." (from msdn) however, sqldatareader has a RecordsAffected p...more >>

I have a client application written in VB.NET that I need to add security to. To take a simple example, say I have an Employee table, some stored procedures to read/write to and from this table and a class which uses these stored procedures to pass data to the application layer. What I need to ...more >>

Working with the 1.1 CLR and VS.NET 2003, I have two small console apps that are executed periodically by a scheduler. One uses ODBC to check a back-end for certain records and the other uses ODBC to update those same records. The ODBC driver I'm talking to is capable of locking up the process...more >>

Hi, I have created an application in vb.net using SQL Server 2000 database . What I want is to restrict users to access the application more than once,from the same computer or from any other computer. What is the best way doing it as database is disconnected. Currenty I am storing/flag the...more >>

I've installed the V1.1 framework and things have stopped working. Basically I can no longer get a connection to our Oracle 8.1.7 server with the 8.1.7 client software installed. It all worked fine with V1.0. If I use the same connection string in V1.1 that worked in V1.0 strConn = "Data Sou...more >>

I have a multi table join...i.e. string sql = "select customers.name, customers.id, address.street, address.city from customers, address where customers.id = address.id" then I execute the following code: Dataset ds = new DataSet(); System.Data.SqlClient.SqlDataAdapter dataAdapter = new...more >>

I have an ASP.NET application written in framework version 1.0.3705 and it's been running for over a year without issues. I just moved it to a new Windows Server 2003 machine with the 1.0 framework installed beside the default 1.1 and now I periodically get this message: Timeout expired. The...more >>

Hi I want to do a data paging page without using Datagrid control. Can someone help me to find properties in ADO.net which had in ADO to do this? I'm using SQL Server 2000. Regards, Koda ...more >>

Ok.. I followed simple code example in MSDN for simple paging of a datagrid, but I get Error: AllowCustomPaging must be true and VirtualItemCount must be set for a DataGrid with ID DataGrid1 when AllowPaging is set to true and the selected datasource does not implement ICollection. Why,??? ...more >>

I've been having trouble with outlook express (OE). I have been "caught up"... then post a new message... click on another group... read messages there for 5-10 minutes... then back on the group in question to trigger a download of headers... my message isn't there. And it never appears later...more >>

Hi, I'm using VSStudio.Net 2003 bound to an Access 2000 DB. Using the datasets and an oledb data adapter. Using the DACW, I generate a dataadapter select and insert,update,delete commands using the DACW. The Insert command parameter type for an Access Date/Time field is DBDate, which results...more >>

Hello I have a function that returns a string array. The string has a name = and an ID number, they are separated by a comma. I cannot for the life of me by using the string methods get to separate = the two items. Example. The string array looks like, the array is called Trainee :-=20 ...more >>