Alert when date matches with system date(C# windows form app

Mohammed Khadir

Dear Friends,

i am working with C# windows form application (with sql), where i need to save the future appointments. Here is the structure, i am saving appoint with AppID, AppName, AppDate, AppAlertDate for date i am using datetime picker.

for example

AppID= 1

AppName=Interview

AppDate=10/06/2017

AppAlertDate=08/06/2017

AppID=2

AppName=Interview

AppDate=11/06/2017

AppAlertDate=09/06/2017

Now what i want is i need to show a alert when my application starts for the first time on the AlertDate Matches with the system date.

can you please help me.

Thanks

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Kumar9y ago
Accepted answer
Hi,

Please use below line of code instead of earlier.
string alertDate = "#" + System.DateTime.Now.ToString("MM/dd/yyyy") + "#";
+1
Vivek Kumar9y ago
Always welcome Mohammed Khadir.
0
Mohammed Khadir9y ago
Thanks
Vivek Kumar
and
Khaja Moizuddin for giving suggestion in getting my required solution.

thank you very much
0
Mohammed Khadir9y ago
Hi Vivek Kumar Sir,
exactly i am using datagridview to display the data which matches the current date.
I tried below code as per your suggestion, but i am getting below error, in sql database i have used date datatype to AlertDate.
cannot perform '=' operation on system.datetime and system.int32
in the line
DataRow[] alertresult = dts.Select("AlertDate =" + alertDate);

below is the code i used

public void Display()
{
con.Open();
commd = new SqlCommand(" select PDCID as ID,PayeeName as Payee_Name, BankName as Bank_Name,InvoiceNo as Invoice_No,Description,PDCDate as PDC_Date, AlertDate, ChequeStatus as Cheque_Status, Date, Image from PDC", con);
SqlDataAdapter das = new SqlDataAdapter(commd);
das.Fill(ds);
int i = ds.Tables[0].Rows.Count;
if (i > 0)
{
DataTable dts = new DataTable();
das.Fill(dts);
string alertDate = System.DateTime.Now.ToString("MM/dd/yyy");
DataRow[] alertresult = dts.Select("AlertDate =" + alertDate);
foreach (DataRow row in alertresult)
{
try
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select PDCID as ID,PayeeName as Payee_Name, BankName as Bank_Name,InvoiceNo as Invoice_No,Description,PDCDate as PDC_Date, AlertDate, ChequeStatus as Cheque_Status, Date, Image from PDC";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter dta = new SqlDataAdapter(cmd);
dta.Fill(dt);
dataGridView1.DataSource = dt;
}
catch (Exception et)
{
MessageBox.Show(et.Message);
}
}
}
else
{
ds.Clear();
}
con.Close();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.RowTemplate.Height = 120;
dataGridView1.AllowUserToAddRows = false;
DataGridViewImageColumn imagecol = new DataGridViewImageColumn();
imagecol = (DataGridViewImageColumn)dataGridView1.Columns[10];
imagecol.ImageLayout = DataGridViewImageCellLayout.Stretch;
}
0
Vivek Kumar9y ago
I think that you are using gridview to show all records with the help of datatable then simply you can use below code for showing the alert box for today's date.
string alertDate = System.DateTime.Now.ToString("MM/dd/yyyy");
DataRow[] alertresult = dt.Select("AlertDate = " + alertDate);
foreach (DataRow row in alertresult)
{
//Here you will get each row record. So you can show alert box as per your requirement
//MessageBox.Show(row[0]);
}
0
Mohammed Khadir9y ago
Hi Sir,
i tried this please let me know where & how i should compare alertdate with system so that i can get all the data which matches the date or greater than date,
below is the code used in page load

con.Open();

commd = new SqlCommand(" select PDCID as ID,PayeeName as Payee_Name, BankName as Bank_Name,InvoiceNo as Invoice_No,Description,PDCDate as PDC_Date, AlertDate as Alert_Date, ChequeStatus as Cheque_Status, Date, Image from PDC", con);
SqlDataAdapter das = new SqlDataAdapter(commd);
das.Fill(ds);
int i = ds.Tables[0].Rows.Count;
if (i > 0)
{

try
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select PDCID as ID,PayeeName as Payee_Name, BankName as Bank_Name,InvoiceNo as Invoice_No,Description,PDCDate as PDC_Date, AlertDate as Alert_Date, ChequeStatus as Cheque_Status, Date, Image from PDC";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter dta = new SqlDataAdapter(cmd);
dta.Fill(dt);
dataGridView1.DataSource = dt;
}
catch (Exception et)
{
MessageBox.Show(et.Message);
}
}
else
{
ds.Clear();
}
con.Close();

please help
thanks
0
Khaja Moizuddin9y ago
Public void Page_Load() { if(AppAlertDate== DateTime.Today || AppAlertdate==Datetime.Now) { // Alert Message based on your requirement. } }
0
Vivek Kumar9y ago
When your application is excuting first time, you can excute the query with given the date value is today and check the date in DB which is matching with the current date or not. If it is matching then show the alert box to the user with the specific message.
0

Alert when date matches with system date(C# windows form app

Vivek Kumar

Khaja Moizuddin for giving suggestion in getting my required solution.