Archived Months
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
all groups > vb.net data > november 2006

SQL Client CommandTimeout being ignored
Posted by jwgoerlich NO[at]SPAM gmail.com at 11/28/2006 1:21:11 PM
Hello group, I have a simple Vb.net application that reads from a SQL 2005 database. Sometimes when I execute a query and fill a data table, a "Timeout expired" exception is thrown. The strange thing is that I have set the CommandTimeout to 10000. This should be more than enough time, given...more >>


Read and write database
Posted by fniles at 11/28/2006 9:36:34 AM
When using VB6 and ADO, if I only do a Read, I will open a recordset with Forward Only cursor and Read Only lock, thus it will be faster than a non Read recordset. In VB.NET, when only need to do a Read, is it correct that I want to use OLEDBDataReader (SQLDataReader for SQL Server), when wh...more >>

Retrieve records from table that match current record in another table?
Posted by mike11d11 at 11/22/2006 2:12:43 PM
I'm working with a dataset table WorkList that has all of the details for a persons accounts displayed in detailed view as individual text boxes for each field. The problem I have is trying to take another table Memos that can hold multiple note lines for each particular account. some how I ne...more >>

Dataconection and multiple forms
Posted by Andy at 11/18/2006 3:33:40 PM
Hi I'm currently working on an application that so was has only used one form, and all connectioninfo to my database is within this. But I've I plan to implement multiple forms, is it best to move the variables regarding the database connection over to a module in my solution? /A. ...more >>

Excel: Numerics are read as Null
Posted by Kjell Weding at 11/17/2006 1:03:28 PM
Software: VB.NET 2.0 and Excel 2003 I have an Excel sheet with 140 records. 135 of the records have alphanumeric data in fields.item(2) (see code below). 5 of the 140 cells in this coloumn is however numeric. When I read the records, the alphanumeric fileds is read OK, but the 5 records ...more >>

passing parameter to class from application
Posted by Smile at 11/17/2006 2:51:21 AM
Hi there, I have a question, please give me some idea. Thanks in advance! Solution1 | |---DBLogic (class library) | | | |-dblogic (class) which defines ConnString, functions to create DataTable by sqlstr | | |---DBObjects (class library) | | ...more >>

HELP!!! System.Data.OleDb.OleDbException: Cannot update the cursor, since it is read-only
Posted by sales NO[at]SPAM advantagewebaccess.com at 11/15/2006 9:21:14 AM
I am trying to add users to a database via asp.net into a foxpro table, i get the following error: Source Error: Line 204: myCommand.Connection.Open() Line 205: Try Line 206: myCommand.ExecuteNonQuery() Line 207: ' Message.InnerHtml = "<b>Record Updated</b><br>" Line...more >>

datagridView in windows form 2.0 creating problem.
Posted by sathya at 11/13/2006 8:57:33 PM
i am adding geeting values from popup and putting that selected value to last row (new row) of datagridview.but when i get value from popup the new row is not formed.So when ever i move out from this record without savving the record the values of the record get vanish. but when i enter the va...more >>



Performance problems, saving 5 values in a second
Posted by Christer S at 11/10/2006 3:23:45 PM
I got this error message occasionally, sometimes is says that it couldn't close connection because its execusing. I call this sub below every 200 millisecond(the applivcation recives measure data from a PLC), and the errors occurce irregularly, somtimes 20 minutes between them and some times ...more >>

how to create a table programmatically in excel?
Posted by Britt at 11/9/2006 10:00:14 PM
Hi, I want to create a table programmatically in excel. How can o do this ("create table ....")?? And then, how to put it in specific cells in the worksheet, and possibly put it into sheet2 of the same worksheet? Thanks for gelp Britt ...more >>

Any RTF Lib out there?
Posted by Leon_Amirreza at 11/9/2006 12:00:00 AM
I need a good RTF Parser (Reader / Writer) Library in C/C++/C# for some text processing purposes? any Free or Commodity Libs I can use? Please give some Web Site Address ...more >>

How to Get the ITextDocument Interface of a .Net RichTextBox?
Posted by Leon_Amirreza at 11/9/2006 12:00:00 AM
Is there Any way I can get the ITextDocument Interface of a .Net RichTextBox? Please post some Sample Code that extracts this interface from RichTextBox? ...more >>

KNOW THE SIZE OF A FIELD
Posted by Raul at 11/8/2006 1:33:03 AM
In visual basic 6 xxx.recordset.fields(1). size and in the fields of type string it indicated you the maximum that allowed In. net opposing net anything resemblance. thank you ...more >>

I'm not able to filter dataset with the dataset.tables.select
Posted by mike11d11 at 11/5/2006 7:38:14 PM
I cant seem to filter down my dataset table by criteria in expression. Can someone tell me why I still have the same amount of rows after I use this filter select option. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.WorkListTa...more >>

bind the data in textbox with recordset
Posted by asad at 11/3/2006 9:08:00 PM
hi everyone!i am trying to bind the data in textbox with recordset such as vb6 can do it as textbox1.datasource= rs but in vb.net there is problem in datasource. plz help me to solve this problem my email address is mustakeel@gmail.com...more >>

Datasource question
Posted by Andy.I at 11/2/2006 12:00:00 AM
Hi just begun playing around with VB and SQL programming, and have a question. When I'm making a data source in my project I want to set up a SQL server connection. But, I see that I have 2 choices, Microsoft SQL Server and Microsoft SQL Server Database file. What are the differences between...more >>


DevelopmentNow Blog