|
Hi Eddy. I managed to get it to work OK. However, now I ams tuck on a another bit of an issue. My tblTimsheetDetails has data as follows:
TimesheetDetailID EmployeeID TimesheetID TSProjectCodeID TaskCode TimeSheetDate HoursWorked
100 F3309134 14 MT101 Test Execution (INT) 2010/07/09 4.00
56 F3309134 14 MT101 Test Support 2010/07/26 2.00
62 F3309134 14 MT101 Project Management 2010/07/27 3.00
66 F3309134 14 MT101 Meeting Project 2010/07/27 0.50
67 F3309134 14 MT101 Meeting Project 2010/07/28 0.50
69 F3309134 14 MT101 Project Management 2010/07/28 2.00
70 F3309134 14 MT101 Meeting Project 2010/07/29 1.00
61 F3309134 13 MT900/910 CR 2010/07/26 0.50
When I run the code I am expecting it to group all the MT101 stuff together and give me as single row with a total sum depending on the date range I select as inout. However, it lists thwm all with the individual timea. this is my first attempt at Crystal Reporting and I am hoping to publish this once I get it all to work 100%.
Ay help or suggestions would be great and it is appreciated mate.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Kwagga wrote: When I run the code I am expecting it to group all the MT101 stuff together and give me as single row with a total sum depending on the date range I select as inout. However, it lists thwm all with the individual timea.
Can you post the generated Sql? Might be something in the GROUP BY clause.
Kwagga wrote: this is my first attempt at Crystal Reporting and I am hoping to publish this once I get it all to work 100%.
I'm afraid I can't help you there; I don't have any experience in creating Crystal Reports. Been using MS-Access for far too long 
I are Troll 
|
|
|
|
|
Kwagga wrote: AS 'TOTAL_HOURS AS COLUMN3
That looks wrong.
|
|
|
|
|
using parameterised statements is a bit dodgy when it comes to crystal reports at run time. I am getting input from DateTimePickers and a pre-loaded comboBox with values from the Database, so SQWL injection is kinda limited or not possible. 
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
You can (and should) use parameterized queries with Crystal.
|
|
|
|
|
I managed to resolve the Issues without parameterized queries mate. Because I am creating the dataset at runtime and then populating it to a database at runtime and dynamically assigning them to columns I had to go the route I went. For some reason it is working perfect now. I understand that parameterized queries workes better and they are safer but I am tunning against an MS Access DB which is not that friendly with stored procedures as far as I have read.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Kwagga wrote: Access DB which is not that friendly with stored procedures
No one said anything about stored procedures. 
Aren't you using parameters within Crystal?
|
|
|
|
|
Hi,
I have worked through the MSDN example of Creating an N-Tier Data Application. However, I'm struggling to get started with my 'save changes' functionality for a DataGridView. Can anyone offer any advice?
My solution consists of SQL Server 2008 (I'm using the NorthWind sample database to go along with the walkthrough linked above), a Data Access Tier, Data Entity Tier, DataService and Presentation Layer and currently my app displays the DataSet in two DataGridViews.
I understand the order of method invocations that is required to achieve what I want, but I'm struggling to get started with the coding of it. I.e capturing the changes made in the DataGridView, saving them to the DataSet and then committing the DataSet to the database via the DataService and Data Access Tier.
Apologies for the long post and if I have missed out any info that would help you answer my question.
Anthony
|
|
|
|
|
FYI: your hyperlink is incorrect, it refers to your own message.
|
|
|
|
|
Ah so it did, as I've corrected it.
Thanks for pointing that out.
|
|
|
|
|
Hey buddies !
I want to develop a WinForm Application (C#) in which i can navigate to next or previous Photos (in pictureBox control)..
Example :
> I have dragged a picturebox control on form.
> then dragged two button for next and previous.
> and i want that when i click on next button then another picture should be come (just like in windows picture and fax viewer)
> all picture should be in Resource file.
Hope so u guy are able to understant that what i want.i m a newbie, and i tried but not succeded...when i click first time on button next picture comes out but on second click nothing happens.
i m doing this..
on button click event code is as follow
picturebox1.Image = Properties.Resource.PIC1;//this event takes me to next image but not more forward.
help me out
|
|
|
|
|
You will either have to keep a record of where you are ("showing picture one", "showing picture two" ...) or check which picture you are displaying and move to the next.
if (picturebox1.Image == Properties.Resource.Pic1)
{
... Move to picture two
}
You could use if..else or switch, it depends on how many you have, and how you are with switch statements!
Me, I would set up an array of Images, loaded at form load from the resources, and have an integer index into it which I increment and check each time.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
How to check the values of the checkbox true/false control in Datagridview and then post it values to the database?
|
|
|
|
|
Please read the instructions at the top of the page "How to get an answer to your question" before you post. "Hello Sir i am muthu from kumbakonam" is not a helpful subject for a question - instead describe your problem in a few words: "Use Checkbox in DataGridView" tells potential answerers a lot more, and doesn't waste thier time if they cannot help you.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
Hi there,
when we want to use a function from a C dll, we have to declare it like:
[DllImport(ThirdPartyDll)]
private static extern int SomeFunction(string Param1, and so on);
Now, ThirdParty provides a row of dlls with all of them implementing that SomeFunction with the same signature (only some interenal parameters differ leading to different results). We want our users to select the dll they want to use for that purpose. That means, ThirdPartyDll in [DllImport(ThirdPartyDll)] must become a variable instead of a constant. But C# does not allow a variable at the DllImport declaration.
In old C++, that's possible, I do not remember the exact way, there was some use of function pointers.
But this is a program written in C# (.Net 2.0). How can we do that here?
Looking forward to your hints.
Bernhard
|
|
|
|
|
I don't know if you have better ways to do this, but one idea is to declare them all and after that you define a Delegate with the same signature.
This way you can assign the corresponding function to the delegate, this way you got pretty much the same functionality that you get with pointers to functions.
|
|
|
|
|
Thanks for this idea. In most cases it would do the job. But ThirdParty might provide another such dll with a new name, and it cannot be used before the function of that specific dll was declared. In C++ there is some way to do that, but in C#?
|
|
|
|
|
Bernhard,
Dynamically loading an unmanaged dll uses an almost direct translation of C code.
In the example note the use of
1) the UnmanagedFunctionPointer attribute on the SomeFunction delegate declaration
2) the Marshal.GetDelegateForFunctionPointer method to convert the raw function pointer to the C# friendly delegate.
using System;
using System.Runtime.InteropServices;
internal class DynamicLoad {
[DllImport("kernel32.dll", SetLastError = true)]
private static extern IntPtr LoadLibrary(String dllToLoad);
[DllImport("kernel32", CharSet = CharSet.Ansi, ExactSpelling = true, SetLastError = true)]
private static extern IntPtr GetProcAddress(IntPtr hModule, string procName);
[DllImport("kernel32.dll", SetLastError = true)]
private static extern bool FreeLibrary(IntPtr hModule);
[UnmanagedFunctionPointer(CallingConvention.StdCall, SetLastError = false, CharSet = CharSet.Ansi)]
internal delegate int SomeFunction(string Param1);
private IntPtr dllPtr;
internal SomeFunction someFunction;
internal Boolean Load(String dllPath) {
dllPtr = LoadLibrary(dllPath);
if (dllPtr != IntPtr.Zero) {
try {
someFunction = (SomeFunction)Marshal.GetDelegateForFunctionPointer(
GetProcAddress(dllPtr, "SomeFunction"),
typeof(SomeFunction));
} catch (ArgumentNullException) {
Unload();
}
}
return (dllPtr != IntPtr.Zero);
}
internal void Unload() {
bool result = FreeLibrary(dllPtr);
dllPtr = IntPtr.Zero;
}
}
Alan.
|
|
|
|
|
Alan,
wow! Extremely complicated don't-c-sharp-code, but it works!
Lots of thanks,
Bernhard
|
|
|
|
|
Not really so complicated - he just makes it look complicated with his loony formatting  . However, I gave him a lolly because it's a very good answer.
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
|
|
|
|
|
Ok, now, that's an answer . And now here's a question, what if SomeMethod's signatures does not match the delegate signature?? Do I get an ArgumentException?? I know this should be a problem since he knows the signature of the method. Just asking out of curiosity.
|
|
|
|
|
Just tested that. I inserted another parameter before the normal first parameter (which is the name of a file), then called the function. The int value returned by the function is an error code, now the result was 1. According to the documentation of the manufacturer "1" means "File access error", i.e. my first parameter (although it was an int) was treated as the expected parameter (a string denoting the file name), and extra parameters seem to have been discarded.
In summary, you do not get an exception, the function just executes (and may happen to return an error code or destroy your system).
|
|
|
|
|
Thank you
|
|
|
|
|
Hi,
I made a web browser in .net c# windows application. In that how can i change appearance of the win form...like changing skin of the browser. How can i archive this using c#.
Thank you.
krishna
|
|
|
|
|
Man, you're writing in your question, that this is WinForms question, so why don't you ask it on WinForms forum?
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
