Hi
I have many tables in my DB all of the tables are join together
I write the below procedure for selecting the record from four tables that they are inner join together
the result of this cod return all records, but I want select just one record where Person_Name equal to an input parameter or query string in C#
In the C# part I want take Person_Name from a Query String
How I do it?
thanks
CREATE procedure [dbo].[Select_Education_TB_Full]
@Eid nvarchar(100)
as
begin
select Person_Name,Field_name_english,SubField_Name_english,Degree_Education,University_Name,Date_Graduated,Experience_Job,CV_Path from Education_Degree_TB inner join Person_TB on Education_Degree_TB.Person_ID=Person_TB.Person_ID join Field_TB on Education_Degree_TB.Field_ID=Field_TB.Field_ID join SubField_TB on Education_Degree_TB.SubField_ID=SubField_TB.SubField_ID where Person_Name=@Eid
end
C# code from OP's other post
SqlCommand cmdEdrop = new SqlCommand("Select_Education_TB_Full",con);
cmdEdrop.CommandType = CommandType.StoredProcedure;
con.Open();
cmdEdrop.Parameters.AddWithValue("@Eid",Request.QueryString["id"]);
SqlDataReader dre;
dre = cmdEdrop.ExecuteReader();
while (dre.Read())
{
LabelName.Text=dre["Person_Name"].ToString();
LblDegree.Text = dre["Field_Name_English"].ToString();
LblField.Text = dre["SubField_Name_English"].ToString();
LblQualifcation.Text = dre["Degree_Education"].ToString();
LabelUniversity.Text=dre["University_Name"].ToString();
LabelGraduated.Text=dre["Date_Graduated"].ToString();
LblQualifcation.Text=dre["Experience_Job"].ToString();
LabelCV.Text=dre["CV_Path"].ToString();
}
con.Close();//
See also comments on repost at
How to select a record in T_SQL useing stored procedure[
^]