|
Try:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM myTable WHERE MyDateColumn BETWEEN @ST AND @END", con))
{
cmd.Parameters.AddWithValue("@ST", dtpStart.Value);
cmd.Parameters.AddWithValue("@EN", dtpEnd.Value);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int id = (int) reader["iD"];
string desc = (string) reader["description"];
Console.WriteLine("ID: {0}\n {1}", iD, desc);
}
}
}
}
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
griff. You should know better than to mix UI elements with database code  !
|
|
|
|
|
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
yo.....
Curious.... Is C#f based Winforms better than MFC for GUI?
Which is faster to develop in?
|
|
|
|
|
Whichever you know better.
I mostly do console apps, but WinForms when I must.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
shiftwik wrote: Is C#f based Winforms better than MFC for GUI?
They're different, like a spoon, a knife and a fork. Which of those three is better?
shiftwik wrote: Which is faster to develop in?
The one that you're familiar with.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
As the other have said, "It depends"
What it primarily depends on is if you know C# or C++.
If you don't know C++, then MFC development will be a real PITA in C#...
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
hey,
please help me i m attesting the code below... it is showing an error failure sending mail
it is working on local server but showing error online
plz help
SmtpClient client = new SmtpClient();
client.Port = 587;
client.Host = "smtp.gmail.com";
client.EnableSsl = true;
MailMessage mail = new MailMessage(new MailAddress("smanghnani23@gmail.com"), new MailAddress(TextBox2.Text));
MailMessage mail1 = new MailMessage(new MailAddress("smanghnani23@gmail.com"), new MailAddress("smanghnani23@gmail.com"));
mail.Subject = "Thank You For Submitting Your Request";
mail1.Subject = "A New HIRING Request is Generated";
mail1.Body = TextBox3.Text;
mail.Body = "Thank you for registering with us";
System.Net.NetworkCredential cred = new System.Net.NetworkCredential();
cred.UserName = "smanghnani23@gmail.com";
cred.Password = "password";
client.Credentials = cred;
client.Send(mail);
client.Send(mail1);
Label3.Visible = true;
Label3.Text = "Send Succesfully";
|
|
|
|
|
And what error is it showing?
|
|
|
|
|
it is working properly when i m running in localhost but when i try with my website it is showing "Failure Sending Mail".
|
|
|
|
|
you can check my website for more information about error
www.jainglobalconnect.com
thanks
|
|
|
|
|
Hi there !
I have two table (mainTable & SubTable) with these
fileds :
mainTable --> IdMetal , NameMetal , Formula , ...
SubTable --> IDDetails,IdMetal , Company , ...
also
mainTable.IdMetal=SubTable.IdMetal
in myForm , I have some TextBox that filled by MainTable Fields
and Datagrid that filled by subTable Fields
when I want to create New row(Save) in main table , at the same time
i want to fill and save in datagrid ,
here is my code :
try
{
OleDbConnection cnnSave=new OleDbConnection(myConnection);
OleDbCommand cmd__AddRows = new OleDbCommand();
cmd__AddRows.CommandText =
@"INSERT INTO MainRegTable (IDMetal,NameMetal,FormulMetal, GroupMetal, CodeMetal,Comments)
VALUES (@p1,@p2,@p3,@p4,@p5,@p6)";
cmd__AddRows.Parameters.Clear();
cmd__AddRows.Parameters.AddWithValue("@p1", txtID.Text);
....
OleDbDataAdapter dagrd = new OleDbDataAdapter(@"Select * From SubTblMetal
WHERE IDMetal=
"+int.Parse(txtID.Text),
cnnSave);
DataSet dsGrd = new DataSet();
dagrd.Fill(dsGrd, "SubTblMetal");
dsGrd.GetChanges();
dagrd.Update(dsGrd);
dsGrd.AcceptChanges();
but , no changes in subtable ...
thanks for Reply
power is knowledge ...
|
|
|
|
|
Well...you haven't inserted anything into the sub table. So I'm not surprised that it contains no records.
If you want to do this, I would recommend that your either use a transaction round both assignments, or better create a stored procedure to create a transaction, and do both inserts - this has the advantage of keeping it all within the DB.
But you are going to need two inserts whichever way you go.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Yes , but I want that the User have an option to Fill datagrid(subTable) or not , so it can be Blank ...
thanks
|
|
|
|
|
|
|
Thank you. Your very good example
|
|
|
|
|
You're welcome!
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Dear All,
I have an array ctrlpoints as following:
float[,] ctrlpoints = new float [4,3] {{ -4.0f, -4.0f, 0.0f }, { -2.0f, 4.0f, 0.0f },{ 2.0f, -4.0f, 0.0f }, { 4.0f, 4.0f, 0.0f }};
My question is how to write &ctrlpoints[0][0] in C#.
Thanks in advance.
|
|
|
|
|
Something like this should do it:
public static unsafe void Find()
{
float[,] ctrlpoints = new float[4, 3] { { -4.0f, -4.0f, 0.0f }, { -2.0f, 4.0f, 0.0f }, { 2.0f, -4.0f, 0.0f }, { 4.0f, 4.0f, 0.0f } };
fixed (float *address = &ctrlpoints[0, 0])
{
}
}In order for this to work, you must set the option to compile unsafe code.
|
|
|
|
|
To ad a bit to Pete's solution...
Accessing address of any variable is unsafe in the .NET word because the CLR (and the GC) can not check the security and safety of such address, so using it is your responsibility. So if you have no an extremely good reason (bad in fact) do not use it, do not copy such code from C/C++ 'as is' but look for the C# (.NET) way to do the very same thing...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
|
suppose, I've program includes 2 frmLogIn and frmMain, the syntax recall frmLogIn in frmMain how ? you see my code below:
in file Program.cs
[CODE]
...
Application.Run(new frmLogIn());
[/CODE]
in file frmLogIn.cs
[CODE]
...
private void CmdLogIn_Click(object sender, EventArgs e)
{
...
this.Hide(); // of frmLogIn
this.DialogResult = DialogResult.OK; // of frmLogIn
frmMain _frmMain = new frmMain();
_frmMain.Activate();
_frmMain.Show();
}
[/CODE]
in file frmMain.cs
[CODE]
/* // Don't called frmLogIn in this way
// If called frmLogIn in this way will be 2 frmLogIn in memory
frmLogIn _frmLogIn = new frmLogIn();
_frmLogIn.Activate();
_frmLogIn.Show();
*/
// I want recall frmLogIn in here, the syntax recall frmLogIn how ?
[/CODE]
|
|
|
|
|
Pass the instance of the first form to the second form:
private void CmdLogIn_Click(object sender, EventArgs e)
{
...
frmMain _frmMain = new frmMain();
_frmMain.TheLogInForm = this;
_frmMain.Activate();
_frmMail.Show();
}
public frmLogIn TheLogInForm { get; set; }
...
_frmLogIn = TheLogInForm ?? new frmLogIn();
_frmLogIn.Activate();
_frmLogIn.Show();
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
modified 7-Jul-14 8:01am.
|
|
|
|
|
i'm the following your way, my program will warning:
Error 1 The type or namespace name 'frmLogin' could not be found (are you missing a using directive or an assembly reference?)
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
