|
|
|
|
|
Total Hits: 169 | Today: 0
|
Author: easerve
|
Rating:
|
|
Adding records to Access database using ADO.NET a fairly strait forward process and is much like adding records to SQL Server 2000.
First, you will need to import the System.Data.OleDb name space at the top of your page....
|
|
|
|
Total Hits: 84 | Today: 0
|
Author: easerve
|
Rating:
|
|
Deleting records from SQL Server 2000 database using ADO.NET a fairly strait forward process, much like deleting records from SQL Server 2000 Database....
|
|
|
|
Total Hits: 74 | Today: 0
|
Author: easerve
|
Rating:
|
|
Deleting records from SQL Server 2000 database using ADO.NET a fairly strait forward process, much like deleting records from Access Database.
First, you will need to import the System.Data.SqlClient namespace at the top of your page....
|
|
|
|
Total Hits: 78 | Today: 1
|
Author: Greg Osborne
|
Rating:
|
|
When you think of a queue, what do you think of? No, it’s not the selfish and all-powerful quantum beings (the “Q”) from the Star Trek Next Generation Series. No when I’m talking about a queue, I’m talking about the mechanism to transport messages to/from an enterprise (not the ship) application. There are two main flavors on the market today; IBM’s MQSeries, and Microsoft’s MSMQ. I’m not going to debate which one is better; too many have done that task before me. What I’d like to do is provide ...
|
|
|
|
Total Hits: 29 | Today: 0
|
Author: AdamNThompson
|
Rating:
|
|
This is a generic data access component I wrote in VB.NET so simplify some of the common tasks used to work with data using ADO.NET and MS SQL 2005. The class contains methods to perform non-queries (Update, Insert, and Delete), and it contains methods to return a SqlDataReader or DataSet. I am overriding the methods as well to allow the use of sql or a stored procedure. This class is extremely easy to use and modify....
|
|
|
|
Total Hits: 17 | Today: 1
|
Author: MalakieUSN
|
Rating:
|
|
Code storage tool for any language but developed using Visual Basic .NET 2005. Includes syntax coloring for VB code and can load via the tools menu external option in Visual Studio 2005.
**Note: This version utilizes SQL server for the database backend. I am almost finished with an Access backend version as well and will upload that once it is completed....
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: jopascual
|
Rating:
|
|
I'm currently developing an inventory management system which caters to multiple warehouses. I will share to you some tips and tricks in the development of this program. The system is somehow still under development.
The database I used was mySQL Server 5.0.x together with mySQL DotNet Connector. Firstly, I'll start to share few tricks in Connecting to mySQL. Discussions on saving, querying and other useful tricks will follow later on....
|
|
|
|
Total Hits: 131 | Today: 2
|
Author: Andy32
|
Rating:
|
|
A little contribution, a datagridview which autosaves inserts and updates to an SQL database, extended with filtering and sorting on multiple columns, and as a bonus it contains the code for a multicolumn combobox....
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: daffrey.
|
Rating:
|
|
Have you ever had to deploy a SQL Server database to a customer? If you have, then you will know that it is certainly not as simple as deploying an application that uses an MS Access database.
With SQL Server databases, you have 3 deployment options that I know of:
1. Distribute your .mdf and .ldf files to your customer and attach the database to their SQL Server instance using the system stored procedure sp_attach_db (or sp_attach_single_file_db). The downside is that the SQL S...
|
|
|
|
Total Hits: 75 | Today: 0
|
Author: Rod Stephens
|
Rating:
|
|
There are many ways you can make a program extensible at run-time. One of the most flexible methods for extending an application at run-time is scripting. By allowing the program to execute new code at run-time, you can enable it to do just about anything that you could do had you written the code ahead of time, at least in theory.
This article explains how a program can execute SQL statements at run-time. Structured Query Language (SQL) is a relatively easy-to-learn language for interacting ...
|
|
|
|
Total Hits: 177 | Today: 0
|
Author: McGraw-Hill
|
Rating:
|
|
If you want to learn more about Transact-SQL statements, this article gets you off to a good start. The first of a multi-part series, it covers batches. It is excerpted from chapter five of the book Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET, written by Dejan Sunderic (McGraw-Hill/Osborne, 2006; ISBN: 0072262281)....
|
|
|
|
Total Hits: 273 | Today: 0
|
Author: Jagadish Chaterjee
|
Rating:
|
|
This article primarily introduces the concept of SQL-DMO together with a small and simple Backup/Restore utility developed using the .NET platform. It mainly focuses on the basics of SQL-DMO, its main objects and how to use them in .NET platform to design and develop MS SQL Server based database administration utilities/applications....
|
|
|
|
Total Hits: 783 | Today: 0
|
Author: MSDN
|
Rating:
|
|
This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table....
|
|
|
|
Total Hits: 430 | Today: 0
|
Author: MSDN
|
Rating:
|
|
This step-by-step article explains two ways that you can debug SQL Server stored procedures and the necessary configuration settings and steps for each approach....
|
|
|
|
Total Hits: 277 | Today: 0
|
Author: MSDN
|
Rating:
|
|
This article demonstrates how to render DataTable columns as Extensible Markup Language (XML) attributes. A DataTable represents one table of in-memory relational data. You can create a DataTable and use it independently, or other Microsoft .NET Framework objects can use the DataTable, most commonly as a member of a DataSet object....
|
|
|
|
Total Hits: 31 | Today: 0
|
Author: Code24.com
|
Rating:
|
|
Business software’s have been a big thing for the industry. Building nice and smart applications connected with databases using Server Query Language (SQL) is a smart thing. The software industry has in many years been developing smart systems using many types of database systems. The NET-Framework system is a smart thing you could use if you want to build business-integrated applications. Microsoft® is one of the companies which are working with coming up with new systems and smart ways that co...
|
|
|
|
Total Hits: 19 | Today: 0
|
Author: Jitender thakur
|
Rating:
|
|
This is a small application that can be used to convert Html Pages to a Database format.
Generally the data we get from the Internet is not in a database storable format. This application comes with with source code and a demo file with database, and will demonstrate how you can extract your fields from a html page and submit it into an access database. It can be run in a loop to convert the database into access. It will not hang your computer and can complete as many files as required but th...
|
|
|
|
Total Hits: 62 | Today: 0
|
Author: easerve
|
Rating:
|
|
Adding records to a SQL Server 2000 database using ADO.NET a fairly strait forward process, much like adding records to an Access Database.
First, you will need to import the System.Data.SqlClient name space at the top of your page....
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: easerve
|
Rating:
|
|
Counting records from Access database using ADO.NET and the .NET Framework can be accomplished easily with a few lines of code.
Also see: Count Records from SQL Database using ADO.NET, SQL, and Visual Basic.NET.
First, you will need to import the System.Data.OleDb name space at the top of your page....
|
|
|
|
Total Hits: 55 | Today: 0
|
Author: easerve
|
Rating:
|
|
First, you will need to import the System.Data.SqlClient name space at the top of your page.
Next, we write the actual code to connect to SQL Server and count the records. We do this with a Count SQL command against the Customers table. We specify the UID (Unique ID) column as the column to count. To execute the Count command we simply call ExecuteScalar to produce the count. As seen below we can simply apply this to the .Text property of the lbCount Label control....
|
|
|
|
|
|
