Based on below SQL code i would like to control the data insert.
Example If select type is 'DM', then only insert into the WM table.
string InserttoWM = ConfigurationManager.ConnectionStrings["CIMProRPT01testserverConnectionString"].ConnectionString;
using (SqlConnection Insertcn = new SqlConnection(InserttoWM))
{
[Code].....
<div>
<asp:TreeView ID="TreeView1" runat="server" ExpandDepth="0" ShowLines="true"
OnSelectedNodeChanged="TreeView1_SelectedNodeChanged">
<HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
<NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black" HorizontalPadding="2px"
NodeSpacing="0px" VerticalPadding="2px"></NodeStyle>
[CODE]...
Came accros your article "How to populate DropDownList in GridView in ASP.Net"
[URL] How-to-populate-DropDownList-in-GridView-in-ASPNet.aspx. Was able to duplicate your code w/o any problem. Works. Noticed that the values selected from the DropDownList are not automatically saved in database.
Question: is it possible just by selecting an item from DropDownList and then moving to another row within GridView save a selected value? I mean without using edit/update/cancel buttons but just by selecting an item from the DropDownList.
in griedview how to save dropdown list value save in sql server .
View 1 RepliesI have days valus in asp.net page ,
How to get values from aspx page to .cs and how to insert sql server .
(Ex: Monday,Sunday,....)
i ask what code can generate on how to Populate and save ASP.Net Dropdownlist with Selected Value in Gridview Rowupdating ?
View 1 RepliesI have created USERNAME,EMALE,PASSWORD,GENDER,(MALE,FEMALE,OTHERS as radiobutton) and COUNTRY(contry list as dropdownlist)USERNAME,EMALE,PASSWORD is geting inserted but radiobutton value is not .I dont know how to insert the radiobutton vale into databse and what will be the datatype i should choose.I am using using
-Oracle.ManagedDataAccess.Client; -.net framework 4.5 -C#
I am adding my code till what i have progressed.
<td class="auto-style2">GENDER</td>
<td class="auto-style8">
<asp:RadioButton ID="MALE" runat="server" GroupName="gender" Text="MALE" />
<asp:RadioButton ID="FEMALE" runat="server" GroupName="gender" Text="FEMALE" />
<asp:RadioButton ID="OTHERS" runat="server" GroupName="gender" Text="OTHERS" />
[Code] ....
I'm referring in this question [URL] ....
and now what I want is without using the submit button and save to database
I have a gridview and users would select some records and would click on the submit button and i will be saving those records into database using a stored proc.... now .... just below the gridview and above the submit button there are few checkboxes by default they wud be checked. How would i save the selected values and the checked boxes in database i wrote the stored proc for the gridview but how would i save the checked checkboxes into the same table.
For i As Integer = 0 To gvSelectScreen.Rows.Count - 1
Dim chkTemp As CheckBox = TryCast(gvSelectScreen.Rows(i).FindControl("cbStatus"), CheckBox)
If chkTemp.Checked Then
ContractNumber = gvSelectScreen.Rows(i).Cells(0).Text
ClientProgramNumber = gvSelectScreen.Rows(i).Cells(1).Text
ClientProgramName = gvSelectScreen.Rows(i).Cells(2).Text
StartDate = CType(gvSelectScreen.Rows(i).FindControl("txtStartDate"), TextBox).Text
EndDate = gvSelectScreen.Rows(i).Cells(5).Text
Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnectionString").ConnectionString
Dim myCon As New SqlConnection(connStr)
Dim cmd As New SqlCommand("usp_ParametersFromGrid")
Dim dt As New DataTable
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ContractNumber", SqlDbType.VarChar, 22).Value = ContractNumber.ToString()
cmd.Parameters.Add("@ClientProgramNumber", SqlDbType.VarChar, 22).Value = ClientProgramNumber.ToString()
cmd.Parameters.Add("@ClientProgramName", SqlDbType.VarChar, 100).Value = ClientProgramName.ToString()
cmd.Parameters.Add("@StartDate", SqlDbType.VarChar, 20).Value = StartDate.ToString()
cmd.Parameters.Add("@EndDate", SqlDbType.VarChar, 20).Value = EndDate.ToString()
cmd.Parameters.Add("@RequestID", SqlDbType.VarChar, 50).Value = RequestID.ToString()
cmd.Connection = myCon
myCon.Open()
cmd.ExecuteNonQuery()
myCon.Close()
End If
Now above the submit button as i said, there are few checkboxes and they are checked by default...how would i save the selected item (in the gridview and the checked checkbox values in the same row in the database(sql server)
i am making use of two listboxes. the data from one listbox is transfered to other listbox on button click, bt teh the data which is selected must be added to the table in the sql server. but it is not storing values it is throwing execption...
private void InsertRecords(StringCollection sc)
{
SqlConnection conn = new SqlConnection("Data Source=ABCD;Integrated Security=True");
StringBuilder sb = new StringBuilder(string.Empty);
[Code].....
[URL]
How can I Edit/Update, Delete and save record to database
I am saving one selected value of Dropdownlist to Database and If I am retriving that value I want that only that value should display in dropdownlist.
For e.g I have Dropdownlist as
Monday
Tuesday
Wednesday
Thursday
If I select Tuesday and I saved it to database, On reftriving I want that Only Tuesday should be seen in Dropdownlist not the other listed value.
How to add checked records in nested gridview to database in ASP.Net?
View 1 RepliesI want to delete selected item of dropdownlist on Delete button click
Hint :1-It should also delete value from Database.
2-I want to Delete with the id of that selected item.
on my aspx I have the below DDL
<asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"
DataTextField="Size" DataValueField="BustId" Width="150px"
AppendDataBoundItems="True">
<asp:ListItem Value="-1">(Optional)</asp:ListItem>
</asp:DropDownList>
If the user does not select an item I get an exception when i call the ObjectDataSource Method and DAL as below to insert into database
ProfileObj.InsertParameters["ColorId"].DefaultValue = ColorDDL.SelectedValue.ToString();
What I want to do is insert a database NULL instead.
i am devalope one webpage it contain one textbox and two listboxes in that user can enter textbox value and select multipule selected values fromlistbox in that how to store database values into one record (i.e database contain 3cloumns in that store in column1:20(textbox value) and clomun2:4,3,5(selected listbox values ) and column3:4,5(selected listbox values)).in that i am using wcf service for inserting method how to pass multipule selected values into services in c
View 1 RepliesI have a gridview displaying the items in the shoping cart. I want the customer to be able to change the size of the item he or she has chosen to buy. I have therefore added a dropdownlist inside the edititemtemplate. I would like to display all sizes that are available in the database in the dropdownlist, but don't know what the sql-statement would look like.
The database looks something like this:
Item
PK: ItemID
ItemAttribute
PK: ItemAttributeID
FK: ItemID
:AttributeName (Size, color etc)
AttributeValue
PK: AttributeValueID
FK: ItemAttributeID
:AttributeDescription (Small, Large etc)
ShopingCart
PK:ShopingCartID
FK:ItemID
FK:UserID
:ItemSize
The dropdownlist looks like this:
[Code]....
The problem is it's display all the other item's attributes and not what kind of attributes that is left, for example Medium, Large, X-Large. how to implement the sizes into a dropdownlist and the sql-statement looked like this:
[Code]....
I want three fields in dropdown list in gridview . Pending , Solved , Escalate.
When I first submit the record it should show pending, then from dropdown I want to update it to solved or escalate , and it will be update with dropdown in database. How can I do this process....
I have used Jquery Qucik serach Plugin and Its working fine for me. But I want to get the each record after filter when click on save button.
let's say gridview has total records are 4 then filtered records are 2.When click on Save button 4 records are getting.
I have some textbox and Dropdownlist in my page and bind it from database
BindDropDownList(DDL3, "Guidcenter", "Centername","id");
DDL3.Items.Insert(0, new ListItem(" please select ", "0"));
I have button in my page that when user click on it insert data into database
Here when users didn't select Item from dropdownlist it insert "please select" ( text that I define for DDL ) into database but I want when users didn't select Item from database it insert NULL in database....
protected void ImageButton2_Click1(object sender, ImageClickEventArgs e) {
string data = Server.UrlDecode(Request.QueryString["BehCode"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[Code] ......
How to retrieve selected value of dropdownlist in gridview when dropdown is added dynamically from database.
View 1 RepliesThere is a Dropdown(named "Station") in my code.
<asp:DropDownList ID="DStation" runat="server" Width="100%"></asp:DropDownList>
Im fetching the data saved in DB inside dropdown SelectedValue on page load as below:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
[Code].....
But its always showing "ABC" (i.e, 1st Id's station) in selectedValue of dropdown, for every "id" dont know why.
URL.... When I wrote this code in other page with different SP It didn't worked correctly I change SP in new SP I used INSERT code instead of UPDATE now when users didn't select Item from ddl3 it insert 'please select' in table these are my code
protected void ImageButton2_Click1(object sender, ImageClickEventArgs e) {
SqlCommand _cmd = new SqlCommand("insertSreg", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[code]....
Two ListBox Items Compare and Distinct Values Insert Into Third ListBox
View 1 RepliesI am usin MVC 1.0 anc C#.
I want to use a dropdownlist to display some data, and select one of them, then press the button "Create" and the value goes to the DB.
i tried to do sth, but all what i did, is to display the data in the dropdownlist in the view, But for saving the selected value, i ally don't know how to proceed, am on this more than 6h today, i am totalled !
here is the code:
for the view :
[Code]....
and the COntroller :
[Code]....
