Comments by DevParashar (Top 14 by date)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CMb
{
public partial class Form1 : Form
{
SqlConnection connect = new SqlConnection("Data Source=Admin;Initial Catalog=Practice_DatabaseSQL;User Id=sa;password=p@ssw0rd");

public Form1()
{
InitializeComponent();
bmbBind();
}

void bmbBind()
{
connect.Open();
SqlCommand cmd = new SqlCommand("SELECT Distinct SoftwareName from dbo.Keys", connect);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

if (dt.Rows.Count > 0)
{
cmbNameS.DataSource = dt;
cmbNameS.DisplayMember = "SoftwareName";
cmbNameS.ValueMember = "SoftwareName";
}
}

private void cmbVersion_SelectedIndexChanged(object sender, EventArgs e)
{
string query = "Select SKeys from dbo.Keys where SoftwareName='" + cmbVersion.SelectedValue + "'";
SqlCommand cmd = new SqlCommand(query, connect);
SqlDataReader data =cmd.ExecuteReader();

if ( data.Read())
{
txtKeys.Text = data.GetSqlValue(0).ToString();
}

}

private void cmbNameS_SelectedIndexChanged(object sender, EventArgs e)
{

string query = "Select VersionNo from dbo.Keys where SoftwareName='" + cmbNameS.SelectedValue + "'";
SqlCommand cmd = new SqlCommand(query, connect);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

if (dt.Rows.Count > 0)
{
cmbVersion.DataSource = dt;
cmbVersion.DisplayMember = "VersionNo";
cmbVersion.ValueMember = "VersionNo";
}
}

}
}



I have the following code changes but not able to get the desired output in the textbox