（常用）C# 连接数据库进行增删查改的基本模板

发布时间：2020-12-16 01:24:48 所属栏目：百科来源：网络整理

导读：string conn_str = @" Server=(local); database = YJ_Database; User id = sa; Password = 123456 " ; SqlConnection conn = new SqlConnection(conn_str); conn.Open(); string sql = " insert into t_Organization values(‘ " +_FNumber+ " ‘,‘ " +_FN

string conn_str = @"Server=(local); database = YJ_Database; User id = sa; Password = 123456";
            SqlConnection conn = new SqlConnection(conn_str);
            conn.Open();
            string sql = "insert into t_Organization values(‘"+_FNumber+"‘,‘"+_FName+"‘)";
            SqlCommand cmd = new SqlCommand(sql,conn);
            int n=cmd.ExecuteNonQuery();
            conn.Close();

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!