评论会员：游客 时间：2012/02/06
检查列值-如果是0，显示一个消息框如果你不知道如何使用一个消息框，看到imgsrc=]
。巴拉Selvanayagam
评论会员：游客 时间：2012/02/06
codeprespanclass="code-keyword"private/spanspanclass="code-keyword"void/spanbutton1_Click(spanclass="code-keyword"object/spansender,EventArgse){spanclass="code-keyword"try/span{SqlConnectionoConn=spanclass="code-keyword"new/spanSqlConnection();oConn.ConnectionString=spanclass="code-string""/spanspanclass="code-string"datasource=SOLAP;database=SAMPLE;user=sa;password=admin1990"/span;oConn.Open();spanclass="code-keyword"string/spanstrSQL=spanclass="code-string""/spanspanclass="code-string"Selectcount(*)fromstockwhereMID='"/span+textBox1.Text+spanclass="code-string""/spanspanclass="code-string"'"/span;SqlCommandoCmd=spanclass="code-keyword"new/spanSqlCommand(strSQL,oConn);spanclass="code-keyword"if/span(Convert.ToInt16(oCmd.ExecuteScalar())==0)MessageBox.Show(spanclass="code-string""/spanspanclass="code-string"nostock"/span);spanclass="code-keyword"else/spanMessageBox.Show(spanclass="code-string""/spanspanclass="code-string"yesstock"/span);}spanclass="code-keyword"catch/span(Exceptionex){MessageBox.Show(ex.Message);}}/pre/code{C}