Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Datatable : partial copy and columns reordering ?
jmd.msdn - 1 Jul 2006 11:24 PM - 4 messages
Hello. I am writing a program that :     1. create a DataTable     2. reads a .csv text file (not created by me) and fills that DataTable     3. from that DataTable,  must suppress some columns and must reorder ...
Score The ugly DeletedRowInaccessibleException error
Johnny - 1 Jul 2006 4:13 PM - 3 messages
I have a situation where I let users manipulate rows trough a datagridview, when they save, I scroll trough the rows created by .GetChanges and report to the database any changes through stored procedures. For updates and inserts, there is no problems but for deletes I need a way to send to the stored ...
Score How to synchronize V & H scrollbar in TreeView
Sanjib Biswas - 1 Jul 2006 1:18 PM - 3 messages
Hi,    I would like to know how to synchronize the vertical & horizontal scrollbars in 2 TreeView to move up & down, left & right synchronously. Noticed that TreeView does not have any scroll event for vertical & ...
Score How to get the LDF file name of a DataBase
ad - 1 Jul 2006 6:42 AM - 2 messages
I am using SQL2005. How to get the LDF file name of a specified Database? ...
Score Number of characters in "SELECT * from ExcelSheetName"
Gary - 1 Jul 2006 12:43 AM - 4 messages
I've got some perfectly fine code that works well for importing data from an Excel spreadsheet into a .NET DataTable, except I discovered today that it's cutting off any cell that contains more than 250 characters at that ...
Score GetSchemaTable not working correctly in SQL 2005/ADO.NET 2.0
Robert Bouillon - 30 Jun 2006 9:54 PM - 2 messages
I ran GetSchemaTable on every table in AdventureWorks, and a few tables came back with bad meta-data. For example, if you run GetSchemaTable on Production.BillOfMaterials, BillOfMaterialsID has an IsKey value of false, which is not incorrect. I know I can use catalog views to get the info I need, but I already ...
Score Setting column Width of new column
Sid Price - 30 Jun 2006 9:14 PM - 3 messages
I have an application that needs to add a column to one of its database tables. I am doing this with the "ALTER TABLE" command and setting the new column to have a width of 80. The query looks like this: ...
Score Finding Records in a Typed DataSet
KarenP - 30 Jun 2006 8:35 PM - 1 message
Hi, I have a typed DataSet and I am having a problem with one of the tables in my DataSet.  The primary key on this table is defined by two fields: one is a byte[] and the other a DateTime.  I am experiencing two problems, one I've ...
Score Probloaam with ODP.NET Bind Parameter in Oracle 8.16
mablao - 30 Jun 2006 5:50 PM - 2 messages
Hi, I´m having a problem using Bind Parameter with Oracle 8.1.6 The same query runs ok on a Oracle 8.1.7 or later... but on Oracle 8.1.6 the first oracleReader.Read() statement takes a very long time ...
Score numeric field bound to a textbox control, wrong format
Fanor - 30 Jun 2006 3:02 PM - 4 messages
I have a  textbox control bound to a integer field of a table. Why when the value of  the field is 0, the textbox. text show as "0.0000" ???? When I tried to  cast this to a integer variable there is an error: ...
Score Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
mark.norgate@gmail.com - 30 Jun 2006 2:48 PM - 8 messages
I'm using ASP.NET 2.0 and Windows Server 2003. A common problem it seems, and I've followed all the advice on the world wide interweb but I still get the following message: Cannot open database requested in login 'verfiy'. Login fails. ...
Score What's wrong with this dataadapter update code?
Bmack500 - 30 Jun 2006 2:35 PM - 2 messages
This code never updates the underlying source database. What I'm trying to do is iterate through a table, and make changes when I find the key in another table (identical schemas). I would like to work with an in - ...
Score Find Unique Values in a DataTable Column
Chris - 30 Jun 2006 1:52 PM - 4 messages
Hello, I have a datatable with 330 rows of data.  ColumnA has repeating values.  I would like to count the number of unique items in ColumnA.   I looked into using a dataview, but I'm not sure what to use for the rowfilter string. ...
Score Nested TransactionScopes
Steve B. - 30 Jun 2006 1:41 PM - 2 messages
Hi, If I have something like this : using(TransactionScope t1 = new TransactionScope()) {   using(TransactionScope t2 = new TransactionScope())   {     // Do something with SqlServer     t2.Complete();   }   // Do something else with SqlServer   throw new Exception(); // Just to make it fail ...
Score SqlDataAdapter.Update() uses Default keyword for null values in Server 2003
Claudio Biagioli - 30 Jun 2006 1:08 PM - 1 message
I've a tricky problem making me mad: 1. Same application: one on a Window Server 2003, another on my Windows XP development machine. 2. It performs a SQLDA.update() of a Dataset containing rows with some field set to dbnull.value. ...
Score Using stored procedures in C# for postgreSQL using ODBC
nishi.hirve@gmail.com - 30 Jun 2006 10:36 AM - 2 messages
Hello, I am writing one simple application in C# in which i m writing some queries for retriving data from database. Database used is postgeSQL which is used through ODBC. I want to write queries using stored procedures, I don't know where to ...
Score Shortest path to deploy an SQL Express solution
Earl - 30 Jun 2006 9:45 AM - 2 messages
I've been using SQL2k for awhile now and have a VS2005 project I want to deploy with SQL Express. Anyone have a link to the shortest, easiest method of deploying everything needed? ...
Score finding queries that works on a table
sai - 30 Jun 2006 9:13 AM - 1 message
hi all,       i have ".mde" application has around 200 queries and 300 tables. and i don't have any VBA code for this application.  how easily i can find the queries that act on the tables when ever this application is performing any ...
Score How to find queries that acts on a table in .MDE application
Rupesh - 30 Jun 2006 9:12 AM - 1 message
hi all,       I have ".mde" application has around 200 queries and 300 tables. and I don't have any VBA code for this application.  how easily I can find the queries that act on the tables when ever this application is performing any ...
Score regarding finding that work on the table
sai - 30 Jun 2006 9:06 AM - 1 message
hi all,       i have ".mde" application has around 200 queries and 300 tables. and i don't have any VBA code for this application.  how easily i can find the queries that act on the tables when ever this application is performing any ...
Score from Express to sql Server 2005
Dave Johnson - 30 Jun 2006 9:00 AM - 3 messages
how to transform a database from sql server express edition to SQL Server 2005 !!?? thanks i am just new to this :) Sharing makes All the Difference ...
Score finding queries that acts on table
sai - 30 Jun 2006 8:25 AM - 1 message
hi all,       i have ".mde" application has around 200 queries and 300 tables. and i don't have any VBA code for this application.  how easily i can find the queries that act on the tables when ever this application is performing any ...
Score Can't seem to speed up Rows.Add in DataTable
Bryan - 29 Jun 2006 10:40 PM - 10 messages
Hello, I am trying to speed up the process for updating a datatable with new rows. First of all I have 2 datatables, ServerTable and ClientTable, ServerTable is from a remote datasource, it has new, and updated records in it. ...
Score ADO.Net with LongVarChar
BrianB - 29 Jun 2006 10:05 PM - 1 message
I am using Visual Studio 2005 and am trying to store the text XML response from a socket communication with a vendor into a LongVarChar field in a table.  The data always seems truncated to 2KB.  I have ...
Score Your kidding me right?
Tony Van - 29 Jun 2006 9:26 PM - 8 messages
I'm a VB6 programmer trying  to make the transition to .NET I just spend many days learning about Datasets and DataAdapters and spend most of two days trying to code an UPDATE command for the dataadapter along with the parameters for a large ...
Score How to convert 'System.String' to 'System.Guid'
Arne Garvander - 29 Jun 2006 8:23 PM - 2 messages
prm = new SqlParameter("@passkey", SqlDbType.UniqueIdentifier); prm.Value = stringvalue; I got this exception Invalid cast from 'System.String' to 'System.Guid' ...
Score Using DataView.RowFilter with DateTimes including both date and time data
pnschofield - 29 Jun 2006 7:44 PM - 2 messages
I've been scouring the Interwebs all day and can't find any documentation on this.  I have a DataTable with two DateTime columns returned from an Oracle database.  What I need to do is use a DataView ...
Score little OT: DB design question
sklett - 29 Jun 2006 6:11 PM - 3 messages
I'm pretty new to DB design and wanted to run a question by you all. I have normalized my schema to level 3 (I think) and I'm now finding that I need to do many joins to bring all my different data together to model an ...
Score Importing lots of rows :-)
Simon Harvey - 29 Jun 2006 2:50 PM - 5 messages
Hi All, I'm not sure how to approach this problem so if anyone could advise me how to do it I would be very grateful. I have an app that calls a web service. The webservice returns an array ...
Score sql update slow
Chris - 29 Jun 2006 1:25 PM - 5 messages
I am having difficulty sending an update of 20,000 rows to an SQL server.   When I use sqlCommandBuiilder to create the update command the update takes less than a minute.   When I manually build the command and the parameters ...
Score is this possible?
André - 29 Jun 2006 10:43 AM - 3 messages
Hi, Is it possible to use the selectedValue of a dropdownlist to fill one of the field of a detailsview? I tried a lot of things, but still without succes. Here are the two methods i tried with two different errors. It works only when i introduce directly a ...
Score Querying through XML String
Baren - 29 Jun 2006 9:45 AM - 4 messages
Hi! Throught code I will be generating a XMl like this "<ROOT><Employee EmpID="137904" Name=""/></ROOT>". Now using this XML string as a parameter to a store procedure, I want to retrieve the data matching the XML attributes. ...
Score DataGrid in WinForm
Goh - 29 Jun 2006 9:24 AM - 5 messages
Hi,         How to make datagridview first row as a add new record row. result only show in others row except first row.         any source to share? ...
Score Loading DataTable very slow
Adrian Roman - 29 Jun 2006 7:46 AM - 1 message
Hi, Here is my problem very short: Loading an oledb table data takes a fair amount of time, if there is only one thread that loads a table with data. If there are two of them, each loading its own table, loading takes unacceptable time. ...
Score ExecuteNonQuery() returns -1
gallian - 29 Jun 2006 1:04 AM - 4 messages
I am trying to insert new records in table via stored proc EMP_Calendar_SAVE_sp. There is no exception thorwn but RowsAffected is -1. I have tested the store proc, it works fine. Any Help? Code as below:= Public Sub EMP_Calendar_SAVE_sp(ByVal EmployeeCode As String, ByVal ...
Score Speed up Bulk Insert Dataset records!
Jay Balapa - 28 Jun 2006 8:44 PM - 2 messages
Hello, I have an  winform compact framework app which returns a dataset from webservice . I need to bulkinsert that database into my SQLCE database. Right now I iterate row by row and  insert rows one at a time. To insert ...
Score How to specify the sort column of a GridView
ad - 28 Jun 2006 7:50 PM - 3 messages
I use a GridView to display data ,  the datasource of my GridView is from a ObjectDataSource. How can I specify the sort column? ...
Score SqlCommandBuilder not disposing of parameter list
Chris - 28 Jun 2006 7:41 PM - 4 messages
I am using SqlCommandBuilder to create an update command to update a table on my DB of approx 20,000 rows and 10 columns.   Unfortunately, I am detecting a small memory leak using PerfMon to monitor Private Bytes and Working Set.    ...
Score transeferring data between databases
RZavulunov - 28 Jun 2006 5:03 PM - 2 messages
I'm trying to write a page in asp.net where i'll be able to do a mass transfer of records from one table in the (Oracle)  DB to another table with a matching structure in a different db also in Oracle. Is there ...
Score About VB.NET
harrypotter - 28 Jun 2006 4:32 PM - 3 messages
I'm a begginer in this field. So where do I start ? Can you help me to find help tutorials ? I have downloaded VB Express 2005 package from Microsoft . I want to go in a quickway. ...
Score right click on datagridview header
Bob Costello - 28 Jun 2006 3:45 PM - 1 message
I have a dgv with a context menu. The application requires that when a right click occurs on the dgv header, different functionality needs to be invoked. However, if I right click on the header, the context menu appears.  It ...
Score Layering in Windows Forms and Windows Forms for Heavy graphics
vikash - 28 Jun 2006 2:47 PM - 2 messages
Hi, I want to develop a windows based application using .Net 2.0 The application will have the heavy UI and it will have the lots of drawing to do on the form. So can any one give me the direction how can i handle the different ...
Score Problems with IDataRecord.IsDBNull
Chukkalove - 28 Jun 2006 1:41 PM - 6 messages
Visual Studio 2003. MySQL database. The following code throws a "Unable to convert MySQL date/time value to System.DateTime" when the column contains a null value if (Reader.IsDBNull(nCount) == false) foo(); This has me stumped. I thought the function was there to test for this ...
Score unique Key constraint
Baren - 28 Jun 2006 1:17 PM - 5 messages
Hi! All, I don't know whether this question fits into this forum or not> I just need some help in regards to the below question. I want to insert a unique key constraint on a column in an already existing ...
Score Cannot connect to MSSQL2005 (Local) Server?
Asaf - 28 Jun 2006 12:24 PM - 9 messages
Hello, I can't connect to MSSQL2005 Standard when providing (Local) for the "data source=" property in the connection string. When setting the computer name instead of (Local) it does connect! Why I can't connect with (Local)? Thanks in advanced, ...
Score Typed DataTable - NewRow() - Identity Field
TheMaxx - 28 Jun 2006 8:30 AM - 5 messages
ADO 2.0 When i do: MyRow = MyDataTable.NewMyRow(); MyRow.IdentityField value equals last ID + 1 What if other user is doing the same thing and gets same ID On DatatTableAdapter.Update both users will try to update with same ID. ...
Score Grid view
sonali_aurangabadkar - 28 Jun 2006 6:23 AM - 2 messages
I want edit whole grid on single button click ...
Score Move Column in Datatable?
Frank - 27 Jun 2006 6:54 PM - 2 messages
Is there a way to re-order datacolumns? Assume I do a "Select * from (insert table here)" and insert the return rows into a datatable, so the exact fieldnames and order of the fields are not known at runtime. Assume I have to move a column called Duration to appear after the column ...
Score Transaction Promotion problem
lestat.majere - 27 Jun 2006 6:02 PM - 4 messages
We are using SQL Server 2005 with Visual Studio 2005. Both the server and client are 2003 Server SP1 with MSDTC enabled (Allow Inbound and Allow Outbound, Mutual Authentication Required). Windows Firewall is disabled on the client. We are trying to use the System.Transaction.TransactionScope object to ...
Score Parameterized Query
Nate - 27 Jun 2006 5:29 PM - 8 messages
I'm trying to use a SqlParameter for the IN operator in a T-SQL statement: myCommand.CommandText = "SELECT CustomerID, CustomerName FROM Customers WHERE AccountNumber IN (@accountNumbers)"; The problem I am having is that I can't figure out what to assign ...
Score Manage BLOB Data in SQL Server with UPDATETEXT during OnRowAdded event
Olivier Matrot - 27 Jun 2006 3:36 PM - 3 messages
Hello, I would like to use UPDATETEXT in SQL Server to manage BLOB data the efficient way. This topic is discribed in [link] The problem with the sample is that, in my case, the image column accepts ...
Score UPDATE Field Database via xml - problem
Ina - 27 Jun 2006 1:35 PM - 1 message
Good morning, I have this code vbscript code for updata a xml file in to a database. (sample) . I need to update a xml from a database1 to another database2. As the results from the database1 generally changes a every ...
Score UPDATE a XML file problem
Ina - 27 Jun 2006 1:14 PM - 2 messages
Good morning, I have this code vbscript code for updata a xml file in to a database. (sample) . I need to update a xml from a database1 to another database2. As the results from the database1 generally changes a every ...
Score ConnectionString in QueriesTableAdapter
Jan - 27 Jun 2006 12:43 PM - 4 messages
How can I change the ConnectionString in QueriesTableAdapter? I have some queiries which returns scalar values in QueriesTableAdapter in DataSet, but I am not able to change connectionString. How can I do that? I know, I can create SqlCommand and set Connection manually, but after that ...
Score Group by on dataset tables
flavio - 27 Jun 2006 11:09 AM - 3 messages
can i group by data from a table in memory , like i filter or sort data by bindingsource object ? thanks in advance FLAVIO ...
Score Thread safety of DataTable class - Filling on background thread OK?
Alan Cobb - 27 Jun 2006 10:35 AM - 10 messages
Hi, The DataTable documentation says:   "This type is safe for multithreaded read operations.   You must synchronize any write operations." So I should be able to do the following safely? Create and fill a DataTable on a worker thread and then ...
Score SystemNullReferenceException using DataSet.Merge
Classgenerator - 27 Jun 2006 9:12 AM - 2 messages
Hi all, i am using two typed datasets (based on the same Class) and get a SystemNullReferenceException (Source: System.Data.dll / ResetIndexes()) when i try to merge like the following: DS1.Merge( DS2.MyTable ); Then after handling the Exception DS2.MyTable is merged correctly into ...
Score Multiple oracle homes - need to choose
bjansson - 27 Jun 2006 8:55 AM - 3 messages
I'm using the built in Oracle data provider and I am connecting to an Oracle 9 database. The problem is that our customer has several oracle homes and the default oracle home is an old version not working with ...
Score Microsoft: Making a simple process impossible to use in .NET 2.0
Chester.West2 - 27 Jun 2006 1:18 AM - 7 messages
In previous versions of .NET (1.0/1.1), I was able to get the easily able to get a count of items contained in a SQL table by creating a dataadapter with a select command similar to the following: ...
Score Closing of data reader..............
Lowry Smith - 26 Jun 2006 10:29 PM - 6 messages
MyReader.ExecuteReader(CommandBehavior.CloseConnection) I am using the above statement for the reader object. Closing of connection object is taken care in the above statement. Do I have to close the 'Reader' exclusively? ..Net 1.1. Thank you, Smith ...
Score Connection Timeout
orourksj - 26 Jun 2006 8:36 PM - 1 message
I have a .NET application written in C# and ASP.NET (VS 2005). The Database is SQL Server 2005. I have several SPs executed from the ASP pages and all seems to work well. However, I have one SP that supplies ...
Score DataTable -> DataView -> Sort -> DataGrid : need related DataTable index
Diamonds - 26 Jun 2006 7:25 PM - 5 messages
Hello, In my DataGrid for ASP.NET C#, In the UI the user adds rows to the DataGrid and the values are saved in a DataTable. The DataTable is displayed by using a DataView. The DataView is sorted then bound to the DataGrid. ...
Score GridView not showing inserted record
David - 26 Jun 2006 3:24 PM - 3 messages
I am using subroutine to add a record to a table that is bound to a GridView via DataSourceID (SQL table).  I have a link button to do this as I sometimes need to do special processing.  After the record is inserted, the ...
Score Soundex and dataview.rowfilter
Danny M - 26 Jun 2006 2:30 PM - 1 message
Is it possible to use soundex in a rowfilter? ...
Score DbDataAdapter.Update does nothing
Olivier Matrot - 26 Jun 2006 1:39 PM - 2 messages
Hello, I'm having trouble inserting data in a table. Basically, I'm adding a datarow to a datatable that was populated from the datasource with an adapter. Before calling the Update command, the datatable is added a new row ...
Score How can i change varchar to datetime
basulasz - 26 Jun 2006 1:38 PM - 4 messages
I have a datetime column in db that stores datetime in varchar format suct that "20060616120621". I want to get this date in a datetime format to make comparisions according to that. How can i do that with an SQL Query or c# ...
Score ExecuteReader question
Gary Howlett - 26 Jun 2006 9:16 AM - 3 messages
Hi, Im using c# and sql 2005 to retrieve data. What im trying to do is... 1) Connect to webservice 2) Open DB connection 3) Read & return 100 records 4) Do some process 5) Reconnect to webservcice 6) start now at record (currently 101) ...
Score Simple Query Notification - Doesn't Work!!
דוד - 25 Jun 2006 9:16 PM - 9 messages
Hi, I'll try to make it short, thing is - I'm trying to implement a query notification (Sql Server 2005) in a C# Windows Application. I've been through plenty samples and guides, I did everything and it still doesn't work. ...
Score You cannot add or change a record because a related record is required in table 'lok"
André - 25 Jun 2006 1:30 PM - 1 message
Hi, Still the same (unsolved problem), but other error now. I have a detailsview for inserting data, and a dropdownlist which selectedValue must be used to fill one of the field of the detailsview. Table 'pc' is related to table 'lok'. ...
Score Unable to get count of tables properly after new database creation using ADO
Ganga Sridhar - 25 Jun 2006 10:52 AM - 1 message
Platform : Windows2000,XP, MSVisualStudio6.0, ADO, MSAccess (20003) Hi, In my application I need to create a database with tables on the fly and then copy data to it from the source database using ADO.For this I create the destination database, create the table structure in the destination ...
Score Can GridView bind to a standalone DataTable
ad - 25 Jun 2006 5:08 AM - 4 messages
I have a type DataTable, it does exist in a DataSet. How could I bind this DataTable to a GridView? ...
Next »