Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Getting Identity back
Tina - 12 Nov 2005 5:11 PM - 6 messages
when I do the following in my VB.Net program, how can I get the value of the primary key back which is an Identity column? (I know how to get identity back with SCOPE_IDENTITY() in T-SQL but I need ...
Score Fill data in Excel table
Nikolay Petrov - 12 Nov 2005 8:48 AM - 5 messages
I need to fill data in Excel table. I have an Excel workbook, where some values should be filled in specified cells. I need to do this without COM interop, because i don't have Excel installed. I red that ...
Score www.dvd100.net Sin Canon ** cds y dvds Verbatim Traxdata Princo** www.dvd100.netX15L
maria - 12 Nov 2005 1:18 AM - 1 message
--- Doceb semuradesi ban vehalotekel senahegike sorufepe botoxetimim selenogofil cikopir ramedikode xarelatebaf sumesana lesolo dugedowa pegic mi . ...
Score DataGridView Update
Giovanni - 11 Nov 2005 8:51 PM - 5 messages
Hi All,      I am using VS 2005 and would like to accomplish the following:      Assuming I have 3-4 grids on a given Windows Form.  I would like to update these grids individually on a specified timer interval without ...
Score sqldatareader.read()
Pat Brown - 11 Nov 2005 8:23 PM - 3 messages
Wondering why the following if statement does not run. // obviously the name of my datareader is not sqldatareader if(sqldatareader.read()) { //code } For some reason when my code hits the following if statement it is reading "(!sqldatareader.read()). There are no other sqldatareaders open. ...
Score Newbie: ADO.NET and thread safety
Navin Mishra - 11 Nov 2005 6:57 PM - 2 messages
Hi,   I've multiple related data tables in a disconnected dataset which could be accessed by mutltiple threads to read and write data. The documentation says that dataset and datatable are thread safe to read in multithreaded environment but one needs to lock them to update. Questions: ...
Score getting Identity value back
Tina - 11 Nov 2005 6:48 PM - 6 messages
when I do the following, how can I get the value of the primary key back which is an Identity column? Thanks, T connPO.Open() Dim strSQL As String strSQL = "INSERT INTO Orders " & _ "(JobID, Description, Notes, Status)" & _ ...
Score SqlTransaction Record Not Found
Joe Rigley - 11 Nov 2005 3:06 PM - 3 messages
Hi All, I am using a SqlTransaction object to process a group of database insert / update statements on Sql Server 200 SP4 to complete a business process. Directly after the Commit method is issued, I perform a select on one of the ...
Score Syncronizing across forms
rossu - 11 Nov 2005 1:35 PM - 2 messages
It is easy to tie two datagrids together (e.g. customers and orders) on a single form as the currency manager keeps things under control.  However,I wold like to put the dependent table (e.g. orders) on a separate form.  I've ...
Score Data View Sortation
Carl Howarth - 11 Nov 2005 9:54 AM - 1 message
Hello there, I am updating an asp.net application to implement caching - I have stored a list of menu information that is diplayed in a dataset and filter it at runtime using a dataview based on the area of the system the user is in. ...
Score ORM Frameworks for Visual Studio 2005
sp00ky - 11 Nov 2005 3:33 AM - 5 messages
Can anybody make suggestions as to which ORM/Persistance frameworks work well with ADO.NET 2.0 and Visual Studio 2005?  I've been using ORM.NET since it was open sourced and have been very pleased with it. ...
Score ado.net begin informix transaction
kevinkliu - 10 Nov 2005 11:27 PM - 1 message
Hi, Is there any one used the following way to open a INFORMIX transaction in ADO.NET?    OleDbConnection conn = new OleDbConnection(connString);    OleDbCommand cmd = new OleDbCommand("Begin Work", conn);    cmd.ExecuteNonQuery();    //....Do the other works .....// ...
Score Subprocedure for Oracle's SET DEFINE OFF command
Nathan Sokalski - 10 Nov 2005 11:04 PM - 5 messages
I want to create a procedure in ASP.NET to run the "SET DEFINE OFF" command in an Oracle database. I tried the following: Public Shared Sub SetDefineOff() Dim myconnection As New OracleConnection(ConfigurationSettings.AppSettings("connectionstring")) Dim cmdsetdefineoff As New OracleCommand("SET DEFINE OFF", myconnection) ...
Score Stored Proc args
baffled - 10 Nov 2005 7:58 PM - 3 messages
Is there an existing ADO.Net or Framework class or library for Sql Server that would allow me to get a list of stored procedures AND the arguments, default values, data types, etc...?  I realize there are stored proces like sp_help & sp_procedure_params_rowset ...
Score Add New in Bindings Navigator problem
Vayse - 10 Nov 2005 5:05 PM - 8 messages
Vb.net 2005, Developer Edition. When one creates a bindings navigator, one of the standard buttons created on the toolbar is Add New. Which works fine if you create a new item. However, if you don't enter any data, and click previous record or Move ...
Score Parameter Limitations with ADO.NET?
Phenom - 10 Nov 2005 4:53 PM - 5 messages
I'm trying to perform a simple insert. I have a stored proc that takes 3 params and inserts values into 2 tables. The proc itself works fine. I tested it with query analyzer. However, I'm unable to get the query ...
Score How to pass a OleDbDataColumn as a parameter?
Jon S via DotNetMonster.com - 10 Nov 2005 10:14 AM - 2 messages
Hi all, I would like to pass an OleDbDataColumn as a parameter.  The idea is I would need to check two column values in that particular record and then manipulate them.  Is this the correct practice in sending across the OleDbColumn or ...
Score Expression - IFF - Performance problem
RichS - 10 Nov 2005 8:30 AM - 2 messages
Hi, I'm trying to use the "Expression" property to convert a column of IDs into Strings.  ( i.e. IIF(INFO_ID = 0, '" + strOption1 + "', IIF(INFO_ID = 1, '" + strOption2 + "' ... ) However, I've noticed that the more IFFs I add the worse the performance of ...
Score Select next item in DB without knowing what ID it has
Neo Geshel - 10 Nov 2005 5:48 AM - 12 messages
I have an Access DB, from which I am going to pull images. Each image has an associated ID, but the ID's are not necessarily sequential (some images may have been deleted, leaving gaps in the list of ID's). ...
Score Binary serialization of datasets doesn't work
Mark Walsh (KAZ Technology Services) - 10 Nov 2005 12:28 AM - 3 messages
Hi. I have an application that uses V2 framework. A Windows form application calls a COM+ component function using HTTP remoting (binary channel). ie: ChannelServices.RegisterChannel(New HttpChannel(Nothing, New BinaryClientFormatterSinkProvider, Nothing), False) The COM+ function queries a database and returns a dataset with its ...
Score Combining 2 Fields Using ListBox.DataTextField
Nathan Sokalski - 9 Nov 2005 11:08 PM - 4 messages
I have a ListBox control which I am using with databinding. However, the text that I want to be displayed is a combination of two fields (in this case, first and last names). What do I enter as the DataTextField property ...
Score SQLXML Issues
Joseph George - 9 Nov 2005 10:08 PM - 1 message
We have the following code in the code behind of an ASPX page. SqlXmlCommand cmd = new SqlXmlCommand(strSQLXMLConString); cmd.BasePath    =    ConfigurationSettingsHelper.AppSettings("BasePathForSQLXML837D"); cmd.CommandType    = SqlXmlCommandType.Template ; //...intermediate code ommited for clarity// ...
Score Deleting row from DataView
Derrick - 9 Nov 2005 8:42 PM - 1 message
Hello; Dealing with Winforms on 1.1 framework, VS.NET 2003. I have a DataView (which is the datasource for a datagrid), and I want to be able to delete rows only if specific columns contain specific values.  For ...
Score Creating stored procedures with Ado.net
Andy - 9 Nov 2005 6:11 PM - 5 messages
Hi all, I'm trying to write code which will create a stored procedure in the database.  The code uses a command object to execute the following sql: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO CREATE PROCEDURE apPersonDelete ...
Score Table doesn't have a primary key--actually has two
mharness - 9 Nov 2005 5:59 PM - 2 messages
Hello, I'm trying to determine if a keyfield exists in a datagrid so that I can add it to the datagrid if it's not there or remove it if it is. When I try to use "contains" I get the error but it's not because there is ...
Score Oracle Adventures
Chris Botha - 9 Nov 2005 5:54 PM - 14 messages
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem. Using the exact same code (copy ...
Score Master/Detail DataSet - relation and IDENTITY issues
Andreiwid - 9 Nov 2005 2:44 PM - 2 messages
I've a DataSet with 2 tables inside. Table A is the Master and Table B is the Detail. I've already set the relation between A and B. DataSet1.Relations.Add("A2B", result.Tables("A").Columns("ID"), result.Tables("B").Columns("ID")) ...
Score Typed Datset Inheritance byapss
zaflap - 9 Nov 2005 1:59 PM - 1 message
Hello, I have a case in which i have few data entities which all have common properties. I'm using typed dataset to implement the entities . I've created one main typed datset and created few other typed datasets which all have the main typed dataset as a public member. ...
Score Can Recovery with XmlRead
ad - 9 Nov 2005 1:47 PM - 1 message
I test the XmlWrite/XmlRead from MemoryStrem, my codes is: \   DataSet ds = Will.DM.ExecuteDataset("Select * from Customer);   MemoryStream msOri = new MemoryStream();   ds.WriteXml(msOri);   DataSet ds2 = new DataSet();   ds2.ReadXml(msOri); It compiled ok, but when it run fail at the last line:  ds.WriteXml(msOri); ...
Score How I populate listbox with dataset?
Lasse Edsvik - 9 Nov 2005 12:51 PM - 2 messages
Hello I've created a class that has a method that returns a dataset like this: public DataSet GetAllCustomers() { Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("CustListAll", dbconn); da.Fill(ds); return ds; } Then I added a new project and then tried to do this: ...
Score Correct handling of Connection.Dispose() and Close()
_DG - 9 Nov 2005 10:42 AM - 2 messages
There seems to be some disagreement on the subject of disposing vs closing connections, and exactly when to do that.  I have an app that repeatedly refers to the same database.  Each access involves only a few lines of code, but I understand that it is still good to at least ...
Score How to fill one datagrid from multiple tables!!! Please help me!!!
Letnak - 9 Nov 2005 9:06 AM - 2 messages
Hello All, In the past few weeks I'm trying to find an answer to my query but no results. My question is very simple (I think). I have tow tables width relations between them. I want to show/fill my datagrid with the join result from the tow ...
Score ADO.NET MSDTC Error
Srini Eadha - 9 Nov 2005 5:06 AM - 3 messages
Hi, we are experiencing strange problem in ADO.NET assembly. we use DTC transactions for MSMQ and SQL server. just recently we are consistently(one or two times in a day) getting following exception and losing messages every time with this exception. ...
Score Informix OLEDB problem...
Javier Rojas Goñi/ Parse Software - 9 Nov 2005 3:02 AM - 1 message
Hi, I am developing a simple web app that run querys against an INFORMIX database and output the results to excel. I am accesing INFORMIX via OLEDB. The app opens a thread for each requirement, and each thread opens a ...
Score OracleNumber Conversion Issue
Eric Cota - 9 Nov 2005 2:39 AM - 2 messages
Running the below code: convert.toint32(oracle_Command.ExecuteOracleScalar) Results in the below error: Run-time exception thrown : System.InvalidCastException - Specified cast is not valid. The sql being ran results in: 10438 Any help would be appreciated Thanks ...
Score DataTable.Select() - is it possible to pass rows back to datatable
Andre Ranieri - 9 Nov 2005 12:13 AM - 6 messages
After querying a data table into a DataRow array using DataTable.Select() method, is there any way of updating the table with changes made to the DataRow array? In this example, rows in the original data table do not change even when I ...
Score Best way to connect to Sybase DB?
VMI - 8 Nov 2005 10:29 PM - 3 messages
What's the best way to connect to a Sybase database? I tried it with Microsoft.Odbc, but it's giving me problems when I I run it in another PC. Is there a better connection method? I just need to run a Select query that ...
Score database formats
Darius - 8 Nov 2005 10:19 PM - 5 messages
Trying to compile a document of all industry standard database formats. I can think of SQL Server, Access, DBASE, SyBASE, Oracle, and ASCII . Does anybody know other formats or where I can get a description of database formats? Asking partly out of curiosity and partly because I'd like to tell my ...
Score Stored Procedure with Output parameter
Phenom - 8 Nov 2005 8:53 PM - 14 messages
I am trying to execute a stored procedure with an output parameter. I believe I am missing a piece of code, because the execution fails. I don't know why. When I run the proc in query analyzer it works fine, so ...
Score Determining native database data type?
Andy - 8 Nov 2005 8:18 PM - 1 message
Hi all, I'm trying to write an application which will examine a table and create stored procedures for modifying the table. I was wondering if ADO.net provides a way to get the native type on the database side.. for example a string containing varchar, char, ...
Score License question: .MDB files in .NET applications
leodippolito - 8 Nov 2005 5:05 PM - 2 messages
Hello sirs, I have an ASP.NET application that I am planning to release under the GPL license, free and open-source. Am I allowed to use and distribute JET databases with this application? I am using OleDB to manipulate ...
Score System.DBNull when reading excel file / column with mixed data
Nickneem - 8 Nov 2005 3:17 PM - 3 messages
I'm having a hard time creating a dataset from an excel worksheet [WORKSHEET] Auto    Drop    DEB    Leverdatum 1    1    33370    9-11-2005 ...
Score How to create an Empty XML file
Gus Gustafson - 8 Nov 2005 1:29 PM - 9 messages
I have an application that must create a new, but empty, XML file on demand.  My original approach was to copy an existing "template XML file" into the new XML file.  I found that I needed to pass through each table in the newly ...
Score Datagrid Current Position
No_So_Clever - 8 Nov 2005 11:43 AM - 20 messages
Hi there, I have th following Code to Get my Current Position and show it in a text box, as "Record 1 of 129" for Example. ") + cmSystemUsers.Count.ToString) << I have a Datagrid on my Winform, When I click on one of the rows in My ...
Score Databindings
No_So_Clever - 8 Nov 2005 11:34 AM - 2 messages
Hi There, I wonder If Somebody could Kindly Help me? Whats the Difference between: textBoxID.DataBindings.Add("Text", custList, "CustomerID") textBoxTitle.DataBindings.Add("Text", custList, "ContactTitle") textBoxLastName.DataBindings.Add("Text", custList, "ContactName") textBoxFirstName.DataBindings.Add("Text", custList, "CompanyName") textBoxAddress.DataBindings.Add("Text", custList, "Address") ...
Score Need confirmation on Adapter object ??
serge calderara - 8 Nov 2005 9:27 AM - 3 messages
Dear all, I just would like confirmation or infirmation on the following topics. When using an SQLAdapter in the folloing way: m_dsAdapter = New SqlClient.SqlDataAdapter m_dsReel = New DataSet m_dsAdapter.Fill(m_dsReel) The m_dsReel dataset is populated by the Fill method of the Adapter, then ...
Score How to import records from one database to another?
Peter - 8 Nov 2005 8:12 AM - 3 messages
I have an MS Access Databbase. Some time I want to export some records to a independent Database(It's small and easy to transfer) and maybe in another time I want to import from the  independent Database. My question is : Is there a easy way to copy some records from one Database ...
Score Dataset Multi-Table Row changes
Michael Jenck - 8 Nov 2005 2:53 AM - 1 message
Hi All, After quite a bit of searching through the newsgroups I have been able to fill a dataset with two tables using two separate datadapters. What I need to do now is to update the records in table1 based on the ...
Score DAO data control or DAO instantiation
the_grove_man@yahoo.com - 8 Nov 2005 1:12 AM - 3 messages
I guess my question can go in two directions. I create applications that run multiple queries against a database. Generally speaking in the past I have used a Data Control (calling it dat1) making it invisible and have used this whenever i needed it. ...
Score How to set DAAB's connection string with No Credentials Access?
ABC - 7 Nov 2005 10:08 PM - 1 message
Follow my project, the connection database will not use Trused Connection from web server to database server.  How to set DAAB's connection string with No Credentials Access? ...
Score Unable to read image file correctly that was written using vb6.0
udit_handa - 7 Nov 2005 10:03 PM - 9 messages
I am facing a strange problem I ahve a datadase which stores  tiff images using Image datatype in Sql server. These images are written using a Vb6.0 desktop application with the following code ==================VB Code==================================== Open strFile For Binary Access Read As #(iFile) ...
Score Using a just-created login
Mike - 7 Nov 2005 9:21 PM - 1 message
This may be more of a SQL question. If so, please let me know so I can post it elsewhere. I have a high-usage web service app that must create SQL logins on the fly. The app attempts to connect as the inbound user, and if the login does not ...
Score User control positioning on calling .aspx page
Mike O'Connor - 7 Nov 2005 9:20 PM - 1 message
Hi, I'm having a bit of a newb problem.  I have a user control which is a table and three <tr>'s with text and server controls contained on it.  I'd like this user control to appear in the middle of a <table> on the calling aspx ...
Score Joining two tables from different databases
Dean Perry - 7 Nov 2005 8:39 PM - 2 messages
I have a table from a SQL Server database and a table from a Foxpro database loaded into a dataset. There is a one-to-one relationship between the tables although there may not be a record in the SQL table. ...
Score nesting XML nodes
bill - 7 Nov 2005 7:55 PM - 2 messages
I am using ADO.net in VB.NET.  I'm trying to export relational data from SQL Server 2000 to XML with appropriate nesting. I have included sample code below.  Using a Northwind example for clarity, the XML output is not nested - Customers are presented first, and then ...
Score Alternative for DeriveParameters? (ADO.NET 2.0)
James Tharpe - 7 Nov 2005 6:56 PM - 4 messages
Hello, My application *only* uses the base-classes (e.g. DbCommand, DbParameter) for data access and uses DbProviderFactories/DbProviderFactory to create the concrete classes. That said, I need the functionality of the DeriveParameters static method that is part of the various xxxCommandBuilder classes. So my question is: if ...
Score Bulk insert problem when the last field in the last row is null
damezumari - 7 Nov 2005 5:09 PM - 3 messages
I have a csv file I want to insert into an existing sql-server table using a vb.net windows form. This is my code:         Try             Dim cn As New SqlConnection ...
Score Ingres II money value with ADO.net and ODBC
PIEBALD - 7 Nov 2005 5:01 PM - 1 message
We're using a product that uses Ingres II for its database. I'm accessing the data with ADO.net via the Ingres II ODBC driver V2.8 There are cases where Ingres II's query test tool reports particular MONEY ...
Score insert null into the database
chambersdon - 7 Nov 2005 4:25 PM - 5 messages
I have an application that needs to insert nulls into the database and I don't seem to be able to do this. I am currently trying to do this with a Typed DataSet but I can't seem to Insert Nulls (or udpate columns with a null value). ...
Score SOLUTION: Internal connection fatal error
dave.kehring - 7 Nov 2005 2:57 PM - 1 message
I though I'd post this in case someone else ran into the same problem. I'm using VS.NET 2003, SQL Server 2000. In my case, the error "internal connection fatal error" was being generated when using a DataReader to read the field values of a record. ...
Score one more byte added when writing blob
DHuang - 7 Nov 2005 9:14 AM - 3 messages
Use SQL Server 2K, C# in .NET 2.0. When writing blob to an image column with in  chunks, why is there one more byte added to the data? For example, an image of 29,592 bytes was written to ...
Score large dataSet (continued)
Francois Malgreve - 7 Nov 2005 6:48 AM - 6 messages
Hi, In a previous post I was asking how could I save (import) a large DataSet (potentially 60.000 rows) into a SQL Server 2000 DB. It is a simple Data transfer operation. It seemed that the best way was to do it through a DTS. ...
Score Copying data from one database to another using ADO.NET...
WATYF1 - 7 Nov 2005 4:13 AM - 6 messages
I honestly didn't think this would be such an impossible task, but it has proven to be so. All I am trying to do is copy data from a table in one database to an indentical table in another database. I want to do ...
Score Any advice about large size database transfer?
Dancefire - 7 Nov 2005 3:37 AM - 4 messages
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, What i am tring to do is to transfer a database tabe SRC to another database DEST. Actually it's not only simple transfer,  but the row in DEST is calculated by row in SRC. ...
Score Dynamically Adding DataLists
Nathan Sokalski - 6 Nov 2005 10:30 PM - 3 messages
I have a page on which I want to display several sections each of which contain a list of names. I have two database tables, one of which contains the section headings, and the other contains the names and which section ...
Score Saving to a DateTime field in Sql Server 2000 using ADO.Net
tab - 6 Nov 2005 3:45 PM - 15 messages
I have a Datetime field in a Sql Server 2000 database, and need to update this from within a Winforms application. I have found the format of the datetime value sent to Sql server is different according to whether I send the value directly or use a ...
Score Connecting to a SQL Server in a untrusted domain
Troy - 6 Nov 2005 10:08 AM - 2 messages
Been banging my head on this one for a day so I thought maybe someone could enlighten me. Scenerio: I have a SQL Server in another domain that is using integrated security only. That domain is untrusted but I do have a login for that domain. I ...
Score Modifiying a dataview while enumeration it (1.x->2.0 broke)
Greg Burns - 6 Nov 2005 6:05 AM - 8 messages
I have a DataView that is currently sorted by the Price column.  The sort is critical to the logic I am applying. In .NET 1.x, it seems I was able to modify the Price column in my DataView ...
Score How to create an empty Dbase IV database?
Sanjib Biswas - 6 Nov 2005 4:54 AM - 7 messages
Hi,      I am writing a software using VB.Net 2005 to convert MS Access and Dbase IV database to XML and vise versa. So far, I have got everything working except, I couldn't find any example of creating an empty Dbase IV ...
Score 10M free hosting
Braba - 6 Nov 2005 4:01 AM - 1 message
send blank message to sa***@lpi-hk.com to get access. ...
Score 10M free hosting
Braba - 6 Nov 2005 4:01 AM - 1 message
send blank message to sa***@lpi-hk.com to get access. ...
Next »