hi,i am creating form of purchase order . so i am using a datatable to get data from textbox, dropdownlist and then i want to display that data in gridview and after that do store that data to table in database . but due to some reason , its not working
i have one simple question; do I have to... or is there any need to validate value from DropDownLists that are populated from SQL Datatables. I know how to validate them, but I am just concerned about potential SQL Injection, because those DropDownLists are going to be "Input fields" for a new Datatable, and insted of using TextBoxes, user will choose values from those DDL's and Submit them (INSERT INTO) to SQL Datatable. Is there a way for a "hacker" to insert his item value into DropDownList. I hop You understand what I mean!?
View 6 RepliesI have a Gridview and two link button in that GridView , one link button click is to add edit row ( Edit ), one link button click is to select row ( Select ). I have a dropdownlist inside row which selected when i click link button Select in the gridview edit template, as of my business logic i need to show the dropdownlist only when the user clicks Edit button and when the user clicks Select button . That mean when the user clicks Select button then they clicks Edit button on the gridvview i should allow him to edit the dropdownlist (showing the value to the user through a label).
ASPX CODE
[Code].... C#
When I click Select link button , then I click Edit link button . They have errors : Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" I don't know what error?. How to fix it
Which one is faster? For a dropdownlist binding it the first time and using ViewSate or Turning of viewstate, keeping the data in a static datatable and binding the dropdownlist each time on a postback
View 7 RepliesI am trying to use a datasource with a dropdownlist. Eventually, my data source method to call a stored procedure and load the datatable is returns, but for now, I am just creating the datatable manually. I need each item to have two attributes, the text, whixh the user will see in the DDL, and the value that the program will retrieve from and store back to the file.
It is partly working in that the DDL has 3 items, however the text for each item reads "System.Data.DataRowView"
I have to be close, but I can't figure out what I am doing wrong.
[Code]....
I will get required data from the web method that returns as table!!!
[System.Web.Services.WebMethod]
public static DataTable call(String code)
{
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
[Code] .....
i have 2 dropdown list and i need to create a Generic method so that I an reuse it...
View 1 RepliesI know the way how to find the value of a control in gridview RowDataBound()
as
<asp:Label ID="ControlId" runat="server" Text='<%#Eval("Field") %>'></asp:Label>
in RowDataBound() i can access the value as
Label lbl= (Label)e.Row.FindControl("ControlId");
But ,I want to access the value in gridview RowDataBound()
as
var value=eval("Field")
Is there any way doing like this ....
I have no problem when paging my FormView, the dropdownlist does not read the next record and keep the value of the first loaded record? All other textbox control behave normally and move from record to record excepted the ddl??Here the code.
Public Sub DoData()
Dim myConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString)
Dim myCommand As SqlCommand = New SqlCommand("SelectSupplier", myConn)
myCommand.CommandText = "SelectSupplier"
[Code]....
I have a Gridview that is using a DataTable as its data source. I want the user to be able to edit the quantity column in the grid.
I have a TemplateField with a LinkButton2 for my Edit command. I have a TemplateField for my "Quantity" column that has Label for the <ItemTemplate> and a textbox for the <EditItemTemplate>
How do I get the grid to switch from the <ItemTemplate> to the <EditItemTemplate> when the user clicks on the Edit Hyperlink.
The Code:
[Code]....
I'm writing a web service that needs to query an Access 2003 database (.mdb). I've found the following code in doing some research on OLEDB connections and queries:
[Code]....
Errors are as follows:
Error 3 A field initializer cannot reference the non-static field, method, or property 'CompleteRentalls.completedb.sqlString'
Error 5 'CompleteRentalls.completedb.da' is a 'field' but is used like a 'type'
Can anyone help me rectify the above code such that the query results are returned to my datatable?
'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Word.DataTable'
View 3 RepliesI am trying to populate (store) an access database with the information from a DropDownList.
At the moment i have a form where the user inputs data into a textbox and on sumbission it adds to the access database. I am unsure how to add data to the database from the selections choosen in the DropDownList. I have a DropDownList for Title e.g. Mr,Mrs,Ms,Miss.
I have provided the code that populates the database from the TextBox's
[Code]....
I have controls like TextBox, DropDownList and button on page.
When I enter data to TextBox, DropDown and if I click on button then it should add to GridView cell's TextBox and DropDownList respectively.
I have some field in datadase which is filled through checkboxlist , only selected checkbox has save to fields otherwise they remain blank: My problem is I want to show only filled value in label text using ";" , but when i am going to display it id display like:
[Code]....
i have two dropdownlist , i want to add item in dropdownlist 2 from database if the city is changed in first dropdownlist..I am using access database
here is my code:
[code]....
but when i select any text , it will not show anything in dropdownlist2 ..
i have a question, i ywant to know how to make if i pick an item from a drop down list it description goes to a textbox beside it automaticaly is very very important to me at this point
View 1 Repliesi have gride view and there are three dropDownList in every row in grideview,i want get selected value from every DropDownList,and pass the values to storeprocedure in sql,I dont know how pass value every row, to store procedure,and StoreProcedure get 3 value.
View 1 Replies How to overlap textbox on dropdownlist, i.e. suppose if i check any item from dropdownlist, the item should display on textbox and dropdownlist dropped items should not visible in dropdownlist(textbox and dropdownlist items should display at the same place)
I have used the following and
<div style="width: 62px">
<asp:TextBox ID="txtsttime" runat="server" Text='<%# Eval("Starting_Time", "{0:hh:mm tt}")%>' BorderColor="#8DC6EC" Width="40px" AutoPostBack="true" OnTextChanged="txtsttime_TextChanged"
BorderStyle="None" Font-Names="Tahoma" Font-Size="7pt" Style="position: static;
z-index: 2; text-align: left"></asp:TextBox>
<asp:DropDownList ID="DropDownList1" runat="server" BorderStyle="None" Width="62px"
BorderColor="#8DC6EC" Font-Names="Tahoma" Font-Size="7pt" AutoPostBack="true"
OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" Style="position: relative;
z-index: 1">
<asp:ListItem></asp:ListItem>
<asp:ListItem>08:00 AM</asp:ListItem>
<asp:ListItem>08:15 AM</asp:ListItem>
<asp:ListItem>08:30 AM</asp:ListItem>
<asp:ListItem>08:45 AM</asp:ListItem>
</dropdownlist>
</div>
the problem with the above is when i put above controls in gridview and try to scroll the gridview, then the textbox data is fixed not scrolling with the gridview. how to scroll the textbox data along with the gridview.
How to set textbox value based on dropdownlist in asp.net?
Eg: DropDown Option: * Small
*Medium
If I select Small I need textbox value as 50 and For medium 100 something like this.
Populate items in DropDownList from TextBox Value in ASP.Net ...
View 1 Repliesi have the dataset with one table.Table contains three column like 'Name','Location','Pin'.I would like to move the data from another table based on schema.
View 2 RepliesIf I am passed a datatable and I cant change the column structure..is there anyway to set an existing column to a Primary key so I can easily Find() the row I am looking for?
View 1 RepliesI have 2 dropdown lists on a WebForm. One of them is populated in the page's Page_Load event. This oneworks fine with the following code.
[Code]....
Then, after a value is selected from this list and a date is selected from a DateTime picker, then I click a button which is supposed to populate the 2nd dropdownlist. In the debugger in the button's click event I can see that the dataset is being populated with data, but then the list is never populated after the DataBind() method is run. Here is code from the button's click event.
[Code]....
I have a DropDownList and I want to populate using a DataTable.
[Code]....
But when appear the DropDownList show System.Data.DataRow why this don't show the real result of the DataTable ?