Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score How to udpate and alter procedure at once.
ad - 3 Jun 2006 12:31 PM - 6 messages
I want to use SqlCommand.ExecuteNonQuery to execute a Sql which is read from a text file. I want to sql to update a record in myTable, and alter a procedure. The text file is like: -------------------------------------------------------------------------------- UPDATE myTable set Col1='text' ...
Score Loading data into an Access Table from CSV or XML
mosscliffe - 3 Jun 2006 10:58 AM - 11 messages
I have lots of old data files, which I am adding to an Access Database. I read somewhere, that you can select directly on a CSV file or XML by changing the Connection String - Extended Property - or I could have ...
Score create *.cub file from DataSet
GM - 3 Jun 2006 10:31 AM - 2 messages
Hi, The environment is .NET 1.1, VS2003. (can also be .NET 2.0 +VS2005) Suppose I have downloaded a DataSet from the server to the client machine. Now I want to create a *.cub file from this DataSet and save it to disk. ...
Score HELP!!! Error installing SQL Express 2005....
ljh - 3 Jun 2006 9:17 AM - 1 message
I have VS 2005 Pro installed, but I tried to install SQL Express (as I did not know if the "developer" edition that installs with 2005 Pro was the same as my customers would be using). I have got to the "SQL Server Database Services" line in the setup progress ...
Score Send Recieve data to insert into tables using Socket
Ahmad Jalil Qarshi - 3 Jun 2006 9:03 AM - 2 messages
Hi, I have to develop a Client Server application. What I want is that the server will listen on a specific port and client will connect to the server and then send a request to retrieve/insert some data from/into the database. ...
Score how to set the value of the parameter for the SelectCommand?
phil - 3 Jun 2006 8:13 AM - 7 messages
Hi, The gridview linked to this datasource shows nothing. The problem is the value of the variable 'a' which is not passed, i'm afraid ... The code-behind contains the value to be passed: public a As String Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) ...
Score SQL Connection still working after KILL the process in SQL
Brisa Argelia - 2 Jun 2006 10:09 PM - 1 message
I would like to know why is this happening: We do have a multithreading windows application in C#. Each thread establish its own SQL connection to an SQL 2003 server,. Those are worker threads for remote proccess, and each one needs to mantain its ...
Score InvalidCastException in DataRow
Jay Balapa - 2 Jun 2006 9:15 PM - 4 messages
Hello, This is a compactframework windows app. Iam trying read from a DataRow. myTextBox.Text=myDataRow("MyColumn") If there is a value for the myDataRow("MyColumn") then the statement executes. But if the column is empty I get invalidCastException, When ...
Score ANN: C# Online.NET Open Soure List
Press Relations - 2 Jun 2006 8:38 PM - 1 message
FOR IMMEDIATE RELEASE The Open Source Movement has yet to play as critical a role in the development of C# systems as it has in the development of Java systems. Perhaps, it never will. But, for those who cannot afford ...
Score multiple types of queries and stored procedures
Steve - 2 Jun 2006 7:55 PM - 2 messages
I'm using MySql and ADO.net I find myself in a situation where I need to execute many different types of queries.  Basically they are all getting the same type of data, but with different WHERE clauses and different levels of required data. ...
Score why different syntaxes in Commnad lines?
phil - 2 Jun 2006 3:55 PM - 3 messages
Hi, I saw three different syntaxes in command lines: UpdateCommand="UPDATE [mytable] SET [name] = @name ... UpdateCommand="Update `mytable` set `name`=? ... UpdateCommand="UPDATE [mytable] SET [name] = ? ... Does the three do the same? Why those differences? Thanks Phil ...
Score Query builder parameter problem
Jay Bryan - 2 Jun 2006 3:15 PM - 2 messages
Using VS2005 Pro and dotnet 2.0 I am trying to add parameters in the query builder tool while configuring my data adapter using the data adapter configuration wizard. I right-click somewhere on the builder pane and then select properties. At the bottom of ...
Score how to use a stored procedure of Access in VWD?
phil - 2 Jun 2006 2:40 PM - 1 message
Hi, I defined a query in Access. I created a AccessDataSource in an aspx page using Visual Web Developer. I specify Access, oledb etc ... and in the window "how do you like to retrieve data from db?" i choose "specify a cusstom sql or stored procedure". ...
Score A severe error occurred on the current command. sp_AddMergePublication
david.brunning - 2 Jun 2006 1:38 PM - 1 message
This is a follow up to a posting I made which I can no longer update ([link]) Issuing the command "sp_addmergepublication" via ADO.NET against a SQL ...
Score Can't fill dataset whith varchar(350)
Victorious1 - 2 Jun 2006 12:29 PM - 1 message
Why is it that when I try to fill my dataset with a column of type varchar(350) I get a error message "Object reference not set to an instance of an object?  I my application bring back only 250 characters in the column ...
Score newbie working with generated code (vb.net & visual studio 2003)
al - 1 Jun 2006 7:31 PM - 1 message
Hi, I'm using VB.Net to create a windows form that will insert data from an xml file into an SQL Server Express database. As I'm new to VB.Net, i'm using the drag and drop method in Visual ...
Score Connection remain open
Hugo - 1 Jun 2006 3:17 PM - 2 messages
hi everybody I have an assembly that contain Datasets, this DataSets connect to one SQL server 2000 database and retrive information to be use for a web Service. The problem is that when the Datasets (TableDataAdapter) connect to the database ...
Score Datatable Datetime column remove zeroes
DG - 1 Jun 2006 2:05 PM - 1 message
I have added calculated column to datatable and expression looks like this: "somecolumn + datetimecolumn1" now, i do not want zeroes from datetime, just date. How to do it? Thanx. my DataTable is filled via adapter from SqlServer. ...
Score datagridview
mahimam_2004 - 1 Jun 2006 12:51 PM - 3 messages
Hi, How to put conbobox column or any other column into datagridview. please provide me with code in c#. Thanks in advance -- mahimam_2004 ------------------------------------------------------------------------ mahimam_2004's Profile: [link] View this thread: [link] ...
Score Executing MS Access Queries using ADO.NET
jeffmeyer7 - 1 Jun 2006 12:32 PM - 3 messages
I'm currently trying to run queries in an Access database using ADO.NET.  My code works when executing a query whose name has no spaces but errors out if I try to run a query whose name has spaces in it. ...
Score Connection
Claudio - 1 Jun 2006 11:38 AM - 2 messages
I mm developping a winforms application. I use a form do include, alter and delete data. I created a connection using the wizard. I would like that each user uses their own password to log in the SQL Server. I noticed the the ...
Score where clause
bill tie - 1 Jun 2006 11:23 AM - 11 messages
I have an arbitrary number of values in the WHERE clause: select foo from bar where   foobar = '1'   and foobar = '2'   ...   and foobar = 'n-1'   and foobar = 'n' What's the best way to program this? ...
Score invalid path error while accessing FOXPRO table from c#
abhayjoukani - 1 Jun 2006 9:03 AM - 5 messages
HI All, i have a problem accessing a DBF file from c#. this is the code i have specified                 string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data ...
Score How to disable a Constrain
ad - 1 Jun 2006 6:32 AM - 2 messages
I am use the new feature of TableAdapter to develop a web application. I use a ObjectDataSouce to link to a TableAdapter The TableAdapter have two constrains. How can I disable one of the contrain when the ObjectDataSouce get data? ...
Score ADODC refresh method fails after upgrading from XP SP1 to XP SP2
Tony - 31 May 2006 11:00 PM - 3 messages
After upgrading from XP SP1 to XP SP2 get "operation is not allowed when the object is open" error messege. the app in production stop working properly. The refresh method is available, but fails. Here is the code: With Adodc1 ...
Score Provider independent data access: creating a data adapter from a connection
Harold Howe - 31 May 2006 9:10 PM - 1 message
I have written a provider independent ado.net utility class for executing queries. One of the routines looked like this in .net 1.1: static public DataSet ExecuteQuery(IDbConnection connection, String sql) {    connection.Open();    DataSet result  = new DataSet(); ...
Score scope_Identiy() problem vs @@Identity with daAdapter.InsertCommand
Rich - 31 May 2006 4:02 PM - 2 messages
Hello, I am having a problem using Scope_Identity() when inserting a row to a sql server (sql server 2000 standard Edition) table using a sql DataAdapter.InsertCommand.  The row gets inserted but it does not display on the datagridview on my client app (vb2005).  I just get a blank row.  But if ...
Score insert parent-child rows with transaction
adeveloper - 31 May 2006 2:56 PM - 2 messages
hi, i have a typed dataset containing two data tables and a data relation which links the two tables in a parent-child manner. i use a sqltransaction to control the insertion of records into the database. here is the code for the insertion. ...
Score OleDbDataAdapter.Fill throws an error (DB_E_BADROWHANDLE) when .NET 2.0 is installed.
Johnny - 31 May 2006 2:41 PM - 2 messages
When I use the OleDbDataAdapter.Fill to fill a DataSet with a ADODB.Recordset an error occurs ("No error message available, result code: DB_E_BADROWHANDLE(0x80040E04)." If only the .NET Framework 1.1 is installed everything works fine. What's wrong (or changed)? ...
Score How can I join 2 bianry files together back to back?
dee - 31 May 2006 2:08 PM - 8 messages
How can I join 2 bianry files together back to back? Thanks dee ...
Score sorting of parent forms
Anastacia via DotNetMonster.com - 31 May 2006 11:39 AM - 2 messages
Hi I can't seem to get the code right to sort the parent form, i can get the child form to sort. Can anyone help Thanks A ...
Score Implement ADO.NET Row Level Pessimistic Locking
MSDeveloper - 31 May 2006 11:15 AM - 2 messages
I am trying to implement record level pessimistic locking using ADO.NET and SQL Server 2000. A reduced structure of the table is shown: CarrierName(varchar)   CarrierCode(varchar)        RefundStatus(int) ------------------------------------------------------------------------ -------- US Postal Service           USPS                              1 ...
Score <<< State of the art web solution Online>>>
mae2x - 31 May 2006 10:39 AM - 1 message
<<< State of the art web solution Online>>> WickedInnovations has an extensive working experience in E-commerce solutions, web site design , website development , graphic design , search engine optimization , database integration, multimedia presentations, corporate Identity and a lot more. ...
Score Silent install for SQL Express?
ljh - 31 May 2006 9:54 AM - 3 messages
If I develop a SQL Express DB for my app, how do I distribute SQL Express also?  Is there a silent install for SQL Express (like for MSDE)? Also, how do I put my DB in the new SQL Express instance and attach to it ...
Score oos! I got an "invalid authorization specification" when testing my connection to Access. What's g
Hexman - 31 May 2006 4:13 AM - 1 message
I've been working on this app for some time now.  Been developing with vs 2005 vb.net and an Access database.  Something happened and I can't figure out what caused it or how to correct it. ...
Score Load typed dataset
JBoeker - 30 May 2006 11:47 PM - 4 messages
What is the preferred way to read (not write) the records of a typed dataset in C# without use of a form? thanks, Jeff ...
Score SQLHelper STored Procedure Output Parameter
rockdale.green - 30 May 2006 10:30 PM - 7 messages
Hi, All How to get the output parameter's value when you use the SQLHelper (Microsoft Data Access Block)? When I try to access my ourput parm I got the following error. System.NullReferenceException: Object reference not set to an instance ...
Score Silent install for SQL Express?
ljh - 30 May 2006 9:14 PM - 2 messages
ANybody know how to do a silent install for SQL Express?  I need to know if this is possible to make my decision to use SQL Express or Access as a database solution. ...
Score System.Data.ObjectSpaces - Is this namespace included in framework 2.0
Umut Tezduyar - 30 May 2006 9:12 PM - 5 messages
I am trying to figure out if object spaces are included in .net framework 2.0. If so, I am trying to find the dll called System.Data.ObjectSpaces.dll Does anybody know this? ...
Score Why choose SQL Express over Access?
ljh - 30 May 2006 8:22 PM - 83 messages
Why would you choose SQL Express (which requires an installed application to work) over the simplicity of an Access database which has no dependencies? ...
Score Suddenly slow ado.net connections
George - 30 May 2006 6:45 PM - 6 messages
Last week we were running some code that connects to two different SQL 7 servers. On Friday, the connection times were normal (almost instananeous).  Today, from all of our development boxes, the connections are taking 5-7 seconds to open.  The app is written using the 2.0 framework. ...
Score Getting "A severe error occurred on the current command" after SP4
dwaine - 30 May 2006 6:37 PM - 3 messages
Codebase has been in place for 1.5 years.  Current version running since 12/2005.  First use of a command object that has 14 parameters. Now I get this error on first use, subsequents work fine.  sproc work ...
Score Re: Change Textbox to Checkbox in datagrid
Jerry H. - 30 May 2006 6:27 PM - 1 message
Hi Anastacia... You didn't indicate what version of NET framework you are using, but you should look at the newer "DataGridView" object in the 2.0 framework - it's a souped up Datagrid in most respects. You can present your columns in Checkbox, Combobox, Text, Button, Link ...
Score Boolean datatype column refuses to Copy to Bit datatype SQL Table
Fiddelm3742 - 30 May 2006 5:25 PM - 2 messages
I have a table that I generate the schema for by way of  da.FillSchema(ds,schemaType.Source, StringLoadTable) One of my columns (numerous columns actually) are created as System.Boolean however the actual SQL column that the schema is pulled from is of datatype ...
Score Table.DisplayExpression
Bart - 30 May 2006 4:04 PM - 3 messages
Hi, What can you do with the Table.DisplayExpression property? I tried to use this as a custom name for my table but only table columns are allowed? Thanks Bart ...
Score dataset question
Simon Whale - 30 May 2006 2:58 PM - 1 message
i have bound a datset to a datagrid control.  but on the dataset i have hidden on of the columns, by using the following data.Tables(0).Columns(0).ColumnMapping = MappingType.Hidden my question is that i want to be able to allow the users the ablility to ...
Score Looking For Example That Opens Connection To Access Database At Run Time
clusardi2k - 30 May 2006 2:54 PM - 2 messages
I am looking for a small example program which will create, at run-time, a connection to an Access database. I would like the example to have a navigation bar and display a table from the database. Please only post code for a working small program. ...
Score typed dataset tableadapters and update (basic question)
milkmate - 30 May 2006 1:54 PM - 2 messages
Hi, I'm using ado.net 2.0 and I have this strongly typed dataset that has this table that has some custom sql update queries. The thing is, my customDataSetTableAdapter.myTable has no generic "Update()" method. It only has some ".myCustomUpdate(param1,param2)" ...
Score ANN: .NET Languages list on C# Online.NET
Press Relations - 30 May 2006 12:44 PM - 1 message
FOR IMMEDIATE RELEASE C# Online.NET assembled a list of .NET languages and .NET language projects to help you become more aware of what is available before you begin that new project. The list contains: - Open Source, freeware, and commercial .NET languages ...
Score The most basic SQL Server questions....
ljh - 30 May 2006 4:39 AM - 4 messages
(sorry if this posts twice....I waited several hours and didn;t see it - so here it is again.....) Perhaps I am somewhat dense.....but, I still need to know..... What do you need to do in order to ship a SQL server Express or Developer ...
Score BeginExecuteReader doesn't work on one machine in my environment
Rhett - 30 May 2006 1:53 AM - 1 message
Hi All, Sorry--I originally posted this in the ado group. The attached listing runs fine on all production machines save for one laptop which throws the following exception "Timout expires. The timeout period elapsed prior to completion of the operation or the server is not ...
Score GetChildRows() Fails.
MioTheGreat - 29 May 2006 11:53 PM - 4 messages
Ok. So here's my situation. I've created a small database in SQL Server 2005 that looks like this: CREATE TABLE [dbo].[TblB](     [Id] [int] NOT NULL,     [Name] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ...
Score It seems to be the most basic questions that I don't see answered.....
ljh - 29 May 2006 11:30 PM - 4 messages
Perhaps I am somewhat dense.....but, I still need to know..... What do you need to do in order to ship a SQL server Express or Developer edition database with your Visual Studio .Net 2005 application? Does SQL Server Express need to be installed on the target machines?  Or, ...
Score Moving Data with DataSets/ADO.NET - looking for examples
kellygreer1 - 29 May 2006 9:50 PM - 5 messages
I'm looking for some examples of: 1) Loading a DataSet with one dataadapter and connection. 2) Reconnecting that DataSet to another dataadapter / new connection 3) Pushing the DataRows back to the database as if they were new rows. For my application of this... the Tables are identical in design (same ...
Score Need physical filename of datasource
Edwin Knoppert - 29 May 2006 8:11 PM - 1 message
My connectionstring has the |DataDirectory| keyword. Unf. the connection object still does not return the real filename. I'm of course able to replace() this keyword in code but i wonder if there was a native call to obtain the folder/filename. ...
Score Linq adoption
ryanbaldwin - 29 May 2006 4:19 PM - 4 messages
pre-emptive apology:  I'm not sure if this is the best place to post about Linq, but I haven't seen a public linq forum, so I figured ado.net would be the closest thing.  My apologies if my assertions have ...
Score Can't get data table to stop constraining user input
David - 29 May 2006 2:17 PM - 2 messages
Hi, I have a data table that was generated using the dataset designer. It refers to a table in a database that has a primary key. The primary key constraint is captured by the designer and enforces a value/uniqueness in client ...
Score DB_SEC_E_AUTH_FAILED: Cannot insert Data into a table
MattHHDE - 29 May 2006 9:23 AM - 1 message
Hello   i try to insert data into a table located in a DB on a MS-SQLServer. Unfortunally every time i try a INSERT INTO i get a DB_SEC_E_AUTH_FAILED error. My Connection string: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security ...
Score Datagrid is not updating in one-to-many relation
webseal via DotNetMonster.com - 29 May 2006 7:44 AM - 1 message
I have set up a one-to-many relation and show data of the master table and the child table in two datagrids. All seems to work fine, data is shown in both grids, and the child datagrid only shows the rows that are dependent from the first master row. The problem ...
Score Image DataType Database Timeout Problem
TreeView Custom - 29 May 2006 5:32 AM - 1 message
Hi We have table with image datatype while retreving from ado.net i am using reader to loop through each record.While looping through i am getting timeout expiration problem. I have table name with below structure -------------------------------------- id              uniqueidentifier ...
Score Object reference not set to an instance of an object in InitConnec
Jim Sneeringer - 28 May 2006 10:22 PM - 2 messages
This occurs on the first attempt to connect to a database in a web application in release mode only. Solution: - Click "Start." - Right click "My Computer" and select "Manage." - Select "Services and Applications," "Internet Information Service," "Web Sites." - Right click the folder for the web app and select "Properties." ...
Score Creating PDF file out of XML datasource
Puneet - 28 May 2006 8:38 PM - 2 messages
Hello everyone, I have data in XML file, thats generated at runtime. Now i want to load this all data into a PDF file and save that file... can someone suggest me dome way of doing the same. Thanx ...
Score Dynamic filter in DataGridView
CMC - 28 May 2006 12:35 PM - 2 messages
Hi! I've a bound DataGridView with 2 columns. The second one is a ComboBoxColumn loaded with a datatable. Can I filter the list of the ComboBoxColumn by the Cell value of the same row of the previous column??? I don't know how! ...
Score Connection Timeout
Thomas Kehl - 28 May 2006 11:43 AM - 2 messages
Hello. I am trying to connect to a SQLServer. Now, it takes long time to detect, if the server is available or not. I think, the parameter Connection Timeout from the ConnectionString will be used to set the Time. Now it takes about ...
Next »