Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Data Source Configuration Wizard and autogenerated code
dimension - 26 Feb 2005 6:55 PM - 2 messages
Hi, i have an Access Database being used in my project. When i double click on this in Solutions Explorer, a wizard pops up ("Data Source Configuration Wizard"). Apparently, this wizard allows you to select database object for which you want "accessor" classes created for.  This is all good and i like ...
Score hi
anuradha ravanan - 26 Feb 2005 4:24 PM - 3 messages
i have loaded .net and sqlserver in my windows xp os.but i have error like "cannot open database requested in login "sqloledb.1".login failed .login failed for user sa" is the message.plz help me correct the error. ...
Score Script problem...
Raphaël Désalbres - 26 Feb 2005 3:55 PM - 4 messages
Hello, I'm having trouble with the following script: Me.cnAccountingProgram.Close() Me.cnAccountingProgram.Dispose() Dim cnMaster As New SqlConnection("Initial Catalog=Master; Data Source=(local); Integrated Security=SSPI") Dim cmd1 As New SqlCommand cnMaster.Open() cmd1.Connection = cnMaster cmd1.CommandText = "DROP DATABASE DB_Accounting" ...
Score Transaction Directives..
mahesh - 26 Feb 2005 9:15 AM - 3 messages
How can i include Transaction Directives. Will it work like same fashion of manual code. My appln is in lauching stage, i dont want to change the coding structure for manual transaction code inclusion. So i decided to include trasaction ...
Score Problem with SQL Server Script...
Raphaël Désalbres - 26 Feb 2005 1:54 AM - 6 messages
Hello, I'm having the following problem. Using the following script works OK when run from Query Analyzer use master go Drop database db_Accounting go RESTORE DATABASE db_Accounting FROM DISK='D:\mydb.bak' But, my question is, how can I make it work through VB.NET code? ...
Score dBase
Charles A. Lackman - 25 Feb 2005 11:50 PM - 3 messages
Hello, I am working with a dBase Plus database and I cannot create a connection string to the darn thing.  I have tried the Fox Pro Driver, ISAM and others and I keep getting "File is not a valid Table" exception.  When I look at my ...
Score WinForms connect to Hosted Database?
MisterKen - 25 Feb 2005 8:53 PM - 3 messages
I initially posted this on the WindowsForms group, but perhaps it's more appropriate in the ADO.NET group. Is it possible to using connect  to a SQL Server database on a shared hosted web account using sqlconnection objects? ...
Score Batch queries in stored procedures?
Eric - 25 Feb 2005 8:52 PM - 8 messages
I'm using SQL Server stored procedures to access my tables, but I'm having problems with concurrency violations when updating. The ADO.NET Core Reference (Ch. 11, pg 469) says you can use batch queries to retrieve data after submitting an update via a data adapter.  Am I ...
Score Sorting and Paging at the same time
WALDO - 25 Feb 2005 8:18 PM - 3 messages
I've been asked to develop a web page in which it displays a series of records which are paged. I have also been asked to add sorting into this page. Either by themselves I have done. The peculiar requirement of this project ...
Score Maximum data size or rows
jj - 25 Feb 2005 7:41 PM - 3 messages
Is there a maximum data size(MB) an Access table is supposed to hold? Or a maximum number or rows? concerned jj ...
Score serializing dataset
sonicsoul - 25 Feb 2005 5:08 PM - 3 messages
Hello, In my custom control, i am providing serialization / deserialization of dataset and noticed that, when a dataset table is empty, it will not be serialized. (no xml is generated for empty tables using ds.GetXml or ds.WriteXml) Example: ...
Score Login based connection string setting!
Raj - 25 Feb 2005 4:23 PM - 5 messages
Hi! I am developing a VB .NET based app for a company X that has five associate companies A,B,C,D, and E. Each of the associate companies has its own database, but have one common database to store the user profile and login ...
Score ERROR IN ORACLE CONNECTION
triptiasawa - 25 Feb 2005 3:41 PM - 2 messages
I HAVE CREATED ODBC CONNECTION FOR ORACLE.But when i use the connection in vb.net i get the following error error:ORA-12154 :TNS:could not resolve servicename Posted Via Usenet.com Premium Usenet Newsgroup Services ----------------------------------------------------------     ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ...
Score Re: ExecuteNonQuery() says I have bad SQL
Tom Nowak - 25 Feb 2005 3:19 PM - 2 messages
I am having the same issue and my fields are date, child, activity, starttime, and endtime?  Are any of these reserved words? ...
Score Insert SQL Error
Tom Nowak - 25 Feb 2005 1:27 PM - 5 messages
I am writing a VB NET program, and I have set up the following InsertCommand property and parameters: dap1.InsetCommand = New OleDb.OleDbCommand( _ "INSERT INTO entry " & _ "(date, child, activity, starttime, endtime) " & _ "VALUES (?, ?, ?, ?, ?)", cnn1) Dim prm11 As OleDb.OleDbParameter = _ ...
Score DataSet Performance
Klaus Aschenbrenner - 25 Feb 2005 12:13 PM - 10 messages
Hi! I've a DataTable with 100 rows and 100 columns. Then I'm updating each column in each row. When I call the Update method on the DataAdapter, this generates 10000 UPDATE statements. Are there any solutions how I can create a better solution, which reduces ...
Score DataTable.Select method bug in .Net Framework 1.1 SP1 and in KB891
lynch - 25 Feb 2005 10:31 AM - 2 messages
There is a bug in .Net Framework 1.1 SP1 with the DataTable.Select method. Microsoft's description of the problem may be found here [link] and you can ask for a fix to that issue. The problem is that the fix does ...
Score Close() and Dispose()
alx - 25 Feb 2005 9:19 AM - 20 messages
On some documentation about ADO.NET, I've found that, during the close of a IDbConnection, is a "best practice" to close a connection with these lines of code:     connection.Close();     connection.Dispose(); For example, Microsoft Data Access Application Block uses this code to ...
Score Subject:Writing a db independent data access layer with DAAB:How?
sedefo - 25 Feb 2005 6:35 AM - 4 messages
I ran into this  Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access Application Block (DAAB) in our .Net projects. We use SqlHelper in SQL based projects, and OracleHelper in Oracle ...
Score Problem in Updating records in DataGrid Control
Ganapathi Hegde - 25 Feb 2005 6:25 AM - 2 messages
Hi, I am new to ASP.NET. I developed an sample application, which displays the database table on DataGrid Control. I added Edit, Update, Cancel (Button Column) to Grid Control. Then I implemented EditCommand, CancelCommand and UpdateCommand When I click on Edit link text box will display for editing the fild. But I ...
Score Multiple raiseerrors = SqlException.Errors
DW - 25 Feb 2005 5:59 AM - 2 messages
Hi all, I posted a question a couple of days ago, but did not receive any answers. I´ll try to explain my issue a bit deeper. I will also attach some example code. One stored procedure and some C# code. ...
Score Cannot do update on a record. Please help.
Newbie - 25 Feb 2005 5:09 AM - 4 messages
I am VERY NEW this whole concept of DataSet and all.  I have a code that goes like this.. =============================================             conn.Open()             Dim ds = New Data.DataSet ...
Score new bie to stored procedure...please suggest me
mahesh - 25 Feb 2005 4:05 AM - 9 messages
Hello groups, I'm new to database, i like to master stored procedures, triggers etc. please suggest me good site to read about all this with good example.. Mahe~ ...
Score How to add new record in a form with BindingManagerBase used?
Davis - 25 Feb 2005 2:58 AM - 4 messages
Dear Experts, I have a problem on adding new record in a form, with btnAdd_Click function, the record stays at current record...even with a clear form function, it only clear the record currently staying at. Seems that the datatable in ds ...
Score unicode parameter with contains() clause in OracleClient
curtis - 25 Feb 2005 1:59 AM - 3 messages
Hi, We are trying to provide keyword searching with the Oracle Text engine using the 'contains' predicate.  However, it does not work when using NVarChar or DBType.String parameters like so: IDbConnection conn = database.CreateConnection(); conn.Open(); IDbCommand comm = conn.CreateCommand(); ...
Score Executing stored procedures as CommandType=Text
Gavin G. Jones - 24 Feb 2005 9:21 PM - 5 messages
I've got an urgent problem - I'm converting a legacy VB app to .NET. I've got thousands of pre-saved strings such as "exec sp_name 'p1', 'p2', 'p3'" that execute on a VB 6 application and ADO. These now need to execute on C# and ADO.NET. ...
Score DataRow in ViewState
Steve Kallal - 24 Feb 2005 8:39 PM - 3 messages
When I try to put a DataRow object into ViewState, I get the following error: The type 'System.Data.DataRow' must be marked as Serializable or have a TypeConverter other than ReferenceConverter to be put in viewstate. Right now I have to create a new DataTable object with excepted structure ...
Score SQL Server Data Access - Conversion to Unicode?
epigram - 24 Feb 2005 8:32 PM - 4 messages
If we have a SQL Server 2000 database that does not use unicode data types (nchar, nvarchar, ntext), but is instead uses character data types (char, varchar, text) does ADO.NET go through some conversion process when it, for example, retrieves these values to store in a .NET string?  In particular, ...
Score The field is too small to accept the amount of data you attempted to add. Try inserting or pasting l
jj - 24 Feb 2005 7:17 PM - 2 messages
I am trying to insert data into an "access" table programmatically. Sometimes I get the following message: "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." I believe it is not the field size, it has to do with the amount of data ...
Score Command.Timeout Property Not Working
Brad - 24 Feb 2005 5:39 PM - 6 messages
When I set the Timeout property of a command I am executing it does not end when it reaches the timeout value specified. Here is the code I am using.  My sample query is simply returning all rows from a table with approximately ...
Score update order
Jon the Blind - 24 Feb 2005 5:08 PM - 3 messages
I feel like I must be missing something here. I'm using SQL Server 2000 and ADO.NET. I have 2 tables, a master and a detail table with the usual relationship. Cascade deletions are disabled by design (though I realize ...
Score Setting up a database class and parameters
tshad - 24 Feb 2005 4:56 PM - 4 messages
I am trying to setup a database class and curious how you would deal with parameters? Part of the class looks like: ***********************************************************************     '     ' This Constructor accepts a connection string as input     ' and makes a connection to that SQL Server. ...
Score Binding a DataAdapter to a DataGrid
javabunch - 24 Feb 2005 3:43 PM - 4 messages
Hello, I am new to .Net and ADO.NET. I used Visual Studo .Net to create a Oracle DataAdapter. Now I want to bind to a DataGrid to display the result of the SQL Statment. I tried the following source code but it ...
Score Updating database with DataRow
wayne - 24 Feb 2005 12:21 PM - 4 messages
I'd appreciate feedback on whether it is possible to update a database using a DataRow object rather than a DataTable. Suppose I have the following code:   OleDbConnection conn = new OleDbConnection(m_Dsn);   OleDbDataAdapter adapter = new OleDbDataAdapter();   adapter.UpdateCommand = new OleDbCommand("sp_UpdatePageItem", conn); ...
Score Exception thrown by the dataAdapter configuration wizard
Oriane - 24 Feb 2005 10:21 AM - 3 messages
Hi, For a few days now, I've been unable to complete the Sql/OleDataAdpater conf wizard on VS .NET 2003 Architect. The message is : "the object reference is not defined on an object instance". Exception is raised by function Microsoft.VSDesigner.Data.VS.VsConnectionManager.CheckConnection(Int32 index, ProviderNameInfo)... ...
Score Retrieving procedure parameter information is not supported
HungTrinh - 24 Feb 2005 7:23 AM - 2 messages
Hi All,     I get an error when I use OleDbCommandBuilder.DeriveParameters to retrieve procedure parameter information. The error is " Retrieving procedure parameter information is not supported by the 'Microsoft.Jet.OLEDB.4.0' provider". Below is the query in MSAccess: ...
Score GetChanges returns nothing after data in bound control is changed
diesel - 24 Feb 2005 7:07 AM - 4 messages
I've got a DataTable called dtOrders that is populated with orders from an Access table. There is an associated DataView called dvOrders, which stores a single record (the current order).  I have several text fields bound to this DataView, as follows: ...
Score BinaryDataSet?
SLE - 24 Feb 2005 7:02 AM - 4 messages
Hi there, I am looking for an approach (or preferably some example code ;-) to "dump" a DataSet in a compressed (binary?) and encrypted (simple algorithm will do) file, reversable of course - i.e. a sort of "BinaryDataSet" derived from DataSet and with overloaded methods for WriteXml() and LoadXml() or custom ...
Score Error opening connection
Eugene - 23 Feb 2005 10:13 PM - 5 messages
I'm having problem opening SqlConnection after MSDE reinstallation. In the following snippet: SqlConnection cnn = new System.Data.SqlClient.SqlConnection( ); cnn.ConnectionString = "Connect Timeout=30; Initial Catalog=master; Packet Size=4096; Data Source=(local); User ID=sa; Password=abc" cnn.Open( ); ...
Score Fill a joined typed dataset
Jeronimo Bertran - 23 Feb 2005 9:14 PM - 2 messages
Hi, I am creating an order detail dataset for a particual order using a typed dataset. I created a stored procedure: CREATE PROCEDURE    SPOrderDetail (    @OrderID int ) AS SELECT   OD.ProductID, OD.UnitPrice,OD.Quantity, P.ProductName ...
Score DataTable.Select Method
csl - 23 Feb 2005 9:11 PM - 2 messages
I have a DataTable that has 240000 rows in it.  My DataTable.Select Method for a particular filter gets me 840 out of 240000 rows.  However, it takes about 5 seconds to process.  The DataTable has 6 columns.  The datatype for ...
Score Oracle CLOBs via ODBC?
Kev - 23 Feb 2005 7:54 PM - 3 messages
Hi all, We've got an application which accesses an oracle database, but uses the ODBC .NET drivers, not the Oracle specific drivers. It works fine, but now we want to access a CLOB in the database. Any select is currently ...
Score Button click and Page refresh issue.
Lenny Shprekher - 23 Feb 2005 5:38 PM - 3 messages
I am using regular server site ASP.NET button to execute function. Works fine, issue is that when I call page-refresh on IE after click I done it is calling same event again. Could anybody suggest how to prevent this behavior? ...
Score Select into new Datatable from Datatables
Daniel - 23 Feb 2005 4:14 PM - 2 messages
Hi I have searched vbcity and the internet for a solution for my question but with no luck. But I am sure it must be simple to accomplish? I have to Datatables, DT1 and DT2, already populated from database. What I want to do is to select data from two (or more) datatables (in ...
Score Creating a master-details relationship between 3 tables
mkidd - 23 Feb 2005 2:15 PM - 5 messages
Hi, I'm new at vb .net and I have an issue that must be a common one, but I haven't found an example of it yet. I want to create parent-child relationships for 3 tables (grandparent-parent-child?). I'm trying to create a contact management ...
Score NVarchar vs NText
alx - 23 Feb 2005 12:56 PM - 7 messages
MS documentation says that DbType.String is implicity converted to NVarChar. But this implicit conversion will fail if the string is greater than the maximum size of an NVarChar, which is 4000 characters. For strings greater than 4000 characters, explicitly set the SqlDbType. ...
Score How to use a datareader against an oracle stored procedure
Stefan Soljemo - 23 Feb 2005 11:37 AM - 3 messages
Hi! I have create an application with a lot of call to SQL Server setored procedures. Now when i add support for Oracle 9i choose the Microsoft OracleClient Provider for .NET. My stored procedure returns a REF_CURSOR like the sample Q309361 at ...
Score Seek method, table-direct, and sql server2005
Manuel Lopez - 23 Feb 2005 7:49 AM - 12 messages
From what I've read in the docs, ado.net currently supports opening sql server ce tables in table-direct mode and performing Seek operations on them (using SqlCeDataReader), but not on the full-blown sql server.  Is this ...
Score Has a bound control been changed
Bruce A. Julseth - 23 Feb 2005 4:43 AM - 2 messages
I have a form with several TextBoxes that are bound with a DataView. I also have an active CurrencyManager. My question: is there some way I can tell if the data has been changed after binding is complete. I use the ...
Score Syntax Check
Cathie Hagen - 23 Feb 2005 4:35 AM - 6 messages
Hi All, Is there a way to do a syntax check on the statement without executing it? Cathie ...
Score The number in this cell is formatted as text or preceded by an apostrophe
Jeremy - 23 Feb 2005 1:51 AM - 3 messages
I'm creating an excel 10 worksheet in vb .net.  If I format a range with     oSheet.Range("G1", "Y1").NumberFormat = "0.00" the finished worksheet shows the little green triangle in each cell in the ...
Score Merge is adding 2 records to the dataset
Hemang Shah - 22 Feb 2005 10:16 PM - 6 messages
What im doing: Adding new record to my form. Creating a temp dataset "dsChanges" by using getchanges() dataadapter.update(dsChanges) Then I merge my original dataset dsOriginal.merge(dsChanges) But now my dataset has 2 records instead of 1, one with the auto id field = -1 and one with the autoid field as the one ...
Score asp.net & sql server
rbutch@coair.com - 22 Feb 2005 9:40 PM - 2 messages
hey guys, is there is anything i need to be mindful of when installing sql server Personal edition on a pc that will be hosting asp.net applications? any special attention to WindowsNT Authentication vs SA Login?    choose both? ...
Score How to get rid of those spaces efficiently?
Andrew - 22 Feb 2005 8:43 PM - 4 messages
In the returned records in a DataSet, all the VARCHAR() field values are appended many spaces. When displaying each value, we have to use ..ToString().Trim(). This is really annoying. Do we have a way to do this more efficiently, say, only trimmed VARCHAR() field values are returned? ...
Score How to retrieve the returned function value?
Andrew - 22 Feb 2005 8:21 PM - 4 messages
Hi, friends, I need to call a function of SQL Server 2000. I tried to use DataSet.SelectCommand by passing a stored procedure command, and then fill the dataset. This works fine with store procedures that return record sets. But failed this time. What is correct way to do this? Thanks a lot ...
Score The difference between DataSet.GetChanges and DataSet.Copy
A.M - 22 Feb 2005 7:39 PM - 3 messages
Hi, In which circimstance  DataSet.GetChanges and DataSet.Copy return two different DataSet? Thanks, Alan ...
Score Querying XML data through a dataset
Al Christoph - 22 Feb 2005 7:34 PM - 3 messages
I have a whole set of of small, very fixed tables that i'd like to treat in much the same way. 1) Mock up in XML 2) Create the Schema 3) Populate manually 4) Create the data set 5) Fill the data set with the XML data in the program ...
Score adding a primary key to a dataset/datatable
Bernie Yaeger - 22 Feb 2005 7:24 PM - 11 messages
I have a need to add a primary key to a dataset/datatable.  How can this be done using a standard oledb data provider? Tx for any help. ...
Score HI window popup
Ramanaji - 22 Feb 2005 7:18 PM - 2 messages
Hi, This is Ramanaji, I have a problem in my project I have a code it will open the showdailog window and after that it need to execute the code in the parent window once the all the process completed then I would like to close ...
Score Data Access Components
A.M - 22 Feb 2005 6:55 PM - 6 messages
Hi, Is there any tool that automatically generates code for Data Access component based on existing database table? Thanks, Alan ...
Score Newbie needs jump start
Donna - 22 Feb 2005 5:43 PM - 3 messages
Hi, I am looking for information on efficient use of ADO .Net. I am totally new to this world (Unix/C++ background) and am looking for rules-of-thumb regarding some basic concepts (note this is for WinForms app in C#) - ...
Score submitting updates when there's no primary key
Bernie Yaeger - 22 Feb 2005 4:49 PM - 9 messages
I cannot for the life of me figure out how to modify the backend when a table has no primary key.  I have used all of the examples in Sceppa's book and they all fail - or, rather, update every row, even unmodified rows, when ...
Score Where clause in DataTable.Select method
Matthew Towpik via DotNetMonster.com - 22 Feb 2005 3:53 PM - 3 messages
Just curious how I would include a WHERE clause in the filter string of the Select method. If I want to SELECT * FROM Column1 WHERE Column2 = SomeValue thanks ...
Score Having real difficulty with datatable relation
Stuart - 22 Feb 2005 3:27 PM - 2 messages
Hi there - this is driving me nuts... I have a dataset that contains two datatables. One datatable (SalesMainTable) contains the main crux of an SQL SPROC and I've had to create another datatable (InvSalesTable) that is not the same shape or size ...
Score Need faster data conversion WRT DataColumns
Tyson Kamp - 22 Feb 2005 3:19 PM - 4 messages
Hi All,    I have a DataTable, something like 500x45 (45 columns).  The Datatable is a result of a query that I run against my db.  I recieve updates to the DataTable frequently, and I'd like to speed up the performance of my app. The ...
Score ReadXmlSchema to DataSet adds _Id column
Joel Sj?berg via DotNetMonster.com - 22 Feb 2005 3:00 PM - 4 messages
Hi, I'm trying to load a schema ReadXmlSchema with defined key and relation into a dataset but the result is that VS adds the _Id column anyway what am I doing wrong? Regards, Joel ...
Score DBConcurrencyException when using OleDBTypes DBDate and Double
G@z - 22 Feb 2005 1:14 PM - 2 messages
I'm a total newbie at this - but I am currently writing a vb.net winforms application which utilises an MS Access database. When trying to delete rows in my datagrid and post the changes back to the database, I keep receiving a DBConcurrencyException informing me that no ...
Score Searching thru a dataset
Arsalan - 22 Feb 2005 9:21 AM - 10 messages
How do I search  row values in the dataset? is there any function to do it? suppose i've two columns named 'item' & 'price' I want to search a table which have been filled in the dataset for ...
Score DataRowCollection.Add and NumberDecimalSeparator
Vyacheslav Lanovets - 22 Feb 2005 8:50 AM - 3 messages
Hello, All! I have a Column object with String DataType, so when it's assigned with Double value it gets converted to String. Convertion uses default locale which in my case has "," as NumberDecimalSeparator. Assigning is perfomed by DataRowCollection.Add(object[]) ...
Score Passing datatable/dataset/array as query parameters to SQL Server
Art - 22 Feb 2005 7:09 AM - 3 messages
Hi folks, I've got an app that retrieves a datatable from a third-party database (the db is hosted by a partner company; we get the data via a web service) containing around 100 rows of product SKUs. I need to take those 100 SKUs, pass them to our SQL Server db to ...
Score error filling a dataset...
gloria - 22 Feb 2005 12:38 AM - 3 messages
I get a strange error when working with a dataset.  I can fill the dataset and assign it to a table.  I get the count.  However, when I try to insert the rows from the dataset to another table I get the ...
Score comparing 2 DataRow.ItemArray.Clones
John B - 21 Feb 2005 7:55 PM - 2 messages
Hello On Form Closing I want to find out if the current datarow has been modifed. I thought I could use the following code to get a copy of the record when the form is loaded and a second copy in form closing and compare the two. ...
Score Reference to a Thread.
Anibal - 21 Feb 2005 7:52 PM - 3 messages
Hi, How can i do to mae a reference to a particular running thread in a given time. For example, supose that i define ans start 3 diferents threads, and what i want is in a given moment create a thread variable and set it to one of ...
Score questions about a Generated Insert Procedure
Bruce A. Julseth - 21 Feb 2005 7:03 PM - 4 messages
A couple of questions about a Generated Insert Procedure. 1. Why is there a "SELECT " statement after the insert? 2. This SELECT statement has "WHERE (PrimaryKey = @@IDENTITY)". I "assume" that @@IDENTITY represents the newly generated "primary key" for the record ...
Score Modifying table structure programmatically
Alexei Adadurov - 21 Feb 2005 6:11 PM - 3 messages
Hello all! I'm new to ADO.NET and I have 2 questions: 1. I need to programmatically create a copy of a table (say, 'table1'), named something like 'table1_copy', containing only the structure of the source table and no data. ...
Score another delete prob.
Marc Miller - 21 Feb 2005 6:05 PM - 3 messages
I've read other posts concerning unsuccessful deletes, but I can't find anything that tells me what is wrong with my code.  After I delete() the row in the dataset, the dataset is empty and I get 0 as the value for ...
Score another delete prob.
Marc Miller - 21 Feb 2005 6:03 PM - 3 messages
I've read other posts concerning unsuccessful deletes, but I can't find anything that tells me what is wrong with my code.  After I delete() the row in the dataset, the dataset is empty and I get 0 as the value for ...
Score another delete prob.
Marc Miller - 21 Feb 2005 5:45 PM - 2 messages
I've read other posts concerning unsuccessful deletes, but I can't find anything that tells me what is wrong with my code.  After I delete() the row in the dataset, the dataset is empty and I get 0 as the value for ...
Score simple way to insert new ms access record and return autoid value
olafmol - 21 Feb 2005 5:14 PM - 2 messages
Hello, i am wondering if there is a simple way to insert a new record into an MS Access db and read out the newly created auto-ID field. Using ASP this was rather simple, but in ASP.NET (VB) it seems to have become rather ...
Score curious problem in production
Ollie Riches - 21 Feb 2005 5:04 PM - 17 messages
I am having a problem call a sql server stored procedure in a test\production environment. I am getting an exception from sql server being propagated back to the web service. The exception is a violation of primary key constraint. The exception message is: ...
Score Diff between PositionChanged and CurrentChanged ?
Hemang Shah - 21 Feb 2005 3:23 PM - 2 messages
BindingManager has two properties, PositionChanged and CurrentChanged What is the difference between them. I want to set flags on my form depending on the value of the current record displayed on the form. (update date & checkboxes). Which event would I put my code into? ...
Score altering .cdx files for visual foxpro
Bernie Yaeger - 21 Feb 2005 2:53 PM - 19 messages
My client has a visual foxpro app that he wants me to hook into.  I'm connecting to it via odbc with this connectionstring: Dim oconn_d As New OdbcConnection("Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\test;exclusive=NO") ...
Score notification on insert or update
Michael - 21 Feb 2005 1:12 PM - 2 messages
Is there a way to receive a notification in vb.net when a row is added or updated in sql server 2000 without installing the notification service.  If it can be possible in any way (datatable, adodb or other way) please can you ...
Score Configuration of DataAdapter
Oriane - 21 Feb 2005 10:35 AM - 4 messages
Hi, When configuring a simple "Client" Sql table sqlDataAdapter, with one single primary key, I can't generate the Delete and Update command, although the Insert and Select command are generated. The message is  (translated from french...) : Impossible to determine the columns identifying uniquely the rows for  "Client". ...
Score Interesting error in OleDbDataAdapter.Fill()
pascal - 21 Feb 2005 8:56 AM - 2 messages
Hi, please have a look at the code below: public DataView ListaDocumente() { //dtCache.Reset(); dtCache.Clear(); dtCache.Columns.Clear(); selectCmd.CommandText = "SELECT ID_Document, Denumire, Autor, Data, Descriere, Stocare, Cale, Exemplare, Info, Destinatie, Foi, Pagini, Observatii, Tiparit, Utilizatori.Nume + ' ' + Utilizatori.Prenume AS ...
Score Dataset - Ineritance
IndraKumar - 21 Feb 2005 5:07 AM - 2 messages
Hi,    I have created a class called 'dsData' which inherit from a dataset. Instance of 'dsData' is added to the windows form.  I unable to open the collection editor for tables and relations from the propery window for the ...
Score Colum naming conventions
RitaK - 21 Feb 2005 3:59 AM - 4 messages
Hi, Hope someon can help with this one.  I have added column names with spaces dynamically into SQLServer 2000, eg. Order Details. This appears as [Order Details] on the server and everything looks fine.  However when I go to ...
Score error wiped controls from the form; how to get them back
Dee - 21 Feb 2005 3:57 AM - 5 messages
Hi I changed the name of a DataSet using VisualStudio and the were build errors as i hadn't changed the name in the code yet. My form lost all the controls that where bound to the DataSet with changed name. These properties still appear ...
Score Database Schema and Property Grid.
Mark - 20 Feb 2005 7:13 PM - 4 messages
Greetings. I am trying to use the PropertyGrid Control to display database schema. So far so good. The property grid control displays the database field properties in the property grid. My Question is: How do I change/alter the actual database architecture (say change a field ...
Score AutoIncrementSeed not working right HELP!!
Joe - 20 Feb 2005 2:01 AM - 5 messages
Given the following code new rows should have their AutoIncrement column set to -1, -2, -3, etc... but this isn't the case. When I inspect the new row it shows the last positive value -1 for the new row yet when I look at the column both Auto properties are set as below. I ...
Next » 2 3 4 5 6 7 8 9 10