C# 查询 插入 修改 删除 sqlserver2008中记录

查询

string sql = "select 列名1 from 表名 where <a target=_blank href="mailto:id=@id">id=@id</a>";

byte[][] image = new byte[41][];

            try
            {
                conn.Open();
                SqlCommand com = new SqlCommand(sql, this.conn);
                SqlParameter id = new SqlParameter("@id", SqlDbType.VarChar);
                id.Value = Id;
                com.Parameters.Add(id);
                com.CommandType = CommandType.Text;
                SqlDataReader reader = com.ExecuteReader();
                int i = 0;
                while (reader.Read())
                {
                    i++;
                    image[i] = (byte[])reader["picture"];
                }
                
                reader.Close();