在数据库中插入数据 [英] Insert Data In database

问题描述

朋友，因为你知道我是c＃的新手并且对c知之甚少＃



在我的申请中我有三个联系方式。



我想在我的联系表中插入这3个盒子值，但不是列明智的想要在特定行中插入每个文本框值



请任何人帮助我怎么可能。

Friends as u know I am new to c# and has a very poor knowledge of c#

In my application I have three contact box.

I want to insert this 3 box value in my contact table but not column wisei want to insert each text box value in particular row

Please any one help me how is it possible.

推荐答案

try
    {
//your database connection string.
        string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Customers.mdf;Integrated Security=True;User Instance=True";

        using (SqlConnection connection = new SqlConnection(connectionString))
        using (SqlCommand command = connection.CreateCommand())
        {
            command.CommandText = "INSERT INTO TableName(ColumnName1, ColumnName2, ColumnName3) VALUES (@value1, @value2, @value3)";

            command.Parameters.AddWithValue("@value1", ContactBox1.Text);
            command.Parameters.AddWithValue("@value2", ContactBox2.Text);
            command.Parameters.AddWithValue("@value3", ContactBox3.Text);
           

            connection.Open();
            command.ExecuteNonQuery();
        }
    }
    catch (SqlException ex)
    {
        Console.WriteLine(ex.Message);
    }

1。连接数据库

2.提供sql命令，例如

1. Connect to Database
2. Give sql command like

string sql= "insert into tablename (Contact) values (?p1) where contactid=values";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("?p1",TextBox1.Text);
cmd.ExecuteNonQuery();
con.Close();

这篇关于在数据库中插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！