|
Pls help me to correct this query?
SELECT Day.Name,iff(Morning,'Yes','No')+','+iff(Afternoon,'Yes','No')+','+ iff(Evening,'Yes','No') as Session3 FROM Session INNER JOIN Day ON Session.SessionID= Day.SessionID
|
|
|
|
|
sajin85 wrote: Pls help me to correct this query?
What is wrong with it? What is it supposed to do? What database system is it for? Why is this not in the SQL forum? What does this have to do with C#?
|
|
|
|
|
Colin Angus Mackay wrote: What is wrong with it? What is it supposed to do? What database system is it for? Why is this not in the SQL forum? What does this have to do with C#?
You don't know? You are supposed to be the expert oracle here! 
[ My Blog] "Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn "Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
|
dnh wrote: You don't know? You are supposed to be the expert oracle here!
Don't insult him. He's the Sql Server around here.;P
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
Hi
I would like to know how to clear a datagridview of its previous data and to populate with data from a stored procedure.
Regardz
Shanzay
|
|
|
|
|
hi all,
i am trying to create a smtp for sending mail via gmail but i am getting error as remote host name unresolved. can any one help me out and tell wats the problem.its urgent. Below is the code :-
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace SendingMail
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
//Create Mail Message Object with content that you want to send with mail.
System.Net.Mail.MailMessage MyMailMessage = new System.Net.Mail.MailMessage("frommailid@gmail.com", "tomailid@gmail.com",
"This is the mail subject", "Just wanted to say Hello");
MyMailMessage.IsBodyHtml = false;
//Proper Authentication Details need to be passed when sending email from gmail
System.Net.NetworkCredential mailAuthentication = new
System.Net.NetworkCredential("frommailid@gmail.com", "password");
//Smtp Mail server of Gmail is "smpt.gmail.com" and it uses port no. 587
//For different server like yahoo this details changes and you can
//get it from respective server.
System.Net.Mail.SmtpClient mailClient = new System.Net.Mail.SmtpClient("smtp.gmail.com", 465);
//Enable SSL
mailClient.EnableSsl = true;
mailClient.UseDefaultCredentials = false;
mailClient.Credentials = mailAuthentication;
try
{
MessageBox.Show(mailClient.Host.ToString());
mailClient.Send(MyMailMessage);
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
}
}
|
|
|
|
|
Help!
I'm trying to retrieve data from database and put it on richtextbox control.
my problem is : the richtextbox control doesn't read the "\r" and "\n" character (13 and 10 in ASCII, return carriage and line feed). so the data was not displayed on different line but go through one line.
any information on it?
thankz a lot
regards
~erwin~
|
|
|
|
|
more information,
I try to display it in RTF Format.
I think RTF Format doesn't accept "\r" and "\n".
Am I correct?
anyway to make RTF Format could read "\r" and "\n" character?
CMIIW
Mail me at erwin@holyknight.us
|
|
|
|
|
...In fact, a carriage return line feed is never expected to be found in an RTF file...
Just found that in RTF Specification for Word2007.
I just replace the "\r" "\n" with "\line" in RTF and it worked for now..
CMIIW
Mail me at erwin@holyknight.us
|
|
|
|
|
5 voted for finding the solution yourself, and then remembering to post it for others to see.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi all,
What can I use within C# to replace the function:
LRESULT SendMessage(
HWND hWnd,
UINT Msg,
WPARAM wParam,
LPARAM lParam
);
Many Thanks in advance
Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's ![Green Alien | [Alien]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/alien.gif)
 Programm3r
My Blog: ^_^
|
|
|
|
|
OK, so I'm using PInvoke - doing the following:
[DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = false)]
static extern IntPtr SendMessage(HandleRef hWnd, uint Msg, IntPtr wParam, IntPtr lParam);
But I'm receiving the following error:
Error 2 The modifier 'extern' is not valid for this item
Error 3 Expected class, delegate, enum, interface, or struct
Why ??? 
The only programmers that are better that C programmers are those who code in 1's and 0's
Programm3r
My Blog: ^_^
|
|
|
|
|
where did you find "HandleRef"? that's why the compiler expected class, delegate, enum, interface, etc I think..
try the code below.. I have no idea how to use it because it only return the message ID which I don't know how to process..
<br />
[DllImport("user32.dll", CharSet = CharSet.Auto)]<br />
private static extern IntPtr SendMessage(IntPtr hWnd, int wMsg, IntPtr wParam, IntPtr lParam);<br />
CMIIW
Mail me at erwin@holyknight.us
|
|
|
|
|
Where do I place it. At the moment I placed it here (is this correct?
...
using System.IO;
[DllImport("user32.dll", CharSet = CharSet.Auto)]
private static extern IntPtr SendMessage(IntPtr hWnd, int wMsg, IntPtr wParam, IntPtr lParam);
namespace WindowsService
{
...
Many thanks for the reply
Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's
Programm3r
My Blog: ^_^
|
|
|
|
|
Hi,
Programm3r wrote: [DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = false)]static extern IntPtr SendMessage(HandleRef hWnd, uint Msg, IntPtr wParam, IntPtr lParam);
you have to put these lines inside a class, any class would do (I use LP_user32 for all
user32.dll functions).
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Yep,
put it inside a class..
search in microsoft documentation for more info about windows messaging, the message type, and other info..
CMIIW
Mail me at erwin@holyknight.us
|
|
|
|
|
Ok, I'm trying this ....
class WindowsService : ServiceBase
{
[DllImport("user32.dll", CharSet = CharSet.Auto)]
private static extern IntPtr SendMessage(IntPtr hWnd, int wMsg, IntPtr wParam, IntPtr lParam);
But I receive this:
Error 1 The type or namespace name 'DllImport' could not be found (are you missing a using directive or an assembly reference?)
The only programmers that are better that C programmers are those who code in 1's and 0's
Programm3r
My Blog: ^_^
|
|
|
|
|
using System.Runtime.InteropServices;
All the best,
Martin
|
|
|
|
|
|
Visual Studio is kind enough to include the probable fix in the error message.
MSDN will tell you which namespace DllImport belongs to.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Add this line to your using directives list:
using System.Runtime.InteropServices;
|
|
|
|
|
|
Is it possible to show a MessageBox from a Service developed in C# ?
Many Thanks
Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's
Programm3r
My Blog: ^_^
|
|
|
|
|
When you say "Service" do you mean that your C# program is running as a Windows Service? That's my assumption here, and yes it's possible. Whether or not it's advisable is another matter.
Now when I say "possible" I mean that the code will compile and build, and the .exe can be installed as a Windows Service and run. Often times one of the main reasons to develop a solution to run as a Windows Service is so that it can run even when no user is logged in to the computer. Now if that's the case, and the code finds it way down the path to where the MessageBox is .Show()'n, I don't know what will happen. Maybe nothing. Maybe it's displayed and causes the Service to stop executing until the nonexistent user clicks the unseen "OK" button.
Of course you could try it and see what happens. If you do, post your results here so everyone can know, too. Then try to find out if a tree falls in the forest.... 
BDF
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
