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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
[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 >>
|