using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace SearsMarket
{
public partial class frontpage2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
if (RadioButton1.Checked==true)
{
string constring = ConfigurationManager.ConnectionStrings["cnnstring"].ToString();
SqlConnection myConnection = new SqlConnection(constring);
myConnection.Open();
SqlCommand cmd =
new SqlCommand
("select goodsnm,goodspc from goods where goodsnm=@xx", myConnection);
cmd.Parameters.AddWithValue("@xx", TextBox1.Text);
cmd.ExecuteNonQuery();
SqlDataReader br = cmd.ExecuteReader();
GridView1.DataSource = br;
GridView1.DataBind();
myConnection.Close();
}
else if (RadioButton2.Checked==true)
{
string constring = ConfigurationManager.ConnectionStrings["cnnstring"].ToString();
SqlConnection myConnection = new SqlConnection(constring);
myConnection.Open();
SqlCommand cmd =
new SqlCommand
("select gkid,gknm,gkrnm,gktel from gk where gkid=@aa", myConnection);
cmd.Parameters.AddWithValue("@aa", TextBox1.Text);
cmd.ExecuteNonQuery();
SqlDataReader br = cmd.ExecuteReader();
GridView1.DataSource = br;
GridView1.DataBind();
myConnection.Close();
}
else if (RadioButton3.Checked==true)
{
string constring = ConfigurationManager.ConnectionStrings["cnnstring"].ToString();
SqlConnection myConnection = new SqlConnection(constring);
myConnection.Open();
SqlCommand cmd =
new SqlCommand
("select oderid,oderdate,odercd from oders where oderdate=@bb", myConnection);
cmd.Parameters.AddWithValue("@bb", TextBox1.Text);
cmd.ExecuteNonQuery();
SqlDataReader br = cmd.ExecuteReader();
GridView1.DataSource = br;
GridView1.DataBind();
myConnection.Close();
}
else
{
string constring = ConfigurationManager.ConnectionStrings["cnnstring"].ToString();
SqlConnection myConnection = new SqlConnection(constring);
myConnection.Open();
SqlCommand cmd =
new SqlCommand
("select lyid,lynr,lytime from liuyan where lytime=@bb", myConnection);
cmd.Parameters.AddWithValue("@bb", TextBox1.Text);
cmd.ExecuteNonQuery();
SqlDataReader br = cmd.ExecuteReader();
GridView1.DataSource = br;
GridView1.DataBind();
myConnection.Close();
}
}
}
}
代碼是這樣的 想實作按不同的條件查詢的功能 結果只有最后一個能查到
uj5u.com熱心網友回復：
因為你的parameter都是字串，你應該轉化為相應的型別。比如gkid如果是數字，那么你應該把textbox的text轉化為數字，再add進parameteruj5u.com熱心網友回復：
我留言是按日期查找的 只有這個radiobutton能被觸發 其他的都不能，而且我的訂單也是按日期查找的啊= =uj5u.com熱心網友回復：
https://docs.microsoft.com/en-us/dotnet/api/system.web.ui.webcontrols.radiobutton?view=netframework-4.8uj5u.com熱心網友回復：
你斷點下這三個值到底是因為按鈕還是SQL的問題
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/89096.html
標籤：C#
上一篇：小白來問問題了