|
|
|
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 |
Simple Crystal Report Viewer Website Posted by Jo Day at 4/30/2007 12:02:00 PM I am slowly learning VB and SQL (from scratch) informally. I am doing a series of projects to learn some of the coding and can usually find what I need through web searches. This one has me stumped though.
I have a dropdown list with a .mdf (sql db) as the data source. Also in that table is a ...more >>
TableAdapter how to write and call a custom function in visual bas Posted by Ed Warren at 4/27/2007 9:02:11 AM Problem. I have a microsoft access database with a number of tables/columns.
I need to have a tableadapter that combines a number of fields into one
field.
Something like:
Select [tableID], [ClientName] as Name, CustomFunction(val1,val2,val3) as
Notes
from TAble1
Then in Visual bas...more >>
Export DataGridView to Excel Posted by Mike Wilson at 4/26/2007 12:23:29 AM Hello all,
I'd like to export a DataGridView to Excel. I am using .NET 2.0 and VB.NET.
But I don't know if the user has Excel on their machines, so can't use COM
Excel object.
Any ideas please? How is an Excel file put together?
Many thanks,
Mike
...more >>
Dataset Question #3 Posted by Peter at 4/25/2007 11:57:47 PM Hello,
I'm relatively new to datasets and data access in VB.NET (I'm using 2002).
I've hacked my bloody way through it to a point, but now I'm stuck on
several points all at once. Most articles on the subject focus heavily on
SQL and ODBC, which I am not using and have no idea about. I'm ju...more >>
Database connection pooling in ASPx Posted by fniles at 4/23/2007 12:05:21 PM In the Windows application (using VB.NET 2005) I use connection pooling like
the following:
In the main form load I open a connection using a connection string that I
stored in a global variable g_sConnectionString and leave this connection
open and not close it until it exits the application...more >>
binding source position when sorted Posted by Rick at 4/21/2007 7:43:11 AM VS 2005
I want to make sure I have this concept down correctly.
I have a strongly typed datatable and a binding source connected to it.
On my windows form a grid is connected to the binding source.
When the grid is unsorted the datatable(bindingsource.positon).mycol =
DirectCast(bindin...more >>
Getting value from ComboBox into gridview Posted by BenCoo at 4/20/2007 12:04:41 PM Hi,
I have a gridview control that displays data from 2 tabels in a sqlserver
2005 database. The table "Temperatures" has a field "LocationID" I populate
the gridview with a ObjectDataSource with the following connectionstring
Dim selTmpr As String = "SELECT Tmpr.TmprID, Tmpr.TmprName, Tmpr...more >>
Select Distinct on a DataTable Posted by Doug Bell at 4/19/2007 12:57:22 AM Hi,
I have a DataSet with a DataTable that has a number of duplicate rows
(except for one column that has a unique value).
Each row has OrderNo, OrderLineNo, etc and there are multiple rows with
the same OrderNo and OrderLineNo.
I need to display data in a DataGrid but displaying only o...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Execute a SSIS Package using VB.NET code Posted by Michael W. at 4/18/2007 6:24:01 AM Hello NG,
i try to execute a SSIS Package on a remote Server using VB.NET.
Is it possible?
Has anyone an idea or maybe a codesnipet?
Thanks a lot.
Michael...more >>
Binding navigator button states Posted by Rick at 4/17/2007 8:26:34 AM VS 2005
The short version:
How can I set the enabled state of a button depending on if a
strongly-typed datatable has a DeleteCommand?
***************************
The long version:
I have a windows form with a binding navigator.
There are various strongly-types datatables used ...more >>
Connection pooling question Posted by fniles at 4/16/2007 4:18:56 PM I am using VS2003 and connecting to MS Access database.
When using a connection pooling (every time I open the OLEDBCONNECTION I use
the exact matching connection string),
1. how can I know how many connection has been used ?
2. If the maximum pool size has been reached, what happens when I cal...more >>
connection pooling for MS Access using OleDBConnection Posted by fniles at 4/16/2007 3:56:52 PM To do a connection pooling for MS Access using OleDBConnection, do I need to
include OLE DB Services=-1 in the connection string ?
What will the connection string be for connection pooling for MS Access
using OleDBConnection ?
Thank you.
ConnectionDemoOLE = New OleDb.OleDbConnection
sPath ...more >>
bindingsource addingnew Posted by Rick at 4/14/2007 1:08:47 PM I have a bindingsource filled by a strongly-typed table via a tableadapter.
I have connected the binding source to the AddingNew event where I want to
supply some values for the new row.
The problem is that this event is triggered when the TableAdapter fills the
binding source.
I'm not ...more >>
Is it possible to work with more than one Datasource? Posted by Vayse at 4/12/2007 12:00:00 AM Using VB2005, SQL Server 2000.
I have two entries in the Datasources window. This seems to cause no end of
problems.
Lets call the two entries Sql_Alpha and SQL_Beta. They are two databases on
the same SQL server.
If I try to configure Sql_Alpha with the wizard, it will configure SQL_Beta.
...more >>
OracleClient ? Posted by JerryWEC at 4/10/2007 6:28:15 PM I'm trying to figure out if there is a known issue with the
OracleCommandBuilder.DeriveParameters(cmd)
method call? I can't seem to get DeriveParameters() to return a Boolean
datatype parameter. I have used IN OUT parameters in the Stored Procedure
(Oracle) and OUT variables. If I change ...more >>
Insert dates using the Commandtext Posted by Michel Vanderbeke at 4/9/2007 1:04:37 AM Hello,
When I try to insert dates in a database table with this code
cmdLogboek.CommandText = "INSERT INTO tblAL_LogboekInloggen(LI_DatumTijd,
LI_Gebruiker) VALUES (Date.Now, "Name")
the error I get is as follows.
System.Data.SqlClient.SqlException occurred
Class=15
ErrorCode=-214...more >>
Use of boolean in a CommandText Posted by Michel Vanderbeke at 4/8/2007 7:13:41 PM Hello,
When passing an SQL-string to a CommandText, the SQL does not seem to accept
a Boolean after the WHERE-statement.
cmdVerkooplocatie.CommandText = "SELECT tblA_Locaties.LO_Locatie_id,
tblA_Locaties.LO_Naam " & _
" FROM tblA_Locaties " & _
" WHERE tblA_Locaties.LO_InGebruik ...more >>
VB.NET 2005 and Crystal Reports Posted by Michel Vanderbeke at 4/4/2007 2:55:33 PM Hello,
I want to create Crystel Reports using Crystal Reports XI Release 2 and
store the reports as individual files on my PC.
My database is a *.mdf (SQL Server database file).
1. Which connection method should I use when creating Crystal Reports in CR
XI r2?
2. Can someone provide me w...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |