Click here to Skip to main content
15,891,184 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: how to get the opposite directory Pin
Colin Angus Mackay8-Jul-06 2:34
Colin Angus Mackay8-Jul-06 2:34 
GeneralRe: how to get the opposite directory Pin
KSCsoft8-Jul-06 2:37
KSCsoft8-Jul-06 2:37 
GeneralRe: how to get the opposite directory Pin
cloudking1196610-Jul-06 2:34
cloudking1196610-Jul-06 2:34 
QuestionCombobox value in c# [modified] Pin
Nagraj Naik8-Jul-06 1:45
Nagraj Naik8-Jul-06 1:45 
AnswerRe: Combobox value in c# Pin
Reza Raad9-Jul-06 0:33
Reza Raad9-Jul-06 0:33 
Questionkeyascii Pin
Abhishek Joshi8-Jul-06 0:00
Abhishek Joshi8-Jul-06 0:00 
AnswerRe: keyascii Pin
eggsovereasy10-Jul-06 7:47
eggsovereasy10-Jul-06 7:47 
Questionprblm in asp.net page,code not working in script tag [modified] Pin
nabeelkhan7-Jul-06 22:41
nabeelkhan7-Jul-06 22:41 
hi all
i have problem ,in html that is inside in the asp.net code,i have table that have rows and colums i want to populate this table through database,bt my whole code is not working...and the following error msgs comes..the
command.text is not define.
tell me the proper way of executing this code.and tell me where i have mistakes
this is my whole code
<%@import namespace="System.Data.OleDb"%>
<%
'dim strConnectionString as new String
'strConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password='';Initial Catalog=dbusa;Data Source=;"
dim conConnection as New OleDbConnection("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password='';Initial Catalog=dbusa;Data Source=")
conConnection.open()
%>
<%
Dim cmd As New OleDbCommand
cmd.Connection = conConnection
Dim dr As OleDbDataReader
cmd.CommandText = "Select course_title,per_name,std_section from tblTT Group by course_title,per_name,std_section"
cmd.CommandType = CommandType.Text
dr = cmd.ExecuteReader
'Set rs = Server.CreateObject("ADODB.Recordset")
'Set rs2 = Server.CreateObject("ADODB.Recordset")
'rs.open "Select course_title,per_name,std_section from tblTT Group by course_title,per_name,std_section", dbCon
%>

<% while dr.read %>
<%
dim strConnectionString1 as new string="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password='';Initial Catalog=dbusa;Data Source="
conConnection1 = New OleDbConnection(strConnectionString1)
conConnection1.open()
Dim cmd1 As New OleDbCommand
cmd1.Connection = conConnection1
Dim dr1 As OleDbDataReader
cmd1.CommandText = "Select time_slot_day,time_slot_from,time_slot_to from tblTT where course_title='" & Session.item("Course_title") & "' AND per_name='" & Session.item("Per_name") &"' AND std_section='" & Session.item("std_section") & "'" "
cmd1.CommandType = CommandType.Text
dr1 = cmd1.ExecuteReader
%>
<%
'rs2.open "Select time_slot_day,time_slot_from,time_slot_to from tblTT where course_title='" & rs("Course_title") & "' AND per_name='" & rs("Per_name") &"' AND std_section='" & rs("std_section") & "'" , dbCon
while dr1.read
%>
<%
end while
%>
<%

end while
conConnection.close()
conConnection1.close()
'rs2.close
'rs.movenext
'wend
'rs.close
%>

Course
<% =dr.item("Course_title")
Session.add("Course_title",dr.item("Course_title"))
%>
<%
if Trim(dr.item("std_section"))="A" OR Trim(dr.item("std_section"))="B" OR Trim(dr.item("std_section"))="C" then
response.Write(" (Section: ") & dr.item("std_Section") & " )"
Session.add("std_section",dr.item("std_section"))
end if
%>

Instructor
<% =dr.item("Per_Name")
Session.add("Per_Name",dr.item("Per_Name"))
%>



<%=dr1.item("time_slot_day")%>
<%=dr1.item("time_slot_from")%> <%= dr1.item("time_slot_to")%>




-- modified at 4:43 Saturday 8th July, 2006
AnswerRe: prblm in asp.net page,code not working in script tag Pin
Guffa8-Jul-06 3:31
Guffa8-Jul-06 3:31 
QuestionHow to make Photogallery in asp.net Pin
varun_khanna177-Jul-06 22:33
varun_khanna177-Jul-06 22:33 
AnswerRe: How to make Photogallery in asp.net Pin
eggsovereasy10-Jul-06 7:49
eggsovereasy10-Jul-06 7:49 
Questioncalling script remotely Pin
Nipal237-Jul-06 20:39
Nipal237-Jul-06 20:39 
AnswerRe: calling script remotely Pin
eggsovereasy10-Jul-06 7:51
eggsovereasy10-Jul-06 7:51 
GeneralRe: calling script remotely Pin
Nipal2310-Jul-06 17:04
Nipal2310-Jul-06 17:04 
QuestionHello doubt on sqlserver Pin
dhulipudi7-Jul-06 20:12
dhulipudi7-Jul-06 20:12 
AnswerRe: Hello doubt on sqlserver Pin
eggsovereasy10-Jul-06 7:52
eggsovereasy10-Jul-06 7:52 
QuestionExcel to asp.net 2.0 Pin
aaraaayen7-Jul-06 19:17
aaraaayen7-Jul-06 19:17 
AnswerRe: Excel to asp.net 2.0 Pin
Mike Ellison7-Jul-06 19:28
Mike Ellison7-Jul-06 19:28 
GeneralRe: Excel to asp.net 2.0 Pin
aaraaayen7-Jul-06 19:30
aaraaayen7-Jul-06 19:30 
GeneralRe: Excel to asp.net 2.0 Pin
Mike Ellison7-Jul-06 20:04
Mike Ellison7-Jul-06 20:04 
GeneralRe: Excel to asp.net 2.0 Pin
aaraaayen7-Jul-06 20:07
aaraaayen7-Jul-06 20:07 
GeneralRe: Excel to asp.net 2.0 Pin
Mike Ellison8-Jul-06 3:54
Mike Ellison8-Jul-06 3:54 
QuestionObjectDataSource and multiple controls Pin
Clickok7-Jul-06 13:54
Clickok7-Jul-06 13:54 
AnswerRe: ObjectDataSource and multiple controls Pin
minhpc_bk7-Jul-06 16:06
minhpc_bk7-Jul-06 16:06 
GeneralRe: ObjectDataSource and multiple controls Pin
Clickok8-Jul-06 12:03
Clickok8-Jul-06 12:03 

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.