|
ya we can reorder it using select query command,
Thanks!!
But i have another query is grid result show desigtime columns as well as runtime columns too!!
Than how to solve this problem?
|
|
|
|
|
If I understood you correctly, it sounds like something is going wrong with the data binding. In other words, you have the columns from design time, and then when the data is bound during runtime, a new set of columns is created instead of the existing ones being used.
My advice is free, and you may get what you paid for.
|
|
|
|
|
A couple of things to check...
First, in your binding code, make sure that you set the DataGridView's AutoGenerateColumns property to False.
Next, make sure your Columns that you created are setup properly to bind to the appropriate table/column names in the dataset/datatable.
|
|
|
|
|
Check to see if there is a GenerateColumns or an AutoGenerateColumns property and set it to false. You may need to write additional code to bind the design-time columns with the columns in the dataset.
|
|
|
|
|
That autogenerate property coes into asp.net application but not in windows,i checked that one also!!
Any other way?
|
|
|
|
|
KIDYA wrote: That autogenerate property coes into asp.net application but not in windows
You might want to check again. DataGridView doesn't work under ASP.NET. It's a WindowForms only control. You can find the documentation on AutoGenerateColumns here[^].
|
|
|
|
|
Hi.
Is there a way to use runningvalue expression using more than one field
I want to be able to perhaps use an IFF based on condition and once that condition is true then grab data from another field whilst keeping the running value count etc. is that even achievable.
e.g.
IIf fields!automotive = "CARS" then runningvalue(!fields!carsid)
IIf fields!automotive = "HOUSE" then runningvalue(!fields!housevalue)
***THIS WILL CODE WILL BE IN ONE TEXTBOX in REPORT VIEWER ****
etc etc
is there a way to use IFF and runningvalue and switch fields whilst running value keeps is count down all rows and again this is to be behind one textbox field producing output on report.
I'd appreciate any assistance on wether this can be done using IFF and runningvalue or perhaps if there is another command/function that will work
Many Thanks
Robbo
|
|
|
|
|
Dear All,
I have one query. Please help me.
Please send me the source code for Time and attendence system for fetching the data from Access Control database. The Database is MS-SQL. So i require the source code for fetching the data from database.
The all transactions will be stored in a single table. We have to fetech the first access and last access from the table including entry and exit time. How to solve the day over lapping ( The employee working in night shift and going next day morning) ?
Please help me.
With regards,
Ravisubrahmnaya
|
|
|
|
|
No.
My advice is free, and you may get what you paid for.
|
|
|
|
|
It is considered rude to ask for (or rather demand, in your case) source code. Try something on your own, and when you get struck somewhere, then come back and post specific questions about the problems you are facing.
|
|
|
|
|
Ravisubrahmanya wrote: Please send me the source code
...and this is where I stop reading you're post. NO, we will NOT just hand over source code so you can pass it off as your own work.
YOU have to write the code and if you have problems with something, then you can come here and ask specific questions about the problem.
Just showing up and asking for code, on any site, is very rude.
|
|
|
|
|
I'd be glad to stop doing what I am doing and write the code for you.
Better yet, send me the email address of your boss or teacher and I will save you any cut and paste time and trouble by sending the code directly to him. I will be sure and mention your name and send him a copy of your original post so you get everything that you deserve.
|
|
|
|
|
Hi,
I am writing this only after exhausting effort to search and find the solution was unsuccessful.
I am using Visual Studio 2005. The Test123 function written in C++ should be called from vb.net by using Interop Services.
The Testing.dll is a CLR dll.
Below is a simplified version of the C++ structure :
typedef struct TEST_STRUCT<br />
{<br />
long lTotal;<br />
int nRow;<br />
int nCol;<br />
CString sName;<br />
BOOL bFound;<br />
int item[100];<br />
} TEST;
Below is a simplified version of the structure declared in vb.net :
<StructLayout(LayoutKind.Sequential, Pack:=1, CharSet:=CharSet.Ansi)> _<br />
Public Structure TEST_STRUCT<br />
' ''<System.Runtime.InteropServices.FieldOffsetAttribute(0)> _<br />
Public lTotal As Integer<br />
Public nRow As Integer<br />
Public nCol As Integer<br />
<System.Runtime.InteropServices.MarshalAsAttribute(System.Runtime.InteropServices.UnmanagedType.LPStr)> _<br />
Public sName As String<br />
<System.Runtime.InteropServices.MarshalAsAttribute(System.Runtime.InteropServices.UnmanagedType.Bool)> _<br />
Public bFound As Boolean<br />
<br />
'<System.Runtime.InteropServices.MarshalAsAttribute _<br />
'(System.Runtime.InteropServices.UnmanagedType.SafeArray, SafeArraySubType:=Runtime.InteropServices.VarEnum.VT_I4)> _<br />
<System.Runtime.InteropServices.MarshalAsAttribute _<br />
(System.Runtime.InteropServices.UnmanagedType.LPArray, SizeConst:=100)> _<br />
Public Item() As Integer<br />
End Structure<br />
<br />
Public Declare Auto Function Test123 Lib "Testing.dll" () As TEST_STRUCT<br />
What can work :
1) I can call the module Test123 from vb.net and it can run.
2) I can interop data for lTotal, nRow and nCol and receive at vb.net without any problem.
What my questions are :
1) How to interop data for sName, bFound and item[100]?
2) Which part I am wrong?
3) How should I declare the structure in vb.net to interop these data?
4) Can Interop support CString directly?
5) Is there any indirect way of marshaling which can work, such as doing the Interop in C# and then call from vb.net?
Your guidance on solving this problem is very much appreciated.
Thanks,
Goutam
|
|
|
|
|
Hi,
1.
AFAIK P/Invoke works equally well from VB.NET as from C#, so a C# detour does not make sense to me.
2.
To embed a fixed-size array inside a struct you need
<MarshalAs(UnmanagedType.ByValArray, SizeConst:=100)>
3.
for the string, I'm not sure. You might define it as an IntPtr, and use one of the Marshal.PtrToStringXxx methods.
4.
as long as one struct member isn't marshaled correctly, everything that follows it may fail.
so start by putting the string last!
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Hello Mr. Luc Pattyn,
Thank you for your prompt reply and interest in this topic.
When I do the testing, I comment out all and test one by one as below. When I can interop every value I need, only then I will put them together :
<br />
typedef struct TEST_STRUCT<br />
{<br />
int item[100];<br />
} TEST;<br />
<br />
<br />
extern "C" __declspec(dllexport) TEST_STRUCT Test123();<br />
<br />
extern "C" __declspec(dllexport) TEST_STRUCT Test123()<br />
{<br />
TEST_STRUCT TestStruct;<br />
<br />
TestStruct.item[0] = 11; <br />
<br />
return TestStruct;<br />
}<br />
1. I agree with you on this.
2. I tried the <MarshalAs(UnmanagedType.ByValArray, SizeConst:=100)>, and it didn't work.
If I declare the bFound as int16 at the vb.net side, then I can get 0 or 1. But that's not what we need.
3. Please enlighten me on the IntPtr and Marshal.PtrToStringXxx methods, as I am still not sure how to use it in this case.
>>4. as long as one struct member isn't marshaled correctly, everything that follows it may fail.
>>so start by putting the string last!
4. I appreciate this advice. I will strictly follow this.
I still could not interop sName, bFound and item[100]. I am getting error message "Method's type signature is not PInvoke compatible."
Any help will be amazing...
cheers,
Goutam
|
|
|
|
|
Hi,
1.
yes ByValArray and SizeConst is what you need to pass an embedded array, here is a C# example:
struct XXX {
[MarshalAs(UnmanagedType.ByValArray, SizeConst=8)]
public short[] array;
...
}
2.
I forgot to warn you about data sizes: most X86 native compilers consider long a 32-bit integer, so its managed counterpart is an int, not a long.
3.
There are additional marshaling fields for strings that I keep forgetting; they allow you to embed a string content (with fixed maximum length) into a struct. Here is an example, again in C#:
struct XXX {
[MarshalAs(UnmanagedType.ByValTStr, SizeConst=32)]
public string lfFaceName;
}
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Hi,
I am sorry to say that I am not making any progress. I wonder if my problem is some where else and I am touble shooting at some where else.
If I create an MFC Active X control, it automatically creates DllRegisterServer and DllUnregisterServer modules, to register to regedit by using regsvr32.
When I create this CLR dll, DllRegisterServer and DllUnregisterServer modules are not created automatically. And, I can't register this dll.
Is it a must to register a dll by using regsvr32?
Well, I am trying to look at the problem from other angels...just to make sure I am not missing anything.
cheers,
Goutam
|
|
|
|
|
Hi,
This is how I understood the DLL stuff:
- a managed code DLL gets referenced by a .NET project; it will either be copied into the EXE folder, or it must reside in the GAC;
- a native code DLL can be stored anywhere, Windows will look for it using the PATH system environment variable;
- a COM code DLL (which holds native code), needs to be registered.
When a .NET exe does not find a DLL it needs, IMO it clearly says so, with one proviso: when it says it is not finding XXX, it may well be it is not finding one of the dependencies of XXX.
I don't understand why you are doubting this, you already have parts of your struct being passed back and forth successfylly!?
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Hi,
I have an array, x = {10,20,30,"",""). I want the length of this array with non-empty fields, i.e. 3 instead of 5.
Also, I want to store the entries without Null in another array.
How to implement this in VB?
thanks
|
|
|
|
|
You'd be better to use a generic list. Then you can remove items at all.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: You'd be better to use a generic list. Then you can remove items at all.
How to implement this in VB?
|
|
|
|
|
He asked this just yesterday I think.
I believe he even copy and pasted his query exactly as before.
|
|
|
|
|
|
Assuming you have a variable that holds how many items are in the array you can use the redim preserve commands.
redim preserve yourarray(number_of_items)
One warning though. Don't overuse this command because internally it creates a new array and copies all of the contents to the new array so if you call this too many times with large arrays it can make your program slow. Also if you resize arrays like this make sure you pass them byref not byval or else the changes won't be reflected in the calling function/sub.
modified on Thursday, November 12, 2009 10:57 PM
|
|
|
|
|
i have a table which i call "RATES" and it s
..............(column1)
..............rate_start....commission.....rate_finish
row 1
................300..............2.............500.....
................501..............3.............600.....
................601..............4.............700 ....
.......................................................
................1500 ............8.............1800....
user entry etc total.text="532" (if user entry is "532" then respond should be "3")
how can i find the correct "commission"
my query is not working right it s ;
"select commission from RATES where rate_start < "' total.text and rate_finish > VALUE ....
plz help me
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
