Advertisement
Guest User

Untitled

a guest
Jun 15th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ASP 0.85 KB | None | 0 0
  1.  private void btnB_Click(object sender, EventArgs e)
  2.         {
  3.             cboToExternal.Items.Clear();
  4.             sqlInfoFetcher2 = new BackgroundWorker();
  5.             sqlInfoFetcher2.DoWork += new DoWorkEventHandler(sqlInfoFetcher2_DoWork);
  6.             sqlInfoFetcher2.RunWorkerCompleted += new RunWorkerCompletedEventHandler(sqlInfoFetcher2_RunWorkerCompleted);
  7.             sqlInfoFetcher2.RunWorkerAsync();
  8.         }
  9.  
  10.  
  11.  
  12.         void sqlInfoFetcher2_DoWork(object sender, DoWorkEventArgs e)
  13.         {
  14.             string connectionString = "Data Source=CLSUTER;Initial Catalog=Contacts;user id=sa;password=sa; Asynchronous Processing=true";
  15.             string query = "SELECT DISTINCT First_Name + ' ' + Last_Name AS Expr1 FROM         dbo.NAME WHERE     (Last_Name LIKE 'B%')";
  16.             e.Result = FetchDataFromDB(connectionString, query);
  17.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement