|
This isn't a limitation of C#, but of how Windows and controls work.
The combobox control you drag over from the toolbox is just a wrapper for a standard Windows control from the Common Controls Library. The way these controls works requires sending messages to the controls to get them to do things, like add an item to a collection in your combobox.
|
|
|
|
|
That is not a technological limitation, it is common sense.
If you were to create the Google search engine, would you have a zillion answers (the entire database) on a single web page without a textbox where one can enter a question?
|
|
|
|
|
If you're only going to put the "name" and "code" in the combo box, WHY ARE YOU DOWNLOADING THE ENTIRE CUSTOMER TABLE?! Inquiring minds would like to know.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Avoid async void methods | You’ve Been Haacked[^]
Try something like this:
private void Form1_Load(object sender, EventArgs e)
{
_ = OnFormLoadAsync();
}
private async Task OnFormLoadAsync()
{
try
{
DataSet ds = await Task.Run(() => LoadCustomers());
mycombo.DataSource = ds.Tables[0];
mycombo.ValueMember = "code";
mycombo.DisplayMember = "cust_name";
}
catch (Exception error)
{
MessageBox.Show("Error.... " + erro.Message);
}
}
private DataSet LoadCustomers()
{
const string query = "SELECT * FROM Customers ORDER BY cust_name";
using (OleDbConnection con = new OleDbConnection(conex))
using (OleDbCommand cmd = new OleDbCommane(query, con))
{
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
}
} But as others have said, loading thousands of records into a combobox is not a good idea.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Using C# code only, how can I get the list of outgoing MSMQ queues ?
|
|
|
|
|
Have a look at the MessageQueue.GetXXX methods!
|
|
|
|
|
Not working... as I mention previously, the MessageQueue.GET... methods show the Public and/or Private queues but not the OutGoing Queues...
I can "create" outgoing queue by send message with exact syntax of connection but can't get the list of current outgoing queues...
|
|
|
|
|
|
Hi,
Thanks, already look at this article, the problem is how to find "...Object library" (either version 1.0, 2.0 or 3.0) that support by new OS versions (Win 10).
Anyway, thanks for the tips
|
|
|
|
|
Hello,
I have a dll created with delphi language (Borland Delphi 7) which thus contains functions in delphi which I would like to use in C# under Visual Studio 2017. It is a native dll.
I want to use for example the GENERATE_FILE function contained in test.dll.
Delphi code :
procedure GENERATE _FILE(Path, Input_File : AnsiString); stdcall;
procedure GENERATE _FILE(Path, Input_File : AnsiString); stdcall;
var
begin
…
GENERATE_CALC(Path_And_File, CRC32, Total, err);
…
end;
In C#, I want to use the function GENERATE_FILE contained in test.dll but what is the type of the parameters Path and Input_File in C# ?
Below is an example of C# code I made to use test.dll in delphi in C#. I set string as a type for parameters of the function GENERATE_FILE.
namespace AppTest
{
Public class Program
{
[DllImport("test.dll", CharSet = CharSet.Ansi)]
public static extern bool CREATE_FILE(string pathDirectory, string filename);
static void Main(string[] args)
{
GENERATE_FILE(@"C:\Users", "file.txt");
}
}
}
I added the test.dll in Visual Studio by right clicking on the project then add an existing element, then, in the properties of the test.dll, I put "Content" in Generation action and I put "Always copy "(output directory). When I run the solution, I have the test.dll in bin\Debug.
But when I test this program, I get the following error at the line that contains:
GENERATE_FILE(@"C:\Users", "file.txt");
System.DllNotFoundException: 'Unable to load DLL' test.dll ': The specified module could not be found. (Exception from HRESULT: 0x8007007E) '
How to solve this problem ?
I think the issue is about the type of parameters in the function GENERATE_FILE. What are the type equivalents between delphi and C# for the function GENERATE_FILE ?
Thank you for your help.
|
|
|
|
|
In C#, you can only use the string type.
See Calling a Delphi DLL from a C# .NET application - Stack Overflow[^] and be sure to read the entire thing. There are links you're going to have to follow and read.
Depending on what your Delphi code is doing, you may need to rewrite it to support being called from an external caller.
|
|
|
|
|
Quote: I think the issue is about the type of parameters
Why? the error message was pretty clear, it said Quote: 'Unable to load DLL test.dll
which may not be entirely accurate, it would better be "unable to load DLL test.dll or some of its dependencies" (that is other DLL's your test.dll might be relying on).
Don't worry about your parameter types right now, first make sure you have all the required DLL files are in a location where the .NET executable can find them. Maybe start looking here[^].
BTW: your DLL files will need to have the same 32-bit/64-bit choice your .NET code has.
FYI: AFAIK there also is Delphi.NET which would mean you could recompile your Delphi code (assumed available) and use its output as a regular .NET DLL, without any P/Invoke stuff.
|
|
|
|
|
Tested example[^]
Should work.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
I am planning a different approach - have written half of the code, but it is not ready for testing yet. In my case, it is one subsystem written in C++, others in C#.
Rather than messing around with P/invoke and all sorts of parameter transfer, synchronization and whathaveyou, I run it as two processes. The two subsystems have limited, and structurally very simple, data interchange. I find it far easier to exchange those data through a named pipe. The data format is application specific, but as these two subsystems belong to the same application, it is like an internal API with no more need to adhere to a standard than any other internal interface.
I like strong isolation between subsystems and modules. It gives greater freedom within each subsystem/module, and it keeps the architecture clean. And it makes the system flexible: If I later want to replace that C++ subsystem with one written in Cobol, say , I could do so without any effect on the C# part. Well, if I could access that Cobol code through the same P/invoke interface, it might be similar, but now I don't have to worry about that at all.
I am considering the same approach even when the subsystems are all in C#: Threads are fair enough, but do not provide the same isolation as separate processes. When different tasks really are independent (such as one monitoring external equipent/events, the other one interacting with the user; the only common data are the summary reports from the monitor process), they might as well be implemented and run as completely separate entities. Two simple entities are better than one complex.
|
|
|
|
|
I'm storing a file in a mysql table in a Longblob.
Now i would like to create a sha256 as a "footprint" for this file, so i can verify if the file exists already in my database.
As a test i've created this code
private byte[] ObjectToByteArray(Object obj)
{
if (obj == null)
return null;
BinaryFormatter bf = new BinaryFormatter();
MemoryStream ms = new MemoryStream();
bf.Serialize(ms, obj);
return ms.ToArray();
}
private void button5_Click(object sender, EventArgs e)
{
byte[] bookData = null;
byte[] bookDataSha = null;
book bog = getBookById("6");
bog.GetEbookHash(string.Format(@"H:\calibre\{0}\", bog.path), 6);
using (var db = new MySqlConnection(@"server = xxxxxxx"))
{
MySql.Data.MySqlClient.MySqlDataReader myData;
db.Open();
MySqlCommand comm = db.CreateCommand();
comm.CommandText = "select content from bookContent where id='6' and type='epub'";
myData = comm.ExecuteReader();
while (myData.Read())
{
bookData = this.ObjectToByteArray(myData["content"]);
bookDataSha = Sha256.ComputeHash(bookData);
}
db.Close();
}
if (bog.EpubHash == bookDataSha)
{
MessageBox.Show("success");
}
MessageBox.Show(bog.getEbookHashStr(bog.EpubHash)+" - "+bog.getEbookHashStr(bookDataSha));
}
My problem is that the 2 sha256's isnt equal.
I've found this Generate a SHA-256 encrypted hash[^]
and when i upload the file i test on, it creates the same sha256 as my code for the file does.
But when i read the data from the longblob and creates a sha256 it is different.
The strange part, is that if i use my website to download the same longblob and saves it as a file... FC cant find any diffeneces.
What do i do wrong ?
Thanks in advance
Yours
Wilco
|
|
|
|
|
Hi,
I'm not familiar with the MySql connector, and I tend not to store files in databases (it does not make much sense to me, it only inflates the DB size). However I noted what follows:
at the bottom of your code there is a while loop, wherein you call Sha256.ComputeHash .
That piece of code looks very suspicious: what remains is just the SHA256 of the last loop iteration, so either you only have one iteration (and the while should be an if), or your logic is wrong (you should collect all the data and then calculate SHA256 on the whole thing).
You could try with a small file, say less than 1KB. Or you could track the while loop behavior, either by adding an output statement, or by using a debugger...
|
|
|
|
|
Hi Luc
You are abosolute right. This example was copied from some where else i my code...
I've changed it to a IF, but change in the hash value.
I thought i would run this by the community to see if anybody have had a problem like this before....
I'll just lay it to side, and later look into the byte array differences... there has to be some, since the sha256 values are different..
Thanks for your response
Yours
Wilco
|
|
|
|
|
The usual method for this is to store the file and the hash in the database, then you only need to compare the hash rather than recompute each time.
The better method is to store the file in the file system and only store the filename and path with the hash in the database.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Hi Mycroft
That is the plan, when i come there... but first step is to be able to compare the 2 hash values.
If i upload a file to the database with a hash, it's ok, but for database maintenance purpose i would like to be able to recalculate the value "on the fly", with out having to save all 3000+ files one at a time to recalculate hash value.
And i just can wrap my brain around the difference... basicly its an array of bytes - both the longblob and the filestream.
As for saving the file to database... this a give premis for this task. I have very limited space in the OS environment, but unlimited space in the database.
Yours
Wilco
|
|
|
|
|
Check the length of the blob that you are saving, vs. the length of the one you are reading. If you suspect the sha256-hash, then replace it with another hashing algo.
As for "not storing files in a db" in support of exposing the filesystem; I would advise against it. Modern databases are fast enough to work as a file-system, and are used as such.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Hello, I'm new to the forum and new to C# and programming in general so any help with this is appreciated.
I have two arrays of strings. sTime holds the string TimePosition and the second holds a text string.
I have an Audio file playing using mediaPlayer.
I am trying to sample the mediaPlayer position to trigger an event when it reached a desired time.
There will be multiple sTimes that will be at random positions throughout the Audio File.
Each time the mediaPlayer.position compares to the sTime it will display the text string associated with the sTime.
Think Teleprompter or Karaoke Player.
I think mediaPlayer is not robust enough the capture every millisecond to compare, so I miss the event.
I could try comparing to see if position is greater or equal to 10.000 but I'll miss 10.678 but this code never triggers the MessageBox.
It also would be more efficient if I knew how to capture the mediaPlayer.position directly and compare it to a variable without all the wasted conversion time. But I don't.
Thanks for any help.
lblLength.Content = mediaPlayer.NaturalDuration.TimeSpan.TotalSeconds;
mediaPlayer.Play();
When the mediaPlayer.position
string Position = String.Format("{0:r}", mediaPlayer.Position.TotalSeconds);
void timer_Tick(object sender, EventArgs e)
{
if (mediaPlayer.Source != null)
{
lblStatus.Content = mediaPlayer.Position.TotalSeconds;
var ucontent = lblStatus.Content;
string eTime = ucontent.ToString();
string tTime;
tTime = "10.000";
if (String.Equals(eTime, tTime))
{
MessageBox.Show("position = " , eTime);
}
}
else
lblStatus.Content = "No file selected...";
}
|
|
|
|
|
You need to dig deeper into the Media Player or "Media Element" class. There's a "Media Timeline" class (and "Storyboard" class) that seem to have some bearing on what you're doing.
You may have to "chunk" your way through the media source with multiple time lines of starting position and duration (if there's no appropriate events to capture or you're not into WPF).
How to: Control a MediaElement by Using a Storyboard - WPF | Microsoft Docs
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
I read this source code then I built my form to draw a rectangle and make it able to resize/ move it, some how, the logic I follow is wrong, because the mouse when it moves up the small rectangles then the mouse cursor should change, it is some times change and others not, even in the console I can see the mouse cursor should apply. Also if I try to resize it then a new rectangle drawn. My form source code:
public partial class Form2 : Form
{
private enum ResizableRect
{
RightUp,
RightMiddle,
RightBottom,
LeftUp,
LeftMiddle,
LeftBottom,
UpMiddle,
BottomMiddle,
None
};
private int m_resizableRectSize = 6;
private ResizableRect m_resizableRectNodeSelected = ResizableRect.None;
Rectangle rect;
Point StartXY;
Point EndXY;
int x = 0;
int y = 0;
bool m_isMouseDown = false;
bool m_movingRect = false;
public Form2()
{
InitializeComponent();
this.DoubleBuffered = true;
}
private void panel1_Paint(object sender, PaintEventArgs e)
{
{
Graphics gObj = panel1.CreateGraphics();
Pen rectPen = new Pen(Color.Red, 2);
rectPen.DashStyle = DashStyle.Dash;
x = Math.Min(StartXY.X, EndXY.X);
y = Math.Min(StartXY.Y, EndXY.Y);
int height = Math.Abs(StartXY.X - EndXY.X);
int width = Math.Abs(StartXY.Y - EndXY.Y);
rect = new Rectangle(x, y, height, width);
gObj.DrawRectangle(rectPen, rect);
foreach (ResizableRect pos in Enum.GetValues(typeof(ResizableRect)))
{
gObj.DrawRectangle(new Pen(Color.Red), GetResizableRectNode(pos));
}
}
}
private void panel1_MouseDown(object sender, MouseEventArgs e)
{
m_resizableRectNodeSelected = GetNodeSelectable(e.Location);
StartXY = e.Location;
m_isMouseDown = true;
}
private void panel1_MouseMove(object sender, MouseEventArgs e)
{
this.Cursor = GetResizableRectCursorType(GetNodeSelectable(e.Location));
if (rect.Contains(new Point(e.X, e.Y)))
{
this.Cursor = Cursors.SizeAll;
}
else
{
switch (m_resizableRectNodeSelected)
{
case ResizableRect.LeftUp:
rect.X += e.X - EndXY.X;
rect.Width -= e.X - EndXY.X;
rect.Y += e.Y - EndXY.Y;
rect.Height -= e.Y - EndXY.Y;
break;
case ResizableRect.LeftMiddle:
rect.X += e.X - EndXY.X;
rect.Width -= e.X - EndXY.X;
break;
case ResizableRect.LeftBottom:
rect.Width -= e.X - EndXY.X;
rect.X += e.X - EndXY.X;
rect.Height += e.Y - EndXY.Y;
break;
case ResizableRect.BottomMiddle:
rect.Height += e.Y - EndXY.Y;
break;
case ResizableRect.RightUp:
rect.Width += e.X - EndXY.X;
rect.Y += e.Y - EndXY.Y;
rect.Height -= e.Y - EndXY.Y;
break;
case ResizableRect.RightBottom:
rect.Width += e.X - EndXY.X;
rect.Height += e.Y - EndXY.Y;
break;
case ResizableRect.RightMiddle:
rect.Width += e.X - EndXY.X;
break;
case ResizableRect.UpMiddle:
rect.Y += e.Y - EndXY.Y;
rect.Height -= e.Y - EndXY.Y;
break;
default:
if (m_isMouseDown)
{
rect.X = rect.X + e.X - EndXY.X;
rect.Y = rect.Y + e.Y - EndXY.Y;
}
break;
}
}
if (m_isMouseDown)
{
EndXY = e.Location;
panel1.Invalidate();
}
}
private void panel1_MouseUp(object sender, MouseEventArgs e)
{
EndXY = e.Location;
m_isMouseDown = false;
m_movingRect = false;
Invalidate();
}
private Rectangle DrawResizableRectNode(int x, int y)
{
return new Rectangle(x - m_resizableRectSize / 2, y - m_resizableRectSize / 2, m_resizableRectSize, m_resizableRectSize);
}
private ResizableRect GetNodeSelectable(Point p)
{
foreach (ResizableRect r in Enum.GetValues(typeof(ResizableRect)))
{
if (GetResizableRectNode(r).Contains(p))
{
Console.WriteLine("GetNodeSelectable: " + r.ToString());
return r;
}
}
return ResizableRect.None;
}
private Rectangle GetResizableRectNode(ResizableRect p)
{
switch (p)
{
case ResizableRect.LeftUp:
return DrawResizableRectNode(rect.X, rect.Y);
case ResizableRect.LeftMiddle:
return DrawResizableRectNode(rect.X, rect.Y + rect.Height / 2);
case ResizableRect.LeftBottom:
return DrawResizableRectNode(rect.X, rect.Y + rect.Height);
case ResizableRect.BottomMiddle:
return DrawResizableRectNode(rect.X + rect.Width / 2, rect.Y + rect.Height);
case ResizableRect.RightUp:
return DrawResizableRectNode(rect.X + rect.Width, rect.Y);
case ResizableRect.RightBottom:
return DrawResizableRectNode(rect.X + rect.Width, rect.Y + rect.Height);
case ResizableRect.RightMiddle:
return DrawResizableRectNode(rect.X + rect.Width, rect.Y + rect.Height / 2);
case ResizableRect.UpMiddle:
return DrawResizableRectNode(rect.X + rect.Width / 2, rect.Y);
default:
return new Rectangle();
}
}
private Cursor GetResizableRectCursorType(ResizableRect resizableRectPoint)
{
Cursor rectPositionCursor;
switch (resizableRectPoint)
{
case ResizableRect.LeftUp:
rectPositionCursor = Cursors.SizeNWSE;
break;
case ResizableRect.LeftMiddle:
rectPositionCursor = Cursors.SizeWE;
break;
case ResizableRect.LeftBottom:
rectPositionCursor = Cursors.SizeNESW;
break;
case ResizableRect.BottomMiddle:
rectPositionCursor = Cursors.SizeNS;
break;
case ResizableRect.RightUp:
rectPositionCursor = Cursors.SizeNESW;
break;
case ResizableRect.RightBottom:
rectPositionCursor = Cursors.SizeNWSE;
break;
case ResizableRect.RightMiddle:
rectPositionCursor = Cursors.SizeWE;
break;
case ResizableRect.UpMiddle:
rectPositionCursor = Cursors.SizeNS;
break;
default:
rectPositionCursor = Cursors.Default;
break;
}
Console.WriteLine("GetResizableRectCursorType: " + rectPositionCursor.ToString());
return rectPositionCursor;
}
}
|
|
|
|
|
Hi,
unfortunately your code already contains a lot of details, making it hard to pinpoint what exactly is the problem. IMHO one should always work on smaller pieces and get them to run satisfactorily before adding to them.
So I will limit my reply to a number of comments, which taken together really indicate I'm not so happy with the current code:
1.
It seems you want a hovering mouse to show what would happen if the mouse were clicked in its current position; that should consist of:
- deciding which if any rectangle is hovered over;
- deciding how it is hit (i.e. in the size handles or in the body).
As size handles overlap the actual rectangle, one must be careful in what order the Contains() logic is applied. I would probably use a slightly larger rectangle and check that first, assuming a move is intended, and on a hit then check whether any of the size handles is hit (which would overrule the move).
2.
Once the mouse goes down, the decision (from #1) should be frozen, and data should be set up to initiate the actual move/resize.
3.
Back in the mouse move handler, the actual action should happen until mouse up is reached.
4.
As a consequence:
- the MouseMove handler should have two completely distinct halves, one for the decision process (mouse still up), one for the execution (mouse down); a single bool (set/cleared by MouseDown/MouseUp) would decide between the halves.
- the MouseDown handler shouldn't do much at all.
5.
If I were creating something like this, I would start from scratch, and initially keep it as simple as possible.
I would also choose variable and method names carefully, e.g. DrawResizableRectNode isn't OK as it does not draw at all.
Added later, two smaller issues I forgot to mention:
6.
There is no need to create a Graphics object explicitly; you get it for free as one of the properties of the PaintEventArgs in a Paint handler.
7.
You should keep Paint handlers as lean as possible, in particular you should create the drawing objects (Pens, Fonts, ...) you need only once, and save them in class level variables for reuse. In your case, that applies to rectPen.
And if you fail to keep them around, it is your duty to dispose of them (by calling their Dispose method or applying a using statement), in order to avoid Windows problems such as handle shortages.
Hope this helps,
modified 27-Apr-20 20:15pm.
|
|
|
|
|
Hi,
Your notes are helpful to help where to look in my code, but still I can't get it work
I started from scratch and made the first step is just to move the rectangle, my issue now is to calculate the new starting XY, but it seems resize the rectangle when mouseUp:
<pre>private void pictureBox1_MouseMove(object sender, MouseEventArgs e)
{
if (rect.Contains(e.Location))
this.Cursor = Cursors.SizeAll;
else
this.Cursor = Cursors.Default;
if (m_mouseDown && rect.Contains(e.Location))
{
if (e.X > StartXY.X)
{
EndXY.X += e.X - StartXY.X;
EndXY.Y += e.Y - StartXY.Y;
}
else
{
EndXY.X += Math.Abs(e.X - StartXY.X);
EndXY.Y += Math.Abs(e.Y - StartXY.Y);
}
StartXY = e.Location;
Console.WriteLine("pictureBox1_MouseMove");
}
if (m_mouseDown && !rect.Contains(e.Location))
{
EndXY = e.Location;
}
Invalidate();
}
Complete code:
public partial class Form1 : Form
{
Rectangle rect;
Point StartXY;
Point EndXY;
int x = 0;
int y = 0;
int height = 0;
int width = 0;
bool m_mouseDown = false;
bool m_movingRect = false;
Pen rectPen = new Pen(Color.Red, 1);
public Form1()
{
InitializeComponent();
this.DoubleBuffered = true;
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void pictureBox1_Paint(object sender, PaintEventArgs e)
{
Graphics gObj = e.Graphics;
x = Math.Min(StartXY.X, EndXY.X);
y = Math.Min(StartXY.Y, EndXY.Y);
height = Math.Abs(StartXY.X - EndXY.X);
width = Math.Abs(StartXY.Y - EndXY.Y);
rect = new Rectangle(x, y, height, width);
rectPen.DashStyle = DashStyle.Dash;
gObj.DrawRectangle(rectPen, rect);
}
private void pictureBox1_MouseDown(object sender, MouseEventArgs e)
{
m_mouseDown = true;
if (rect.Contains(e.Location))
{
m_movingRect = true;
Console.WriteLine("m_mouseDown");
}
else
{
StartXY = e.Location;
}
}
private void pictureBox1_MouseMove(object sender, MouseEventArgs e)
{
if (rect.Contains(e.Location))
this.Cursor = Cursors.SizeAll;
else
this.Cursor = Cursors.Default;
if (m_mouseDown && rect.Contains(e.Location))
{
if (e.X > StartXY.X)
{
EndXY.X += e.X - StartXY.X;
EndXY.Y += e.Y - StartXY.Y;
}
else
{
EndXY.X += Math.Abs(e.X - StartXY.X);
EndXY.Y += Math.Abs(e.Y - StartXY.Y);
}
StartXY = e.Location;
Console.WriteLine("pictureBox1_MouseMove");
}
if (m_mouseDown && !rect.Contains(e.Location))
{
EndXY = e.Location;
}
Invalidate();
}
private void pictureBox1_MouseUp(object sender, MouseEventArgs e)
{
if (!m_movingRect)
{
EndXY = e.Location;
}
m_mouseDown = false;
m_movingRect = false;
Invalidate();
}
}
|
|
|
|
|