选择陈述书中的错误 [英] error in select statment

问题描述

SqlDataAdapter cmd = new SqlDataAdapter("select * from calender where date= " + monthCalendar1.SelectionRange.Start , con);
            
            SqlCommandBuilder cb = new SqlCommandBuilder(cmd);
            DataSet ds = new DataSet();
            cmd.Fill(ds);


            dataGridView1.DataSource = ds.Tables[0];

可以解决此问题，以便在从日历中选择日期时显示信息

can solve this problem to show the information when select the date from calender

推荐答案

更改

Change

SqlDataAdapter cmd = new SqlDataAdapter("select * from calender where date= " + monthCalendar1.SelectionRange.Start , con);

到

to

SqlDataAdapter cmd = new SqlDataAdapter("select * from calender where date= CAST('" + monthCalendar1.SelectionRange.Start.ToString() + "' as datetime)" , con);

请参考 http://msdn.microsoft.com/en-us/library/ms187928.aspx [ ^ ]将字符串转换为日期时间有关更多参数.
我建议使用参数.您可以找到许多用于创建带参数命令的示例.

希望对您有帮助.

please refer http://msdn.microsoft.com/en-us/library/ms187928.aspx[^] to cast string to datetime for more parameters.
I would suggest to use parameters. You can find many samples for creating command with parameters.

Hope this helps.

感谢它给了我这个问题

从字符串转换日期时间时转换失败.

thanks it give me this problem

Conversion failed when converting datetime from character string.

非常感谢它解决了

这篇关于选择陈述书中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！