1,数据查询
//查询全部
private void QueryAllCourse()
{
//数据库连接串
string connStr = "Data Source=.;Initial Catalog=test;User ID=sa;Password=123456";
//创建SqlConnection的实例
SqlConnection conn = null;
try
{
conn = new SqlConnection(connStr);
//打开数据库
conn.Open();
string sql = "select ID ,AXIS_NAME ,HOME_LOWSPEED ,HOME_HIGHSPEED , HOME_OFFSETPOS ,HOME_ACCTIME ,HOME_DECTIME ,MAX_LIMIT ," +
"MIN_LIMIT , EQUIVALENT ,START_SPEED ,MAX_SPEED ,END_SPEED ,ACC_TIME , DEC_TIME from Axis_table";
//创建SqlDataAdapter类的对象
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
//创建DataSet类的对象
DataSet ds = new DataSet();
//使用SqlDataAdapter对象sda将查新结果填充到DataSet对象ds中
sda.Fill(ds);
//设置表格控件的DataSource属性
dataGridView1.DataSource = ds.Tables[0];
//设置数据表格上显示的列标题
//dataGridView1.Columns[13].HeaderText = "轴名称";
dataGridView1.Columns[1].HeaderText = "轴名称";
dataGridView1.Columns[2].HeaderText = "回零起始速度(mm/s)";
dataGridView1.Columns[3].HeaderText = "回零运行速度(mm/s)";
dataGridView1.Columns[4].HeaderText = "回零开关偏差";
dataGridView1.Columns[5].HeaderText = "回零加速时间(s)";
dataGridView1.Columns[6].HeaderText = "回零减速时间(s)";
dataGridView1.Columns[7].HeaderText = "最大软件限位";
dataGridView1.Columns[8].HeaderText = "最小软件限位";
dataGridView1.Columns[9].HeaderText = "脉冲当量";
dataGridView1.Columns[10].HeaderText = "初始速度(mm/s)";
dataGridView1.Columns[11].HeaderText = "定位速度(mm/s)";
dataGridView1.Columns[12].HeaderText = "终止速度(mm/s)";
dataGridView1.Columns[13].HeaderText = "加速时间(s)";
dataGridView1.Columns[14].HeaderText = "减速时间(s)";
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("隶书", 14);
//foreach (DataGridViewColumn column in dataGridView1.Columns)
//{
// column.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
//}
//设置数据表格为只读
dataGridView1.ReadOnly = true;
//不允许添加行
dataGridView1.AllowUserToAddRows = false;
//背景为白色
dataGridView1.BackgroundColor = Color.White;
//只允许选中单行
dataGridView1.MultiSelect = false;
//整行选中
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.DefaultCellStyle.Font = new Font("隶书", 14);
// this.dataGridView1.Rows[0].Selected = true;//默认选中第一行
}
catch (Exception ex)
{
MessageBox.Show("查询错误!" + ex.Message);
}
finally
{
if (conn != null)
{
//关闭数据库连接
conn.Close();
}
}
}
//数据库连接串
string connStr = "Data Source=.;Initial Catalog=test;User ID=sa;Password=123456";
//创建SqlConnection的实例
SqlConnection sqlCnn = null;
try
{
sqlCnn = new SqlConnection(connStr);
//打开数据库
sqlCnn.Open();
tag = true;
string sql = "select * from signalOut_tab";
//创建数据库命令
SqlCommand cmd = sqlCnn.CreateCommand();
//创建查询语句
cmd.CommandText = sql;
//从数据库中读取数据流存入reader中
SqlDataReader reader = cmd.ExecuteReader();
//从reader中读取下一行数据,如果没有数据,reader.Read()返回flase
while (reader.Read())
{
string signal = reader.GetString(reader.GetOrdinal("signal"));
string id = reader.GetString(reader.GetOrdinal("id"));
//格式输出数据
Console.WriteLine("signal:{0}==id:{1}", signal, id);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error");
}
finally {
sqlCnn.Close();
}