Search   Articles   Dev Forums   Personalize   Favorites   Member Login   ASP.Net Hosting
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Saturday, November 22, 2008

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 
FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home > Search > Articles & Samples > Visual Basic.Net > Database > Miscellaneous
Search:
What's New - What's Hot


simple code how to convert datagridview contents to excel        
Total Hits: 202  |  Today: 0 Author: v.rajanikanth       Rating:  
Read Reviews | Write Review |   Your Rating: 

Here i have to add reference :microsoft excel 11.0 object library
Here I am having tables materialsdetails
And one textbox named as txt_xlsfilename for giving file name....

VB.NET Data Types        
Total Hits: 19  |  Today: 0 Author: Budi Kurniawan       Rating:  
Read Reviews | Write Review |   Your Rating: 

The new version of Visual Basic, VB7 (or VB.NET), is a big jump from VB6. With VB7 you can use the type library in the .NET Framework, and your applications run on the Microsoft .NET Framework Common Language Runtime (CLR).There are also a number of changes from the previous versions. VB7 now supports inheritance and has a new error-handling mechanism. As part of the .NET Framework, VB7 needs to update the data types for interoperability with other programming languages such as C# and C++, and w...

BizTalk Server 2000: Architecture and Tools for Trading Partner Integration        
Total Hits: 102  |  Today: 0 Author: Aaron Skonnard and Bob Laskey       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article provides an overview of the concepts involved with implementing a trading partner integration system on BizTalk Server 2000 and details the document interchange server architecture and toolset. Additionally, an early look was taken at some business process integration features planned for the production release of the product that allow easy design, execution and sharing of new business processes with trading partners. The concepts and architecture presented allow companies to prepa...

HOW TO: Copy DataRows Between DataTables by Using Visual Basic .NET (Q305346)        
Total Hits: 758  |  Today: 0       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article demonstrates how to copy specific DataRow objects from one table to another by using the ImportRow method of the DataTable class....

Wrapping Database Modifications within a Transaction        
Total Hits: 87  |  Today: 1 Author: Scott Mitchell       Rating:  
Read Reviews | Write Review |   Your Rating: 

As we saw starting with the An Overview of Inserting, Updating, and Deleting Data tutorial, the GridView provides built-in support for row-level editing and deleting. With a few clicks of the mouse it is possible to create a rich data modification interface without writing a line of code, so long as you are content with editing and deleting on a per-row basis. However, in certain scenarios this is insufficient and we need to provide users with the ability to edit or delete a batch of records....

VB.NET Data Types        
Total Hits: 455  |  Today: 1 Author: Budi Kurniawan       Rating:  
Read Reviews | Write Review |   Your Rating: 

Budi gives us a tour of the new data types in VB 7 (VB .NET) that are different from VB 6. These are not the only changes in the language, but hopefully this is a good start for VB 6 programmers to begin migrating to VB 7.
...

Properties and Object Oriented Database Development with VB.NET 2005        
Total Hits: 170  |  Today: 1 Author: Jagadish Chaterjee       Rating:  
Read Reviews | Write Review |   Your Rating: 

This is the third article in a series on developing object oriented database applications using Visual Basic.NET 2005. In this article, I shall deal with the concept of “properties” in depth, along with data access....

Dynamic binding to a TreeView control in ASP.NET 2.0 and navigating child nodes with JavaScript        
Total Hits: 163  |  Today: 1 Author: ihatetomato       Rating:  
Read Reviews | Write Review |   Your Rating: 

Here is the code for dynamic binding of a treeview and also the server side java script for navigating URL to the child nodes.

I have gone through many forums to get the information of the treeview control the only bug i studied is _dopostback javascript that stops the navigating URL of the child nodes.many of them suggested me to better go for autopostproperty to set as true .but the treeview control does'nt have autopostback property.

the optional way I suggest you for the chi...

student library information using database connectivity with ms access        
Total Hits: 197  |  Today: 0 Author: sourav roy       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article explains how to keep records for all students in library using a database and a vb.net program.using ms access the database connectivity and connection string it has been done...

Determining if a database value is null in VB.NET        
Total Hits: 535  |  Today: 0       Rating:  
Read Reviews | Write Review |   Your Rating: 

