convert checkbox into textbox(message) in datagridview directly from sql while running the...

[k jyothi]

i have a sql table like

in datagridview shows like

SNo-------int 1,2,----

Date------nvarchar(50) 2016-02-10

time------nvarchar(50) 4:50:00PM

shift------varchar(50) A/B/C

status------bit chechbox(tick mark)

barcodename---varchar(50) afd


i want to change status column type in datagridview like textbox(message like if it is cliked show used otherwise unused)

i wrote the code in button like

private void button4_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "data source=AMULYA-PC;initial catalog=barcode;integrated security=true";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(@"select * from tblBarcodeTest1 ", con);
DataSet dt = new DataSet();
sda.Fill(dt);
dataGridView1.DataSource = dt.Tables[0];

}

while running the program ,in datagridview status column as displayed like checkbox i want to show it like a textbox(if status is null then show unused in datagridview if not used)

in datagridview i want to show

status------as---- used/unused

please can anybody help me.....

Continue reading...