C#

USERS
- UserID (INT)
- UserName (VARCHAR)
- UserType (INT)

USERTYPES
- UserType (INT)
- UserTypeDescription (VARCHAR)

SELECT * FROM USERS;

SELECT UserID, UserName, UserTypeDescription FROM USERS INNER JOIN USERTYPES ON USERS.UserType = USERTYPES.UserType;

private void myDataGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
    for (int row = 0; row < (sender as DataGridView).Rows.Count; row++)
    {
    	// Create a new DataGridViewComboBoxCell that will replace the existing UserType cell in the relevant column
        DataGridViewComboBoxCell newCell = new DataGridViewComboBoxCell();
        
        // Populate the DataSource of the combo box
        using (SqlCommand sqlCommand = new SqlCommand("SELECT UserType, UserDescription FROM UserTypes", mySQLConnection))
        {
            using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())
            {
                DataSet ds1 = new DataSet();
                DataTable dt1 = new DataTable();
                ds1.Tables.Add(dt1);
                ds1.Load(sqlDataReader, LoadOption.PreserveChanges, ds1.Tables[0]);
                newCell.DataSource = ds1.Tables[0];
                newCell.DisplayMember = "GroupName";
                newCell.ValueMember = "GroupID";
            }
        }
        
        // Set value of combo box to the current value of the UserType cell
        newCell.Value = myDataGridView.Rows[row].Cells["UserType"].Value;
        
        // Replace existing UserType cell with the newly created combo box cell
        myDataGridView.Rows[row].Cells["UserType"].Value = newCell;
    }
}

Unable to cast object of type 'System.Windows.Forms.DataGridViewComboBoxCell' to type 'System.IConvertible'.Couldn't store <DataGridViewComboBoxCell { ColumnIndex=-1, RowIndex=-1 }> in ConnectGroupID Column.  Expected type is Int32.

is_form_exists = false;

foreach (Form search_form in this.MdiChildren)
{
    if ((string)search_form.Tag == "BROWSE_PATIENTS")
    {
        search_form.Activate();
        is_form_exists = true;
        break;
    }
}

if (is_form_exists == false)
{
    frmSearchResult SearchResultForm = new frmSearchResult(public_var);
    SearchResultForm.Tag = "BROWSE_PATIENTS";
    SearchResultForm.MdiParent = this;
    SearchResultForm.Dock = DockStyle.Fill;
    SearchResultForm.find_what = "FILE";
    SearchResultForm.find_text1 = (sender as TextEdit).Text.Trim();
    SearchResultForm.find_text2 = null;
    SearchResultForm.Show();
}

<pre lang="c#">
        public static void Download(String strURLFileandPath, String strFileSaveFileandPath)
        {
            HttpWebRequest wr = (HttpWebRequest)WebRequest.Create(strURLFileandPath);
            HttpWebResponse ws = (HttpWebResponse)wr.GetResponse();
            Stream str = ws.GetResponseStream();
            byte[] inBuf = new byte[100000];
            int bytesToRead = (int)inBuf.Length;
            int bytesRead = 0;
            while (bytesToRead > 0)
            {
                int n = str.Read(inBuf, bytesRead, bytesToRead);
                if (n == 0)
                    break;
                bytesRead += n;
                bytesToRead -= n;
            }
            try
            {
                
                FileStream fstr = new FileStream(strFileSaveFileandPath, FileMode.OpenOrCreate, FileAccess.Write);
                fstr.Write(inBuf, 0, bytesRead);
                str.Close();
                fstr.Close();
            }
            catch (Exception e) {
                MessageBox.Show(e.Message);
            }
            
        }



        private void button2_Click(object sender, EventArgs e)
        {
            if (phpurl.Text == "") {
                MessageBox.Show("Invalid Url");
            }
            else if (Uri.IsWellFormedUriString(phpurl.Text, UriKind.Absolute) == false)
            {
                MessageBox.Show("Invalid Url");
            }
            else {
                Download(phpurl.Text, @"D:\test");
            }

            
        } 

<?xml version="1.0" encoding="utf-8"?>
<asmv1:assembly manifestVersion="1.0" xmlns="urn:schemas-microsoft-com:asm.v1" xmlns:asmv1="urn:schemas-microsoft-com:asm.v1" xmlns:asmv2="urn:schemas-microsoft-com:asm.v2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <assemblyIdentity version="1.0.0.0" name="MyApplication.app"/>
  <trustInfo xmlns="urn:schemas-microsoft-com:asm.v2">
    <security>
      <requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
        <!-- UAC Manifest Options
            If you want to change the Windows User Account Control level replace the 
            requestedExecutionLevel node with one of the following.

        <requestedExecutionLevel  level="asInvoker" uiAccess="false" />
        <requestedExecutionLevel  level="requireAdministrator" uiAccess="false" />
        <requestedExecutionLevel  level="highestAvailable" uiAccess="false" />

            Specifying requestedExecutionLevel node will disable file and registry virtualization.
            If you want to utilize File and Registry Virtualization for backward 
            compatibility then delete the requestedExecutionLevel node.
        -->
        <requestedExecutionLevel  level="requireAdministrator" uiAccess="false" />
      </requestedPrivileges>
    </security>
  </trustInfo>
  
  <compatibility xmlns="urn:schemas-microsoft-com:compatibility.v1">
    <application>
      <!-- A list of all Windows versions that this application is designed to work with. Windows will automatically select the most compatible environment.-->

      <!-- If your application is designed to work with Windows 7, uncomment the following supportedOS node-->
      <!--<supportedOS Id="{35138b9a-5d96-4fbd-8e2d-a2440225f93a}"/>-->
      
    </application>
  </compatibility>
  
  <!-- Enable themes for Windows common controls and dialogs (Windows XP and later) -->
  <!-- <dependency>
    <dependentAssembly>
      <assemblyIdentity
          type="win32"
          name="Microsoft.Windows.Common-Controls"
          version="6.0.0.0"
          processorArchitecture="*"
          publicKeyToken="6595b64144ccf1df"
          language="*"
        />
    </dependentAssembly>
  </dependency>-->

</asmv1:assembly>