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 > march 2005 > threads for march 1 - 7, 2005

Filter by week: 1 2 3 4 5

Error. Someone can help me
Posted by at 3/7/2005 10:59:31 AM
Dear all, I am a vb.NET beginner. My case is that I created a form, inside have a datagrid. I used SqlDataAdapter to connect the SQL server and get the vendor table. That's mean I have SqlDataAdapter1, Sqlconnection1 and DataSet11 now. In DataFrid properties; I already set DataMember...more >>

Update MsAccess using Dataset
Posted by Vibhu at 3/6/2005 10:48:25 PM
Hello All, I am trying to update a database using dataset but seems that I am missing out something. After going through a lot of posts and checking my code, I am still at my wits end to figure out how to do a simple update. Here is the code. Any help would be greatly appreciated. Regard...more >>

One Sql Command, two result sets
Posted by Michael C# at 3/6/2005 8:08:30 PM
When running the sp_helpdb 'master' command in SQL Server 2000, two result sets are returned. I can access the first result set via a SqlDataReader. How can I access the second result set? Thanks ...more >>

heresy ? connected data sans datasets and OleDbCommandBuilder ?
Posted by Barret Bonden at 3/6/2005 6:45:06 PM
Is there any connected method (not using datasets, and lacking the need for OleDbCommandBuilder to write back to the database) in ado.net ? I admit here to being an old (20 years in the field) programmer who cut his teeth on dbase and who now makes a living with MS Access and VB6 - I'm look...more >>

ADO vs DAO
Posted by Floris Frieswijk at 3/6/2005 5:58:52 PM
Hi everybody, i am porting an application from VB 6 to VB.NET. This application uses an Access database in various ways. It's a database that holds numerical data that is updated at least every minute and therefor a lot of (large) records. The VB 6 app uses DAO as interface to the db. At fi...more >>

How to know NOT Responding?
Posted by Mahmoud Metwally at 3/6/2005 3:15:52 PM
Dear Sir, Which VB6 functions can I use to detect some program is not responding to make it automatically restarted. So, how to detect that this is NOT RESPONDING program, and How To Restart it. Thank U V.Much ...more >>

Getting Data from an AS400 Database, how?
Posted by RD at 3/6/2005 12:55:07 PM
Customer has data sitting on a legacy As400. How do we get to use it (read and write) they have internal staff that knows the database structure and they can give us access. What do we have to be watchfull for? Thanks for any help Bob ...more >>

Need to capture count(*)
Posted by Dave at 3/4/2005 4:31:06 PM
I need to capture the number of records returned by a query in an inline VB.NET application. I had hoped this would work: Dim sql as string sql = "select count(*) from tblMyTable " Dim cmd As New SqlCommand(sql, con) NumAffected = cmd.ExecuteNonQuery() But, of course, it doesn't (it ...more >>



[Active Directory] best protocols
Posted by RTT at 3/4/2005 9:28:33 AM
does anyone has axperience with accessing AD information through VB.Net. Is the best protocol LDAP? does anyone has a site for information about AD and VB.Net cause it's the first time i have to work with active directory in vb.net so all sources of information would be helpfull. Thanks ...more >>

Create Access database using ADOX in VB.Net 2003 - display in DataGrid at same time?
Posted by Dave Baker at 3/3/2005 1:00:31 PM
I am using VB.Net 2003 to create an Access database, using the following code (partial): ==================== Dim cat As New ADOX.Catalog Dim tbl As ADOX.Table Dim con As ADODB.Connection Dim sCreateString As String sCreateString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Dat...more >>

ExecuteReader() not firing exceptions from stored procedures, also HasRows() vs Read()
Posted by James Hokes at 3/2/2005 11:00:16 AM
Hi All, We're using the 1.1. Framework against SQL Server 2000, and are having a strange issue where we don't get errors back from the stored procedure, i.e. the exception never gets thrown. The scenario is this: 1.) Set up SqlConnection and SqlCommand 2.) Set SqlDataReader equal to the re...more >>

Compare 2 datasets
Posted by klj_mcsd NO[at]SPAM hotmail.com at 3/1/2005 12:04:54 PM
How do I compare 2 datasets to see if they are the same. I'm first saving the initial state of the dataset like this: ds1 = Session("ds") ds = Session("ds") 'making a change to initial dataset ds.tables(0).Rows(0).Items(1) = txt1.text Now txt1 might not have changed. How do I ...more >>

which way is better
Posted by Scott Reynolds at 3/1/2005 11:52:33 AM
Hello! I developed a web application to display results from the database. Now I need to add search function, to search, sort and filter data. My question is, which way is better... 1) Store all related data in a single DataSet and use DataView to filter and sort data OR 2) Join rel...more >>


DevelopmentNow Blog