Click here to Skip to main content
15,914,074 members
Home / Discussions / C#
   

C#

 
AnswerRe: bitmap lockbits/unlockbits Pin
V.22-Jul-14 22:51
professionalV.22-Jul-14 22:51 
AnswerRe: bitmap lockbits/unlockbits Pin
Kornfeld Eliyahu Peter22-Jul-14 22:55
professionalKornfeld Eliyahu Peter22-Jul-14 22:55 
GeneralRe: bitmap lockbits/unlockbits Pin
V.22-Jul-14 23:10
professionalV.22-Jul-14 23:10 
AnswerRe: bitmap lockbits/unlockbits Pin
Kornfeld Eliyahu Peter22-Jul-14 23:21
professionalKornfeld Eliyahu Peter22-Jul-14 23:21 
GeneralRe: bitmap lockbits/unlockbits Pin
V.23-Jul-14 2:05
professionalV.23-Jul-14 2:05 
AnswerRe: bitmap lockbits/unlockbits Pin
Kornfeld Eliyahu Peter23-Jul-14 2:56
professionalKornfeld Eliyahu Peter23-Jul-14 2:56 
AnswerRe: bitmap lockbits/unlockbits Pin
Kornfeld Eliyahu Peter22-Jul-14 3:24
professionalKornfeld Eliyahu Peter22-Jul-14 3:24 
GeneralRe: bitmap lockbits/unlockbits Pin
V.22-Jul-14 19:55
professionalV.22-Jul-14 19:55 
AnswerRe: bitmap lockbits/unlockbits Pin
Kornfeld Eliyahu Peter22-Jul-14 20:06
professionalKornfeld Eliyahu Peter22-Jul-14 20:06 
GeneralRe: bitmap lockbits/unlockbits Pin
V.22-Jul-14 20:13
professionalV.22-Jul-14 20:13 
QuestionClasses Pin
AnilUppala22-Jul-14 1:52
AnilUppala22-Jul-14 1:52 
AnswerRe: Classes Pin
Ravi Bhavnani22-Jul-14 2:06
professionalRavi Bhavnani22-Jul-14 2:06 
GeneralRe: Classes Pin
AnilUppala22-Jul-14 2:12
AnilUppala22-Jul-14 2:12 
QuestionHELP!!!! Pin
Member 1094467922-Jul-14 1:22
Member 1094467922-Jul-14 1:22 
AnswerRe: HELP!!!! Pin
Dave Kreskowiak22-Jul-14 2:16
mveDave Kreskowiak22-Jul-14 2:16 
SuggestionRe: HELP!!!! Pin
Richard Deeming22-Jul-14 2:18
mveRichard Deeming22-Jul-14 2:18 
AnswerRe: HELP!!!! Pin
OriginalGriff22-Jul-14 3:08
mveOriginalGriff22-Jul-14 3:08 
QuestionNo column found exception occourd Pin
vishavajeet21-Jul-14 1:56
vishavajeet21-Jul-14 1:56 
AnswerRe: No column found exception occourd Pin
Kornfeld Eliyahu Peter21-Jul-14 1:59
professionalKornfeld Eliyahu Peter21-Jul-14 1:59 
GeneralRe: No column found exception occourd Pin
vishavajeet21-Jul-14 2:06
vishavajeet21-Jul-14 2:06 
C#
string query = "SELECT A.emp_id, A.emp_first_name, A.emp_last_name, B.vehicle_no FROM (SELECT emp_id, emp_first_name, emp_last_name FROM emp_detail WHERE (emp_id = (SELECT emp_id FROM Tag_Assign WHERE(Tag_no =(select tag_no from tag_master where tag_id='" + textBox2.Text.Trim() + "'))))) AS A CROSS JOIN (SELECT emp_id, vehicle_no FROM Tag_Assign AS Tag_Assign_1 WHERE(Tag_no =(select tag_no from tag_master where tag_id='" + textBox2.Text.Trim() + "'))) AS B";

DataTable dt = con.datasource(query.Trim());

if (dt.Rows.Count > 0)
{
   lblEmp_name.Text = dt.Rows[0][1].ToString() + " " + dt.Rows[0][2].ToString();

   lblVehicle_no.Text = dt.Rows[0][3].ToString();
}



In above code it gives exception at dt.Rows[0][0].ToString();
AnswerRe: No column found exception occourd Pin
Kornfeld Eliyahu Peter21-Jul-14 2:21
professionalKornfeld Eliyahu Peter21-Jul-14 2:21 
GeneralRe: No column found exception occourd Pin
vishavajeet21-Jul-14 2:50
vishavajeet21-Jul-14 2:50 
AnswerRe: No column found exception occourd Pin
Kornfeld Eliyahu Peter21-Jul-14 2:51
professionalKornfeld Eliyahu Peter21-Jul-14 2:51 
GeneralRe: No column found exception occourd Pin
vishavajeet21-Jul-14 3:08
vishavajeet21-Jul-14 3:08 
GeneralRe: No column found exception occourd Pin
Eddy Vluggen21-Jul-14 3:02
professionalEddy Vluggen21-Jul-14 3:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.