Tutorials to .com

Tutorials to .com » Dotnet » Database » .Net Database

.Net Database Articles


181: Create a fixed table head, table body scroll the DataGrid
When using DataGrid, sometimes the first fixed header table, the form can be a rolling body, the following code is the code to achieve this function. ShowFixedHeader.aspx <% @ Page Language = "vb" EnableViewState = "False" A...

182: SQL Server database to add a picture
The following code to the SQL Server database to add picture and text functions. First of all, in the SQL Query Analyzer run the following statement to create tables and stored procedures. Drop Table Person Go Create Table Person ( PersonID In...

183: Extracted from the SQL Server database and displayed in the DataGrid picture
The following code extracted from the SQL Server database and display the picture of the functions in the DataGrid. The following is the complete code, copy to run: <% @ Page Language = "vb"%> <% @ Import Namespace = "Syst...

184: GetOLEDBSchemaTable method using the OleDb database schema information to be
We can use the OleDb database GetOLEDBSchemaTable approach to all views, tables, stored procedures and other information. GetDataBaseSchema.aspx <% @ Page Language = "vb" AutoEventWireup = "false" Codebehind = "GetDataB...

185: After the creation of the code in the DataGrid control
After the creation of the code in the DataGrid control This article describes how to use code to create DataGrid, and bind four out and out a template to support the sort function. Code is as follows: C # CreateDataGrid.aspx <% @ Page langua...

186: To achieve a similar Windows Explorer the DataGrid
In the DataGrid, we can achieve similar to Windows Explorer effect, that is, sort the list, the list of different colors with other out. Is to realize the following code: C # code: DataGridLikeWindowsExplorer.aspx <% @ Page language = "c ...

187: Style XP can drag the column to sort the DataGrid example
This article describes the style of XP drag out, sort the DataGrid example, see To use the source code, please download the following documents: downarrow.gif sortBlank.gif sortUp.gif sortDown.gif uparrow.gif xpTable.css xpTable.htc Source ...

188: How to control the content of DataGrid in line and do not wrap?
Unusual demand, and some require the contents of the table automatically wrap, and some do not require, in fact, set the DataGrid's CSS style attributes can be realized alone most of the demand, but do not wrap the realization of a single style ...

189: Add a DataGrid column for the Radio (single box) out
Forum often see people ask how to achieve in DataGrid in radio, is a realization of the following methods. See examples <% @ Page Language = "C #" AutoEventWireup = "True" EnableViewState = "true"%> <% @ Imp...

190: DataGrid output to Excel format and processing
In our data on the DataGrid into Excel, if encountered in a long string of figures, such as identity card number, will be in Excel as a number of years, and to convert the format of a scientific count, resulting in data loss, the following methods t...

191: DataGrid - to export Excel file
There are many ways, I only used the most simple method 1. Excel.dll reference COM components 2. To achieve the following public void ExportExcel () ( DataSet ds = this.DataSet; / / get the DataSet to bind dataGrid if (ds == null) return; stri...

192: Database table through the procedures of the association between
using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data. SqlClient; namespace database management automation ( / / / <summary> / / / ...

193: . NET value types of precision
float type accounted for 32bit space, only seven precision, the following procedures public class FloatPrecision ( public static void Main () ( Console.WriteLine ((int) 123456789F); ) ) Output the results of 123,456,792. 64bit accounted dou...

194: Custom Paging for DataGrid Add a custom navigation and paging information
In the last article I talked about the implementation of the custom DataGrid paging, this can be avoided in order to show the data to obtain a record of the entire data set, so as to enhance the efficiency of paging, but the DataGrid using the navig...

195: ACCESS database access components (a)
ACCESS database access components (a) ACCESS_Database.cs using System; using System.Data; using System.Data.OleDb; using System.Collections; namespace XLang.VideoOnline.Framework.Database.Access ( / / / <summary> / / / XLang.VideoOnlin...

196: ACCESS database access components (b)
ACCESS database access components (b) ACCESS_Table.cs using System; namespace XLang.VideoOnline.Framework.Database.Access ( / / / <summary> / / / Summary description for ACCESS_DataTable. / / / </ Summary> public class DataTable: ...

197: ACCESS database access components (c)
using System; using System.Data; using System.Data.OleDb; using System.Collections; namespace XLang.VideoOnline.Framework.Database.Access ( / / / <summary> / / / Summary description for ACCESS_DataTablesCollection. / / / </ Summary&...

198: ACCESS database access components (d)
using System; using System.Data; using System.Data.OleDb; using System.Collections; namespace XLang.VideoOnline.Framework.Database.Access ( / / / <summary> / / / Summary description for ACCESS_DataViewsCollection. / / / </ Summary&g...

199: DataGrid paging custom UserControl
PageChange.ascx ================================================== ============== <% @ Control Language = "c #" AutoEventWireup = "false" Codebehind = "PageChange.ascx.cs" Inherits = "Ex_Test.PageChange" ...

200: Drag and drop DataGrid column - from MSDN
Abstract: Learn how to use basic GDI functions, and thus through the DataGrid control was the effect of visualization. Trust across borders through the call, you can use GDI functions of the machine to perform the screen capture, and finally drag-an...


Page 10 of 17
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]