窗体软件通过select 得出表格 datagridview 出现错误

本人小菜鸟，求大神解答

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\SQL\\JANTYSQL.mdb;Jet OLEDB:Database Password=janty2017";
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();
string tx = "select * FROM [dbo_JANTY_TMGG] where [SPID] = '" + this.textBox1.Text + "'";
OleDbCommand cmd3 = new OleDbCommand(tx, conn);
OleDbDataAdapter da = new OleDbDataAdapter(tx, conn);
DataTable table = new DataTable();
da.Fill(table);
this.TMB_sql.DataSource = table;
conn.Close();

熊猫办公

java语言，领先的AI写作工具，原创文档内容生成，完整内容，3分钟直接获取.java语言，支持智能问答/文案写作/整理大纲/笔记记录/脚本策划等各种需求，免费体验!

2025-04-10 11:54广告

立即查看

跪求解答

自己顶~！！！！急急急~公司急用，跪求大神进来！

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;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace 百胜条码工具
{
public partial class BsTable : Form
{
public BsTable()
{
InitializeComponent();
//if(Login.bs_loging == 1) //获取操作员姓名
//{
// this.label1.Text = DateSet.NameSet.datename0;
//}
//else
//{
// this.label1.Text = Login.bs_name;
//}
}
private void BsTable_Load(object sender, EventArgs e)
{
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\SQL\\JANTYSQL.mdb;Jet OLEDB:Database Password=janty2017";
OleDbConnection con = new OleDbConnection(strConnection);
con.Open();
string tx = "select * FROM [dbo_JANTY_TMGG]";
OleDbCommand teble = new OleDbCommand(tx, con);
OleDbDataAdapter da = new OleDbDataAdapter(tx, con);
DataTable table = new DataTable();
da.Fill(table);
this.TMB_sql.DataSource = table;//连接数据库表
con.Close();
//TMB_sql.Columns[1].Frozen = true;
//TMB_sql.Columns[0].HeaderCell.Value = DateSet.NameSet.datename0;//dr["vDateName"].ToString();
//TMB_sql.Columns[1].HeaderCell.Value = DateSet.NameSet.datename1;
//TMB_sql.Columns[2].HeaderCell.Value = DateSet.NameSet.datename2;
//TMB_sql.Columns[3].HeaderCell.Value = DateSet.NameSet.datename3;
//TMB_sql.Columns[4].HeaderCell.Value = DateSet.NameSet.datename4;
//TMB_sql.Columns[5].HeaderCell.Value = DateSet.NameSet.datename5;
//TMB_sql.Columns[6].HeaderCell.Value = DateSet.NameSet.datename6;
//TMB_sql.Columns[7].HeaderCell.Value = DateSet.NameSet.datename7;
//TMB_sql.Columns[8].HeaderCell.Value = DateSet.NameSet.datename8;
//TMB_sql.Columns[9].HeaderCell.Value = DateSet.NameSet.datename9;
//TMB_sql.Columns[10].HeaderCell.Value = DateSet.NameSet.datename10;
//TMB_sql.Columns[11].HeaderCell.Value = DateSet.NameSet.datename11;
//TMB_sql.Columns[12].HeaderCell.Value = DateSet.NameSet.datename12;
//TMB_sql.Columns[13].HeaderCell.Value = DateSet.NameSet.datename13;
//TMB_sql.Columns[14].HeaderCell.Value = DateSet.NameSet.datename14;
//TMB_sql.Columns[15].HeaderCell.Value = DateSet.NameSet.datename15;
//TMB_sql.Columns[16].HeaderCell.Value = DateSet.NameSet.datename16;
//TMB_sql.Columns[17].HeaderCell.Value = DateSet.NameSet.datename17;
//TMB_sql.Columns[18].HeaderCell.Value = DateSet.NameSet.datename18;
//TMB_sql.Columns[19].HeaderCell.Value = DateSet.NameSet.datename19;
//TMB_sql.Columns[20].HeaderCell.Value = DateSet.NameSet.datename20;
//TMB_sql.Columns[21].HeaderCell.Value = DateSet.NameSet.datename21;
//TMB_sql.Columns[22].HeaderCell.Value = DateSet.NameSet.datename22;
//TMB_sql.Columns[23].HeaderCell.Value = DateSet.NameSet.datename23;
//TMB_sql.Columns[24].HeaderCell.Value = DateSet.NameSet.datename24;
//TMB_sql.Columns[25].HeaderCell.Value = DateSet.NameSet.datename25;
//TMB_sql.Columns[26].HeaderCell.Value = DateSet.NameSet.datename26;
//TMB_sql.Columns[27].HeaderCell.Value = DateSet.NameSet.datename27;
//TMB_sql.Columns[0].Width = DateSet.NameSet.datewidth0;//列宽
//TMB_sql.Columns[1].Width = DateSet.NameSet.datewidth1;
//TMB_sql.Columns[2].Width = DateSet.NameSet.datewidth2;
//TMB_sql.Columns[3].Width = DateSet.NameSet.datewidth3;
//TMB_sql.Columns[4].Width = DateSet.NameSet.datewidth4;
//TMB_sql.Columns[5].Width = DateSet.NameSet.datewidth5;
//TMB_sql.Columns[6].Width = DateSet.NameSet.datewidth6;
//TMB_sql.Columns[7].Width = DateSet.NameSet.datewidth7;
//TMB_sql.Columns[8].Width = DateSet.NameSet.datewidth8;
//TMB_sql.Columns[9].Width = DateSet.NameSet.datewidth9;
//TMB_sql.Columns[10].Width = DateSet.NameSet.datewidth10;
//TMB_sql.Columns[11].Width = DateSet.NameSet.datewidth11;
//TMB_sql.Columns[12].Width = DateSet.NameSet.datewidth12;
//TMB_sql.Columns[13].Width = DateSet.NameSet.datewidth13;
//TMB_sql.Columns[14].Width = DateSet.NameSet.datewidth14;
//TMB_sql.Columns[15].Width = DateSet.NameSet.datewidth15;
//TMB_sql.Columns[16].Width = DateSet.NameSet.datewidth16;
//TMB_sql.Columns[17].Width = DateSet.NameSet.datewidth17;
//TMB_sql.Columns[18].Width = DateSet.NameSet.datewidth18;
//TMB_sql.Columns[19].Width = DateSet.NameSet.datewidth19;
//TMB_sql.Columns[20].Width = DateSet.NameSet.datewidth20;
//TMB_sql.Columns[21].Width = DateSet.NameSet.datewidth21;
//TMB_sql.Columns[22].Width = DateSet.NameSet.datewidth22;
//TMB_sql.Columns[23].Width = DateSet.NameSet.datewidth23;
//TMB_sql.Columns[24].Width = DateSet.NameSet.datewidth24;
//TMB_sql.Columns[25].Width = DateSet.NameSet.datewidth25;
//TMB_sql.Columns[26].Width = DateSet.NameSet.datewidth26;
//TMB_sql.Columns[27].Width = DateSet.NameSet.datewidth27;
//TMB_sql.Columns[0].Visible = DateSet.UserSet.dateusing0;//.Columns(0).Visible = False //启用状态
//TMB_sql.Columns[1].Visible = DateSet.UserSet.dateusing1;
//TMB_sql.Columns[2].Visible = DateSet.UserSet.dateusing2;
//TMB_sql.Columns[3].Visible = DateSet.UserSet.dateusing3;
//TMB_sql.Columns[4].Visible = DateSet.UserSet.dateusing4;
//TMB_sql.Columns[5].Visible = DateSet.UserSet.dateusing5;
//TMB_sql.Columns[6].Visible = DateSet.UserSet.dateusing6;
//TMB_sql.Columns[7].Visible = DateSet.UserSet.dateusing7;
//TMB_sql.Columns[8].Visible = DateSet.UserSet.dateusing8;
//TMB_sql.Columns[9].Visible = DateSet.UserSet.dateusing9;
//TMB_sql.Columns[10].Visible = DateSet.UserSet.dateusing10;
//TMB_sql.Columns[11].Visible = DateSet.UserSet.dateusing11;
//TMB_sql.Columns[12].Visible = DateSet.UserSet.dateusing12;
//TMB_sql.Columns[13].Visible = DateSet.UserSet.dateusing13;
//TMB_sql.Columns[14].Visible = DateSet.UserSet.dateusing14;
//TMB_sql.Columns[15].Visible = DateSet.UserSet.dateusing15;
//TMB_sql.Columns[16].Visible = DateSet.UserSet.dateusing16;
//TMB_sql.Columns[17].Visible = DateSet.UserSet.dateusing17;
//TMB_sql.Columns[18].Visible = DateSet.UserSet.dateusing18;
//TMB_sql.Columns[19].Visible = DateSet.UserSet.dateusing19;
//TMB_sql.Columns[20].Visible = DateSet.UserSet.dateusing20;
//TMB_sql.Columns[21].Visible = DateSet.UserSet.dateusing21;
//TMB_sql.Columns[22].Visible = DateSet.UserSet.dateusing22;
//TMB_sql.Columns[23].Visible = DateSet.UserSet.dateusing23;
//TMB_sql.Columns[24].Visible = DateSet.UserSet.dateusing24;
//TMB_sql.Columns[25].Visible = DateSet.UserSet.dateusing25;
//TMB_sql.Columns[26].Visible = DateSet.UserSet.dateusing26;
//TMB_sql.Columns[27].Visible = DateSet.UserSet.dateusing27;
}
}
private void button3_Click(object sender, EventArgs e)
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\SQL\\JANTYSQL.mdb;Jet OLEDB:Database Password=janty2017";
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();
string tx = "select * FROM [dbo_JANTY_TMGG] where [SPID] = '" + this.textBox1.Text + "'";
//OleDbCommand cmd3 = new OleDbCommand(tx, conn);
OleDbDataAdapter da = new OleDbDataAdapter(tx, conn);
DataTable table = new DataTable();
da.Fill(table);
this.TMB_sql.DataSource = table;
conn.Close();
}

fill 应该是dataset 吧

找到原因了，是数据库select字段设置了不能为空值，把要搜寻那一列设置为可以为空值就行了

扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！

7回复贴，共1页

<<返回c#吧

分享到:

日	一	二	三	四	五	六