C#插入SQL数据库

        string strconn = "server=.;User Id=sa;Password=sa;database=数据库名;integrated security=true";
        SqlConnection conn = new SqlConnection(strconn);
        conn.Open();

        string sqlstr = "insert into table1(item1,item2,item3) values('1','2','3')";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        cmd.EndExecuteNonQuery();
        conn.Close();

posted @ 2010-06-21 17:04  微硬  阅读(262)  评论(0编辑  收藏  举报