need to populate a gridview using a StoredProc calledspListRetailLocations
My code is as follows:
dr = SQLDataReaderdr = SQLHelper.ExecuteReader(strConn, CommandType.StoreProcedure. "spListRetailLocations")
[code].....
I have a storedproc accepts parameters in XMLtype as
CREATE OR REPLACE PROCEDURE GetDetails(
p_para IN XMLTYPE,
i have to pass 4 parameters to this proc how to do this?
i am passing param as db.Parameters("p1", Oracle.DataAccess.Client.OracleDbType.Varchar2, _
' LN.Length, CObj(LN), Data.ParameterDirection.Input)
[code]....
I have created a connection string, and i am populating a dropdownlist with an ID from a sql database.I want to be able to click on a ID from the dropdownlist and run a query to populate a gridview with data. I have made the dropdownlist autopostback = Enabled. I am not getting an error.
Here is my code:
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlContracts.SelectedIndexChanged
Dim ds As New DataSet
[code]....
I want to populate a checkbox field in a gridview.
I am using the Checked='<%# Convert.ToBoolean(Eval("Inactive")) %>' statement but the issue that I am facing is that in the database some records contain NULL for Inactive. If it encounters a 0 or 1 value it works fine but if NULL it throws an exception.
Kindly guide me how to populate the checkbox so that it should be unchecked even if the field is null.
I'd like to have a backgroundworker process data that will eventually populate a gridview in my windows form. I need to use a backgroundworker because the process takes a little while, normally causing the program to slow/freeze until it's opening and streaming connections.. So, I'm using a background worker to perform these methods.How can I take the data from the background worker (on a separate thread than the UI) and use it to populate controls in the UI?
View 4 RepliesIt has been so long since I have coded a page in VB. For the life of me I just cannot remember how to do this. I have a GridView on an ASP page. Each row has a comment ImageButton. I already have the gridview and text box wrapped in a UpdatePanel. The gridview shows all of the correct information. I just need to add some code to populate the text box with the comment when a user clicks on that row's ImageButton.
The comments are stored in SQL 2005 DB if that makes a difference. Should I shove the comments inside a hidden field of the gridview or is there a function that will allow me to query the db for that specific comment. End goal would be to not refresh the page if possible.
If I used a generic list Class to hold data objects that I am pulling from SQL Server using Linq to sql to populate a datagridview would I need to make any modifications to the datagridview control to accomodate multiple columns or would I need to make any modifications to the generic list class to accomodate the multiple columns in a row that is typical of a record in SQL Server? And one more thing which I believe is the easy part. To bind the list to a datagrid view would I just use the datasource property of the datagridview control.
View 2 RepliesI am using a gridview in my form.aspx page. The textboxes in each row of the gridview are to be populated from a datagrid upon clicking a particular field of the datagrid
View 1 RepliesI have a typical data entry form to show one Customer. All textboxes, controls, etc. are bound to a BindingSource.
Clicking a button, I pop up another form with a DataGrid to show all Customers in a table, this way:
VB
Sub btn_Click
Dim frmPopUp As New frmSearch
frmPopUp.BindingSource1.DataSource = Me.BindingSource1
[Code].....
How can I populate the fields in Form1 selecting a row of the grid in frmSearch?
What I need, is to synchronize the databindings (I think).
I have a table in Oracle that has a column with the Long data type. I create a simple recordset and bind it to a gridview.
Me.grdFollowup.DataSource = rsDataSet
Me.grdFollowup.DataBind()
All of the columns populate correctly except for the Long column. It returns a null for all rows. I have tested the SQL statement in Toad and it works perfectly. how to get an Oracle Long data type to populate in a gridview? This is driving me nuts
I have to set GridView.DataKeyNames(This is really a question about the syntax for a string array, in VB.Net.)I am discovering the PrimaryKey columns names from within a loop, ie:For Each fld As IEntityField In Me.llbDataSource.EntityCollection(0).PrimaryKeyFields'fld.Name ' this is where the column name is stored, so I have to get this into an array Next..[code]So, basically, how does one declare a string array (as required by GridView.DataKeyNames), and then populate the elements of the array from within a loop?
View 3 RepliesI have a form which populates a TextBox I want to use the textBox.text to then load a gridView with the results
[code]...
I have a gridview as follows
<asp:GridView ID="productListTable" runat="server" DataSourceID="srcProductListPerCustomer" AutoGenerateColumns="False" AlternatingRowStyle-CssClass="tr_dark" HeaderStyle-CssClass="header_req"
[Code]....
And it actually seems to work on first instance (altho im not sure the above is a good way to do it, but the problem is when use the pagination on the gridview I get the error
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
On the line
Dim productId As String = productListTable.DataKeys(i).Value
why I am getting this error and also is there a better way to do it ?
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 RepliesI need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 RepliesI am using VB.net.
I need to fill a gridview(1) with data that cames from another gridview(2), ie:
(2) - All articles in the database.
(1) - Selected articles from (2)
What is the best way to do that?
I have asked this question before but didn't get any help. I am going to try to rephrase it a bit.
I have 5 input boxes; let's call them chck1, chck2, chck3, chck4, and chck5.Each input box has an associated checkbox, let's call them chckbox1, chckbox2, chckbox3, chckbox4, chckbox5. These are in a section called '*Step 3****
THe spec is that if you enter a number into one of the input boxes and check the associated checkbox in Step 3, the number gets populated into the corresponding box in step 4.
For instance, if i check a checkbox called chckbox1 and enter a number into chck1 in step3, that number gets populated into chck_amt in step 4 as long as the checkbox next to the inputbox in step3 is checked.
If a number is entered in any of the boxes in step 3 but the associated checkbox is not checked, the number doesn't get populated into the corresponding box in step4.The issue that I have so far is that if I check a box FIRST before entering a number, the corresponding box in step4 gets populated.
If, however, I enter a number into a box in step3 BEFORE checking the associated checkbox, that number does NOT get populated into the corresponding box in step4.Does anyone know how to ensure that whether a number is entered first in step3 or a box is checked first, as long a box is checked, that number needs to get populated into the corresponding box in step4.
[Code]...
I have tested the code for the DataSet and DataAdaptor and both work fine, and as test was able to place the MaxRows variable into one of the text boxes on my form so I know thats all ok. But I am now trying to use the function below to copy the 1st cell of each row into a combo box to populate the options and comes up with a null exception error but cant get my head around it.
[Code]...
i know how to do this in vb.net? to populate datagrid in vb.net?like in the vb6
View 1 RepliesI'm working on a project for personal use to make my life as an IT administrator a little bit easier. (Yea right)So basically, i'm creating a windows application with a form. On this form, it has a button, and a listview.When they click this button, it will load all "Windows XP run commands" into the list view. I also, have a on-click event to capture a click on certain lines in which it will automatically open said run command, or shortcut.
Here is an example of what I am working with so far. (It populates correctly, and the clicking event works like a charm. However, i'm just looking for a better way to clean this code up, or maybe, a better way to go about everything).Once done, I will populate this to the codebank if there isn't another similar thing out there.
On to the code:This is what I have for the form_load event
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
With ListView1
.View = View.Details 'Changes the view to "detailed" view
.LabelEdit = True 'Allow user to edit text
[code]....
I want to populate my asp:table with the contents from my SQL query. The page loads but with nothing in the table.
<%@ Page Title="stuff"Language="vb" AutoEventWireup="false" MasterPageFile="~/Site1.Master" CodeBehind="stuff.aspx.vb" Inherits="WebApplication1.WebForm1" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Net.Mail" %>
[Code] .....
I'm trying to populate a list box with XML so that when the user clicks on a list item it them populates with the next set of elements.
View 1 RepliesI'm trying to populate a combo box with some data from a xml document, but so far all i'm getting is this error message in the combo box[code]...
View 2 RepliesI have my mysql query selected fields (item_code, item_name, item quantity, item_selltype, item_selldetail) but some of these fields are variants.
Dim sqlConn As String = ("SELECT item_code, item_name, item_quantity, item_selltype, item_selldetail FROM qa_items")
Dim objDataAdapter As New MySqlDataAdapter(sqlConn, objConn)
[Code]....
I have created a sub that I am using over and over again. However, I am not able to get the values from the database. Screen shots and code attached. I need a second pair of eyes, can't seem to figure out what is wrong.
Form Load
vb
'Populate the drop down lists
PopulateDropDownListFromDB(cboReferrerType, "ReferrerType", "ReferrerName")
[Code]....
I select first value from a combobox1 but combobox2 was not populated corresponding to value selected from first one. Again I select same value now combobox was populated
View 2 Repliesthe information displays in the datarepeater correctly when loading the form, but i can not get new data to be displayed, (when saved to the database) no matter what i try. I think it is just beyond me.here is the code for which i import the initial data into the datarepeater:
Function test()
Dim bsStaff As New BindingSource
Dim dtStaff As New DataTable()
[code].....