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 Repliesi am using sql server 2005 as backend for developing webforms with asp.net using C#.i have two tables table1 and table2.
table1 has user_id(primary key,not null),user_name. and table2 has dept_id(primary key,not null),user_id(foreign key,not null),dept_location.
Firstly i created table1 and insert data in it.. later i created table2 with foreign key relationship with table1..In the add form design of table2 for entering data and insert into table2,i placed a dropdownlist which is binded with user_id from table1...dropdownlist's.datatextfield is equal to "user_name" and datavaluefield is equal to "user_id"..i have to select user_name from dropdownlist.... what i have to do is to insert data into table2... i used the simple sql insert statement as follows..
insert into table2 values(......); but it shows error :insert statement conflicted with the foreign key.
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 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 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
I 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 want to populate data from database and display it to dropdownlist.
View 3 RepliesI have 1 listbox named lbCountry
i have inserted each selected value from listbox into database by following code:
[code]....
now i dont know how to fetch data from database and fill listbox with multiple selected value.
I have menu list like this
and I want to fill it's Items from my SQL database, is that possible ?
I need to pull the data from DB and fill the view model, is there any better way to do this? Currently I'm doing something like this.
ViewModel vm = new ViewModel();
var recentBill = context.Money.Take(10);
foreach (var r in recnetBill)
{
vm.lst.Add(r);
}
Populating CheckBoxList from a column of a table.
View 1 RepliesI 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">
I have a database where a user inputs data to multiple databound drop down listboxes. That's saved to my aspnet database. Then when the page loads again, I want to select the ddls items that the user selected as stored in the database to these databound ddls. But it doesn't work, because on pageload, they haven't been databound yet.
What's the best way to do this? Do I need to run a SELECT statement for each and every ddl on it's databound event?
I am making a login page in asp.net. when am trying to fill the data into the database it can give the error..."Incorrect syntax near 'Password'." my code is
SqlConnection sqlConnection = new SqlConnection("Data Source = DELLVOSTRO; Initial Catalog = ALPHA; User Id= sa; Password= intransit");
string queryString = ("INSERT INTO LOGIN(User_Id, Password, Confirm Password, E_Mail, Security_Question, Security_Answer) VALUES ('" + CreateUserWizard1.UserName + "','" + CreateUserWizard1.Password + "','" + CreateUserWizard1.ConfirmPassword + "','"
+ CreateUserWizard1.RequireEmail + "','" + CreateUserWizard1.Question + "','" + CreateUserWizard1.Answer + "')");
sqlConnection.Open();
SqlCommand cmd = new SqlCommand(queryString, sqlConnection);
cmd.ExecuteNonQuery();
i am created a user control(.ascx)
<span><asp:DropDownList ID="Drop_DocType" runat="server" DataTextField="DOCTYPE"DataValueField="DOCTYPE"/></span>
how to fill it rom database and where i put soure code
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 string taskID[texbox],string projectID[texbox],,string description[texbox],,int totalHrs[texbox],,int billableYN[CheckBox],int activeYN[CheckBox]
outside the grid view .
I have gridview with edit button with bound columns taskID,projectID,description,totalHrs,billableYN,activeYN.
I want when i click on edit button this taskID,projectID,description,totalHrs,billableYN,activeYN should populate outside the grid view on string taskID[texbox],string projectID[texbox],,string description[texbox],,int totalHrs[texbox],,int billableYN[CheckBox],int activeYN[CheckBox]
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]...
I 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 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 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.