query to return n item using a unique id

you can use cmd.ExecuteScalar() to return student_name
as

object student_name = cmd.ExecuteScalar();
where cmd is your SqlCommand object.

like

private string get_name(int id)
{
SqlConnection con = new SqlConnection("write your connection name");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select student_name from student_master where student_id = '" & id & "'";
cmd.Connection = con;
object name = cmd.ExecuteScalar();
string student_name = Convert.ToString(name);

return student_name;
}

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Refer
http://forums.asp.net/t/1908673.aspx
http://mentormate.com/blog/improving-linq-to-entities-queries/

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

i was doing this one in c# but the method has a n issue
This is wat am using
public Students GetStudentName(string StudentName)
{

in mi code behind i have this code below

Student newStudent = db.Students.SingleOrDefault(studentname =>studentname.StudentName == studentName);
return newStudent;
This one cannot return any data

StudentNameRadtextbox.Text =Studentsdata.GetStudentName(studentname).StudentId.ToString();



}

Mark as answer if satisfied

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

string studentQuery =
    (from student in students
    where student.id == 90
    select student.Name).FirstOrDefualt();

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Use FirstOrDefualt instead of SingleOrDefault.

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

hi,when i pass a paremeter in the method from the database it picks e. when i enter the studentname it shows the value but if i dont provide it cannot return any value ,how i can i bind it to the item selected from the comobobox as it returns nothing wen i do that,
This is whereby when i add an item from databse

StudentNameRadtextbox.Text =Studentsdata.GetStudentName(studentname) .StudentId.ToString();
when i replace the student name with a name from database it shows up,

Mark as answer if satisfied

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Have used first or default and still getting same results

Mark as answer if satisfied

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Get the checked item from comboBox and assign it to studentname
Support links are:
http://stackoverflow.com/questions/15779562/how-to-get-last-selected-value-from-radcombobox
http://stackoverflow.com/questions/4662703/persist-radcombobox-selected-item-between-postbacks
http://www.dotnetdawgs.com/post/Telerik-Radcombobox-multiple-selections-with-Checkboxes-Server-Side.aspx
http://www.sitefinity.com/developer-network/forums/general-discussions-/can-t-set-selecteditem-in-radcombobox-in-a-user-control-custom-designer

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jopito, if this helps please login to Mark As Answer. | Alert Moderator