|
|
Hi, perhaps someone can help me...
I run a query like this:
string str = "SELECT LOG.Type, LOG.Time, LOG.Nick, LOG.Message FROM LOG WHERE (((LOG.Type) Like 'SAY') OR ((LOG.Type) Like 'ACTION') ) AND ((LOG.Message) Like '*text*') ORDER BY LOG.Time DESC";
OleDbDataAdapter sda = new OleDbDataAdapter(str, accessConn);
sda.Fill(dt);
DataRow[] rows = dt.Select();
For simplicity, str equals the string i copied from a stringbuilder object while debugging. The Message field is of memo type. dt is a DataTable object.
Now the problems is, rows.Length = 0 after last statement, while sending the exact query via Access produces the correct results.
After some more debugging, it seems the problem is with the wildcards at Message Like '*text*' . Changing the query to Message Like 'text' produces the correct results.
Can anyone try this or help
|
|
|
|
|
OK i sorted this, maybe a bug
Resolution:
converted access db to access 2002 format and made db ANSI-92 complaint.
i then search using ANSI-92 standards IOW % instead of * for wildcard.
|
|
|
|
|
|
From MSDN:
Initializes a new instance of the String class to the value indicated by a specified pointer to an array of 8-bit signed integers, a starting character position within that array, a length, and an Encoding object. This constructor is not CLS-compliant.
[C#] unsafe public String(sbyte*, int, int, Encoding);
I assume this is what you need.
Read MSDN
|
|
|
|
|
I have a DLL which was made in Delphi 6.0
Its source code looks like this:
===========================================
library TestDLL;
uses
SysUtils,
Classes,
Windows;
procedure GetInteger(var N : integer);
begin
N:= 115;
end;
exports
GetInteger;
begin
end.
======================================
As i thought this function after calling it in C# by:
======================================
[DllImport ("C:/MyTest.dll")]
static unsafe extern void GetInteger(int* i);
int N = 0;
GetInteger(&N);
Console.WriteLine("N value after calling GetInteger: " + N);
=========================================
Have to write string "N value after calling GetInteger: 115" in console, but i saw "N value after calling GetInteger: 0"...
So my anser is: where is my mistake?
|
|
|
|
|
koenig wrote:
[DllImport ("C:/MyTest.dll")]
static unsafe extern void GetInteger(int* i);
int N = 0;
GetInteger(&N);
change to:
[DllImport ("C:/MyTest.dll")]
static unsafe extern void GetInteger(ref int i);
int N = 0;
GetInteger( ref N);
|
|
|
|
|
Not work properly
|
|
|
|
|
ok, try adding dll to working dir of application or anywhere in your PATH, then reference the dll like "MyTest.dll" , if that doesnt work, then i guess the dll is at fault.
You can mail it to me if u want to.
|
|
|
|
|
Problem was in DLL.
I changed procedure in Delphi, and now everything ok =)
procedure GetInteger(var N : integer); stdcall; //!!!!!!
//stdcall converts integer to MS format for integer
begin
N:= 115;
end;
Thanx for help...
|
|
|
|
|
Try using a different CallingConvention in your DLL import. Its likely that a Delphi DLL won't be the default MS convention.
|
|
|
|
|
>> Delphi DLL won't be the default MS convention.
Yes, it's realy so...
I solved a problem by changing function in Delphi.
|
|
|
|
|
Well this may be a stupid question, and some of you may laugh.... eventhough here goes: How the H..., do you move a form using C#???
//NJ
|
|
|
|
|
|
Thanks..... actually I just found out another way.... I will still try your's....
|
|
|
|
|
Anonymous wrote:
Well this may be a stupid question, and some of you may laugh....
Take it easy frind.Feel free to post your question.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Is there a way to perform this feature on DropDowns... I think I know of a way it used to be done in VB but Don't know if I can Get it to work in C#.. Method was to use SendMessage Method from the Windows API to perform this operation...
Insight is appreciated.. Code would be wonderful
Morgan
|
|
|
|
|
While you could use ShAutoComplete From the Shell API it will only AutoComplete URLs. If you want it to autocomplete the Items in a combobox you would have to do a lot of nasty COM interop.
However, I am in the middle of developing a .NET ComboBox that features autocomplete so I already have some code you can have to do this in an inherited combobox. Just use it as you would a regular combobox. Enjoy
using System;
using System.Windows.Forms;
namespace YourNameSpace
{
public class ACComboBox : ComboBox
{
protected string oldText = "";
protected override void OnKeyPress(KeyPressEventArgs e)
{
if(!Char.IsControl(e.KeyChar))
{
int possibleMatch=0;
string textBefore = Text;
possibleMatch = FindString(Text);
if(possibleMatch >= 0)
{
oldText = Text;
SelectedIndex = possibleMatch;
Select(textBefore.Length,Text.Length-textBefore.Length);
}
}
base.OnKeyPress(e);
}
protected override void OnTextChanged(EventArgs e)
{
oldText = Text;
base.OnTextChanged(e);
}
}
}
|
|
|
|
|
|
Here's some quick code: (similar to previous reply)
private void comboBox_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
int where = comboBox.FindString(comboBox.Text);
int start = comboBox.Text.Length;
if ((where >= 0) && (e.KeyChar >= 32))
{
comboBox.Text = ((string) comboBox.Items[where]);
comboBox.Select(start, comboBox.Text.Length);
}
}
Nice, quick.
PS: How the hell do i get code nicely displayed like some other posts i have seen?
|
|
|
|
|
leppie wrote:
PS: How the hell do i get code nicely displayed like some other posts i have seen?
Put the code within PRE tags
This is within pre tags
Nish
Author of the romantic comedy
Summer Love and Some more Cricket [New Win]
|
|
|
|
|
I am getting ready to build a webservice that will comprise several components. Am I better off building several components with one webservice as an abstraction layer or several smaller webservices.
Steve
Not all who wander are lost...
|
|
|
|
|
Hi Steve
This sounds like an interesting problem.
Please can you provide some more info so I can give you a better answer.
Cheers,
Simon
"Every good work of software starts by scratching a developer's personal itch.", Eric S. Raymond
|
|
|
|
|
I am beginning a research project in which I will begin to develop an application to manage a small to mid-size hospital. I am wondering what the best way to architect this is. I was thinking of building a webservice for consumption by and ASP.NET site as well as a piece of software on handheld devieces. There is so much functionality that will be exposed that roling it into a single webservice will produce an enourmous service. I was thinking after I posted that COM+ may be the way to go. I have no experiance developing enterprise applications so any advice or good resources would be appreciated.
Thanks.
Steve
Not all who wander are lost...
|
|
|
|
|
OK. Here's my take on the web services architecture thing.
All a web service (ws) really is, is a class that happens to be exposed to the web. Ideally, in my opinion, the ws should just wrap an existing class. So, ws X would wrap (and expose) class X.
My reasoning behind this is because of 2 primary factors: performance and reusability.
Performance - if ws X is the sole provider of functionality X then another class on the same machine will have to take the performance hit of calling a ws (marshalling, HTTP, address resolution, etc...).
Reusability - follows on from previous point. Also, I view a ws to be a requirement of a class and not necessary a point of functionality itself.
The thing to remember is that a ws is just a class. So, if your class/ws is too large, then chances are that it hasn't been factorised properly. One school of thought (Bruce Eckell, I think) is to design your class on a small flash card. The premise being that if you require more physical space on the card to jot down member and attribute names then you should use another card/class. I think this is a pretty nice idea! Thanks, Bruce.
An idea would be to remove the concept of web services from your initial design and rather give a special attribute to the classes that need to be exposed to the web/intranet. This can later be enhanced into a decorator class of soughts.
Your idea of having ASP.NET as your front end that consumes web services is a valid design. What would the reason be to expose web services though?
If your reason is to expose a subset of functionality for other apps to use, then cool.
The architecture I'm working on at the moment uses ASP.NET pages (very light) that consume ws as per your idea. There was a very specific reason for it though. The entire backend (ws included) will be migrated to a J2EE & ws system in a few years time and we wanted to prevent a[nother] rewrite for that.
As far as COM+ is concerned: COM+/MTS no longer gives you the reduction in object creation time that it would do for pure COM components, so that's minus 1 point. Hopefully, this will change with COM+ 2 (?) in the .NET servers.
The reasons that COM+ might be useful in a .NET world is for things like transactions. Will this be a requirement for your application?
If you are keen to continue this offline, then either MSN Messenger/mail me at simon_stewart@hotmail.com.
Cheers,
Simon
"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)
|
|
|
|