Click here to Skip to main content
15,903,724 members
Home / Discussions / Web Development
   

Web Development

 
QuestionProblem of Web service calling Pin
mani.thirumalai15-Jul-09 20:27
mani.thirumalai15-Jul-09 20:27 
AnswerRe: Problem of Web service calling Pin
Marc Firth15-Jul-09 22:10
Marc Firth15-Jul-09 22:10 
GeneralRe: Problem of Web service calling Pin
mani.thirumalai15-Jul-09 23:57
mani.thirumalai15-Jul-09 23:57 
GeneralRe: Problem of Web service calling Pin
Marc Firth16-Jul-09 0:21
Marc Firth16-Jul-09 0:21 
GeneralIE8 font error Pin
krishna.kommula15-Jul-09 18:50
krishna.kommula15-Jul-09 18:50 
GeneralRe: IE8 font error Pin
Marc Firth15-Jul-09 22:07
Marc Firth15-Jul-09 22:07 
GeneralRe: IE8 font error Pin
dbkman1017-Jul-09 15:44
dbkman1017-Jul-09 15:44 
QuestionInserting Data Into SQL Server Database Pin
pstyles115-Jul-09 2:42
pstyles115-Jul-09 2:42 
Hi guys!

Am trying to insert data from a drop-down menu and text boxes on a web page into a SQL 2008 database table, but it doesn't seem to be working!

Can you please tell me where I have gone wrong, see code below:

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
SqlDataSource2.InsertCommand = "INSERT INTO [LessonTimes] ([Name], [Lesson Date], [Lesson Time]) VALUES (@Name, @Lesson Date, @Lesson Time)"
SqlDataSource2.InsertParameters.Add("Name", DropDownList1.SelectedValue)
SqlDataSource2.InsertParameters.Add("Lesson Date", TextBox3.Text)
SqlDataSource2.InsertParameters.Add("Lesson Time", TextBox2.Text)
SqlDataSource2.Insert()

End Sub



The table is called LessonTimes, and there is also a primary key on this table called LessonID.

Thanks in advance.
AnswerRe: Inserting Data Into SQL Server Database Pin
DoctorMick15-Jul-09 5:24
DoctorMick15-Jul-09 5:24 
GeneralRe: Inserting Data Into SQL Server Database Pin
pstyles115-Jul-09 5:31
pstyles115-Jul-09 5:31 
AnswerRe: Inserting Data Into SQL Server Database Pin
goodideadave16-Jul-09 13:21
goodideadave16-Jul-09 13:21 
QuestionDetecting server certificates in browser Pin
Karo915-Jul-09 0:40
Karo915-Jul-09 0:40 
QuestionFolder Browser dailogBox Pin
raushan_914-Jul-09 20:31
raushan_914-Jul-09 20:31 
AnswerRe: Folder Browser dailogBox Pin
Marc Firth14-Jul-09 21:59
Marc Firth14-Jul-09 21:59 
GeneralRe: Folder Browser dailogBox Pin
raushan_914-Jul-09 22:19
raushan_914-Jul-09 22:19 
GeneralRe: Folder Browser dailogBox Pin
Marc Firth14-Jul-09 22:44
Marc Firth14-Jul-09 22:44 
GeneralRe: Folder Browser dailogBox Pin
raushan_914-Jul-09 23:02
raushan_914-Jul-09 23:02 
GeneralRe: Folder Browser dailogBox Pin
Marc Firth14-Jul-09 23:06
Marc Firth14-Jul-09 23:06 
GeneralRe: Folder Browser dailogBox Pin
Marc Firth14-Jul-09 23:09
Marc Firth14-Jul-09 23:09 
GeneralRe: Folder Browser dailogBox Pin
raushan_914-Jul-09 23:55
raushan_914-Jul-09 23:55 
GeneralRe: Folder Browser dailogBox Pin
Marc Firth15-Jul-09 0:26
Marc Firth15-Jul-09 0:26 
GeneralRe: Folder Browser dailogBox Pin
raushan_915-Jul-09 0:56
raushan_915-Jul-09 0:56 
GeneralRe: Folder Browser dailogBox Pin
Marc Firth15-Jul-09 0:57
Marc Firth15-Jul-09 0:57 
GeneralRe: Folder Browser dailogBox Pin
raushan_915-Jul-09 1:02
raushan_915-Jul-09 1:02 
GeneralRe: Folder Browser dailogBox Pin
Marc Firth15-Jul-09 1:03
Marc Firth15-Jul-09 1: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.