1. Data Query .
//Query All
Private void QueryAllCourse()
{
//Database connection string
String connStr=" Data Source; Initial Catalog; Test; User ID; Sa; Password; 123456"
//Create an instance of SqlConnection
SqlConnection conn= Null
Try
{
Conn= New SqlConnection (connStr)
//Open Database
Conn. Open()
String SQL=" Select ID, AXIS_NAME, HOME_LOWSPEED, HOME_HIGHSPEED, HOME_OFF SETPOS, HOME_ACCTIME, HOME_DECTIME, MAX_Limit,"+
" MIN_LIMITED, EQUIVALENT, START_SPEED, MAX_SPEED, END_SPEED, ACC_TIME, DEC_TIME from Axis_Table"
//Create an object of the SqlDataAdapter class
SqlDataAdapter sda= New SqlDataAdapter (SQL, conn)
//Create an object of the Dataset class
Dataset ds; NewDataset()
//Fill the novelty search results into the Dataset object ds using the SqlDataAdapter object sda
Sda Fill (ds)
//Set the Datasource property of a table control
DataGridView1. Datasource= Ds. Tables [0]
//Set the column headings displayed on the data table
//DataGridView1. Columns [13]. HeaderText=" Axis Name
DataGridView1. Columns [1]. HeaderText=" Axis Name
DataGridView1. Columns [2]. HeaderText=" Zero return starting speed (mm/s)"
DataGridView1. Columns [3]. HeaderText=" Zero return operating speed (mm/s)"
DataGridView1. Columns [4]. HeaderText=" Zero return switch deviation
DataGridView1. Columns [5]. HeaderText=" Zero return acceleration time (s)"
DataGridView1. Columns [6]. HeaderText=" Zero return deceleration time (s)"
DataGridView1. Columns [7]. HeaderText=" Maximum software limit"
DataGridView1. Columns [8]. HeaderText=" Minimum software limit
DataGridView1. Columns [9]. HeaderText=" Pulse equivalent
DataGridView1. Columns [10]. HeaderText=" Initial speed (mm/s)"
DataGridView1. Columns [11]. HeaderText=" Positioning speed (mm/s)
DataGridView1. Columns [12]. HeaderText=" Termination speed (mm/s)"
DataGridView1. Columns [13]. HeaderText=" Acceleration time (s)"
DataGridView1. Columns [14]. HeaderText=" Deceleration time (s)"; .
DataGridView1. ColumnHeadersDefault CellStyle. Font= New Font (" Lishu", 14)
//Foreach (DataGridViewColumn in dataGridView1. Columns)
//{
//Column AutoSizeMode= DataGridViewAutoSizeColumnMode AllCells
//}
//Set the data table to read-only
DataGridView1. ReadOnly= True
//Adding rows is not allowed
DataGridView1. AllowUserToAddRows= False
//The background is white
DataGridView1. BackgroundColor= Color White
//Only allow selecting a single row
DataGridView1. MultiSelect= False
//Select the entire row
DataGridView1. SelectionMode= DataGridViewSelectionMode FullRowSelect
DataGridView1. defaultCellStyle. Font= New Font (" Lishu", 14); .
//This. dataGridView1. Rows [0]. Selected= True// The first row is selected by default
Catch (Exception ex)
{
Message Box Show (query error! Ex. Message)
Finally
{
If (conn!= null)
{
//Close database connection
Conn. Close()
} .
//Database connection string
String connStr=" Data Source; Initial Catalog; Test; User ID; Sa; Password; 123456"
//Create an instance of SqlConnection
SqlConnection sqlCnn= Null; .
Try
{
SqlCnn= New SqlConnection (connStr)
//Open Database
SqlCnn Open()
Tag= True; .
String SQL=" Select * from signalOut_Tab;; .
//Create Database Command
SqlCommand cmd= SqlCnn CreatCommand()
//Create a query statement
Cmd CommandText= SQL
//Read the data stream from the database and store it in the reader
SqlDataReader reader= Cmd ExecuteReader(); .
//Read the next line of data from the reader. If there is no data, the reader Read() returns flare
While (reader. Read())
{--> .
String signal; Reader GetString (reader. GetOrdinal (" signal"))
String ID= Reader GetString (reader. GetOrdinal (" id")); .
//Format output data
Console WriteLine (" signal: {0}== id: {1}", signal, id)
Catch (Exception ex)
{
Message Box Show (ex.Message," error")
Finally {
SqlCnn Close()
} .