C#

surasaku wrote:

Hi Guffa,

Thanks for reply my message. I use Access database.Could you please see my code below? After debugging,the error message is "Syntax error in INSERT INTO Statement". Where is it wrong?

[Code]
string sql2;
string ContentUpdate = textBox2.Text;
DataView dv4 = new DataView(Dset.Tables["myData"]);
dv4.RowFilter = "Date =#"+dateselect+"#";
if (dv4.Count!=0)
sql2 = "UPDATE Content SET Content = '"+ContentUpdate+"' " +
"WHERE Date = #"+dateselect+"#";
else
sql2 = "INSERT INTO Content(Date) VALUES(#2006-05-30#)";
OleDbCommand cmd = new OleDbCommand();
OleDbTransaction trans;
try
{
conn.Open();
trans = conn.BeginTransaction();
cmd.Connection = conn;
cmd.CommandText = sql2;
cmd.Transaction = trans;
cmd.ExecuteNonQuery();
if(MessageBox.Show("Are you sure to Save data?","Data
Saving",MessageBoxButtons.OKCancel) == DialogResult.OK)
trans.Commit();
else
trans.Rollback();

}
catch(Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}

using System.Web.Mail;<br />
<br />
protected Boolean SendEmail(string strFromEmail, string strToEmail, string strSubject, string strBody)<br />
{<br />
Boolean bStat = false;<br />
try<br />
{<br />
MailMessage Message = new MailMessage();<br />
Message.To = strToEmail;<br />
Message.From = strFromEmail;<br />
Message.Subject = strSubject;<br />
Message.Body = strBody;<br />
<br />
// enter your smtp server here<br />
// if login is required you may need extra params<br />
// see the doc for the SmtpMail object<br />
SmtpMail.SmtpServer = "your.smtpserver.com";<br />
SmtpMail.Send(Message);							<br />
bStat = true;<br />
}<br />
catch (Exception)<br />
{<br />
bStat = false;<br />
}<br />
return (bStat);<br />
}

<br />
byte[] image_bytes = null;<br />
using (MemoryStream ms = new MemoryStream())<br />
{<br />
  image.Save(ms, ImageFormat);<br />
  image_bytes = ms.ToArray();<br />
} <br />

The Quran's Rational Arguments (Audio)
Background on Prophet Muhammad (in progress)

"They are MUSLIM. It does not matter how you split it up: all msulims (so they say) see every other muslim as a brother, regardless of origin or nationality." -legalAlien. Alhamdullah for the blessing of Islam

public void Foo()
{
  lock (this) {
    // rest of method
    ...;
  }
}

Califgal wrote:

And I am trying to access public method of 'TestClass' from Form1.cs file, but if I write

TestClass.

the intellisense doesn't show the methods I have created inside TestClass.

TestClass x = new TestClass()
x.