get data from database

anuj

10y836Visual Basic .NET

how to get a specific colum value from database ..with the combobox selction ..in window application form

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arul R10y ago
Accepted answer
Kindly refer the below links, Hope this will solve your problem.

http://www.codeproject.com/Questions/342593/How-we-display-database-table-one-column-values-in

http://www.dreamincode.net/forums/topic/145973-fill-data-from-database-in-the-combobox/

http://www.codeproject.com/Articles/8597/Populate-data-from-database-in-a-ComboBox

http://csharp.net-informations.com/dataset/dataset-combobox.htm

http://dotnetsridhar.blogspot.in/2012/04/binding-combobox-in-windows.html

Let me know for any thing more....
If your problem solved means kindly Accept my answer
0
anuj10y ago
my table name is customer..
and customer table colum name is
id int,
name varchar(20),

and i bind the combobox with tha customer table ...
i want id value from cutomer table with the selection of combobox

try
{
con.Open();
SqlCommand cmd = new SqlCommand("select id from customer where Name ='" +comboBox1.SelectedValue + "'", con);
int anuj1 = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
if (anuj1 > 0)
{
txtid.Text = Convert.ToString(anuj1);
}
}
catch
{
}
0
Manas Mohapatra10y ago
Are you getting any exception after executing the code.
0
Ranjit Powar10y ago
There is any error in your query?
0
anuj10y ago
SqlCommand cmd = new SqlCommand("select id from customer where Name ='" +comboBox1.SelectedValue + "'", con);

int anuj1 = Convert.ToInt32(cmd.ExecuteScalar());

i want id value from datatabel customer..
0
Rajeesh Menoth10y ago
Hi,

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

namespace WindowsApplication44
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

SqlDataAdapter da;
DataSet ds = new DataSet();

private void Form1_Load(object sender, EventArgs e)
{
// Build the Connection String and create a SQL Connection object
String cnnStr = "Data Source = localhost; Initial Catalog = Northwind; Integrated Security = SSPI";
SqlConnection cnn = new SqlConnection(cnnStr);
// Create a SQL Command object from the connection object and setup the SELECT command
SqlCommand cmd = cnn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM Customers";
// Create the data adapter to use to get the data and handle connecting to the DB
da = new SqlDataAdapter(cmd);
// Get the data from the database. I am using the Northwind database the customers table
da.Fill(ds, "Customers");
// Disconnect the event handler to handle the comboBox1_SelectedIndexChanged event
// while the combo box is being populated, otherwise it will fire a couple of times
// before you are ready to handle them.
this.comboBox1.SelectedIndexChanged -= new System.EventHandler(this.comboBox1_SelectedIndexChanged);
// Connect the cobo box to the data source from where the data is comming from
// In this case the Customers data table in the dataset.
comboBox1.DataSource = ds.Tables["Customers"];
// Tell the combo box what collumn to display to the user
comboBox1.DisplayMember = "CompanyName";
// Tell the combo box what collumn to use with the displayed value, value is not displayed
comboBox1.ValueMember = "CustomerID";
// Restored the event handler
this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
// When the user clicks on a item in the combo box ist primary key will be displayed.
MessageBox.Show("Customer Primary Key is \"" + comboBox1.SelectedValue + "\"");
}
}
}

Reference :

http://www.codeproject.com/Questions/342593/How-we-display-database-table-one-column-values-in
0