在我的代码中,我最终有了很多转换和从int的转换.
必须有一个更好的方法.我错过了什么？

sqlItem.enumValue = (int)myEnumValue;
...
myEnumValue = (MyEnumType)sqlItem.enumValue

sql Server或LINQ将值作为字符串或int存储在数据库中无关紧要,我只想避免所有这些类型转换都在我的代码上洒下来.

可以通过扩展方法解决我的linq-to-sql-classes,如果是这样的话呢？

假设您在Visual Studio中工作(执行这些操作的顺序可能会引起高度的刺激,因为在打开属性时,它会自动在编辑器中取消选择当前的选择,等等)：

>打开DBML编辑器,
>打开“属性”视图/选项卡
>在“类型”字段中指定类型.

根据我的经验,只需输入< namespace>.< type>的形式.并不总是成功,我认为这是@leppie所指的细微差别;为了安全起见,请使用全局::< namespace>.< type&gt ;.

从我的代码中,它需要输入几个记录,但只插入数据库中的第一条记录.任何人都可以通过单击保存按钮帮助我在数据库中保存5条记录吗？

这是我的代码：

DataSet ds = new DataSet();

    sqlConnection cs = new sqlConnection(@"Data Source=DELL-PC;Initial Catalog=Image_DB;Integrated Security=True");

    sqlDataAdapter da = new sqlDataAdapter();

    sqlCommand cmd = new sqlCommand();

    BindingSource Input = new BindingSource();
    DataView dview = new DataView();

    private void Form1_Load(object sender,EventArgs e)
    {
        //create a DataGridView Image Column
        DataGridViewImageColumn dgvImage = new DataGridViewImageColumn();
        //set a header test to DataGridView Image Column
        dgvImage.HeaderText = "Images";
        dgvImage.ImageLayout = DataGridViewImageCellLayout.Stretch;

        DataGridViewTextBoxColumn dgvId = new DataGridViewTextBoxColumn();
        dgvId.HeaderText = "ID";

        DataGridViewTextBoxColumn dgvName = new DataGridViewTextBoxColumn();
        dgvName.HeaderText = "Name";
        dataGridView1.Columns.Add(dgvId);
        dataGridView1.Columns.Add(dgvName);
        dataGridView1.Columns.Add(dgvImage);
        dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
        dataGridView1.RowTemplate.Height = 120;
        dataGridView1.AllowUserToAddRows = false;
    }

    // button add data to dataGridView
    // insert image from pictureBox to dataGridView 
    private void btn_Add_Click(object sender,EventArgs e)
    {
        MemoryStream ms = new MemoryStream();
        pictureBox1.Image.Save(ms,pictureBox1.Image.RawFormat);
        byte[] img = ms.ToArray();
        dataGridView1.Rows.Add(txt_UserID.Text,txt_Name.Text,img);
    }

    // browse image in pictureBox1 Click
    private void pictureBox1_Click(object sender,EventArgs e)
    {
        OpenFileDialog opf = new OpenFileDialog();
        opf.Filter = "Choose Image(*.jpg; *.png; *.gif)|*.jpg; *.png; *.gif";
        if (opf.ShowDialog() == DialogResult.OK)
        {
            pictureBox1.Image = Image.FromFile(opf.FileName);
        }
    }

    private void btn_Save_Click(object sender,EventArgs e)
    {
        for (int i = 5; i < dataGridView1.Rows.Count; i++)
        {
            string col1 = dataGridView1[0,dataGridView1.CurrentCell.RowIndex].Value.ToString();
            string col2 = dataGridView1[1,dataGridView1.CurrentCell.RowIndex].Value.ToString();
            string col3 = dataGridView1[2,dataGridView1.CurrentCell.RowIndex].Value.ToString();

            string insert_sql = "INSERT INTO Input(UserID,UserName,PassImage) VALUES ('" + col1 + "','" + col2 + "','" + col3 + "')";

            this.getcom(insert_sql);
        }

        MessageBox.Show("Record Added");
    }

    public sqlConnection GetsqlConnection() //connection function
    {
        string str_sqlcon = "Data Source=DELL-PC;Initial Catalog=Image_DB;Integrated Security=True";

        sqlConnection mycon = new sqlConnection(str_sqlcon);
        mycon.open();

        return mycon;
    }

    public void getcom(string sqlstr) //function for adding rows
    {
        sqlConnection sqlcon = this.GetsqlConnection(); // Watch out same string type as GetsqlConnection function
        sqlCommand sqlcom = new sqlCommand(sqlstr,sqlcon);
        sqlcom.ExecuteNonQuery();
        sqlcom.dispose();
        sqlcon.Close();
        sqlcon.dispose();
    }

更好的尝试这个.

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
    string col1 = dataGridView1.Rows[i].Cells[0].Value.ToString();
    string col2 = dataGridView1.Rows[i].Cells[1].Value.ToString();
    string col3 = dataGridView1.Rows[i].Cells[2].Value.ToString();
    string insert_sql = "INSERT INTO Input(UserID,'" + col3 + "')";
    this.getcom(insert_sql);
}

如果需要,更改代码逻辑.