I have a series of GridViews in a Tab Panel - databound to a generic List of Business Objects.
The columns in the Gridview are all similar to the following:
<asp:TemplateField HeaderText="Company" SortExpression="Company.ShortName">
<ItemTemplate>
<asp:Label ID="lblCompany" runat="server" Text='<%# Bind("Company.ShortName")
[Code].....
I am fairly new to VB (have done some VB in excell, but its a bit different)
I have a couple of questions:
1) How do I populate a dropdown list from a Database Row 2?
2) When I create a Database from Acess, where do I save the database? and If I build the exe program later on, will it include the database, or how does it work? I feel completely stupid, but one of the best ways to learn is to try over and over again
I'll try to clarify by using the following example. In here I have two Drop down lists (ddlInsertEmployee + ddlInsertCustomer) which should both be bound to fetch data from tables [Employee.EmployeeID] and [Customer.CustomerID] and insert it into table [Task].
The problem is that it inserts data from Employee.Fullname and Customer.Fullname into resp.Employee.EmployeeID and Customer. CustomerID.If I would change the Drop down lists to textboxes, and manually insert the IDs, it works like a charm, but this is not very efficient, I want to be able to see the entire Fullname.how to change my Sqlstring in order to make this work correctly.
Imports System
Imports System.Collections.Generic
Imports System.Data[code].......
I'm using Visual Studio for the first time and VB. I have programed for awhile, but mostly new to windows related softwares. I have an access database connected to my test application and I am trying to display a drop down box with a listing of the item names in my table and the value that is sent off to my database is the actual item id. I can figure out the database part in terms of adding and editing, but I haven't been able to figure out how to display the full list. If I click the next button the list that is generated it displays the next item, but I would rather just list all items in the drop down box and remove that toolbar all together.
View 1 RepliesHere is my drop down list and data source. My question is.. when is it possible to set a defaulted selected option for the drop down list, aka when have all the dropdownlists been databound and their ListItems populated? I have tried Page_PreRender, age_PreRenderComplete, Page_Load.I have read over MSDN's Page Life cycle event which suggest Page_PreRender.
<asp:DropDownList ID="ddlRampStandard" runat="server"
DataSourceID="RampStandardDataSource" DataTextField="StandardName"
DataValueField="StandardName" RepeatDirection="Horizontal"
[code].....
I need to show a drop down list when the page loads, the default selected value is nothing, or an empty element (such as "-"). When the user selects one value from the list, another drop down list is added below the first one, and so on.My problem with this is how you make the page to remember the drop down lists created through postbacks and the values they have selected?
EDIT: I did this example for dynamically add drop down lists and suscribe them to an event handler but the event won't fire.
EDIT 2: Changed the code because I labelled for VB.Net and posted something in C#. I update the code with some trivial improvements, but still won't fire the event :(
Private myDdlArray As New List(Of DropDownList)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (Session("ddl") Is Nothing) Then
[code]....
I have a couple drop down lists connecting to an Access database. I can get the first drop down list to populate with the departments I have listed under "dept" in my access file. After someone selected a "dept" i want the second drop down list to populate with the names ("name"). Right now the second dropdown list is showing up but isn't poplulating. What am I doing wrong?!? I would like to include a third dropdown list for another selection with a button to then show things from the specific selections. Right now, I just need to figure out how to populate a list upon another lists' selections.
View 1 Repliesok, I'm basically trying to make mulitple drop down lists on my form. When the page loads, I can get my main dropdown list, called makelist, to fill in with the items that I want from a txt file.
What I'm trying to do is whenever the selectedindex is changed in makelist, it has to load a different dropdown list, called modellist with items from a different txt file.
[Code]...
I've written a program to work out the flight distance between a set of seven cities around the world using a 2D array but was wondering how I would if possible go about having the values for each city selected via two drop down lists (say start city and destination city).
Public Class frmDistance
Private Sub Flightdist_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim rowcolumn(7, 7) As Integer
Dim sr As IO.StreamReader = IO.File.OpenText("Distance1.Txt")
[code]....
I have two list boxes. A users selects a value from each, clicks a button and the application creates a relationship between the two selected items by saving them in an array and displaying the relationship in a third list box.
What I want to allow is for users to be able to drag a value from one list box and drop it on top of another value. I have the code to capture the value of the item dragged but I don't see how to capture the item that the data is dropped onto.
Is there a way to capture the targeted selected item?
I've got a couple of drop down lists for languages. I bind them to a language list that comes from a query. Then the fields are also bound to the row in the DB they relate to. I have several panels with the language drop down - each "tied" to a different table in my DB. When I call up different records on the same panel the drop downs immediately "set to the position" of that rows language in the list. But when I call up another panel - tied to another database table - I see that language in the drop down.
[Code]...
I'm using vb.net. Basically, I have a drop down list, text box and a submit button. You choose a movie director from a drop down list, then type in a movie, click button and it adds the data to my database.There's another button which hides/shows drop down list, text box and submit button using Visible = True and Visible = False, but what I don't like about it is when it hides the things I said before, it leaves some white/empty space like if they are still there, but not visible.Is there anyway to put some kind of holder/container and place a button which when clicked could add my drop down list, text box and submit buttons to that place?
View 1 Replieshow I can simply dynamically edit a cell in a gridview. i.e. Just click on it and type, and post the changes when I lose focus to the gridview?I have tried defining a cell as a template control (textbox) and get it to display and let me type in, but it does nothing beyond that. I cannpt even get the default value from the underlying dataset into that cell.
View 4 RepliesI'm trying to update some records in my table using the GridView Item templates. It's like this:
<asp:GridView ID="grdCursos" runat="server" CssClass="grdTable"
AutoGenerateColumns="False" DataKeyNames="CourseID">
<Columns>
[Code].....
What im trying to accomplish is to try to edit a gridview by using the updating event but not sure how to do this. The way im populating the datagrid is putting it into a dataSet and using that as the dataSource and doing a databind. Here is my datagrid below.
[Code]...
All my collegue programmer asked me to do is disable the editing of a checkbox in a grid. I have tried to set the column to readonly, does not work, does not seem to have any effect:
dgvPatients.Columns(0).ReadOnly = True in the Load handler of the containing form.
The code happily goes to the compiler, but the GUI still allows editting.
And I tried catching the CellClick event, and in the handler do nothing. It gets there, but still it does, what it did, editing that checkbox. Propably some other event or the parents of the class event is still changing the checkbox.I used dgvPatients.CellContentClick I have also set the property:
In the properties, gridview, edit columns, select that column, bound columns properties, ReadOnly to true in the designer, it let me down. Still the gui lets the user change that check box. what I am doing wrong? My collegue will be in tomorrow, may-be he knows but it bites me this problem.I have searched on the internet, I have spend quite a lot of effort in it, and I am out of options now. What is this??
I have a searchbox and when I search for a record it is fine the records shows up however once I click edit on the gridview the page does a postback and all the records show back up with the first record selected for editing. How can I disable this post back or make it when I click edit all the records do not display again?
VB.CodeBehind
Protected Sub btnClear_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnClear.Click
txtSearch.text = ""
sourcegridview.DataBind()
End Sub
[code] .....
I have a gridview which can be filtered from one or more values in a querystring. That all works great: e.g. "?subject=Maths&authorName=Bond_James&type=Magazine" The values passed to the query string come from 3 drop down lists: Subject, Author, Type.What I'd like is when the user presses "Filter" it will take the selected values from the drop down lists and pass them to the querystring - it could be 1 value, 2, or all 3 (like above).
The drop down lists have an item called "All Subjects" / "All Author" / "All Type" each with a value of -1. The idea being that if the user leaves these items selected then the Filter button just ignores them.
Here is my code so far:
Protected Sub buttonFilterGo_Click(ByVal sender As Object, ByVal e As EventArgs) Handles buttonFilterGo.Click
Dim queryString As String
Dim selectedAuthorString As String = "author=" & dropAuthorList.SelectedItem.Value
[code]....
Also, one more thing. How do I get the drop down lists to have the filters selected when the page re loads?
EDIT: I changed the default values of the drop down lists to "" - this leaves the URL looking messy though ?author=&subject=&type= This works, is it the best way?
I have four drop down lists here and I've assigned the datasource and displaymemberproperties so they are populated by a table. When I run the program and select a choice, all four of them get updated with the new choice.
View 3 RepliesI have a gridview with a button, and when the button is clicked, it fires a rowcommand procedure and adds a new row to the database. Everything works fine until I add a databound drop down list to the gridview.
With a databound dropdown list, the page loads fine, but when I click the button the error shows as "Internet Explorer cannot display the webpage". here is my code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCommand="GridView1_RowCommand"
DataSourceID="SqlDataSource1">
[Code].....
I am working on visual studio 2008 , when i drag and drop a GridView control, I cant see any way of showing the page index by run time. How do I associate one DataSet object (which has got 10 rows) first 5 rows I need to show in first page rest i need to show in next page, basically I need to divide my dataset information in to two seperate page indexes.
View 3 Repliesi have a treeview filled with directory structure, now want to drag some file name from treeview and drop it to GridView.
i tried with the Item_Drag event it works for drag only...but GridView's DropOver event doesn't work what can do ?
So in this gridview, there is a column for status and I want to have a drop down list with Pass, Pending, Fail appear when the edit button is clicked. These values are already in a table, so I need to somehow bind from this table to each ddl for every row.Here is the column from the gridview. As you can see, I would like to just have a label showing when not in edit mode, and a ddl when the edit button is pressed
<asp:TemplateField HeaderText="During Production Status" SortExpression="DuringProductionStatus">
<EditItemTemplate>
[code]......
I have two lists. One list is a list of names, the other list is a list of how many times each name is found in the first list noted in the database
so...
Nick
John
Jim
Jack
is the firs tlist
10
13
13
2
is the second list. Nick had 10, john 13 and so on.I want to sort the second list from large to small, but have the index for the first list still linked to the correct amount of calls.i do it this way so I can
for x = 0 to num_of_names
string = lst_name(x) & "-" & lst_count(x)
next x
I know how to check whether an item exists in a list using (MyList.Contains), But I do not know how to check the whole list. For example (use one button and one richtextbox):
[Code]...
In times past, most people coded on a terminal that was 80 characters wide. In many languages this has become, if not holy then close to it. But now many people have 20"+ monitors (or dual monitors), so screen real estate isn't as prime as it once was.
So my question is this: in Visual Basic code, should code be limited to 80 characters, should there be no limit, or is it really a subjective thing, dependent on where you work and your own preferences?
I have a lot of HD images within my program design and it is causing the screen to flicker when loading other forms. It is kind of
slow too. Is there a way to resolve this, for example, using a reference or component such as DirectDraw. Here are my computer
specifications:
Intel Pentium 4 /2.53GHZ
1.5 GB RAM
512 MB ATI Radeon HD 2400 PRO AGP Video card
19 IN. LCD Widescreen 1440x900 resolution monitor.
could it be the refresh rate of only 60HZ?
I am developing an application that has multiple forms and I wanted to know the best method to have application wide methods and functions. Currently I am using a Module with all my methods that are needed to be used across the entire application in it. However, I read at one point that modules should not be used, as they are only there to preserve backwards compatibility with older VB code. Is there a better way to have methods able to be called anywhere?
View 1 Replieshow can i capture system wide selectedtext?
i've managed so far to get a global mousehook + i'm hoping to capture the selectedtext from anywhere system wide when the user left clicks.
i tried using the keybd_event api to send CTRL+C to copy any selectedtext to the clipboard but it has unexpected effects + seems to run before the text i've just selected becomes selected.
here's the code i'm using:
Public Class Form1
Private Declare Function keybd_event Lib "user32" Alias "keybd_event" _
(ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Integer, _
[Code].....
I'm trying to open a tool window as a child and although I can set the width to something like 50px wide in the ide, when it opens up its 125px wide. What is there to opening a widow with out much width am I missing.I have turned off the maximize and minimize gadgets and even the whole drag bar. When they open up when I run they are fat again. Looking for something like the tool window in paint.net.
View 1 Replies
