如何在insert，update，Delete中编写函数 [英] How to write function in insert,update,Delete

问题描述

Hi,

How to use function in insert,update,Delete ,then how to call this function in c# coding.

推荐答案

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con))
        {
        com.Parameters.AddWithValue("@C1", myValueForColumn1);
        com.Parameters.AddWithValue("@C2", myValueForColumn2);
        com.ExecuteNonQuery();
        }
    }

删除和更新非常相似:有关详细信息，请参见W3Schools: http://www.w3schools.com/sql/sql_delete.asp [ ^ ]和

Delete and update are very similar: See W3Schools for details: http://www.w3schools.com/sql/sql_delete.asp[^] and http://www.w3schools.com/sql/sql_update.asp[^]

尊敬的先生，

写一些初始代码，我将进一步纠正
rgds

Dear sir,

Write some initial code i''ll rectify further
rgds

这篇关于如何在insert，update，Delete中编写函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！