| Groups | Blog | Home |
|
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 |
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 Connection is busy with results for another command Posted by Lee Schipper at 2/4/2004 11:05:05 PM After migrating an existing app from VB6 to VB .Net, SQL operations on ADO
started giving this error periodically:
Connection is busy with results for another command
I am still using the ADODB library -- I did not migrate to ADO.Net
Looking at the SQL Server enterprise manager, I see t...more >>
When a connection closes.... Posted by Twitch at 2/4/2004 8:40:55 PM WRT:
System.Data.SqlClient.SqlConnection
When an SqlConnection goes out of scope, is the .close() called by it's
destructor?
thanks.
...more >>
DataGrid newbie question Posted by Andy at 2/4/2004 4:45:09 PM How to change columnheader's text in datagrid ?
TIA
...more >>
Optimising app Posted by John at 2/4/2004 4:29:37 PM Hi
We have an access application running over a win2k network. I have now
rewritten the ap in vb.net and the problem is that the vb.net app runs
generally slower(!) then than the access app.
I am using a typical dataset/dataadapter scenario and doing most of the
things in code including the...more >>
DataView Posted by EDYRIHE at 2/4/2004 3:56:05 PM Hello
I am editing serveral textboxes that are bound to a DataView, But I don't know how to updatd my Tables with the changed information
thanks for helping me....more >>
DAAB: hierarchical updates and deletes Posted by taryn.knous NO[at]SPAM champsoftware.com at 2/4/2004 2:53:44 PM I have a parent child relationship that I have having a hard time
either inserting and updating or deleting. I have a parent DataTable
(Contact) and a child DataTable (ContactPhone). I am using a
DataRelation between them. I am also using the MS Data Access
Application Blocks. I have read nu...more >>
DataSet / DataTable / Row selection Posted by Sébastien at 2/4/2004 1:37:11 PM Hi,
Does someone could tell me an easy way to select the last row added in a
DataTable inside a DataSet ?
Something like :
DataSet.Table(myTable).SelectLastRowAdded ()
Thank you.
...more >>
SqlDataAdapter.Update() Posted by Paul at 2/4/2004 11:41:08 AM I read some records from a text file using OleDbDataAdapter into a DataTable. Now I'd like to upload these records to Sql Server using SqlDataAdapter. Currently, I clone my DataTable and insert records into my cloned DataTable. This way the SqlDataAdapter properly recognizes that the records are ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DataSet serialization Posted by Viorel Ghilas at 2/4/2004 11:03:00 AM Hi all,
I have my own classes that derives from DataTable,
Ex.
[Serializable]
public class MyTable1 : DataTable {
public MyTable1() : base { ... }
public MyTable1(SerializationInfo info, StreamingContext context) :
base(info, context) {}
}
My business layer create and fill the t...more >>
Connection to paradox 4 from vb.net application ? Posted by ItsMe at 2/4/2004 10:19:40 AM Hi,
How can I connect to paradox 4.0 from my vb.net application ? Any sample
code ?
Help me !
...more >>
UTF 8 Encoding in ADO.NET Posted by Paulraj thomas at 2/4/2004 10:01:07 AM Hello
we are into internationzation our App. we are facing one issue : right now, VB.NET is communicating to the ODBC driver (Teradata) in utf16 encoding. but the odbc driver can handle only utf-8 encdoing , not the utf-16. we tried to use th
utf-8 encoding function to convert the utf8 to utf16 w...more >>
Identifying a newly created row ? Posted by JorgenD at 2/4/2004 9:26:09 AM Hi
I have a DataGrid bound to a DataView, and when adding a new row to the view I want it to be the current/selected one
I've tried the followerin
DataRowView row = myView.AddRow()
row["Date"] = DateTime.Today
.
.
row.EndEdit()
myGrid.Select(myView.Count-1)
This works fine as long the vi...more >>
Can someone educate me? Posted by Aaron at 2/4/2004 8:12:09 AM I have been building a windows app with a sql query, but I was using a
view and I learned that it is very difficult to use a view for updates.
So I began investigating this and found some information regarding
creating multiple sqldataadapters, one for each table, and then
generating a data...more >>
DataAdapter.Update Problem Posted by HKM at 2/4/2004 8:11:07 AM
hi all,
I'm building a typed dataset from a sql table. Later programmatically inserting rows upon user data. When I execute DataAdapter.Update(ds). I get a constraint violation on one of the columns which is non-null column. Looking at the XML data in the dataset, I get an exception on a row th...more >>
Cancel a delete operation Posted by Roshawn at 2/4/2004 7:34:27 AM Hi,
I am trying to cancel the deletion of a datarow. When the user presses the
Delete button, a messagebox displays asking the user if they really want to
delete the current row. If "Yes", then the delete occurs; if "No", then the
current row remains in the table and is not marked for deleti...more >>
Moving Data Between 2 Databases (SQL) Posted by rdm412_18 NO[at]SPAM hotmail.com at 2/4/2004 6:26:16 AM I have created a web form that enables a user to pass a large amount
of data between 2 different SQL 2000 Databases. The current
methodology is to extract the source data, store it in a .Net dataset
and then using the CmdBuilder, pass each line of data out to the
destination database.
I'm ha...more >>
Fill question Posted by Woody Splawn at 2/4/2004 6:21:07 AM Does a Fill command make an automatic connection when initiated? When it is
through does it automatically disconnect?
I am just wondering if I need something like the following around a fill
command?
mySqlConnection = New SqlConnection(myConnectionString)
DaContracts.Fill(DsMain1, "Contr...more >>
Filters with Dataview or new SELECT Posted by Masahiro Ito at 2/4/2004 4:10:14 AM I am new to database programming, and would like to follow the preferred
programming methods when possible...
I have large databases, in a small 'always connected' environment. I have
been pulling large tables, and creating filters with some checkboxes etc..,
which create dataviews. Coupl...more >>
Repeater Vs Datagrid Posted by Pums at 2/4/2004 1:11:06 AM Hi All
For one page I want to implement sortng as well as paging. Curretly that page is using datagrid for data binding and sorting. Datagrid supports attributes like sortexpression and sort order to provide sorting very easily. is there any thing supported by repeater. Also for repeater I have on...more >>
Sysntax Error Inserting into a table with an OleDbCommand Posted by Oluwole Kolawole at 2/4/2004 12:02:17 AM Hi all,
I need another set of eyes to look at a problem I'm having. I'm trying to
insert data into a Micrsoft Access 2002 table using the following SQL
statement (all fields are Text):
"Insert Into Customers (UserName, Password, FirstName, LastName, Address,
PostCode, PhoneDay, PhoneEve, Ph...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |