Click here to Skip to main content
15,881,856 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi this is my code :
C#
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 naft
{
    public partial class M : Form
    {

        
        SqlCommand cmd;
        SqlConnection con;
        SqlDataAdapter da;


        public M()
        {
            InitializeComponent();
        }
        private void BtnSave_Click(object sender, EventArgs e)
        {
            con = new SqlConnection(@"Data Source=SHADOW\AL;Initial Catalog=Filelib;Integrated Security=True");
            con.Open();
            cmd = new SqlCommand("INSERT INTO M (M_Name, M_Code) VALUES (@M_Name, @M_Code)", con);
            cmd.Parameters.Add("@M_Name", TxtM_Name.Text);
            cmd.Parameters.Add("@M_Code", TxtM_Code.Text);
            cmd.ExecuteNonQuery();
        }


when i want to insert name and code it show me this error : invalid object name Naft ( after i change it to "m" it says invalid object name "m" )

"naft" is my sql database and the table that i want to insert data is "M" how to fix it ?

What I have tried:

i searched a lot but i can't fix it.
Posted
Updated 13-Feb-21 0:19am
v2
Comments
[no name] 15-Mar-16 8:47am    
Make sure that table "M" is available in "Filelib" database.
brandon1999 15-Mar-16 9:16am    
thanks fixed it.
Mohammad Reza Valadkhani 15-Mar-16 8:59am    
are you sure that table and filed exists?!
brandon1999 15-Mar-16 9:05am    
yes i'm sure
Mohammad Reza Valadkhani 15-Mar-16 9:11am    
double check your database, if you have enough access try to check your query interaction in your SQL server to find out the error, technically this error happen when your table or filed is missing.

1 solution

Quote:
"naft" is my sql database
Then your connection string should look like this:
C#
@"Data Source=SHADOW\AL;Initial Catalog=naft;Integrated Security=True"

And then your query should work like you've shown it ("INSERT INTO M ...") provided that there are no mistakes with the column names and types.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900