|
Giorgi Dalakishvili,
Just wondering, but whys it not recommended to use "select * from" in SQL?
Regards,
Gareth.
|
|
|
|
|
As far as I remember when you use "select * from" sql server has to find out all the columns that are present in the table you are querying. On the other hand, when you list the columns you wish to select sql just selects them, in other words it doesn't need to perform one extra step. So it is better to specify the columns you wish to select rather then use * even if you need all columns from the table
|
|
|
|
|
Giorgi Dalakishvili,
Ahhh, thanks for that. I thought it might of been a security risk of some type. Learn something new everyday and all that!
Regards,
Gareth.
|
|
|
|
|
You are welcome
|
|
|
|
|
|
i was working on a project and want to develope an application using visual studios 2005 that can search through all files on my windows system and get all shared is there any class that can get this done for me
|
|
|
|
|
Hi,
for searching through file system, I think you can use
Microsoft.VisualBasic.FileIO.FileSystem Class by adding reference of
Microsoft.VisualBasic.dll, it will give u very flexible way for handling
files and folders.
Regards,
Amar
|
|
|
|
|
I'm tempted to mark this as Abuse
led mike
|
|
|
|
|
Hi all, quite new to asp.net c# programming, i have a mifare reader PCR310U , i need to develop a website which can retrieve information(like card ID) through website using remote mifare reader in remote computer when surfing the website.
for example, i already published my website, when i'm not at the server computer and at my own house, i have a mifare card reader which is connected to my house's PC and a mifare Card, i wish to register the card ID together with my IC number and save into my system website database. can anyone enlighten me on how to go about doing it?i really have no idea how i can retrieve information through mifare reader through the internet website.
if you can help me pls email me.this system quite urgent for me.
thanks alot
tyrone
tyrone_93@Hotmail.com
|
|
|
|
|
Tyrone Boon wrote: i have a mifare reader PCR310U , i need to develop a website which can retrieve information(like card ID) through website using remote mifare reader in remote computer when surfing the website.
Tyrone Boon wrote: i wish to register the card ID together with my IC number and save into my system website database.
Wow I don't really know what you are trying to do. I could make some wild guesses based on that but:
Tyrone Boon wrote: quite new to asp.net c# programming
What else are you quite new to? If you are new to software development then I suggest you are tackling a far more complex project that is appropriate for a novice software developer.
led mike
|
|
|
|
|
Hi Tyrone,
You'll probably have to write and install something on the client. Javascript, and by extension pretty much anything on the client side, can't poke around on a client computer for information, for obvious security reasons. Research Activex objects; I've never used them, so I can't give you more help than that, but it's where you'll probably want to start.
|
|
|
|
|
SAWestbrook wrote: Hi Tyrone,
You'll probably have to write and install something on the client. Javascript, and by extension pretty much anything on the client side, can't poke around on a client computer for information, for obvious security reasons. Research Activex objects; I've never used them, so I can't give you more help than that, but it's where you'll probably want to start.
using smart cards in web application
Hi, i have problem with the above topic, can you help? i have to develop a website that can read/write in information(example like card ID) from smart card readers and save into database .my smart card reader are gemplus GemPC USB-SL and Promag PCR310U, i'm using C# programming language and asp.net website to do it..i have no idea how to go about doing it...pls email me at tyrone_93@hotmail.com if you have sample codes or if you have knowledge in doing it...thanks you so much......i really have to finish this system fast...hope you can reply asap thanks!!!
i found out that i have to create active x control and use it to obtain what i need...but how to do a active x control file ? i'm considered intermediate for asp.net c# programming
|
|
|
|
|
Ok, hopefully, this will be an easier problem to solve. I have a program that has a NotifyIcon control. When the user completes the MainFrame form, the window minimizes and then hides. I want to be able to double-click the notifyicon to make the window reappear. I also want to be able to right-click the n-icon and have my context menu strip show.
Now this works perfectly well when the window (MainFrame) is minimized, but once the user completes the MF form and the window hides, the n-icon does not respond. Here's my code:
<br />
private void MainFrm_Resize(object sender, EventArgs e)<br />
{<br />
if (this.WindowState == FormWindowState.Minimized)<br />
Hide();<br />
}<br />
...<br />
private void TB_Icon_DoubleClick(object sender, EventArgs e)<br />
{<br />
Show();<br />
WindowState = FormWindowState.Normal;<br />
}<br />
...<br />
private void TB_Icon_MouseUp(object sender, MouseEventArgs e)<br />
{<br />
if (e.Button == MouseButtons.Right)<br />
{<br />
ContMenuStrip.Show();<br />
}<br />
}<br />
...<br />
private void ContMenuStrip_Click(object sender, EventArgs e)<br />
{<br />
Show();<br />
WindowState = FormWindowState.Normal;<br />
}<br />
<br />
<br />
Now, keep in mind that after the user completes the MainFrame form (clicks the "OK" button), a loop is constantly running. Nothing happens when I double-click or right-click on the notifyicon. Thanks for the help.
|
|
|
|
|
The double click event for the notify icon should be MouseDoubleClick.
The TB_Icon_MouseUp method should not be needed - assign ContMenuStrip to TB_Icon's ContextMenuStrip property.
Dave
|
|
|
|
|
I changed it to MouseDoubleClick and the ContMenuStrip is already assigned to the ContextMenuStrip property of TB_Icon. Still, the icon does not respond.
|
|
|
|
|
This is working for me.
(Added button[btnOK], notifyIcon[TB_Icon], contextMenuStrip[ContMenuStrip] and a toolStripMenuItem to ContMenuStrip with TB_Icon's ContextMenuStrip property set to ContMenuStrip)
public partial class MainFrm : Form
{
public MainFrm()
{
InitializeComponent();
btnOK.Click += new EventHandler(btnOK_Click); Resize += new EventHandler(MainFrm_Resize);
TB_Icon.MouseDoubleClick += new MouseEventHandler(TB_Icon_MouseDoubleClick);
ContMenuStrip.Click += new EventHandler(ContMenuStrip_Click);
}
void btnOK_Click(object sender, EventArgs e)
{
WindowState = FormWindowState.Minimized;
}
void MainFrm_Resize(object sender, EventArgs e)
{
if (WindowState == FormWindowState.Minimized)
Hide();
}
void TB_Icon_MouseDoubleClick(object sender, MouseEventArgs e)
{
Show();
WindowState = FormWindowState.Normal;
}
void ContMenuStrip_Click(object sender, EventArgs e)
{
Show();
WindowState = FormWindowState.Normal;
}
}
Dave
|
|
|
|
|
Hi,
why do you hide the main form when it gets minimized? when it gets minimized it
is no longer visible on the desktop. I am afraid hiding it explicitly makes it
not responding on anything anymore until you somehow make it visible again.
if you want to remove it from the task bar, use the Form.ShowInTaskbar Property
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
I have tried the ShowInTaskbar approach, but still, no dice.
I tried to "run to cursor" to the point where the double-click event occurs, but it never goes to it. So, obviously, the icon does not recognize any mouse clicks. Is there a way to ensure that it does?
|
|
|
|
|
danielhasdibs wrote: Now, keep in mind that after the user completes the MainFrame form (clicks the "OK" button), a loop is constantly running
This could be where your problem lies. How are you calling this loop and what's happening in it?
Dave
|
|
|
|
|
This is a reminder program. On the MainFrame form, the user enters a time to be reminded. After the reminder is set (the user clicks OK), the window minimizes and hides. Then the program enters a loop checking the difference in timespan. When the timespan.minutes is less than one, the reminder activates.
I had the thread sleeping between iterations just to keep the memory usage down, but even when I remove the sleep methods, the icon does not respond.
|
|
|
|
|
Please see my last comment explaining what the program does.
|
|
|
|
|
I'm guessing your loop is preventing you main window from processing messages. You could identify this by putting an Application.DoEvents() line into the loop which should resume processing. However, this is bad and should not be seen as a solution only a test to see if it is message processing.
The better approach would be to have your okay button start a timer rather than wait in a loop. You can use a timer control which should be able to do what you require.
|
|
|
|
|
I've tried the timer, but it still doesn't work. Could you give me a sample code that works for you using a timer (or a loop) and a NotifyIcon? Thanks.
|
|
|
|
|
public partial class MainFrm : Form
{
Timer MyReminder = new Timer();
public MainFrm()
{
InitializeComponent();
btnOK.Click += new EventHandler(btnOK_Click);
Resize += new EventHandler(MainFrm_Resize);
TB_Icon.Icon = Icon;
TB_Icon.MouseDoubleClick += new MouseEventHandler(TB_Icon_MouseDoubleClick);
ContMenuStrip.Click += new EventHandler(ContMenuStrip_Click);
MyReminder.Interval = 2000;
MyReminder.Tick += new EventHandler(MyReminder_Tick);
}
void MyReminder_Tick(object sender, EventArgs e)
{
Console.WriteLine("You have been reminded at " + DateTime.Now);
}
void btnOK_Click(object sender, EventArgs e)
{
WindowState = FormWindowState.Minimized;
}
void MainFrm_Resize(object sender, EventArgs e)
{
if (WindowState == FormWindowState.Minimized)
{
Hide();
MyReminder.Start();
}
else
{
MyReminder.Stop();
}
}
void TB_Icon_MouseDoubleClick(object sender, MouseEventArgs e)
{
Show();
WindowState = FormWindowState.Normal;
}
void ContMenuStrip_Click(object sender, EventArgs e)
{
Show();
WindowState = FormWindowState.Normal;
}
}
Dave
|
|
|
|
|
Thank you, thank you!
Solution is above.
Thanks to DaveyM69.
|
|
|
|