I've tried to avoid them cause of that.
Code:
SELECT Vrijeme From (SELECT (CAST(Racun.datum AS DATETIME) + CAST(Racun.vrijeme AS DATETIME)) AS Vrijeme From Racun) WHERE Vrijeme BETWEEN '2012-09-11 00:00:00' AND '2012-09-19 10:40:08'
Djiber
Last Activity: May 22 '13, 12:48 PM
Joined: Apr 27 '12
Location:
-
Doesn't subquery use more resources.
I've tried to avoid them cause of that.
-
My Columns in Table are date and time(0) and if you meant start/endDateTimeStri ng I don't understand why would it matter cause it's String in the Query anyway.
Problem was I've used Alias Column Vrijeme and thought it'll Compare with it, but it used Racun.vrijeme whole time(I didn't work with SQL for some time so I forgot simple things)
This:
...Code:SELECT (CAST(Racun.datum AS DATETIME) + CAST(Racun.vrijeme AS DATETIME))
Leave a comment:
-
DateTime WHERE BETWEEN Query problem
I have an Database Table containing columns, 2 columns of my problem concern are:
- column Date
- column Time
I'm using that Table to show data by DateTime
On my form I have:
- 4 dateTimePickers (2 of them for Date, 2 of them for Time)
- dataGridView
- button
On button click I would like to populate dataGridView with data that's between 2 DateTimes:
...Code:private
-
SQL Database Read Only
Mine C# WinForm Application is using SQL Server 2008 Express and it's database to store/browse Data.
On computer which I've used to develop application everything is working, but on my brother's computer I get an Exception that Database is Read Only when I try to submit some changes.
I've menage to get it working with Connection string:
...Code:Data Source=.\SQLEXPRESS;AttachDbFilename=C:\MyApp\Base.mdf;Integrated
-
Why does ShowInTaskbar = false close my form when Child Form is closed?
I have MainForm with 20+ buttons, every button on click opens new form for Data Input.
I'm trying to achieve to have only one Taskbar Icon like this:
And it's...Code:private void button27_Click(object sender, EventArgs e) { this.ShowInTaskbar = false; Rez RZ = new Rez(); RZ.Owner = this; RZ.ShowDialog(); } -
Winform Schedule Control
I would need Schedule Toolbox Control for my application, is there some Free Controls for download or a tutorial for creating it.
I've searched and didn't find any working solution
It should be able to display something like this:
... -
Calendar or something like that
What is the easiest way to accomplish this:
Image ^^
I've made this picture with Excel :P
I have a Database of tasks and I would need to make a preview of them like an calendar.
Like you see on the picture some tasks need 2-3 days to complete so I would need to draw rectangle or something that would represent that task and over it task ID/Name should be written.
That rectangle... -
I'm using Visual C# 2010 Express
SRY I didn't reply sooner, but didn't have access to internet over the weekend.
Yes I've thought picture may help, cause it's hard to explain it on my language and even harder on English, I don't speak it that often :P
I'm gonna check that thread, try to implement it and check does it solve my problem.
Thanks for the reference
Edit:
Yap setting...Leave a comment:
-
http://desmond.imageshack.us/Himg857...pg&res=landing
Red/Selected Row is row that I've selected, edited, then refreshed grid and reselect it (When I click on "Promjeni" button/Edit button I can edit that row and it'll reselect it again)
Blue/Phantom Selected Row is row that gets autoselected (You can notice the arrow/triangle on the Row Header) If I click Down...Leave a comment:
-
Hmmm, now I'm not sure if you didn't understand me or I don't understand you :P
This ^^ is code that fires everytime selected row is changed cause it's a part of refresh function and now like I've said it does work it selects the row I wish it to select, it focus it so if it's in the middle of the database it'll go to it and select it so it scrolls to it and everything.
On Form I have edit button that when you click it will...Leave a comment:
-
dataGridView Selection?
Is it possible and how to disable selection of 1'st row in dataGridView.
I made it select some other row, but even so when u try to move with arrows on keyboard it'll select 2'nd row(cause 1'st row was selected initially and you can see it's selected on RowHeader-1'st/Left Column)
This is my code for selecting row:
...Code:dataGridView1.ClearSelection(); dataGridView1.Rows[BoPrI].Selected = true;
-
Thank you for confirmation, computer I'm working on is old, has 1GB of RAM and 2,4 GHz CPU :PLeave a comment:
-
@Plater
How do you mean?
I have EventHandlers for button.Click for what would I need it for Visible state? (Like I've said it's a Menu so I just need that Buttons are shown when I click on button that's always visible and that they disappear when I click on another+it makes visible another set of buttons)Leave a comment:
-
Puting them in groupBox helped but now it's not pretty :P
I still don't understand if drawing is the problem how is it easier to draw them(make them visible) then destroy them (make them invisible)Leave a comment:
-
Buttons visibility
I have app in which I would like to use buttons as an Drop Down menu.
...Code:private void button16_Click(object sender, EventArgs e) { button1.Visible = true; button2.Visible = true; button3.Visible = true; button4.Visible = true; button5.Visible = true; button6.Visible = true;
No activity results to display
Leave a comment: