未处理的异常“无效的对象名称” [英] Unhandled exception "Invalid Object name"
问题描述
我得到这个未处理的异常。 i get this Unhandled exception. 这篇关于未处理的异常“无效的对象名称”的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
无效的对象名称dbo.FakturaDb_Faktura
但是表名是这样的,问题是什么?
< pre lang =c#> var dt = new DataTable();
const string constring = @ Data Source = MARTIN; Initial Catalog = FakturaDB; Integrated Security = True;
使用( var con = new SqlConnection(constring))
{
使用( var cmd = < span class =code-keyword> 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
Invalid object name dbo.FakturaDb_Faktura
But 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