Tutorials to .com

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

.Net Database Articles


21: Microsoft Office System in the use of ADO.NET data sets (b)
Create a DataSet Let's say you have to use a flexible data object, this object allows you to contain multiple tables, in between the table and the table settings, as well as read data forward or backward. ADO.NET provides these features - even...

22: Microsoft Office System in the use of ADO.NET data sets (b)
Create a DataSet Let's say you have to use a flexible data object, this object allows you to contain multiple tables, in between the table and the table settings, as well as read data forward or backward. ADO.NET provides these features - even...

23: Asp.Net (C #) + Sql Server three-tier data access programs under the framework of (f)
# region constructor public ScoreSetting () ( ) / / / <summary> / / / Overloaded constructor / / / </ Summary> / / / <param Name="id"> points set ID </ param> public ScoreSetting (int id) ( this.id = id; ...

24: ado.net detailed study (a)
Recently, high-performance read wrox master ADO.NET, have feelings, I hope to share with you. The first time to write articles, not understanding please. First: ADO.NET the concept of ADO.NET middle contains the following common categories: Conne...

25: Cache cache data using DataTable large amount of data to improve data access performance
Introduction: The amount of data is not in the circumstances, the procedure is basically how to write performance is not very different, but when we are faced with tens of thousands of data, I would like to have to consider the performance is a pro...

26: a detailed study ado.net (b) - DataReader (a)
We study in detail the DataReader. My personal favorite is the DataReader, although it is not as good as DataSet powerful, but in many cases is the flexibility we need to read a lot of data rather than inside the cache data in memory. For example, e...

27: a detailed study ado.net (c) - DataReader (b)
DataReader Class 1. Create a DataReader object Mentioned earlier, they could not create a DataReader object constructor. Usually we use the Command class ExecuteRader way to create a DataReader object: SqlCommand cmd = new SqlCommand (commandText...

28: Database connection in ADO.net
MSDN in the,. Net database connection string has detailed instructions, I am here to source out some way of example, the specific significance of each of the representatives can see MSDN. Database ADO.net connection (Microsoft) Microsoft has provi...

29: Article go fast do not show the tree algorithm, for the Oracle database (1)
Display of uncertainty in the number of tree nodes, we use to the vast majority of algorithms and databases to connect several times to operate check the data, I say the following algorithm, only the operation and data only once, and then use the dy...

30: Add datagrid column in the drop-down list
private void AddGrdComBox () / / column in the datagrid to add the drop-down list ( DataGridTextBoxColumn dgtb = (DataGridTextBoxColumn) grd_please.TableStyles [0]. GridColumnStyles [8]; / / 8 is the serial number listed ComboBox cmbFunctionArea ...

31: Hex string to 16
string StrToHex (string str) ( string strTemp = ""; if (str = "") return ""; byte [] bTemp = System.Text.Encoding.Default.GetBytes (str); for (int i = 0; i <bTemp.Length; i + +) ( strTemp + = bTemp [i]. ToStr...

32: ACCESS database so that keep pace
Sync (Synchronization) is a database application in the network environment to be involved in an important concept. Broadly divided into the basic course of the following steps: First of all, a copy of the database properties can be set into the des...

33: datagrid binding data out of the extraction of binding Button
Assuming I have a datagrid bound in 3 out 0 and 1 is the relevant data, the two bind button is out I click on a line corresponding to the button, how to get out of the 0 specific text? private void search_DataGrid_SelectedIndexChanged (object sen...

34: Use DataAdapter and DataSet to update database
Update method DbDataAdapter call, DataAdapter will analyze the changes have been made and the implementation of the appropriate command (INSERT , UPDATE or DELETE). When the DataAdapter changes encountered on the DataRow, it will use the InsertComm...

35: DataGrid few tips!
Method one: Use the template column We have good data binding DataGrid to add a template column, placed in a button column <asp:TemplateColumn> <ItemTemplate> <asp:Button id="btnDelete" runat="server" Text=&quo...

36: DataGrid into Excel Introduction examples
Response.Clear (); Response.Buffer = true; Response.ContentType = "application / vnd.ms-excel"; Response.Charset = ""; this.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter (); Syst...

37: Time Records page
<script language="C#" runat=server> DateTime startTime; void Page_Init (Object sender, EventArgs e) / / page load ( startTime = DateTime.Now; / / Response.Write ( "page init <br/>"); ) protected override void R...

38: SQL SERVER with the parameters of the return
CREATE PROCEDURE LoginUser @ loginUN char (50) OUTPUT, @ loginPW char (40) AS if @ loginPW = (select [password] from users where username = @ loginUN) return 0; else return -1; GO LoginUN return value to it's defined as OUTPUT, the corr...

39: How to get all database table fields and description field of Chinese
How to get all database table fields and description field of Chinese The following information, through a senior csdn moderator of getting from the SQL: in sql SELECT (case when a.colorder = 1 then d.name else''end) N 'Table Name...

40: According to the text of the document is an array of string per line
'According to the text of the document is an array of string per line Function GetLineStrByTxtFile (ByVal txtFileName As String) As ArrayList Dim fs As IO.FileStream = New IO.FileStream (txtFileName, IO.FileMode.Open, IO.FileAccess.Read) Dim ...


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