Hi, I'm pretty new at coding but this fits what I need perfectly, however when I search for dapper in visual studio, I can only find Dapper Crud Generator, is that the same thing?
Sir / Madam If there are two dates in a form then how to search for a single date. For example licence registration date & expire date & form register date. How to search record form registration date in a one month.
@@foxlearn i'm having one calibration excel document which consists of item ,serial no, due date. now i want to display only the due items row after comparing with datetimepicker in the datagridview using c#. please help
I am trying there is no built error but when i try to load it show incorrent syntanx near 'o'; on last line of code beneath: can anyone help: Thanks if (db.State == ConnectionState.Closed) db.Open(); string query = "select o.OrderID, c.ContactName, C.Address, c.PostalCode, c.City, c.Phone, o.OrderDate" + "from Orders o inner join Customers c on o.CustomerID=c.CustomerID" + $" where o.OrderDate between'{dateTimePicker1.Value}' and '{dateTimePicker2.Value}' "; ordersBindingSource.DataSource = db.Query(query, commandType: CommandType.Text);
The text to speech you are using is really very beautiful! Can you bring up a tutorial on how you create these wonderful videos?
Hi, I'm pretty new at coding but this fits what I need perfectly, however when I search for dapper in visual studio, I can only find Dapper Crud Generator, is that the same thing?
You should install dapper from manage nuget packages
@@foxlearn haha told you I was new! I got it now, thanks so much for the fast reply!
very good
Thank you
Sir / Madam If there are two dates in a form then how to search for a single date.
For example licence registration date & expire date & form register date. How to search record form registration date in a one month.
Can u please suggest me how to do this in access DB based Datagridview
OK. Thank you for your suggestion. I'll upload soon !
How i do it for one table plz send me SQL command fr 1 table because inner join used for 2 tables plz guide
select *from youtable where yourDate between @fromDate and @toDate
Thank you so much👌
how to add rows only column due dates cell value
Not clear your idea
@@foxlearn
i'm having one calibration excel document which consists of item ,serial no, due date.
now i want to display only the due items row after comparing with datetimepicker in the datagridview using c#.
please help
Fox Learn I have an error: " Conversion failed when converting date and/or time from character string."
Please input your date with format correctly dd/mm/yyyy or mm/dd/yyyy base on your datetime computer
@@foxlearn So actually I should input date whic is based on my computer datetime?
@@foxlearn And anyways it's not working
I am trying there is no built error but when i try to load it show incorrent syntanx near 'o'; on last line of code beneath:
can anyone help: Thanks
if (db.State == ConnectionState.Closed)
db.Open();
string query = "select o.OrderID, c.ContactName, C.Address, c.PostalCode, c.City, c.Phone, o.OrderDate" +
"from Orders o inner join Customers c on o.CustomerID=c.CustomerID" +
$" where o.OrderDate between'{dateTimePicker1.Value}' and '{dateTimePicker2.Value}' ";
ordersBindingSource.DataSource = db.Query(query, commandType: CommandType.Text);
You missing, it should " from Orders o inner join Customers c on o.CustomerID=c.CustomerID", add a backspace
thank you
Thank you
please without music very good thanks
Thank you for your suggestion
very good
Thank you so much :)