C#

shah123 wrote:

OleDbDataAdapter adp=new OleDbDataAdapter(sql,database); adp = new OleDbDataAdapter(sql2,database);

FillComboBox(comboBox, sql)
    {
      DataSet ds = new DataSet(); 
      try 
      { 
        database = new OleDbConnection(connectionString); 
        database.Open();

        OleDbDataAdapter adp = new OleDbDataAdapter(sql, database); 
        adp.Fill(ds, "tableName");         
        
        foreach (DataRow dr in ds.Tables[0].Rows) 
        { 
          comboBox.Items.Add(dr[0].ToString()); 
        }
      }
      catch (Exception x) 
      { 
        MessageBox.Show(x.Message); 
      }
    }

private void Form1_Load(object sender, EventArgs e)
        {
            
            string sql ="SELECT distinct ProductName FROM Products";
            string sql2 = "SELECT DISTINCT Packing.PackingName FROM Packing INNER JOIN Products ON Packing.PackingID=Products.Packing";
            

			DataSet ds=new DataSet();
            
            
			try 
			{
				database = new OleDbConnection(connectionString);
                database.Open();
			}
			catch (Exception x)
			{
				MessageBox.Show(x.Message);
			}
			
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, database);
            adp.Fill(ds, "ProductName");

            adp = new OleDbDataAdapter(sql2, database);
            adp.Fill(ds,"PackingName");
							
			foreach (DataRow dr in ds.Tables[0].Rows) 
			{
				comboBox3.Items.Add(dr[0].ToString()) ;
                                comboBox1.Items.Add(dr[1].ToString());
             		
			}

BEGIN TRANSACTION
INSERT INTO Customers (CustName) VALUES ('John') -- Id field is identity, and therefore not named in the fieldlist.
DECLARE @custId AS BIGINT
SELECT @custId = @@IDENTITY -- put new custId key into "@custId" var
INSERT INTO ORDER (OrderId, CustomerId) VALUES (1, @custId)
COMMIT TRANSACTION

I are troll

// remoteExe is the url of the exe on the server (http://machinename/websitename/my.exe)
// localExe is the path where you want to save it locally
System.Net.WebRequest request = System.Net.WebRequest.Create(remoteExe);
// you may need to pass network credentials here, search WebRequest in MSDN for details
using (System.Net.WebResponse response = request.GetResponse())
{
    using (System.IO.Stream stream = response.GetResponseStream())
    {
        byte[] content = new byte[response.ContentLength];
        stream.Read(content, 0, content.Length);
        System.IO.File.WriteAllBytes(localExe, content);
    }
}
// executing the saved exe, if you need you can pass additional parameters here
System.Diagnostics.Process.Start(localExe);

pradeep455 wrote:

iexplore http://machinename/websitename/my.exe"