Question

在没有任何数据时进行无效的读取尝试。

private string GetConnectionString()
{ string con = "server=(local);Initial Catalog=discretemats;uid=sa;pwd=";
return con;
}
private void WriteToFile(string path, ref byte[] buff)
{
FileStream newFile = new FileStream(path, FileMode.Create);
newFile.Write(buff, 0, buff.Length);
newFile.Close();
}
private int WriteToDB(string strName, string strType, ref byte[] Buff)
{
int FileID = 0;
SqlConnection mycon = new SqlConnection(GetConnectionString());
SqlDataAdapter myda=new SqlDataAdapter("select * from tblfile",mycon);
myda.MissingSchemaAction=MissingSchemaAction.AddWithKey;
SqlCommandBuilder mycmdb = new SqlCommandBuilder(myda);
DataSet myds;
try
{
mycon.Open();
myds=new DataSet();
myda.Fill(myds,"tblFile");
DataTable mydbl=myds.Tables["tblFile"];
DataRow myrow=mydbl.NewRow();
myrow["FileName"]=strName;
myrow["FileSize"]=Buff.Length;
myrow["FileData"]=Buff;
myrow["FileType"]=strType;
mydbl.Rows.Add(myrow);
myda.Update(myds,"tblFile");
if(!myrow.IsNull("FileID"))
FileID=Convert.ToInt32(myrow["FileID"].ToString());
}

Answer 1

哟，瞅着是C#呀