DataGridView连接Sql数据库
一直搞不明白这是什么问题, 求大神解答下
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 _03大项目
{
public partial class Form1 : Form
{
//连接字符串
string str = "Data Source=.;Initial Catalog=MyDeskInfo;Integrated Security=True";
public Form1()
{
InitializeComponent();
}
//窗体加载
private void Form1_Load(object sender, EventArgs e)
{
//加载餐桌
LoadDeskInfoByDelFlag(0);
}
/// <summary>
/// 该方法是加载所有没有被删除的餐桌
/// </summary>
/// <param name="p">删除标识 0---未删除,1---删除</param>
private void LoadDeskInfoByDelFlag(int p)
{
List<DeskInfo> list = new List<DeskInfo>();
//通过连接字符串连接数据库
using (SqlConnection con = new SqlConnection(str))
{
//拼接sql语句
string sql =