网格视图不显示数据(当我运行程序时,表单为空)
本文关键字:程序 表单 运行 视图 显示 数据 网格 | 更新日期: 2023-09-27 17:51:13
请帮助我解决此问题。由于某些原因,我无法在gridview中显示数据库中的表。每当我运行程序时,windows窗体都是空白的(什么都没有(。
Connection Manager类从这里开始:
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace OCUTutoringSchedule
{
public class OCUTutoringScheduleDBConn
{
public static SqlConnection getStringConn()
{
string connectionString = "Data Source= (LocalDB)''v11.0;AttachDbFilename="
+ "C:''Users''Honopac''Documents''Visual Studio 2013''"
+ "Projects''OCUTutoringSchedule''OCUTutoringSchedule''"
+ "TutoringSchedule.mdf;Integrated Security=True";
SqlConnection connection = new SqlConnection(connectionString);
return connection;
}
}
}
数据访问类从这里开始:
using System;
using System.Data;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace OCUTutoringSchedule
{
public class TutorDB
{
public TutorDB()
{
}
public DataTable displayTutor()
{
DataTable dt = new DataTable("TutorsInformation");
string selectStatement = "SELECT * FROM Employees";
SqlConnection connString = OCUTutoringScheduleDBConn.getStringConn();
connString.Open();
using (SqlCommand cmd = new SqlCommand(selectStatement, connString))
{
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
return dt;
}
}
}
表单加载事件从这里开始:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace OCUTutoringSchedule
{
public partial class Tutoring_Schedule_Maintainace : Form
{
public Tutoring_Schedule_Maintainace()
{
InitializeComponent();
}
private void Tutoring_Schedule_Maintainace_Load(object sender, EventArgs e)
{
TutorDB tutorDB = new TutorDB();
DataGridView gv = new DataGridView();
gv.AutoGenerateColumns = true;
gv.DataSource = tutorDB.displayTutor();
gv.Visible = true;
}
}
}
您没有将数据网格视图添加到表单中。您可以使用设计器轻松地完成此操作,而不是自己实例化它。
gv.Location = New System.Drawing.Point(10, 55)
gv.Size() = New System.Drawing.Size(130, 95)
this.Controls.Add (gv)
您需要使用this.Controls.Add(gv);
将gv
添加到Form.Controls属性中,而不是将gv.Visible
设置为true
。