|
Hi All,
Having some trouble selecting data out of a DataTable. Basically I have a column that contains names. Some names are prefixed with an asterisk (*) and some are not. I can't seem to come up with a query to be able to select either the prefixed names or the non-prefixed names. In SQL my queries look like this:
--without the prefix
select * from MyTable where Name not like '*%';
-- with the prefix
select * from MyTable where Name like '*%' ;
How can I achive this using the query syntax a DataTable accepts ? The asterisk (*) is a wildcard in the DataTable's query syntax language so MSDN suggests to escape it with a pair of brackets ([]) but I still can't get it to work. If someone could translate the above two SQL statements into the query syntax the DataTable's Select() method understands it would be much appreciated. Thanks in advance...
|
|
|
|
|
Select * from MyTable where substring(Name,0,1) = '[*]'
Select * from MyTable where substring(Name,0,1) <> '[*]'
Just an untested guess...might not need {} in this case, since not a LIKE statement
Anger is the most impotent of passions. It effects nothing it goes about, and hurts the one who is possessed by it more than the one against whom it is directed.
Carl Sandburg
|
|
|
|
|
Thanks Robert this seemed to have done the trick for me
-Peter
P.S.: Love you sig...
|
|
|
|
|
I am using "CreateProcessWithLogonW" in my code. it works fine it runs the application as intended, up to the point that returns a process in code.
My problem is: Since I am impersonating another user, Access to the process is denied. I need to add the "Exited" event to this process, but I keep getting the "Access denied" message.
Thank you for any help I can get.
|
|
|
|
|
Keep in mind you have to turn on Process.EnableRaisingEvents before receiving any events. That said, I'm not sure if you'll actually receive an Exited event since the process never launched successfully.
*edit* whoops, forgot you were using P/Invoke. Can you put a try/catch statement around your call to logon with credentials? That would tell you if it wasn't launched successfully AFAIK. You won't be able to hook into any events since this isn't a .NET Process object; you could however check for the existence of the process on some interval, then raise your own event when discovered the process is not running.
Tech, life, family, faith: Give me a visit.
Judah Himango
|
|
|
|
|
Thank you for your reply.
My process runs fine. I get and id back and I use the getprocess method to get the process. but when it hit the code Process.EnableRaisingEvents or any Process.(something) it gives me an Access denied message. But if i impersonate myself, it works fine.
this is the code:
bool ret = true;
ret = CreateProcessWithLogonW(m_username, m_domain, m_password, (int)LogonFlags.WithProfile,null,m_sb, (uint)PriorityFlags.NormalPriority | (uint)CreationFlags.UnicodeEnvironment, IntPtr.Zero,"c:\\", ref m_sui, out m_pi);
if(ret)
{
System.Diagnostics.Process p = System.Diagnostics.Process.GetProcessById(m_pi.dwProcessId);
p.EnableRaisingEvents = true; "FAILS IN THIS LINE"
}
|
|
|
|
|
I used http://www.codeproject.com/cs/media/perpxalpha_sharp.asp to create a non-rectangular window.
Then I tried to add a Label Form, but that didn't work (didn't show up). Therefore I thought that this maybe wouldn't be possible when you have a this type of window and tried directly to draw strings in my loaded bitmap:
<br />
Graphics g = Graphics.FromImage(newBitmap);<br />
newBitmap.Dispose();<br />
Font font = this.Font;<br />
Brush brush = new SolidBrush(Color.White);<br />
g.DrawString("Hallo wie geht es dir?",font,brush, 50,50);<br />
g.DrawImage(newBitmap,0,0);<br />
bitmap = newBitmap;<br />
newBitmap contains the loaded png (with alpha mask) image.
The assignment of bitmap seems to crash (System.ArgumentException) because I disposed newBitmap. But why? I however assigned newBitmap again with g.DrawImage...
|
|
|
|
|
Draw image does not assign a bitmap, I'm suprised it isn't crashing on you at g.DrawImage line.
Don't dispose the newBitmap until you're really done with it; or dispose it, then assign it again with
newBitmap = new Bitmap() .
Tech, life, family, faith: Give me a visit.
Judah Himango
|
|
|
|
|
|
Hi this is my code -
<br />
printDialog1.Document = new TextPrintDocument();<br />
printDialog1.ShowNetwork = true;<br />
printDialog1.ShowDialog();<br />
but it only show my default printer in the dropdown?? (all the printers installed on my machine are network printers including the default one). I need to display all available printers so that the user can make a selection of where to print. Any ideas or help will be greatly appreciated. Thanks
|
|
|
|
|
i need to create a new treenode object, with 2 or 3 images before the text; i'm not sure about the way to take:
1) create a control that inherits from treenode and draw it;
2) create a control that inherits from treeview and change its draw (this way is more complex and the time, as always, is poor)
3) any other idea ?
thanks for your suggestions
luke
|
|
|
|
|
Hello friends,
I would like use CurrentCellChanged event for navigating the next cell of a datagrid?Can anyone help?
Code like this:
private void dgRegion_CurrentCellChanged(object sender, System.EventArgs e)
{
dgRegion.Select(dgRegion.CurrentCell.RowNumber);
//how can I navigate the next cell...Suppose that I am at the last column
//then how can I pass the next line and first column.
}
|
|
|
|
|
first u have to change the selected row
u can do this by accessing the SelectedRowIndex.
Mr.Cooper
|
|
|
|
|
Please friend...I HAVE PASSED THREE HOURS HERE...I TRIED EVERYTHING...PLEASE HELP..HOW?
|
|
|
|
|
Hi
have a look at my project here
www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp
I think and hope it will help you
Huseyin Altindag
|
|
|
|
|
I'm looking for information on programming against a socket secured with SSH. Could someone point me to a good site or book on how to do this? Thank you,
Jason W.
|
|
|
|
|
I have a PowerPoint file that I want to generate thumbnails from. How would I go about doing this? I think it would be best if I had it in some sort of generic image format (as it is going to be displayed on the web) however I dont know whats best. Any help would be appreciated.
Jim
|
|
|
|
|
Hi
I'm new to C# and try to send and receive UDP packets to a Counter-Strike server.
Sending packets works fine. Examining the network traffic show that I also get back a response packet from the server. But my client waiting for any UDP packets never receives any packets!
What am I doing wrong?
using System;
using System.Net;
using System.Net.Sockets;
using System.Text;
class UDPClient
{
static void Main(string[] args)
{
UdpClient recv = new UdpClient();
IPEndPoint rep = new IPEndPoint(IPAddress.Parse("217.160.132.82"), 27015);
while(true)
{
try{
Byte[] bytes = recv.Receive(ref rep);
string packet = Encoding.ASCII.GetString(bytes);
Console.WriteLine(bytes.Length + " Bytes received.");
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
}
}
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
There's a good chance that either your hardware firewall (i.e. a router) or your software firewall (i.e. ZoneAlarm or Windows XP Firewall) is blocking that port. Make sure the port you need to receive the packets on is opened for traffic. Otherwise you could disable your firewalls, if possible, or put your machine on the DMZ if you can't disable all firewalls.
Tech, life, family, faith: Give me a visit.
Judah Himango
|
|
|
|
|
There's no firewall involved. I get the response packet (examined in a packet sniffer), but UdpClient.Receive() just hangs and does nothing.
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Ok i switched to the plain "Socket" class instead of the "UdpClient" and now everything works fine. Strange...
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Hi!
I cant find a easy solution to retrive the status from a faxmess that are send to the fax (modem/fax)
I have the Job ID and are trying with this find out if the Job is finished, if there were som errors like the number didnt exist or the line was busy?
i use the FAXCOMEXLib.FaxJobStatusClass status
and just have diffucult to set status to the ID that i want?
Happy for any help!
/Johan
|
|
|
|
|
I need Information about huffman algorithm , how can I make it faster.
Thanks for your time.
|
|
|
|
|
Which algorithm are you using at present? One thing you should consider (if possible) is increasing the number of potential children any one branch could have.
Obviously having too many is pointless (as it defeats the purpose of using the algorithm) and too few can cause unecessary traversals. Placement of leaf nodes can improve performance as well. You could decide that by logic, algorithm, organically (i.e on the fly depending on the needs as they change}, or just through a test battery (which is likely easiest).
Hope this helps, mail me if you need more info.
Jim
|
|
|
|
|
I would add to the normal context menu (copy/cut/delete/cancel) of Windows (that appear when the user right-click inside a textbox) a new voice during my software' installation.
That if clicked call my software passing a "pointer" to that textmenu, so i can set its text with what i want.
How can i do?
Please answer me becouse it is important.
|
|
|
|