decalre the scaler varible [英] decalre the scaler varible

问题描述

我必须声明标量变量，但声明如下



有人能告诉我这段代码有什么问题。



谢谢

I am getting must declare the scalar variable but it is declared below

Can someone tell me what's wrong with this code.

thanks

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.IO;
using System.Data.SqlClient;
namespace homeWork2
{
    public partial class entry : Form
    {
        public entry()
        {
            InitializeComponent();
            
        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog op = new OpenFileDialog();
            DialogResult result = op.ShowDialog();
            if (result == DialogResult.OK)
            {
                String file = op.FileName;
                Image im = Image.FromFile(file);
                this.pictureBox1.Image = im;
            }
            
        }

        private void button2_Click(object sender, EventArgs e)
        {
            OpenFileDialog op = new OpenFileDialog();
            DialogResult result = op.ShowDialog();
            if (result == DialogResult.OK)
            {
                String file = op.FileName;
                FileStream f = new FileStream(file, FileMode.Open);
                StreamReader sr = new StreamReader(f);
                string str = sr.ReadLine();
                string desc = sr.ReadToEnd();
                this.textBox1.Text = str;
                this.richTextBox1.Text = desc;
            }
           
        }

        private void richTextBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void contextMenuStrip1_Opening(object sender, CancelEventArgs e)
        {

        }

        private void button3_Click(object sender, EventArgs e)
        {
            string p = this.pictureBox1.ImageLocation;
            string name = this.textBox1.Text;
            string description = this.richTextBox1.Text;

            DateTime da = new DateTime();
            string date = da.ToString("dd/MM/YYYY");
            string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Gardezi\Documents\Visual Studio 2012\Projects\homeWork2\homeWork2\Database1.mdf;Integrated Security=True";
            SqlConnection con = new SqlConnection(connString);
            string query = "insert into diaryDB(Title , Description , Date , pic) values (@name , @description ,@date , @p)";
            SqlCommand comm = new SqlCommand(query, con);

            SqlParameter p1 = new SqlParameter("Title", name);
            SqlParameter p2 = new SqlParameter("Description", description);
            SqlParameter p3 = new SqlParameter("Date", date);
            SqlParameter p4 = new SqlParameter("pic", p);

            comm.Parameters.Add(p1);
            comm.Parameters.Add(p2);
            comm.Parameters.Add(p3);
            comm.Parameters.Add(p4);
            con.Open();
            comm.ExecuteNonQuery();
            con.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            mainMenu m = new mainMenu();
            m.Show();
            this.Close();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            mainMenu m = new mainMenu();
            m.Show();
            this.Close();
        }
    }
}

推荐答案

替换

replace

string query = "insert into diaryDB(Title , Description , Date , pic) values (@name , @description ,@date , @p)";
SqlCommand comm = new SqlCommand(query, con);
SqlParameter p1 = new SqlParameter("Title", name);
SqlParameter p2 = new SqlParameter("Description", description);
SqlParameter p3 = new SqlParameter("Date", date);
SqlParameter p4 = new SqlParameter("pic", p);

comm.Parameters.Add(p1);
comm.Parameters.Add(p2);
comm.Parameters.Add(p3);
comm.Parameters.Add(p4)

with

with

string query = "insert into diaryDB([Title] , [Description] , [Date] , pic) values (@name , @description ,@date , @p)";
SqlCommand comm = new SqlCommand(query, con);
//use the same name given in the sql statement as parameter name
comm.Parameters.AddWithValue("@name", name);
comm.Parameters.AddWithValue("@description", description);
comm.Parameters.AddWithValue("@date", DateTime.Now.ToString("dd/MM/YYYY"));
comm.Parameters.AddWithValue("@p", p);

这篇关于decalre the scaler varible的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！