all groups > dotnet ado.net > september 2003 > threads for saturday september 27
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 30
bind a combo by coding
Posted by NewsGroup de Microsoft at 9/27/2003 7:53:17 PM
how can i bind by coding with valueMember, displayMember and datasource
properties.
if i do it visually, that's right but if i code it, not.
i do somethin' like that:
Dim gCadenaConexion As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source= " & ObtenRutaAplicacion() & "Datos\Datos... more >>
Queries problem
Posted by John at 9/27/2003 2:25:49 PM
Hi
I have two queries as sql strings. How can I take the results of two queries
and use them in a third sql query?
Thanks
Regards
... more >>
Visual Studio generated Update Queries.. Is this the way to go?
Posted by W.G. Rowland at 9/27/2003 12:27:57 PM
I'm fairly new to SQL Server, and I've been using Visual Studio to help
generate some SQLCommands to make life easier. The Insert, Delete, and
Select Commands it produces all seem fairly straightforward, but I'm
wondering about the Update Commands it generates.
Basically what it seems to do i... more >>
Re-Arrange columns in datagrid?
Posted by What-a-Tool at 9/27/2003 12:06:52 PM
Ended up using the following to hide unwanted columns and set the width of a
column. Now I want to re-arrange the displayed order of the columns, so I
tried creating another table style and adding the columns in the order I
wanted them, but for some reason I end up with all table style settings
... more >>
Looking for good reference on the data binding interfaces, especially IBindingList
Posted by W.G. Rowland at 9/27/2003 11:44:26 AM
Does anybody know of any good books or sites that cover the data binding
interfaces? I'm trying to put together a set of business collections to
handle my data, and though I can find articles that cover parts of the
interfaces, I've yet to find any detailed explanation on all of
IBindingList.. ... more >>
Syntax error in Update Statement
Posted by scorpion53061 at 9/27/2003 9:38:49 AM
Please let me know what I am doing wrong........
With Dslogin1.Tables("cbEmployee")
' Modify the first record (just append 3 asterisks to Name field)
'.Rows(0)("Employeeid") = .Rows(0)("Employeeid").ToString
..Rows(0)("EmployeeName") = TextBox1.Text.ToString
..Rows(0)("AlphaPagerNumbe... more >>
Multiple queries
Posted by John at 9/27/2003 2:31:55 AM
Hi
I have several queries as sql strings. I need to execute these, then take
the results and do further queries on them. In access we generate tables
from first set of queries then we use these table into second level of
queries and so on. How do you do this kind of stuff in vb.net?
Thanks... more >>
some clarifications about adonet and access database
Posted by Mr. x at 9/27/2003 1:37:21 AM
Hello,
I am using .NET technology and access database.
to connect to the database I use :
....
dim conn
.....
conn = new oleDBConnection("provider = microsoft.jet.oledb.4.0; data source
= " & server.mappath("mydb.mdb"))
....
Is it true that the above is good for ado.net, and it only provide... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Connection timeout problem
Posted by majid at 9/27/2003 1:17:50 AM
I have a problem with the connection timeout property .It
dosn't work properly . I have changed its value but
the "Timeout expired" error appears.... more >>
SELECT records with field employee # in a series of #
Posted by Mark Owert at 9/27/2003 1:12:07 AM
What is the SQL string to select records with CODE, for example, in a
series of CODES.
SELECT * from employees for code in "2345,4566,5678,7777"
That's the idea, to select employees whose code is one in the series of
the string.
There has to be an easier equivalent to..
SELECT * fr... more >>
|