I have gridview binded from database..
I have following code:
protected void Page_Load(object sender, EventArgs e)
{
BindGrid();
}
Now, I have checkBox and drop-down inside the gridView, When user selects some rows from checkboxes and clicks on Update Button, Page_Load event fires and calls BindGrid(); method and selected rows should get hidden. How can I retain checkbox values after the page load event.
i have a GridView bound to a DataView. Some columns in the DataView's table are foreignkeys to related tables(f.e. Customer). I want to enable sorting for these columns too, but all i can do is sorting the foreignkey(fiCustomer) and not the CustomerName.
I have tried this without success(" Cannot find column ERP_Customer.CustomerName "):
<asp:TemplateField HeaderText="Customer" SortExpression="ERP_Customer.CustomerName" >
A tried also the DataViewManager, but i've a problem to detect the table to sort:
Dim daCharge As New ERPModel.dsERPTableAdapters.ERP_ChargeTableAdapter
daCharge.Fill(dsERP.ERP_Charge)
Dim viewManager As New DataViewManager(Me.dsERP)
[Code].....
How to show pop up menu from database in gridview on each gridview row items ?Example of this is : http:[url].....Move your cursor to Departure time and arrival time...a want this type of popup in gridview items....which fetch entries from database..
View 2 RepliesIn my application,i have a gridview in which columns are created at runtime.Actually these columns are created when i am entering data in a database table.[code]where Column1,Column2,column3 may vary during runtime.i need to enter values to these columns during runtime.But i cant bind these columns because these are created during runtime.The first column "Description" will not change.It will remain constant.For each description, there will be values for each column.At last these data will be saved to the database.How to add columns in the gridview during runtime?
View 2 RepliesI am able to export a gridview to excel, my problem is that I cannot figure out how to remove the formatting from coming over from the girdview. Here is the code I am using to export the gridview: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
I have a modal popup that contains a gridview. On the click of a button inside of a grid i reload the gridview with the data that depends on the id of the row clicked in the gridview. I would have like to reload the gridview onclientclick but I couldn't find a way to do that. Is it possible to reload a gridview client-side without the user even knowing the page partially loaded?
View 2 RepliesWhat's your list of blogs for anything asp.net and vb.net related. I know for instance Scott Gu's stuff is the first on the rank for asp.net.I'm trying to compile a list of 'good' stuff that will teach me things as I read, the more I gather the better, this way I'll get several posts a day, as most blogs post only once a week if that.jsut to list some of my favs, scottgu & phill haack... although he talks too much about his baby!
View 3 RepliesI downloaded a 3 tier sample code , but that has no code for related tables, I am trying to complete this.
These are the tables and part of the sample code
[CODE...]
this looks like to the forum I need. I have a question on somethings. My data is pulled from a local SQL sever express. First, Form1(Customer) has has data. his customer has a vehicle in another form this form is called (Vehicle) form.I have created the customer form in a detailed form and the vehicle form on a grid design.
View 1 RepliesIm using wikipedia and want related searches to pop in a listbox that the user can look at as well. If anyone has some insight of where to start that would be awesome. I tried getting the heading of the main searched topic by referencing the titles of the website but that ended quickly with many boundaries.
View 1 Repliesi would like to know where is a sample code programmed in 3 tier or n tier to update 2 related tables.
View 7 Repliesi need to sort name as in the picture?
View 1 RepliesThe way it works is for each event, there can be multiple 'disciplines'. So I have a disciplines table related to my events table.
I save an event and save a discipline within it, when I open the application again, the event has saved but the discipline hasn't.[code]...
If the database is not Oracle, it is MS SQl 2008. My task: if Oracle, add two more parameters when calling a stored proc. Oracle and MSFT stored procs are generated; Oracle ones have 3 extra parameters:
Vret_val out number,
Vparam2 in out number,
Vparam3 in out number,
the rest
(The are not actually named Vparam2 and Vparam3, but this should not matter).So, the code for a helper VB.Net class that calls a stored proc:
[Code]...
I am using vs2005 with access db. I am retrieving a tables data thru datagridview using an access query. The table i am calling is contains "ID" of something and I convert it thru the query and show it as names for the sake of my users.
My problem is how to store again the related "ID" s after they alter the datagridview cells? (i.e:the retrieved table contains only id's of customers and i showned the users as names, after they are editing how can i convert the user name as "ID" because the field is Long Integer foreign key field) Or otherwise how can i show the datagridview partuclar cell value as combobox style?
Imports System.Data.OleDb
Public Class frmdgEdit
Private Sub txtSearch_TextChanged(ByVal sender As System.Object, ByVal e As
[Code]....
I've created a combobox for navigating orders in a grid view.
[Code]...
I have a datagridview bound to a bindingsource. Two of the columns contain values that link to the primary keys in other tables. Instead of displaying the primary key values, I would like to display the name of the item associated with the primary key. In other words, the primary key value may be 3 but I want to display "Furnace 5" in the datagridview instead of 3 (which it is now displaying).
View 1 RepliesProcessing an XML file with LINQ to add records into a table in a SQL Server database via a data context. As we are adding records we need to assign the parents in various other tables. Most of the time we can find the existing parent and use it but sometimes we will need to create a new parent.Thought we could do this like this:
Dim defaultPub As publication
defaultPub = New publication With {.name = e..Value}
Dim pub = _Data.publications.Where(Function(s) s.name =
[code].....
I get an error when updating a related table, the main table can be updated but the related gives me a concurrency error but I don't know why. Btw I'm the only one using the program and it's connecting to sql server 2005 express.Inserting works like a charm.My piece of code, I hope you get it. The concurrency error is given on Me._objtblOrderinformatieA.Update(Me.objdtsOrders.orderInformatie)
If MessageBox.Show("Bent u zeker dat u deze record wilt wijzigen?", "Orderbeheer", MessageBoxButtons.YesNo) = 6 Then
update_dataset()
Me._objtblOrdersA.Update(Me.objdtsOrders.orders)
[code]....
I;m trying to make a program that automatically detects files in a folder and display them in my listview control with an checkbox, an image and the name of that certain file located in my directory folder.I've manage so far to make my app to populate my listview from a folder, show the checkbox, and also the image. What i cannot achieve is the following:
1. To show the path in my second Column of the listview;
2. And to run the checked files via a Command Button. [code]
I have added Following HTML in the Form:
<asp:Table runat="server" ID="tblFlightDetails">
<asp:TableRow>
<asp:TableCell CssClass="ASPTableHeader">
<dx:ASPxLabel runat="server" ID="lblFrom" Text="From" CssClass="LabelFont"></dx:ASPxLabel>
</asp:TableCell>
[Code]...
Now from Serverside code I have added 3 rows dynamically.. when ever page gets Postback.. all dynamically added rows get disappear.How can i get the dynamically added rows after postback??
Just getting introduced with visual basic so this may be a simple question or something that makes no sense. BUT, Im making a program that searches Wikipedia depending on what the user inputs into the text box. I have what they searched in my web browser save to a listbox. Im wondering if there is a way to turn this into the history, so they can click these texts in the list box and go back to those previous web pages.
View 2 RepliesI have a simple "two-tables" database (SQL EXpress) and a very simple application (VB 2008 Express). The two tables are customer and order and their structures are:
customer(IDcustomer, LastName, FirstName) IDcustomer=primary key orders(IDord, Number, Description, IDcust)
IDord=primary key the tables are related (IDcustomer-->ID cust)
In VB2008 environment I create a dataset, by means of Data Source Configuration Wizard, which encompass both customer and order tables (xsd file). By opening xsd file I set the relationship in the following manner:
"Both relation and foreign key constraint"
Update Rule = Cascade
Delete Rule = Cascade
In my form I show customer table in detail-mode and orders table in datagridview-mode. Two Fill method are created in the Load event and they work correctly.In "CustomerTableAdapter" I create, with QueryBuilder, a search query (say LastName query) and I write the following code:
Private Sub frmSearch_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.CustomerTableAdapter.FillByLastName(Me.CustomerOrdersDataSet.custom er, "D") 'All Lastnames with first letter = D
[Code]...
i have 3 tables in ms access that is patient , NOK,and admission they have related fields, i am using vb 2005. when i delete a record from the patient table i want the related records from the other tables to be deleted.
View 1 RepliesI don't really know how to deal with the next issue So, I've a webbased application developped with ASP.NET MVC3, which is used to remember when an event is relayed to some people.
[Code]...
Class Structures
Public Class SBO_Collection
Private p_sample As SBO_Sample
[Code].....
I am facing prblm in selecting compbobox...I have a 2 combobox...cboxSelunits and cboxseldept
In selected index change of Cbxunit i am filling CbxDept.and in selected index change of cboxseldept i need to populate the treeview
[Code]...
what are delegates?How are the lambda expressions related to the delegates?
reading the msdn about the delegates is really confusing me ;so i need a start off from here before moving on to the msdn.
Is there a way to clear all the textbox and combobox in a form without looping through panels and tabpages, because those textboxes and comboboxes were place in a tabpages and panels.
View 7 RepliesI really need help on another assignment i have and its to do with matrices. from the code below could anyone tell me where matrice is being used and what its exactly doing? The program is basically moving the shape around and in different positions.i will screen shot the program asap.[code]
View 2 Replies