You must create an object of the System.DBNull class and then once you have an instance of it you can check your variables like the example below shows....

The Closest thing to a VB6 control array in VB.NET        
Total Hits: 19  |  Today: 0 Author: kepler77       Rating:  
Read Reviews | Write Review |   Your Rating: 

Any VB programmer who has moved to VB.NET knows the frustration of losing the ability to create control arrays in a form. VB.NET adds a great amount of flexibility and power, but at the cost of losing some of the features that made VB a great rapid development environment that hid many of the programming details from the developer. One such loss is the control arrays. In the past, you could drop a number of controls on the screen with the same name, and VB took care of creating a member variable...

Creating CSV from table attaching it to word as datasource and then creating mailmerge document        
Total Hits: 23  |  Today: 0 Author: Member 3209760       Rating:  
Read Reviews | Write Review |   Your Rating: 

The code is devided into three parts
1) Creating CSV file
2) Opening CSV file
3) Using CSV file to mailmerge with word document...

Multiple table Databinding in TreeView        
Total Hits: 32  |  Today: 0 Author: TL Wallace       Rating:  
Read Reviews | Write Review |   Your Rating: 

At the time of this writing, the standard Windows Forms .NET TreeView control doesn't support the concept of databinding like the ASP.NET TreeView control. So, we are left writing our own solutions. This solution provides a standardized way to use databinding with the Windows Forms .NET TreeView control. This functionality will enable you to quickly develop user-friendly ways to create and view complex data information.
It includes the Databinding as well as the following Design Patterns: Fac...

Get Database Server Date and Time        
Total Hits: 20  |  Today: 0 Author: Hemant.Kamalakar       Rating:  
Read Reviews | Write Review |   Your Rating: 

The requirement is to display the database servers Current System Date and Time in the client application. When the client application starts it fetches the Current Date and Time on the Remote server(Database Server) and keeps incrementing it by one second using a Timer....

DTS (VB.NET)        
Total Hits: 21  |  Today: 0 Author: vipinjosea       Rating:  
Read Reviews | Write Review |   Your Rating: 

DTS (Data Transformation Services) is one of the nice and very useful feature that available with SQL Server 2000 . But in case of end user there is not much technical knowledge regarding this so they can't use 'as it is' so they prefer a single click interface for a predefined DTS process ,in SQL Server 2000 not natively supports this(DTS Package saved in SQL Server itself is possible to run with single click but there is certain drawbacks the major one is there is no facility to backing up thi...

Convert Enums to DataTables        
Total Hits: 18  |  Today: 0 Author: ferran9       Rating:  
Read Reviews | Write Review |   Your Rating: 

This is just a quick trick to convert an Enum into a DataTable, not sure if it would be of any practical use. There are no projects to download since is just a code snippet, copy and paste from this page and you are ready to go, well... let me know what you think about it....

Expanding Enumerators for Saving to a Database or Displaying to a User        
Total Hits: 30  |  Today: 0 Author: Michael Bosch       Rating:  
Read Reviews | Write Review |   Your Rating: 

When I'm developing an application, I often like to use enumerators as properties of my objects to improve the readability of my code. Often, the enumerator value will come from a table in the database....

DataTable: Uniquing a Column        
Total Hits: 71  |  Today: 0 Author: Charles Carroll       Rating:  
Read Reviews | Write Review |   Your Rating: 

This example illustrates how to created a sorted DataView and then use that to create an unique datatable for a specific column....

What's the deal with Databinder.Eval and Container.DataItem?        
Total Hits: 44  |  Today: 0 Author: Raj Kaimal       Rating:  
Read Reviews | Write Review |   Your Rating: 

The databinding expression %# some expression % is evaluated in the language of the page (VB, C#, etc.) This can have a big impact on the current syntax, so be very careful when you are looking at docs for the language you are using....

Using Methods with Object Oriented Database Development with VB.NET 2005        
Total Hits: 195  |  Today: 1 Author: Jagadish Chaterjee       Rating:  
Read Reviews | Write Review |   Your Rating: 

This is the second article in a series on developing object oriented database applications using Visual Basic.NET 2005. In this article, I shall deal with the concept of “methods” a bit more in depth, along with data access....


1  2  Next >> 


DevASP.Net - Disclaimer - Privacy
Copyright © 2008 DevASP.net