| Groups | Blog | Home |
|
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 |
Query between dates? Posted by Tom Rahav at 4/26/2006 12:00:00 AM Hi,
I use Visual Basic .net 2005 and MS SQL Server (express Edition) 2005 as DB.
When I try the following query:
"SELECT * FROM Visits WHERE VisitTime >= " & dtFromTime & " AND VisitTime <=
" & dtToTime
(while dtFromTime and dtToTime are VB variables of Date type)
I get no results, alth...more >>
New to .NET... need Help. Posted by MATT at 4/23/2006 8:23:02 PM I am having trouble understanding VB.NET (2005) and Databases - this should
be simple... But i need help.
I am having trouble executing SQL statements. Could someone please give me
the syntax for a simple App... all it does is when you click "RUN" connect to
a SQL DB (northwind), run this QU...more >>
got problem adding data using VB Posted by zheetee NO[at]SPAM gmail.com at 4/23/2006 9:22:20 AM i am beginner to link asp.net and access 2gether
i use asp .net matrix...and wrote the Insert data coding
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole
DB Services=-4; Data Source=C:\Documents an"& _
"d Settings\AliceLee\My Documents\db\equipment.mdb"
Dim dbC...more >>
Using SQL statement for temporary table? Posted by kovac at 4/19/2006 3:00:03 AM Hello,
I created the table and inserted some records. Now I want to select and
groups my table using a simple SQL statement, but ADO.NET has only FILTER and
SORT methodes!
for example, this code view all rows from tblExample and I can set filter or
sorting but not grouping:
'
Dim myTbl...more >>
xml file data source Posted by Dirk at 4/18/2006 11:21:28 AM I would like to run SELECT SQL queries against DataTable's in my DataSet
which has been initialized with ReadXml. Has anyone done this? What is the
connect string, provider, etc? How?
...more >>
Restricted URL Posted by Bob Day at 4/18/2006 10:20:58 AM That URL is restriced content, and I cannot reach it without paying a fee.
Any other ideas?
Thanks
Bob
...more >>
SQL 2005 Express AutoIncrement Column Posted by Burtamus at 4/18/2006 10:12:12 AM How do I make a column auto-increment? I want a table of customers and want
to add one to the ClientID field?
I'm using VB.Net 2005 as well.
TIA, Burt
=====================
There's nothing so permanent as
a temporary solution - Me.
=====================
...more >>
VBNet 2005 and SQL Server Posted by M at 4/17/2006 4:27:39 PM
It seems to me the current VB.NET 2005 Express version does not support
connect to SQL Server 2000 or SQL Server 2005. Or I am not doing correctly.
I cannot even make the some samples project working
Thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Successfully executing queries Posted by John at 4/17/2006 3:30:47 AM Hi
I need to run separate insert & update queries. I suppose I can use
execute.nonquery to execute the queries. How can I tell if the queries were
successful?
Thanks
Regards
...more >>
Inserting info in a table Posted by John at 4/15/2006 12:00:00 AM Hi
I have a set of values that I need to insert and sql server table. My
question is, out of all the methods what is the best (in terms of being
simplest/most straightforward) method to do that?
Thanks
Regards
...more >>
Changing Default Column Widths Posted by Bob Day at 4/13/2006 10:26:01 AM Using VS 2003...
When using the Solutions Explorer, add new item, Data Form Wizard, when it
produces the grid layout for multiple records, the form column names are to
long to fit in the default column heading witdth, so it requires a lot of
manual work to get
the form useable. This is a q...more >>
2.0 Windows Form DataGridView binding problem. Posted by Bob at 4/13/2006 12:00:00 AM Hi,
Trying to bind the datagridview to a dataset that is filled with one to many
data by a datalayer.
Inspection of the dataset shows that the datalayer has correctly filled it.
In version 1.1 you just assigned the dataset to a datagrid's datasource
property and hey presto you had an expandabl...more >>
Data Access Application Block Posted by Chubbly Geezer at 4/10/2006 3:23:01 PM Does anyone have any experience of this functionality. I have started to
swap out my connection code for the std functionality within these dll's.
The data connection is fine, I can also run commands and return datasets.
However, the example they use to update a dataset is awful. It seems to...more >>
No SQL Analyser? Posted by Edward at 4/8/2006 12:00:00 AM Hi All,
Thanks upfront for any help.
I just installed Visual Studio 2005 Professional & Sql Server on an XP SP2
PC and I do not see the old Sql Server Enterprise Manager and Sql Analyser?
Would anyone know what happened to these tools?
Thanks
Edward
...more >>
TableAdapter problems ... Posted by Liz at 4/3/2006 11:12:30 PM Hi all ....
If I use the TableAdapter Configuration wizard to automatically generate
INSERT, DELETE and UPDATE code in a DataSet and then drop a data source on a
DataGridView do I have to
handle row adds and changes myself or are they wired up "automatically" ?
It does not appear that the...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |