I Have a data table like this:
UserID Username Password Email
an a dropdownlist that is binded to this table
DisplayMember is Username
Value member is UserID
now how can I get forexample Email when an Item is selected?
Suppose the given picture*(consider the picture as a web page)* is a web page...i have saved this web page to my HDD...now i want to parse/copy data from a specific area from the web page and store it into the database accordingly. Is this possible?? I wanna know if this thing is possible??If yes then how??
View 2 RepliesI recently made a database that saves user information into a MS Access database from a form.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
objDA = New OleDbDataAdapter("SELECT * FROM CDetails",
[code].....
fetching data from simulated model
View 1 Repliesi have two item in form it is---1 is textbox and 2nd is combo box.now i have single value in textbox but there is a multiple value for a combobox with is totally depend on a value of textbox.*i am already add data to the backend files ... in which 1 columns that is called column A it's value is for textbox and 2 column that is called column B it's value for combo box When i write in textbox it's dependent ALL value can be get in the combo box.Can any one solve my problem..
View 1 RepliesIn a windows form i want to fetch data for the combobox1,combobox2,combobox3 and combobox4 from the BankAccount table and fetch data for combobox5 from the TransferMoney table and fill the dropdown list of these combobox's at the form load event.
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
[code].....
How do I fetch the loginID and display the student data on the textbox?E.g. I login with loginID of 18 but it only display the data of 12
Private Sub frmLibrary_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'LibraryDataSet.Student' table. You can move, or remove it, as needed.
Me.StudentTableAdapter.Fill(Me.LibraryDataSet.Student)
End Sub
I recently made a database that saves user information into a MS Access database from a form.
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
objDA = New OleDbDataAdapter("SELECT * FROM CDetails",
[Code]....
Now when they go to the next form, I have labels such as lblFirstName, lblSurName ect. I want to display the information that the user has inputted into these labels. How can I fetch data saved into the database and display it onto these labels? and how can I select rows?
i am making a website for trading, with trading feeds coming from a source in an excel sheet. I have to show data from the excel sheet in a gridview. When i make connection it will fail due to rapidly changing data; each cell in the sheet changes value 1-3 times per second. I am using an Ajax Timer of interval 100. Here is my code:
[Code]...
I am using VB 2005 professional and SQL Server 2005 express edition.
For the last two weeks I have been trying to have a datagridview control on a form that will have datasource from a dataset with two tables that are related. I want child the column to be a ComboBoxColumn where userts can select options and update the other data(from the other table).
I have two tables in an sql server 2005 database named computers:-
computers
locations
Table computers looks like thisID is the primary key column)
ID Location
Computer139
Computer240
[Code].....
With the location column being a ComboBoxColumn so that when a user enters a new ID say Computer5,they have a choice of a dropdownmenu for the Location column. In the database table computers the item should be saved as well as the index value(to correspond to the LocationID).
I need some clarification. I'm planning to make a Scheduler program where it will fetch data from a MS Access Database, and I also want it to upload the data to a web server (MySQL Database) in JSON Format.
In the first process which is the fetching, I'll use System.Data.Ole.db namespace. This namespace mostly worked in MS Access. In the 2nd process which is the uploading, I am planning to use FTP protocol and should be JSON Format.
I was just confused with the second step, is FTP protocol applicable for this process?
I will make an Android apps to view all the data that will be saved on the web server.
I used a class MyList and with the Help of this MyList the combo box named cboCity was filled with City Code(like 1001,1002,etc..) as Value member and City Name (like Canada,California etc...) as display member.
Public Class MyList
Private _dispName As String
Private _valMember As Integer
Public Sub New()
[code].....
The value members 1001,1002,1003,1004 get inserted as per cbocity(combo box)display name selection , into the database and during the retrieval of the record the value member is obtained and based on that for eg:when i get 1001 the selected item should be Canada.I tried many ways while fetching the record and set the selected item but all fails .
I fetch data from an SQL Express database table named ALARMLOG to a datagridview1. One of the columns of ALARMLOG is "TheTime" which has datetime data type values. This values are in the following format "22/04/2010 13:23:45 PM".When I fetch the data to the datagridview1 I get "22/04/2010 13:23 PM".The problem is that I can't display the seconds in datagridview1. I tried the CORVERT command of SQL in order to convert from datatime to varchar but nothing...
[Code]...
I have been used getelmentbyid in past in vb6 using webbrowser control and internetexplorer instance But in vb.net i tried to fetch webpge using the httpwebresponse Which gives the html / source in the form of sting Is it possible to fetching data by getelementbyid using httpwebresponse and httpwebrequest method ?
View 11 Repliesjust want to ask if a textbox with databinding can be used to search or filter data and display it to other textboxes with databinding on the same form?
View 7 RepliesI migrated a project from VB 2005 to VB 2010. I have a datagridview binded to a dataset populated by the MySql Connector. One of the columns, with integer values, is displayed in a datagridviewcombobox type column. In VB 2005 it worked perfectly. But now, once migrated to VB 2010, the column doesn´t show anything. If I change the type a a textboxcolumn type, it does show the data. The column in the dataset is Integer, and the column in the datagridview is Integer also. But, strangely, although the value of the cell (when debugging) is Integer 1, the formatted value is String "" (empty). If I add integer items to the combo manually, the formatted value is the first added item, but still string, and not equal to the value property. It is the same whether the column is designed and added programatically or visually with the editor of the datagridview. It seems a bug in the combobox type.
View 14 RepliesI have a datagridview with 3 columns. The second column is a combobox which I want to bind with a dataset. How do I go about setting the column index for it as I am doing something like this.
Dim ComboCol As New DataGridViewComboBoxColumn
ComboCol.DataSource = SDS.Tables(0)
ComboCol.ValueMember = "Specie"[code].....
I am building a VB 2008 Express Edition application.I have built a database (with a single table) using SQL Server Compact 3.5 and have connected it to the project. I am able to view and edit the data using a DataGridView on a second form (tutorial made this very easy). I need to work with the data in the table within the application. how to easily load the entire table into an array or even read the table a row or cell at a time so that I can make all of the data available for manipulation within the application (the tutorials only seem to show how to display the data).
View 7 RepliesI have a window having 2 dropdowmlists(schemename-SN and propertyno-PN) , one chkbox ,one "VIEW" button.SN has options "all" with value=0 and many other options with respctive values.Now,i want the code should behaves as follows:
1.0n window onload, SN must b visible bt PN nt.
2.if i select SN other thn All...the PN shud b visible and if i select "All" ,PN hides.
3.when check box is checked- PN hides,and if it is unchecked- PN visible..
Important:-This whole ddl n chk box are in updatable panel,button is nt in that.I want a browser compatible code so javascript can't b used directly(cz they give problem in mozzila and chrome).Right now, i have done this JavaScript and its is working fine.
function window.onload()
{
DisableProperty();
}
[code]....
but this code is not browser compatible.here onload,onkeyup and onclick functions are used , but they dont work in other browsers except internet explorer.
I have been trying to pass selected data from two dropdownlist (page1.aspx) to (page2.aspx) I am not having any luck as it seems the data is not being passed when selected. Please help, this doesn't seem that difficult, but I can not get it work. On (page2.aspx) the data from the dropdownlists will be passed to a stored procedure and all results will be in a gridview.
Here is my code:
Page1.aspx
<asp:DropDownList ID="ddlState" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="ST_Code" DataValueField="ST_Code" />
[code].....
Im trying to do bind a dropdown list to a details view but keep getting an error about the dropdown list ID field:
<asp:TemplateField HeaderText="Approval">
<ItemTemplate>
<asp:DropDownList ID="Approved" runat="server" DataValueField="Approved" SelectedValue='<%#Bind("Approved") %>'>
<asp:ListItem Text="Approved" Value="Approved" />
[code]....
The error message as follows:
'Approved' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value
What is the proper way to attach the value of the dropdownlist to my object so that it can be properly created in the database? Most of my searches keep telling me how to bind a dropdownlist to an object data source, but that is not what I need to do. This is a basic drop down list of 2 items that will never change.
I have two dropdownlist, one is State and one is City. When a State is selected, the City dropdownlist becomes populated. At that point you can select a city, however if you select a city and go back and select a different state, the city dropdownlist is populated by the cities for both states. How do I get it clear the cities for the first state?
Here is the code behind
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
[Code].....
I am not a .net programmer but I can write bits and pieces that I need, however, I have been having trouble working out the best way to achieve something for a website I'm altering.I basically need to have a drop down list which is bound to a certain SQL call (already in place) but I also need the ability to manually type into the drop down list for items that do not exist. These items do not need to be entered into the SQL (I can handle the additional data separately) but I cannot find a way to type inside a drop down list while it is bound to a datasource.Some entries in the datasource (SQL table) are used for one thing, but then a text string needs to be entered for optional entries which do not exist within this SQL table.
Does anyone know how I can achieve this or maybe another similar control can be used that offers this kind of functionality?**Update to be more clear:I need this at runtime. For instance, I do not need this to be within code I actually need the control to accept user input when someone is on the webpate.Imagine a shopping list and all the items are within the drop down list then the user wants to add another item to the shopping list so they just type it into the drop down box and submit the page and its value will be used instead of an existing item.
i did this code to delete data from the database and update the dropdownlist of the combobox(i.e,remove the deleted data from the dropdownlist of the combobox):
Private Sub Delete_Btn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Delete_Btn.Click
Dialog1.ShowDialog()
[Code]....
I have a bit of a tricky scenario. It consists of some partial problems for which I have individually found solutions, but I couldn't find anything that makes it all work together smoothly.
-Upon selecting an item in a datagrid, a new page loads with the details regarding that entity.
-The entity represents a product that can have any amount of variants (such as a t-shirt's color or size)
-I dynamically add dropdownlists to this detail-page that represent these variants (there can be any amount of variants, and each variant can have any amount of different values, each value or combination or values from different variants representing a unique product entity)
-Upon selecting a different variant in a dropdown, a delegate is called that will change the session variable to the productId associated with the selected variant and a postback is fired that will reload the page with new data based on this productId
The problem: the postback is fired BEFORE the dropdownlist's (OnSelectedIndexChanged) delegate is called. Since this delegate defines the productId in the session, the new to-be-used productId isn't known at the time of postback.
Result: loading the correct data in the page is always delayed by one postback. Each time I change the selected index of any of the dropdowns, the page is loaded with data based on the session variable that the PREVIOUS OnSelectedIndexChanged delegate of the dropdown set.
I have a LoadData() method that sets the values of all textboxes, fields, labels etc. based on the productId stored in the current session. This method is called on Page_Load.
Private Property CurrentProduct As Product
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
LoadData()
[Code] .....
It seems that I haven't been completely clear on what does and doesn't apply to this scenario regarding Page Lifecycle.
1) My dropdownlists are added dynamically, which works fine on the first page_load.
2) The content of the dropdownlists is defined by what entity's details i'm loading on the page.
3) What entity's details I'm loading on the page is at first(not-postback) defined by the product I selected in a gridview in the previous page.
4) At postback, this entity is based on a sessionvariable containing the id of the entity.
5) This session variable is defined by what item in the dropdownlist I select.
6) This dropdownlist dissapears after postback since it's not defined on the page, but dynamically. So is the event.
So my guess would go towards some clientside script that stored the selected value before postback, but then I would be clueless on how to get that variable to the server since the logic that retrieves the entity is in the business logic layer which is far away from this page..
I have found a couple of examples on the internet to do this but really struggling to get it working in VB. (Tried a converter but had mixed results) I need the selection options of a Dropdownlist to be populated based upon the differing values in the first dropdown list.
Can anyone help with a releativley simple example in VB? Not fussed if the values are "hard coded" in the script. Or a SQL bit that pulls the data from a table
I have a checkbox in my application,when the checkbox is checked then i want to fetch the data from the database and add it to the dropdownlist of the combobox.Again when the checkbox is unchecked then i want to ramove all the data from the dropdownlist of the combobox.
I did this
Private Sub CheckBox1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
If CheckBox1.Checked = True Then
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=Etech.mdb")
[CODE]...
When the checkbox is checked then the data is added from the database to the dropdownlist of the combobox but when i uncheck it then the data is not removed from the dropdownlist of the combobox. In the above code i think i need to add an else condition to remove the data from the dropdownlist of the combobox and make it empty when the checkbox is unchecked.......but i cant give the proper else condition in the above code.
How do I fetch the document id of an open document in Word? I need that doc id to upload the opened document to a server. Can I do this by creating an instance of that document and use some property?
View 3 RepliesI've created an user control in VB.Net. My requirement is to make this user control read values from a form .say for eg. read a filename which will be provided from app.config.
View 1 RepliesIf i have multiple textboxes with the same Id and name in a form, how to fetch there values separately in vb.net? in javascript iv used fetched them like this
[Code]...