search sql database data from winForm using link labl conrol

Question

Sir I am now doing a C# windows form project with database.

I have 21 forms in my project and a database.

among my forms, i have form named frmStudent.

it has a label named lnksearchApplicationFormNo(using to search database data by application form no.

My database table name representing this form is tbl_Student.

it has a column named 'applicatnformNo'.

how can search the applicatnformNo in linklabel1_click_event?

and also i want to display all data retrieved from the database in the concerned fields.

please help me by write coding.

Iftikar Hussain · Answer

You can send me only the code frmStudent.cs. I like to see the code for when Search Application Form No is clicked. Regards Iftikar

Bineesh VP · Answer

Sir this which code is to be send? I am confused of the program. actually I got result by setting fk key to null. Though I can pass the value to database this project not give me the result I expects. It have parts like sql Table Stored Procedure Info class sp class and form.cs . each coding to be interconnected and the value passes should have equality to each to others. I getting a error while I try to attach my project in this site. I even tried to upload the files separately but in vain. So If you give your email Id i will send you the whole project and you can do the repairing with ease. any way tell which of the code need?.

Iftikar Hussain · Answer

please share your code. Regards Iftikar

Bineesh VP · Answer

the data type of applicationFormNo is numeric(180).

Iftikar Hussain · Answer

what is the datatype of applicatnformNo column? Regards Iftikar

Bineesh VP · Answer

Hi please take a look to my form:- You can see a linkLabel control named 'Search Application Form No' . when I click it I want to retrieve all the data from the table to the concerned fields of this form. i.e when I click the label admissionNo to be inserted to the textbox representing admissionNo.

Bineesh VP · Answer

I am sorry to say that this code is not working. I am getting lot of errors:- 1) Error1: Cannot implicitly convert type 'string' to 'decimal' because of( int id = textbox applicatnformNo.text) This problem is solved when I write(decimal id = decimal.Parse(txtApplicationFormNo.Text) 2) 3) Error3: The name 'dataGridView1' does not exist in the current context can you tell me the cause for arise these errors?

Iftikar Hussain · Answer

Hi You can do like this private void button1_Click(object sender EventArgs e) { GetData(); } private void GetData() { int id = textbox applicatnformNo.text ; DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(@Data Source=.\SQLEXPRESS;Initial Catalog=Northwind;Persist Security Info=True;User ID=MyUserId;Password=MyPassword)) { if (conn.State == ConnectionState.Closed) conn.Open(); string ambi1 = select *from tbl_Student where applicatnformNo= @Field; SqlCommand cmd = new SqlCommand(ambi1 conn); cmd.Parameters.AddWithValue(@Field id); SqlDataAdapter dap = new SqlDataAdapter(cmd); dap.Fill(dt); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); } dataGridView1.DataSource =dt; } Regards Iftikar