//已经好的存储过程
if object_id(N'up_selectPay') is not null
drop proc up_selectPay
go
create proc up_selectPay
@Fdate_down datetime,
@Fdate_up datetime,
@FCh varchar(255)
as
select * from icstockbill ,icstockbillentry
where icstockbill.finterid = icstockbillentry.finterid and
fbillno like 'TJ%' and
fdate between @Fdate_down and @Fdate_up//连接数据库
public SqlConnection getK3con()
{
string str = "server = (local);database = ais20090413161510;trusted_connection = yes";
SqlConnection conn = new SqlConnection(str);
return conn;
}
//创建DataSet 对象
public DataSet getK3Payds(string sqlstr, DateTimePicker dtp_fdate_down, DateTimePicker dtp_fdate_up, ComboBox cbx_CH)
{
SqlConnection mycon = this.getK3con();
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, mycon);
myda.SelectCommand.CommandType = CommandType.StoredProcedure;
myda.SelectCommand.Parameters.AddWithValue("@Fdate_down", dtp_fdate_down);
myda.SelectCommand.Parameters.AddWithValue("@Fdate_up", dtp_fdate_up);
myda.SelectCommand.Parameters.AddWithValue("@FCh", cbx_CH);
DataSet myds = new DataSet();
myda.Fill(myds);
return myds;
//显示存储过程数据
private void btn_Find_Click(object sender, EventArgs e)
{
try
{
#region
//显示入库数据
DataSet ds = SClass.getK3Payds("up_selectPay", dtp_dateDown, dtp_dateUp, cboxCh);
dGV_Pay.DataSource = ds.Tables[0].DefaultView;
#endregion
}
catch (Exception ex)
{
MessageBox.Show(ex .Message);
}
提示:未处理 System.ArgumentException
Message="不存在从对象类型 System.Windows.Forms.DateTimePicker 到已知的托管提供程序本机类型的映射。"
求正解
if object_id(N'up_selectPay') is not null
drop proc up_selectPay
go
create proc up_selectPay
@Fdate_down datetime,
@Fdate_up datetime,
@FCh varchar(255)
as
select * from icstockbill ,icstockbillentry
where icstockbill.finterid = icstockbillentry.finterid and
fbillno like 'TJ%' and
fdate between @Fdate_down and @Fdate_up//连接数据库
public SqlConnection getK3con()
{
string str = "server = (local);database = ais20090413161510;trusted_connection = yes";
SqlConnection conn = new SqlConnection(str);
return conn;
}
//创建DataSet 对象
public DataSet getK3Payds(string sqlstr, DateTimePicker dtp_fdate_down, DateTimePicker dtp_fdate_up, ComboBox cbx_CH)
{
SqlConnection mycon = this.getK3con();
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, mycon);
myda.SelectCommand.CommandType = CommandType.StoredProcedure;
myda.SelectCommand.Parameters.AddWithValue("@Fdate_down", dtp_fdate_down);
myda.SelectCommand.Parameters.AddWithValue("@Fdate_up", dtp_fdate_up);
myda.SelectCommand.Parameters.AddWithValue("@FCh", cbx_CH);
DataSet myds = new DataSet();
myda.Fill(myds);
return myds;
//显示存储过程数据
private void btn_Find_Click(object sender, EventArgs e)
{
try
{
#region
//显示入库数据
DataSet ds = SClass.getK3Payds("up_selectPay", dtp_dateDown, dtp_dateUp, cboxCh);
dGV_Pay.DataSource = ds.Tables[0].DefaultView;
#endregion
}
catch (Exception ex)
{
MessageBox.Show(ex .Message);
}
提示:未处理 System.ArgumentException
Message="不存在从对象类型 System.Windows.Forms.DateTimePicker 到已知的托管提供程序本机类型的映射。"
求正解
myda.SelectCommand.Parameters.AddWithValue("@Fdate_down", dtp_fdate_down.Value.ToString("yyyy-MM-dd"));
myda.SelectCommand.Parameters.AddWithValue("@Fdate_up", dtp_fdate_up.Value.ToString("yyyy-MM-dd"));