Comments by Jignesh J patel

Jignesh J patel 22-May-12 14:42pm View

thanx for ur support i got my answer....

Jignesh J patel 20-May-12 14:11pm View

sir, can you help me for above problem please..

Jignesh J patel 18-May-12 13:43pm View

but for fetching multiple data it's not working.

Jignesh J patel 18-May-12 13:42pm View

this is code for fetch single value
string str0 = "SELECT * FROM TIMETABLE WHERE DEPARTMENT_CODE ='" + lbldepartment.SelectedValue + "' AND TIME = '" + "02:00-03:00" + "' AND SEMESTER = '" + lblsemester.SelectedItem + "'";
SqlDataAdapter ada = new SqlDataAdapter(str0, con);
DataTable dt = new DataTable();
ada.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i].ItemArray[5].Equals("Monday"))
{
Response.Write(dt.Rows[i].ItemArray[5].Equals("Monday"));
Label35.Text = dt.Rows[i].ItemArray[1].ToString();

Jignesh J patel 18-May-12 4:15am View

may i used this query with datatable ? how ?

Jignesh J patel 18-May-12 4:14am View

Deleted

may i used this query with datatable?how?

Jignesh J patel 17-May-12 16:47pm View

ya.this works fine. when i used this in query builder it will return proper value but when put into code it will generate this error.

Jignesh J patel 17-May-12 16:31pm View

i used like this..
"SELECT SUBJECT_CODE + ' ,' AS [text()] FROM TIMETABLE WHERE DEPARTMENT_CODE ='" + lbldepartment.SelectedValue + "' AND TIME = '" + "04:00-05:00" + "' AND SEMESTER = '" + lblsemester.SelectedItem + "' FOR XML PATH('') "
but it generates en error of Index was outside the bounds of the array.how can i soleved this.

Jignesh J patel 17-May-12 15:52pm View

there is only on label control. it's not in grid view.problem is that i have develop timetable. i that for displaying i have used label. in perticular slots there will be more than one labs allocated to each slots. so i have to display more than one slots in asp:label control.

Jignesh J patel 17-May-12 15:39pm View

there is only on label control. it's not in grid view.problem is that i have develop timetable. i that for displaying i have used label. in perticular slots there will be more than one labs allocated to each slots. so i have to display more than one slots in asp:label control.

Jignesh J patel 17-May-12 15:36pm View

Deleted

thanks.....

Jignesh J patel 17-May-12 14:43pm View

in that case how can i concate values in single label..

Jignesh J patel 17-May-12 14:26pm View

though this solution is correct but i have a problem that i have fire this query for select values SELECT * FROM TIMETABLE WHERE DEPARTMENT_CODE ='" + lbldepartment.SelectedValue + "' AND TIME = '" + "05:00-06:00" + "' AND SEMESTER = '" + lblsemester.SelectedItem + "' " and i want to select multiple values and display on label .... please replay...

Jignesh J patel 17-May-12 14:21pm View

though this solution is correct but i have a problem that i have fire this query for select values SELECT * FROM TIMETABLE WHERE DEPARTMENT_CODE ='" + lbldepartment.SelectedValue + "' AND TIME = '" + "05:00-06:00" + "' AND SEMESTER = '" + lblsemester.SelectedItem + "' " and i want to select multiple values and display on label .... please replay...

Jignesh J patel 15-Apr-12 5:55am View

i have developed timetable for class in that i have used no. of button. on click i have inserted values in table. but when i want to update type of the lecture to lab at that time i want to disable the below button also. so i asked this question for that purpose..

Jignesh J patel 13-Apr-12 2:34am View

but i have used i think 60 button in that than every time i have to pass the button name.

Jignesh J patel 11-Apr-12 17:00pm View

i have developed it but when i going to insert it then problem with lab manual

Jignesh J patel 31-Jan-12 8:48am View

IT IS NOT DISPLAYING ON WEBPAGE..

Jignesh J patel 31-Jan-12 7:22am View

value is stored in database but it will not retrive from database...

Jignesh J patel 30-Jan-12 7:36am View

yes..

Jignesh J patel 30-Jan-12 7:33am View

String str = "insert into TIMETABLE values ('" + SUBJECT_CODE.Text + "','" + OFFER_ID.Text + "','" + CLASS_ID.Text + "','" + DropDownList1.SelectedItem + "','" + TIME.Text + "','" + FACULTY_ID.Text + "','" + DropDownList2.SelectedItem + "','" + DURATION.Text + "') ";
cmd = new SqlCommand(str, con);
dr = cmd.ExecuteReader();
if (dr[2] == CLASS_ID.Text && dr[4] == TIME.Text && dr[3] == DropDownList1.SelectedIndex)
{
Response.Write(" Slot Already Given Please Choose another Class");
}

Jignesh J patel 3-Jan-12 3:49am View

can we devlop in visual studio

Jignesh J patel 14-Nov-11 6:19am View

thanks for reply. but if i wanted to directly fetch data from master table to foreign key table

Comments by Jignesh J patel (Top 23 by date)