private void btnReport_Click(object sender, EventArgs e) { dset.Clear(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.Connection = cnn; cmd.CommandText = "SELECT SerialId,GoodsName,GoodsType,Amval,Radeh,Condition,city,PlaceKeeping FROM tblRegister WHERE city like'" + txtShahrestan.Text.Trim() + "' AND Radeh like'" + txtRade.Text.Trim() + "' AND GoodsName like'" + txtGoodsName.Text.Trim() + "' AND GoodsType like'" + txtGoodsType.Text.Trim() + "' AND Condition like'" + txtCondition.Text.Trim() + "' "; SqlDataAdapter adpter = new SqlDataAdapter(); adpter.SelectCommand = cmd; adpter.Fill(dset, "tblRegister"); stiReport1.RegData(dset); stiViewerControl1.Report = stiReport1; stiReport1.Show(); }
like
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)