i can not take the value of a string. I assigned the value in the
Code:
kisi_ad = dat.Rows[rCount]["kisi_ad"].ToString();
but i returns null
the code is below. i am waiting your answers..
Code:
//here i take the group name
String kisi_ad="";
protected void ddlGrup_SelectedIndexChanged(object sender, EventArgs e)
{
cblNames.Items.Clear();
String grup = ddlGrup.SelectedItem.ToString();
switch (grup)
{
case "Aile":
OleDbConnection con = dbConnection.GetConnectionObject();
OleDbCommand cmd = new OleDbCommand("select kisi_ad,kisi_soyad from kisi where k_id=@kid and grup=@gname", con);
cmd.Parameters.AddWithValue("@kid", Session["k_id"].ToString());
cmd.Parameters.AddWithValue("@gname", "Aile");
con.Open();
OleDbDataAdapter adapterr = new OleDbDataAdapter(cmd);
DataTable dat = new DataTable();
adapterr.Fill(dat);
int rCount;
for (rCount = 0; rCount <= dat.Rows.Count - 1; rCount++)
{
cblNames.Items.Add(dat.Rows[rCount]["kisi_ad"] + " " + dat.Rows[rCount]["kisi_soyad"]);
kisi_ad = dat.Rows[rCount]["kisi_ad"].ToString();
}
con.Close();
break;
case "Arkadaş":
OleDbConnection conn = dbConnection.GetConnectionObject();
OleDbCommand cmdd = new OleDbCommand("select kisi_ad,kisi_soyad from kisi where k_id=@kid and grup=@gname", conn);
cmdd.Parameters.AddWithValue("@kid", Session["k_id"].ToString());
cmdd.Parameters.AddWithValue("@gname", "Arkadaş");
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(cmdd);
DataTable dt = new DataTable();
adapter.Fill(dt);
int RCount;
for (RCount = 0; RCount<=dt.Rows.Count - 1; RCount++)
{
cblNames.Items.Add(dt.Rows[RCount]["kisi_ad"] + " " + dt.Rows[RCount]["kisi_soyad"]);
kisi_ad = dt.Rows[RCount]["kisi_ad"].ToString();
}
conn.Close();
break;
case "İş Arkadaşı":
OleDbConnection connn = dbConnection.GetConnectionObject();
OleDbCommand cmddd = new OleDbCommand("select kisi_ad,kisi_soyad from kisi where k_id=@kid and grup=@gname", connn);
cmddd.Parameters.AddWithValue("@kid", Session["k_id"].ToString());
cmddd.Parameters.AddWithValue("@gname", "İş Arkadaşı");
connn.Open();
OleDbDataAdapter adapterrr = new OleDbDataAdapter(cmddd);
DataTable dta = new DataTable();
adapterrr.Fill(dta);
int rcount;
for (rcount = 0; rcount <= dta.Rows.Count - 1; rcount++)
{
cblNames.Items.Add(dta.Rows[rcount]["kisi_ad"] + " " + dta.Rows[rcount]["kisi_soyad"]);
kisi_ad = dta.Rows[rcount]["kisi_ad"].ToString();
}
connn.Close();
break;
}
}
// and there i assigned the values from db to labels by using checkboxlist
protected void cblNames_SelectedIndexChanged(object sender, EventArgs e)
{
Response.Write(kisi_ad);
OleDbConnection connect = dbConnection.GetConnectionObject();
OleDbCommand command = new OleDbCommand("SELECT * FROM kisi WHERE kisi_ad=@pad", connect);
command.Parameters.AddWithValue("@pad", kisi_ad);
connect.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
DataTable dat = new DataTable();
adapter.Fill(dat);
int r;
for (r = 0; r < dat.Rows.Count - 1; r++)
{
lblAd.Text = dat.Rows[r]["kisi_ad"].ToString();
lblSoyad.Text = dat.Rows[r]["kisi_soyad"].ToString();
lblMeslek.Text = dat.Rows[r]["kisi_meslek"].ToString();
lblEvtel.Text = dat.Rows[r]["kisi_evtel"].ToString();
lblIstel.Text = dat.Rows[r]["kisi_istel"].ToString();
lblCep1.Text = dat.Rows[r]["kisi_cep1"].ToString();
lblCep2.Text = dat.Rows[r]["kisi_cep2"].ToString();
lblEvAdres1.Text = dat.Rows[r]["kisi_evadres"].ToString();
lblEvAdres2.Text = dat.Rows[r]["kisi_evadres2"].ToString();
lblSehir.Text = dat.Rows[r]["kisi_sehir"].ToString();
lblIsAdres1.Text = dat.Rows[r]["kisi_isadres"].ToString();
lblIsAdres2.Text = dat.Rows[r]["kisi_isadres2"].ToString();
lblEmail.Text = dat.Rows[r]["kisi_email"].ToString();
}
connect.Close();
}