Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > february 2004 > threads for monday february 2

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

How do I create a table and an Access database using .NET and C#?
Posted by Bob at 2/2/2004 11:51:09 PM


Property Value Changes Value between calls
Posted by polynomial5d at 2/2/2004 11:26:07 PM
Property Value Changes Value between calls In frmTopicFromStart I call a procedure in clsDataChor to retrieve the autoincrementing ID for the topic. I place it in a textbox and also put it in a public variable in btnSaveTabGeneral: clsDChor.TransferID(txtID, iTopicID) MsgBox(...more >>

Very Slow Performance
Posted by Shahzard at 2/2/2004 8:06:13 PM
Hi, I used frontPage 2000 to build my websites which is hooked to MS SQL server 2000. Once I create an application from frontpage with the appropriate database settings and save it and finally Click "preview in web Browser", It takes too much time to display. I don't know when it will be displayed....more >>

Validating in a datagrid
Posted by Karl at 2/2/2004 7:45:01 PM
Hi All I'm trying to validate some values in a datagrid so that if the user does not fill in all required fields the focus remains in the row until they complete the requirements or cancel the entry. Presently I'm using the DataRowChangeEventArgs to check the columns for the required values...more >>

Insert a file into a SQL fields using VB.net
Posted by michael at 2/2/2004 6:45:35 PM
Hi all ! I am new in this NewsGroup ! My question is:: I using VB.net and i want to insert into a fields(SQL server) a picture who are on my hard drive! Can someone help me thx ! ...more >>

Going Crazy with this!
Posted by Merlin at 2/2/2004 6:19:58 PM
Hi Again Group, Sorry to trouble you all again but i`ve been looking at this problem for 2 weeks now and just don`t seem to be able to grasp how to create a relationship in VB.NET with ADO.NET. I have the following: Private Sub frmMainMenu_Load(ByVal sender As System.Object, ByVal e As S...more >>

removing items from a combobox
Posted by Bhavna at 2/2/2004 5:01:09 PM
Hi I wanted to know if it is possible to remove the items that are in a combobox. I only want to remove those items that are in an array that i have E.g if my combobox contains and my array contains I want the values 2 and 4 removed. Is this possible If it is poss how do i go ab...more >>

Connection pool close timeout
Posted by Kevin Jackson at 2/2/2004 4:05:32 PM
It appears that with ADO.NET, an entry is removed from the connection pool after 5 minutes of being not used. At least this is how it appears as we watch the SPIDs on SQL Server. This used to be 1 minute in ADO. Can anyone confirm this 5 minute value? ...more >>



Please help with this Error:
Posted by JFB at 2/2/2004 2:45:48 PM
Hi, I have an error when I fill the dataadapter with : Me.OleDbDataAdapter1.Fill(Me.DataSet11) Here is the error: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll What is the problem? Tks JFB ...more >>

Odd connection issue - (yes I'm running in mixed mode authentication)
Posted by Coder Mouse at 2/2/2004 1:01:09 PM
Here is the scenario... - There are two sql servers: "Production" and "Staging". PLEASE READ THIS BEFORE REPLYING --> Both SQL servers are set to "SQL Server and Windows" mixed authentication mode. (I have verified this multiple times). Both Sql Servers have Named pipes and TCP/IP port...more >>

DataColumn Expression
Posted by Sébastien at 2/2/2004 10:13:26 AM
Hi, I have a DataSet with some DataTables. I would like to set the Expression column of on DataTable to the value of another column in anothe DataTable. Is there any way to do it ? Example : I have 3 tables : Bird, Dog, Cat I create a column called Bird_Name in Cat table. Then I wan...more >>

Data View - explanation
Posted by Morx at 2/2/2004 9:18:25 AM
Couold you please point me to some web sites where I could find more about Data Views and how to use them? Thanks ...more >>

DataGrid and DataSet information
Posted by Sébastien at 2/2/2004 9:08:04 AM
Hi, I have 2 parents tables (example : Car and Road). That Car can use n Roads and Road can be use by n Cars. In that case, I need a middle table because it is a n-to-n relation. So we had a Link_Car_Road table with the primary key of Road and Car as foreign key in Link_Car_Road. So if ...more >>

RowChanging - stop moving from current row
Posted by Dan at 2/2/2004 7:50:30 AM
Hello There is a way to stop moving from current row in data table RowChanging event ? Throwing an exception not work as I want. Thank you ! Dan ...more >>

Newbie Problems Updating SQL
Posted by Aaron at 2/2/2004 7:48:53 AM
I am having some problems updating an SQL view with a button click. Could someone point me in the right direction? This code runs without any errors, but the sql command never makes it the the SQL server. I'm not using a parameters collection or anything, basically because I am not sure...more >>

Execute a View from ADO.NET:Failed to enable constraints...
Posted by Plunaldo at 2/2/2004 2:21:06 AM
Hi Everybody I have a Problem getting Data out of a View...I always get: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. " I have no Idea what the error might be... my view: SELECT DISTINCT dbo.tb...more >>

how to select by a binary column?
Posted by emmanuel.touzery NO[at]SPAM regulussoft.com at 2/2/2004 1:26:10 AM
Hello, I have a binary column in a .NET (C#) in-memory DataTable, and I wish to make a selection based (among others) on this column. It's easy to do such a thing on eg MS-SQL, but I want to do it in .NET's in-memory data. I tried to format the byte array in many ways (including the 0x0001 fo...more >>


DevelopmentNow Blog