开发者

I want just the insert query for a temp table

I am using C#.Net and Sql Server ( Windows Application ). I had created a temporary table. When a button is clicked, temporary table (#tmp_emp_details) is created. I am having another button called "insert Values" and also 5 textboxes. The values that are entered in the textbox are used and whenever com.ExecuteNonQuery(); line comes, it throws an error message Invalid object name '#tbl_emp_answer'.. Below is the set of code.. Please give me a solution.

Code for insert (in insert value button):

private void btninsertvalues_Click(object sender, EventArgs e)  
        {
            username = txtusername.Text;
            examloginid = txtexamloginid.Text;
            question = txtquestion.Text;
            answer = txtanswer.Text;
            useranswer = txtanswer.Text;
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=tempdb;Integrated Security=True;");
  开发者_高级运维          SqlCommand com = new SqlCommand("Insert into #tbl_emp_answer values('"+username+"','"+examloginid+"','"+question+"','"+answer+"','"+useranswer+"')", con);
            con.Open();
            com.ExecuteNonQuery();
            con.Close();
        }


You said you created the temporary table #tmp_emp_details but are trying to insert into a table of a different name, #tbl_emp_answer.

  • Have you created the table #tbl_emp_answer?
  • Should you be inserting into #tmp_emp_details instead?
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