search sql database data from winForm using link labl conrol

Bineesh Viswanath

13y2kC#

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.

8 Replies

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

Iftikar Hussain13y ago
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
0
Bineesh Viswanath13y ago
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?.
0
Iftikar Hussain13y ago
please share your code.

Regards,
Iftikar
0
Bineesh Viswanath13y ago
the data type of applicationFormNo is numeric(18,0).
0
Iftikar Hussain13y ago
what is the datatype of applicatnformNo column?

Regards,
Iftikar
0
Bineesh Viswanath13y ago
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.
0
Bineesh Viswanath13y ago
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 = textboxapplicatnformNo.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?
0
Iftikar Hussain13y ago
Hi,
You can do like this

private void button1_Click(object sender, EventArgs e)
{
GetData();
}

private void GetData()
{
int id = textboxapplicatnformNo.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
0