各位哥我的绑定是这样的看有没有什么问题?拜托. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conn = New SqlConnection(ConfigurationSettings.AppSettings("SQLConnString"))
cmd = New SqlCommand("custom1", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@condition1", "%" & start_time.Text & "%")
cmd.Parameters.Add("@condition2", "%" & ddywnr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition3", "%" & TextBox1.Text & "%")
cmd.Parameters.Add("@condition4", "%" & dddwxz1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition5", "%" & ddkhjb1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition6", "%" & ddjbbm1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition7", "%" & ddsspq1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition8", "%" & ddjbr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition9", "%" & last_time1.Text & "%")
conn.Open()
conn.Close()
BindData1()
End Sub
Private Sub BindData1()
Dim cmd As New SqlCommand("custom1", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@condition1", "%" & start_time.Text & "%")
cmd.Parameters.Add("@condition2", "%" & ddywnr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition3", "%" & TextBox1.Text & "%")
cmd.Parameters.Add("@condition4", "%" & dddwxz1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition5", "%" & ddkhjb1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition6", "%" & ddjbbm1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition7", "%" & ddsspq1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition8", "%" & ddjbr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition9", "%" & last_time1.Text & "%")
conn.Open()
DataGrid1.DataSource = cmd.ExecuteReader()
DataGrid1.DataBind()
conn.Close()
end sub
conn = New SqlConnection(ConfigurationSettings.AppSettings("SQLConnString"))
cmd = New SqlCommand("custom1", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@condition1", "%" & start_time.Text & "%")
cmd.Parameters.Add("@condition2", "%" & ddywnr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition3", "%" & TextBox1.Text & "%")
cmd.Parameters.Add("@condition4", "%" & dddwxz1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition5", "%" & ddkhjb1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition6", "%" & ddjbbm1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition7", "%" & ddsspq1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition8", "%" & ddjbr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition9", "%" & last_time1.Text & "%")
conn.Open()
conn.Close()
BindData1()
End Sub
Private Sub BindData1()
Dim cmd As New SqlCommand("custom1", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@condition1", "%" & start_time.Text & "%")
cmd.Parameters.Add("@condition2", "%" & ddywnr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition3", "%" & TextBox1.Text & "%")
cmd.Parameters.Add("@condition4", "%" & dddwxz1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition5", "%" & ddkhjb1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition6", "%" & ddjbbm1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition7", "%" & ddsspq1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition8", "%" & ddjbr1.SelectedItem.Text & "%")
cmd.Parameters.Add("@condition9", "%" & last_time1.Text & "%")
conn.Open()
DataGrid1.DataSource = cmd.ExecuteReader()
DataGrid1.DataBind()
conn.Close()
end sub
cmd.Parameters.Add("@condition1", "%" & start_time.Text & "%")
改為
dim val1 as string ="%" &start_time.text &"%"
cmd.Parameters.Add("@condition1", val1)
我怎么都觉得你都写反了呢
我是菜鸟
学习
SqlParameter[] addressParameter={
new SqlParameter("@CategoryID",SqlDbType.Int,4)
};addressParameter[0].Value=nCategoryID;
------------------------------------
return this.RunProcedure("AddressBook_Address_GetAll",addressParameter,"AddressBook");