I am using Visual Studio 2010 C# with SQL database. I have a web form that has Textbox, CheckBoxList, and FileUpload controls. When a user click on "Submit" Button, the data is sent to a table in the SQL database.What is the code behind the "Submit" button? And how can I do it?
View 2 Replies
When users submits data, I want to send an automatic e-mail acknowledging their submission. Below is the code I am running now, which basically submits data into the DB.
[Code]....
how to send email when you submit a new request into the database.
View 6 RepliesI need to collect the data entered by user for a quote and send all the data with labels to an email address. SMTP server is set up in web.config file, but I need to know the code behind for the submit button click event for the form. I do not need to store any data in a data base just need to send each label,field,radiobutton,etc. user responses to email address. All of the code I have been able to find has not applied to my situation.
View 10 RepliesI have webpage containing 3 views of multiview control. In the first view there are 3 fields Name Age Surname
which will be captured in the textbox for the respective fields.In the second view i have three more fields
sex
maritalstatus
bloodgroup
which will be entered in the respective textboxes and a submit button to store the data in both the views in the sql server database. I have all the fields in the sql server table which are mentioned in the webpage.I need the complete code for storing the entered data in both the views of the multiview control after hitting the submit button.
i have 2 text box, on submit button i want to fill data in database.and another gridview to DBi made 1 table in db name ankpracti.i m using sqlserver2000 and visualstudio2005.want whole code and step by step solution.
View 4 RepliesHow to add code to redirect my user on successful submit to my database.
Code...
Imports System.Data
Imports System.Data.SqlClient
Partial Class CPD_OnlineSurvey
Inherits System.Web.UI.Page
Public Sub UpdateOnlineSurvey(ByVal sender As Object, ByVal e As EventArgs)
Using conn As New SqlConnection()
conn.ConnectionString = ConfigurationManager _
.ConnectionStrings("wincts").ConnectionString
Using cmd As New SqlCommand()
cmd.CommandText = "update OnlineSurvey set IsSelected = " & _
"@IsSelected where QuestionId=@QuestionId"
cmd.Connection = conn
conn.Open()
For Each item As ListItem In ChkOnlineSurvey.Items
cmd.Parameters.Clear()
cmd.Parameters.AddWithValue("@IsSelected", item.Selected)
cmd.Parameters.AddWithValue("@QuestionId", item.Value)
cmd.ExecuteNonQuery()
Next
conn.Close()
End Using
End Using
End Sub
End Class
I have 2 SUBMIT button in a form one is display:hidden and one is display:block if user click on SUBMIT button (display:block) then another SUBMIT button {display:hidden} should also submitted.
View 2 RepliesI have a databound Gridview (with a LINQ datasource). The gridview displays questions from the SQL DB to the user. I've inserted a radio button list into the gridview with 3 horizontal radio buttons with fixed values of 1,2,3 for the user to select. I have a question ID, a tempuserID, and AnswerValue columns set up in the database. It all works nicely.
After the user selects radio buttons, I would like for them to push a button to submit the QuestionID, the associated Radio Button Value (AnswerValue) and their tempUserID into the DB. How do I do this? I'm not sure what to do next and what VB/LINQ code to put in the code behind file in the button click event handler. I'm also not sure on what to use for the tempUserID, can I use the sessionID? I'm using VB and here's my code:
[Code]....
In ASP.NET when we have multiple input section with required field validator (Like on header for login with userid & Password is required and second on footer for subscription) when we click on subscription login section's userid required field validator activates and say userid required & i can not submit subscription.
when i submit subscription details login section should not have concern with this. how to avoid this conflicts.
In C#/Asp.net I have 2 submit button i.e.
btnOk and btn_Submit
Initially I am doing validating form by clicking on btnOK and in btn_Submit I am inserting record into table. I again want to call btn_Ok event in btn_Submit click event for re-checking validation, if it validates properly thne rest of code of btn_submit should work.
I saw similar posts but some weren't clear.Here is the repeater head:
<asp:Repeater ID="rptGetAll" OnItemCommand="Buttons_OnItemCommand" runat="server" OnLoad="rptGetAll_Load">
in my asp.net+vb web with access database. i have gridview. i had added a form with submit button to add the data in gridview.
i am using accessdatasource to bind the data to gridview.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:webauth.mdb"
Dim con As OleDbConnection = New OleDbConnection(connectString)
[Code]....
even after the data inserted message flshes the data inserted is not viewed in the gridview . when i press F% or refresh tha page the gets displayed in gridview. how can i solve the problem
In one order form, user have to input/answer about 30 questions before clicking submit button.
Sometime due to network problem, submission is failed and user need to re-input/answer all questions again.
Is it necessary to save data before submit? If yes, where to save them?
I have three drop down lists that are all databound to a gridview. When the user selects 1. a school, 2. a house number, and 3. a street from seperate drop down lists, bus stops for that address are displayed in a gridview. Everything works fine. After the user selects a valid school/house number/street combination the gridview automatically displays. I would like to add a "Submit" button and not have the gridview display until this button is clicked.
View 6 RepliesI am trying to edit data using checkbox value. Firstly, I created popup window which using querystring some data from main page. In popup window, I want to change the checkbox value. For example, I made setSpare column and given the value to show bit data type such as 0 or 1 using checkbox(false or true). If some data has non setSpare(means 0), it wil lbe come out uncheckbox. If I want to check it and clicking submit button, It was not change. I am going to show the code below.
public partial class AddSpare : BasePage
{
string ObjectId;
protected void Page_Load(object sender, EventArgs e)
{
ObjectId = Request.QueryString["ObjectId"];
displayComInfo(ObjectId);
}
protected void displayComInfo(string ObjectId) // it informed relative data on web through using DB.
{
string query = "usp_ShowComputerList";
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SCSConnectionString2"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramobjectId = cmd.Parameters.Add("@ObjectId", System.Data.SqlDbType.Int);
paramobjectId.Value = ObjectId;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
ModelTxt.Text = dr["Model"].ToString();
ModelTxt.ReadOnly = true;
ComputerTxt.Text = dr["ComputerName"].ToString();
ComputerTxt.ReadOnly = true;
userTxt.Text = dr["UserName"].ToString();
userTxt.ReadOnly = true;
ntTxt.Text = dr["NtLogon"].ToString();
ntTxt.ReadOnly = true;
HDDTxt.Text = dr["HddSize"].ToString() + "GB";
HDDTxt.ReadOnly = true;
RAMTxt.Text = dr["MemorySize"].ToString() + "GB";
RAMTxt.ReadOnly = true;
SerialNoTxt.Text = dr["SerialNo"].ToString();
SerialNoTxt.ReadOnly = true;
TextBox1.Text = dr["Spare"].ToString();
inputChkSpare.Checked = (bool)dr["Spare"]; //(bool)dr["Spare"] display false or true.
dr.Close();
}
}
}
catch (Exception ex)
{
MessagePanel1.Type = MessageType.Error;
MessagePanel1.Text = MessagePanel1.Text = "This is an error." + ex.Message;
}
}
protected void okBtn_Click(object sender, EventArgs e)
{
string query = "usp_SetSpare";
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SCSConnectionString2"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramobjectId = cmd.Parameters.Add("@objId", System.Data.SqlDbType.Int);
SqlParameter paramspare = cmd.Parameters.Add("@spare", System.Data.SqlDbType.Char);
paramobjectId.Value = ObjectId;
if (inputChkSpare.Checked == true) // if I change the check box, it does not bring the changed value. It will bring the above value(already displayed thing)
{
paramspare.Value = "1";
}
else {
paramspare.Value = "0";
}
conn.Open();
cmd.ExecuteNonQuery();
cancelBtn.Value = "Close";
okBtn.Enabled = false;
MessagePanel1.Type = MessageType.Information;
MessagePanel1.Text = "This computer is spare from now.";
}
}
catch (Exception ex)
{
MessagePanel1.Type = MessageType.Error;
MessagePanel1.Text = MessagePanel1.Text = "This is an error." + ex.Message;
}
}
I have a Drodownlist , hich is being filled with data from tables at Page Load with the check that Postback is false. Now I want to insert the selected value of dropdownlist to the table, but after pressing the Submit button, its numeric value is getting lost and is substituted with a "" (blank). How do i persist its value.
View 6 RepliesI'm using objectdatasource to get my data. it works fine. Thecurrentway how it works. When the page opens it loads the gridview.but I don't want this.I would like to load the gridview after I press a submit button. so infact after postback...I tried to remove the select Method in aspx and set programmaticallyin the submit button eventhandler but then I get an error thatSelectmethod is not set.Can someone advice me how I can load the gridview usingobjectdatasource after pressing a submit button?
View 20 RepliesI would like to hide a submit button if a DataList is empty. I don't really know the code. If you submit an answer please show me the code also. I have to do it in VB.Net. I googled and found the following code that I place in the code behind under the Page load event.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dv As DataList
dv = SqlDataSource3.[Select](DataSourceSelectArguments.Empty)
[code]...
How do i hide button Add after data submission and display button cancel.
View 1 RepliesI create a webform to register new customer..In my form i have "ID" for customer.And i have database with table "CustomerDetails" with existing data..Existing data "ID" start from 300000 and already have data till 302000..Now i want to use the database to register new customer with "ID" 302001..and i want to generate ID when click "submit" button...this is my problem..i wanna generate ID after click submit..
View 2 RepliesI have 3 tabs with 3 seperate gridview and radios buttons in them. Each page has a seperate submit button, but for some reason each pages submit button is validating all the radio buttons on each tab, i picked the seperate controls to validate under but on any submit theya re all validated instead of just the ones on that tab.
[Code]....
This works in other browsers but not in chrome. I am trying to allow users to upload large files and have an ajax call to update them on the progress of the file upload.
So a unique ID is generated on the client side and added to the action of the form before sending. Then the form is submitted (form only contains a file upload input) and an ajax call is made to get the progress of the upload. The ajax call goes to another page and uses the ID to lookup the upload.
I am using JQuery 1.5.1. Debugging this and putting something on the error function give me nothing other than "error". Not very helpful. I used Chrome's debugger and it just says failed to load resource xxxx.aspx. xxx.aspx is the URL i needed. Turns out that there seems to be some sort of conflict between the form and the ajax call.
I need to send some parameters to an external website using the <asp:HiddenField /> controls and also at the same time, submit data to a sql server database. The part for submitting the data to the database is working, but I need to try to get the parameters from the hiddenfields to also be passed through. I thought all I had to do is create the hidden fields and in the code behind, set the values from the textboxes that the user would fill out.
My source code is below:
[code]...
What am I missing? The hidden fields are losing their value before posting to the external website. I've looked everywhere to see why this won't work.
working on a project interfacing RFID and Vb.
I have got the code for interfacing VB to RFID CAN ANYONE TELL ME HOW CAN I SUBMIT MY ENTRY TO DATABASE AS SOON AS THE TEXT APPEARS IN THE TEXTBOX AND WITHOUT USNG A SUBMIT BUTTON?
