本文介绍了未处理的异常“无效的对象名称”的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 我得到这个未处理的异常。 无效的对象名称dbo.FakturaDb_Faktura 但是表名是这样的,问题是什么? var dt = new DataTable(); const string constring = @ Data Source = MARTIN; Initial Catalog = FakturaDB; Integrated Security = True; 使用( var con = new SqlConnection(constring)) { 使用( var cmd = new SqlCommand( SELECT * FROM dbo.FakturaDB_Faktura,con)) { dataGridViewAllaFakturor.ColumnCount = 1 ; cmd.CommandType = CommandType.Text; 使用( var sda = new SqlDataAdapter(cmd)) { sda.Fill(dt); dataGridViewAllaFakturor.AutoGenerateColumns = false ; dataGridViewAllaFakturor.ReadOnly = true ; dataGridViewAllaFakturor.Columns [ 0 ]。DataPropertyName = FakturaNr; dataGridViewAllaFakturor.Columns [ 0 ]。Name = FakturaNr; dataGridViewAllaFakturor.Columns [ 0 ]。HeaderText = @ FakturaNr; 解决方案 运行此 SELECT * FROM dbo.FakturaDB_Faktura 查询在visual studio中检查它是否在数据库中工作。 试试这个, SELECT * FROM [dbo]。[FakturaDB_Faktura ] -KR i get this Unhandled exception.Invalid object name dbo.FakturaDb_FakturaBut the table name is like that, whats the problem?var dt = new DataTable(); const string constring = @"Data Source = MARTIN; Initial Catalog = FakturaDB;Integrated Security = True"; using (var con = new SqlConnection(constring)) { using (var cmd = new SqlCommand("SELECT * FROM dbo.FakturaDB_Faktura", con)) { dataGridViewAllaFakturor.ColumnCount = 1; cmd.CommandType = CommandType.Text; using (var sda = new SqlDataAdapter(cmd)) { sda.Fill(dt); dataGridViewAllaFakturor.AutoGenerateColumns = false; dataGridViewAllaFakturor.ReadOnly = true; dataGridViewAllaFakturor.Columns[0].DataPropertyName = "FakturaNr"; dataGridViewAllaFakturor.Columns[0].Name = "FakturaNr"; dataGridViewAllaFakturor.Columns[0].HeaderText = @"FakturaNr"; 解决方案 Run this SELECT * FROM dbo.FakturaDB_Faktura query in visual studio to check if it is working on the database.Try this,SELECT * FROM [dbo].[FakturaDB_Faktura]-KR 这篇关于未处理的异常“无效的对象名称”的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-18 09:08