有关C#数据库问题

来源:百度知道 编辑:UC知道 时间:2024/06/04 03:45:16
比如 if(数据库中存在图片)//这个条件不懂得怎么写
{
try
{
SqlConnection conn = new SqlConnection("Data Source=(Local);Integrated Security=SSPI;DataBase=StudentManage");//连接字符串
conn.Open();
string sqlstr = string.Format("select StuPhoto from tabStudent where StuNo='{0}'", dgvStu.CurrentCell.Value);
{
SqlCommand mycmd = new SqlCommand(sqlstr, conn);
SqlDataReader myread;
myread = mycmd.ExecuteReader();
if (myread.Read())
{
lblPhoto.Text = "该生照片:";
byte[] mydata = ((byte[])myread["StuPhoto"]);
MemoryStream myStream = new MemoryStream(mydata);
Image myImage = Image.FromStream(myStream);

SqlConnection conn = new SqlConnection("Data Source=(Local);Integrated Security=SSPI;DataBase=StudentManage");//连接字符串
conn.Open();//连接数据库
try
{
//查询数据局对应列是否存在值
string sqlstr = string.Format("select StuPhoto from tabStudent where StuNo='{0}'", dgvStu.CurrentCell.Value);
{
SqlCommand mycmd = new SqlCommand(sqlstr, conn);
SqlDataReader myread;
myread = mycmd.ExecuteReader();
if (myread.Read())
{
if (myread["StuPhoto"] != null)
{
lblPhoto.Text = "该生照片:";
byte[] mydata = ((byte[])myread["StuPhoto"]);
MemoryStream myStream = new MemoryStream(mydata);
Image myImage = Image.From