C#插入图片数据并返回自增字段(ISID)的值
作者:C/S框架网  发布日期:2011/06/03 11:33:40
C#插入图片数据并返回自增字段(ISID)的值




private void button1_Click(object sender, EventArgs e)

        {

            //插入图片数据并返回自增字段(ISID)的值 BY JONNY SUN ,www.csframework.com

 

            //建立连接

            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = @"server=.\sqlexpress;database=XX;integrated security=true";

            conn.Open();

 

            string insert = "INSERT INTO TCertImages(CertID,ImageName,CertImage) VALUES (@CertID,@ImageName,@CertImage)";

            insert = insert + " SELECT @@IDENTITY AS ISID"; //获取最新自增字段的值

 

            SqlCommand cmd = new SqlCommand(insert, conn);

            cmd.Parameters.Add("@CertID", SqlDbType.VarChar, 50, "CertID").Value = "test";

            cmd.Parameters.Add("@ImageName", SqlDbType.VarChar, 50, "ImageName").Value = "test name";

            cmd.Parameters.Add("@CertImage", SqlDbType.Image, 0, "CertImage").Value = new byte[2] { 111, 222 }; //图片数据

            object isid = cmd.ExecuteScalar(); //ISID

 

            MessageBox.Show(isid.ToString());

        }



上一篇 下一篇