如何撤消变量值并粘贴模板字符串 [英] How can I do withdraw variable value and paste in template string

问题描述

Hi!  All my friends!
Please help me, it’s my first project  for airport (student practice).  I’m learning coding C# My Data base connected  to  forms DataGridView and I see any changes real time (used SqlDependency).

Next step, how can I do for example when changes one column in Database (flight condition)  withdraw "flight_number, destination_airport" and paste this information (variable value) in template string "Dear passenger ''flight_number'' to ''destination_airport'' was canceled. (passenger display notifications). 
How can I do for C#, please give an example code. sorry my English, i hope you understand me. Thank you!

我尝试了什么：

What I have tried:

//Load Data
       void LoadData()
       {
           DataTable dt = new DataTable();
           if (con.State == ConnectionState.Closed)
           {
               con.Open();
           }
           SqlCommand cmd = new SqlCommand("SELECT flight_number, destination_airport, flight_status, checkin_place, gate FROM DFP", con);
           cmd.Notification = null;

           SqlDependency de = new SqlDependency(cmd);
           de.OnChange += new OnChangeEventHandler(de_OnChange);

           dt.Load(cmd.ExecuteReader(CommandBehavior.CloseConnection));
           dataGridView1.DataSource = dt;

       }
       public void de_OnChange(object sender, SqlNotificationEventArgs e)
       {
           SqlDependency de = sender as SqlDependency;
           de.OnChange -= de_OnChange;
           if (OnNewHome != null)
           {
               OnNewHome();
           }
       }
   }

推荐答案

string msg = string.Format（ 亲爱的乘客航班号{0}到目的地_机场{1}被取消。（乘客显示通知）。，flight_number，destination_airport）;

string msg = string.Format("Dear passenger flight number {0} to destination_airport {1} was canceled. (passenger display notifications).",flight_number,destination_airport);

HI！请写详细的代码，如何在我的代码中插入？

HI! Please write detailed code, how to insert in my code?

这篇关于如何撤消变量值并粘贴模板字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！