Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Catalog of tables in an SSCE database
Garry - 25 Nov 2006 3:38 PM - 7 messages
What objects and services do I use to visualize the collection of tables and the table's collections of columns in a SSCE database file. Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to allow me to see the contents very quickly. The Data Source Display inside vs2005 ...
Score No value given for one or more required parameters
Wannabe - 25 Nov 2006 2:34 PM - 2 messages
I am trying to run the following method and keep getting the error "No value given for one or more required parameters". I've seen that if you have a field misspelled, that you can get this error, so I ran the query through ...
Score Storing HTML code into SQL 2005 by using asp.net2
pmn - 25 Nov 2006 1:21 PM - 5 messages
hi, i wabt to insert a rich text format(*.rtf) file type with a picture into sql database. i have done this issue by converting rtf into web page and save the html code into sql server table. but the problem is when the web page has a ...
Score Master and Content pages
Rick - 25 Nov 2006 1:04 PM - 3 messages
I'm trying to get the hang of using master and content pages in ASP.NET 2. I have a web page of various reports setup in a table like this: ************************************************ * * *                                       Header ...
Score Getting a table schema from an Excel File in ADO.NET
Garry - 25 Nov 2006 10:06 AM - 3 messages
Sorry - previous post has incorrect title I am using the following code which appears in slightly different versions in many articles on the web Dim excelConn As New System.Data.OleDb.OleDbConnection Dim dtXlsSchema As DataTable Dim int As Integer ...
Score Getting the Table Schema from an Access file in ADO.NET
Garry - 25 Nov 2006 7:54 AM - 1 message
I am using the following code which appears in slightly different versions in many articles on the web Dim excelConn As New System.Data.OleDb.OleDbConnection Dim dtXlsSchema As DataTable Dim int As Integer excelConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data ...
Score Performanve Issue-Datasets in VB.net
Kashif - 24 Nov 2006 5:27 PM - 6 messages
I'm using datasets in vb.net to pull the data from MSDE server. I refresh the data from server every 30 seconds. Since, i refresh the data i clear the dataset using dataset.clear and then fill it again. This clear method each time seems to be increasing the delay to refresh data. My dataset has information from 4 tables with relationships. Also, when i save the data in database and then refresh the datasets that also keeps increasing the time delay. I'm not sure what else to do as this application is running in a multiuser enviorment and i need to refresh data on 3 PCs running the same applcation. Any advise on how to tackle the problem? Regards, Kashif ...
Score How to covert an Oracle GUID to string ?
Freddyboy - 24 Nov 2006 5:23 PM - 3 messages
Hi, I would like to convert an Oracle GUID to its string representation and I don't know how I can do this. Could you help me please. I need this GUID in its string representation to execute an sql query later ...
Score Can Strongly Typed DataSet contains Stored Procedure Wrappers?
Jon B - 24 Nov 2006 10:51 AM - 4 messages
Hi There! I'm looking into Strongly Typed DataSets in the .NET Framework. I know it can generated strongly typed tables as objects and column names as properties. However, one thing that I would like to know is if it wraps database Stored ...
Score Check these dot net Interview Questions
chrisplanters - 24 Nov 2006 10:05 AM - 1 message
Hi All Check this link... [link] nice set of Interview Questions Thanks Chris ...
Score Question about the DataSet Merge.
Benny Ng - 24 Nov 2006 6:58 AM - 3 messages
Dear All,   Now i have a two dataset. they have same db structure and same columns and same rows.   just the content is not same between them.   for example:   datagrid 1:                 name,sex,order_quality ...
Score World Wide Web Publishing©MIISªºÃö«Y
ad - 22 Nov 2006 11:47 PM - 1 message
½Ð°ÝWorld Wide Web Publishing¬O¤£¬Oµ¥©óIIS©O? ©ÎªÌ¨âªÌ¤§¶¡¦³¤°»òÃö¨t©O? ...
Score What is a good strategy for joining data from separate databases
Eric - 22 Nov 2006 10:45 PM - 4 messages
I have a situation where I must restructure my data access, and was hoping the community could give me pointers or links to articles that would help. My situation is that I need to query data from two separate databases.  One ...
Score reuse connection object with diff username password?
jtbr - 22 Nov 2006 4:43 PM - 16 messages
I have an ado.net based application (using BDP borland data provider actually). Everything is working fine. Up till now the connection string for my single connection object has been hard coded. set in designer. Now its time to implement login functionality using different user names and passwords. For a 'login' I figured, ok i'll close the connection if its open, then just change the ConnectionString. I set the exact same connection string as designer, I just set different username & password values. ...
Score Schema.ini is ignored
Kris - 22 Nov 2006 4:09 PM - 3 messages
Hi, i  have another problem yet with |-seperated values: i have my connection: connCSV = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\path;Extended Properties=""Text""") and my schema.ini: [test.txt] Format=Delimited(|) but i get one big field containing text like "name|phone|street|" and ...
Score SqlTransaction rollback error
Doug - 22 Nov 2006 2:52 PM - 8 messages
Hi, I've read through some posts on this error but none seem to exemplify what I had happen to me and wanted to see if anyone else has seen this. I know a lot of people like to see code, it's going to be hard to show ...
Score Bad record count importing excel spreadsheet to DataAdapter?
Bmack500 - 22 Nov 2006 1:46 PM - 4 messages
Hello! I'm using the code below to import an Excel datasheet into an ado.net table. The problem is, when I get to the point where I want to iterate the recods, it always thinks that there is 999 records in the table! If the table (worksheet) is ...
Score SQL Server Express Error on Connection
elziko - 22 Nov 2006 1:01 PM - 4 messages
My application uses the following code to attach and open a connection to an SQL Server Express Database: Dim conDatabase As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename="c:\database.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True") conDatabase.Open() ...
Score Querying a Dataset
Evan Camilleri - 22 Nov 2006 9:21 AM - 12 messages
I have a dataset populated from a variety of sources, such as Access Database, SQL Database and Web services. I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE clause etc in this dataset. What's the best way to do it? ...
Score DataAdapter.Update bug updating Child table via Relations / RowState corrupted?
Chris Bordeman - 21 Nov 2006 8:30 PM - 10 messages
Hi all.  .Net 2.0. It seems the DataAdapter.Update Method changes the RowState of child records to 'Modified' when updating them through a Relation. If the child records' .RowState is "Added" or "Deleted," shouldn't they STAY that way?  Otherwise when you try to update the child table, you get ...
Score Data Provider for Oracle: MS version vs. Oracle?
Marina Levit [MVP] - 21 Nov 2006 6:14 PM - 17 messages
Anyone have experience with the provider from Microsoft vs. the one from Oracle? I haven't looked very much at either. One would assume that the one written by Oracle itself should perform better, since they should be able to optimize it? ...
Score updating child records in a DataSet w/ new autoinc values after parent insert?
Chris Bordeman - 21 Nov 2006 4:54 PM - 4 messages
Hi all. Using Dot Net 2.0. I have a typed dataset generated by VS. It contains a parent and a child table with a relationship set up in the MSSQL database and showing in the dataset.  _Both_ tables have new records that need to be added to database. ...
Score Schema.ini for all textfiles in the folder
Kris - 21 Nov 2006 11:50 AM - 2 messages
Hi, i try to import several cvs-files into a database. These csv's are delimited by a "|". (don't ask me why it's named csv then ;-) ..Net seems to ignore my settings in the connectionstring: ....Properties=""text;HDR=Yes;FMT=Custom-Delimited(|)""" ...
Score [Datagrid Onclick Error]
DK - 21 Nov 2006 6:10 AM - 2 messages
Hi all, Anyone know how to solve the datagrid onclick problem as below: i click a row in a datagrid then the row change to another color, but when i click on another row, the previous row that i clicked still red ...
Score DataView.Find not working with GUID
Warren J. Hairston - 21 Nov 2006 5:30 AM - 22 messages
Using .NET 2.0, I have a DataView with two columns: JobID (a GUID) and JobNumber (an integer). DataView.Sort = "JobID". When I perform a DataView.Find(SomeJobID), I always get a result indicating the row was found, but it's the wrong row (code below). In the code below, ...
Score RowFilter date expression
petro - 20 Nov 2006 10:41 PM - 3 messages
Is there an easy way to filter a datetime column on the year.  The following does not work: YEAR(BeginDT) = 2006 Also does any one know if there is a list of valid expressions for the rowFilter? Thanks for your help. ...
Score OleDbPermission failed
elora_c - 20 Nov 2006 9:44 PM - 5 messages
I am trying to test distributing a Windows application that accesses a Jet DB (.mdb) database file.  On my development box running Windows XP Pro with Office Pro (and Access) installed, it runs fine.  On my test machine running Windows Server 2003 without Office, it fails with ...
Score InsertCommand gives "Must declare the scalar variable "@..."
Klaasjan - 20 Nov 2006 9:41 PM - 5 messages
Hi, I have a strange problem and i think the sollutions is simple, but I don't get it. I have the following piece of code         Dim pCommand As New System.Data.OleDb.OleDbCommand ...
Score Test
Alex Deriskiba - 20 Nov 2006 8:54 PM - 2 messages
...
Score Save DataSet to Data Definition File
Esha - 20 Nov 2006 8:38 PM - 1 message
I have hundreds of Crystal Reports which have been created on Data Definition Files (ADO Recordset saved into ttx file) All these reports are invoked from VB6 application, and as a datasource for each of them I supply ADO Recordset. ...
Score Connection String - how to include timeout?
Doug - 20 Nov 2006 8:37 PM - 6 messages
Hi, I am having a problem creating a connection string in DotNet.  Here is an example below: "Integrated Security=SSPI;database=MyDatabase;server=MySqlServer;Connect Timeout=60" The problem is in the timeout setting.  I am running a query using this ...
Score Best way to reference a value in DataRowView
offwhite - 20 Nov 2006 5:32 PM - 4 messages
When looping over items in the RowDataBound event for a GridView (ASP.NET) I can access e.Row.DataItem which shows as a DataRowView. The following code allows me to access the data for that row. e.Row.DataItem, System.Data.DataRowView).Row.Item(0) ...
Score Trouble displaying info from access db
GeekyChicky79 - 20 Nov 2006 4:13 PM - 2 messages
Hi Everyone, I have the project below where I'm pulling out information from 1 table "Subjects", pulling the Subjects, and SubjectCode. The Subjects are displaying in the Combo Box just fine, but I can not get the corresponding Subject Code to display in the Label. ...
Score Oracle
Bragadiru - 20 Nov 2006 10:42 AM - 5 messages
Hi, My app needs support for Oracle 10 g database : reading (select ...) + updating + calling stored procedures + distributed transactions eventually. I built it in VS 2005 (ado.net 2.0). What should I use ? Microsoft Oracle .NET Managed provider or Oracle Data ...
Score Re (by Cor): update DataSet - transaction
TheMaxx - 20 Nov 2006 10:36 AM - 4 messages
I think you finally got me! This is an answer i was looking for. But it just feels like a walkaround instead a straight forward, 'by the book (MSDN)' stuff. It's hard to belive that Microsoft did not provide something simpler for a ...
Score help: failed to update data in access database
bill white - 20 Nov 2006 8:35 AM - 1 message
Hi, The attached is a test project, it just demonstrate updating data in db1.mdb(db1.mdb.bak is a copy). There are two records in tenant table, but one record can be updated and another one cannot. If you reset the field ...
Score Datagridview image column nulls
Earl - 19 Nov 2006 8:59 AM - 3 messages
I've got a datagridview bound to Sql2k database. When the image columns return null, I get the goofy looking [X] in the column instead of a blank. Anyone know how to make that just appear as empty instead of the default ...
Score a
TzvikaDotNet - 19 Nov 2006 6:22 AM - 1 message
a ...
Score Insert in Access threw typed dataset Tableadapter
TzvikaDotNet - 19 Nov 2006 6:18 AM - 3 messages
After creating the typed dataset , i've created the wanted sql functions in the .xsd file.  Now i'm trying to enter the data into database threw the insert query that was automaticly created by .net . Must add that in the access itself the sql query work , so i'm pretty sure ...
Next »