使用按钮搜索具有多个文本框值的SQL Server数据库

问题描述

在button_click事件中我想检查同一行中的两个文本框值我怎么能这样做..我已经使用这个代码使用一个文本框：

 字符串 Roll = TextBox1.Text; 
 
 DataTable dt =  new  DataTable（）; 
 
  string  query =   SELECT * FROM RESULT_TABLE WHERE ROLL = + Roll; 
 
 SqlConnection sqlConn =  new  SqlConnection（ConfigurationManager.ConnectionStrings [  mycon]的ConnectionString）。 
 sqlConn.Open（）; 
 SqlCommand cmd =  new  SqlCommand（query，sqlConn）; 
 SqlDataAdapter da =  new  SqlDataAdapter（cmd）; 
 
 da.Fill（dt）; 
 sqlConn.Close（）; 
 
 
 ReportViewer DeptReportViewer =  new  ReportViewer（）; 
 
 DeptReportViewer.Reset（）; 
 DeptReportViewer.LocalReport.Dispose（）; 
 
 ReportDataSource rds =  new  ReportDataSource（  ashik，dt）; 
 DeptReportViewer.ProcessingMode = ProcessingMode.Local; 
 DeptReportViewer.LocalReport.ReportPath = Server.MapPath（  Report.rdlc）; 
 
 DeptReportViewer.LocalReport.DataSources.Add（rds）; 
 
 DeptReportViewer.LocalReport.Refresh（）; 
 
警告[]警告; 
  string  [] streamIds; 
  string  mimeType =  string  .Empty; 
  string  encoding =  string  .Empty; 
  string  extension =  string  .Empty; 
  byte  [] bytes = DeptReportViewer.LocalReport.Render（  PDF， null ， out  mimeType， out 编码， out 扩展名， out  streamIds， out 警告）; 
 
 
 Response.Buffer =  true ; 
 Response.Clear（）; 
 Response.ContentType = mimeType; 
 Response.AddHeader（  content-disposition，  attachment; filename = Test.pdf）; 
 
 Response.BinaryWrite（bytes）; 
 
 Response.Flush（）; 

如果滚动和注册号不相同则会显示错误消息...请帮助.....

解决方案

in button_click event i want to check the two textbox values either in same row how could i do it..i have done using one textbox using this code:

String Roll = TextBox1.Text;

DataTable dt = new DataTable();

string query = "SELECT * FROM RESULT_TABLE WHERE ROLL = " + Roll;

SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ConnectionString);
sqlConn.Open();
SqlCommand cmd = new SqlCommand(query, sqlConn);
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);
sqlConn.Close();


ReportViewer DeptReportViewer = new ReportViewer();

DeptReportViewer.Reset();
DeptReportViewer.LocalReport.Dispose();

ReportDataSource rds = new ReportDataSource("ashik", dt);
DeptReportViewer.ProcessingMode = ProcessingMode.Local;
DeptReportViewer.LocalReport.ReportPath = Server.MapPath("Report.rdlc");

DeptReportViewer.LocalReport.DataSources.Add(rds);

DeptReportViewer.LocalReport.Refresh();

Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
byte[] bytes = DeptReportViewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);


Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=Test.pdf");

Response.BinaryWrite(bytes);

Response.Flush(); 

if the roll and registration number are not same then it will show error message...help please.....

解决方案

这篇关于使用按钮搜索具有多个文本框值的SQL Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！