• 连接sql server的语句


    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Windows.Forms;
    using System.Data.SqlClient;

    namespace linksql
    {
    public partial class Form1 : Form
    {
    public Form1()
    {
    InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
    string strcon, strsql;
    strcon=@"Data Source=.;Initial Catalog=stumanage;Integrated Security=true";
    // strcon = "Server=,;database=stumanage;trusted_connection=true";
    strsql = "select * from student";
    SqlConnection mycon = new SqlConnection(strcon);
    SqlDataAdapter myda = new SqlDataAdapter(strsql, mycon);
    DataSet myds = new DataSet();
    myda.Fill(myds,"dbo.student");
    dataGridView1 .DataSource=myds.Tables ["dbo.student"];

    }

    private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
    {

    }
    }
    }

  • 相关阅读:
    three.js模型
    three.js贴图
    three.js材质
    three.js自定义形状
    border
    虚拟主机Dede程序安装
    万网虚拟主机目录
    ConcurrentHashMap
    Oracle中select使用别名
    单例模式
  • 原文地址:https://www.cnblogs.com/zhaoshunjie/p/3764669.html
Copyright © 2020-2023  润新知