|
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.
|
|
|
|
|
How isn't it working?
Are you getting an error?
|
|
|
|
|
Not getting an error, but the data just isn't appearing in the table itself.
|
|
|
|
|
You're probably getting an error of some kind, but not trapping it. Wrap the code in a try...catch block (or whatever the VB equivalent is) and see what pops up.
My other signature is witty and insightful.
|
|
|
|
|
We have developed common asp.net web app that requires SSL. Our client is a CA and they issued new certificate for this app. The problem is that their certificate is not present on most systems as trusted root yet. Clients are therefore getting security warnings in their browsers, and we think that they are discouraged to proceed.
Is there any way to detect if browser trusts web app certificate or if it has required authority certificate in its trusted root? This way we could at least display some instructions about certificates and point them to CA page to download it.
|
|
|
|
|
Hello,
how to create a Folder Browser dailogbox in Html Page.
|
|
|
|
|
|
its a File Browser..
but i want to create Folder Browser...
|
|
|
|
|
The difference being...?
Do you mean you want to select multiple files at once (i.e. an entire folder)?
|
|
|
|
|
yes.....
means select only Folder... not a particular file....
|
|
|
|
|
AFAIK this can't be done with html,php,javascript and css - I've done it with adobe flash though - and there's bound to be a Microsoft control if you using asp/c# etc.
|
|
|
|
|
if you're interested in the adobe solution see swfupload[^]
|
|
|
|
|
Thanks for Reply...
Can u Please give solution in Javascript....
|
|
|
|
|
No.
"AFAIK this can't be done with html,php,javascript and css"
Sorry, but you'll need to use something else. JavaScript cannot access the desktop (filesystem).
|
|
|
|
|
Thanks...
i will try to do something else...(but i have a single HTML page and i have need a folder dailog box ... for desktop(filesystem).
|
|
|
|
|
|
Thanks,
How can i use SWFupload in html file... Because I haven't idea about swfupload..
|
|
|
|
|
read the documentation and look at the demos. Theres more than enough there.
|
|
|
|
|
Thanks.... a lot for such cooperaation...
|
|
|
|
|
Hi ,
I am developing one web application. In that i want to automate printer settings [like paper size : A4,A3].How can i change printer settings.
Regards,
Raja baireddy
|
|
|
|
|
you can't do this with php/javascript/html/css. You might have more luck with activex. But I think you might run into another problem in that every printer is different - so unless this is for one printer only, you might end up rewriting it for every printer(!)....
I don't know much about activex either - you might have to write a different one for each browser as well.
|
|
|
|
|
|
Hi there,
I am experiencing a problem which no doubt someone else has come across before but I cant work out for the life of me what the deal is with it.
I have included code below for an onload function and its call that enables me to be able to call multiple functions on-load. There are two at the moment, one that calls the current date and time and puts it in a div and another that "refreshes" an AJAX call and places content in yet another div.
The problem that I am having is that although both functions are being called (the second one is made in another script using a version of the same function call), only the second one is actually producing visible content (in this case a text field). However if I alert a message between the function calls both bits of content are produced as expected.
The code is as follows:
//The function call
print "window.onload = callOnLoads(\"getCurDateTime\", \"\", \"\", \"\")";
//The function definition
function callOnLoads(pageFunction1, pageFunction2, var1, var2)
{
return function()
{
if (pageFunction1 == "getCurDateTime")
getCurDateTime();
if (pageFunction2 == "addDocType")
addDocType("addTypeDiv", "", "", var1, var2);
}
}
The function call is made from a PHP script and the JS definition is held in a JS file.
Anybody have any ideas about this? Im guessing its something to do with the speed of execution given that if I halt it with an alert it then works!
As always, any help is very gratefully received.
Bryant
|
|
|
|
|
I don't really get your code - but if it work with a pause (alert) the you could try using php's "sleep()" or the JavaScript equivalent
|
|
|
|
|
Hello Friends,
I've taken two dropdown(select) in ASP.NET and filling first dropdownlist with CityNames and second dropdown with LocationName accordingly CityName. So i've taken an array in the array i'm having name of locations but i also want to store Location ID's for further searching.
Can anybody let me know how can i do that
|
|
|
|