Im struggling to display the content of my database. I'd like to create a submenu (subpages within pages) to use in my CMS.
Here is my menu so far, as you can see the pagetitles are repeated for each subtitle. I only want one pagetitle to appear for each submenu.
About Us
Your Services
Equality and Diversity Team at SCHS
subpage title 1
[Code].....
I am trying to display the content of the text box according the number of records in the database. When i do it manually it works but when i do it through the "for" loop i am confused. my code is as below
For i = 0 To total_rec
fname1.Text = ds.Tables("roster").Rows(total_rec).Item("FirstName")
lname1.Text = ds.Tables("roster").Rows(total_rec).Item("LastName")
Next
Now i want to change the index of "fname1" some thing like "fname(total_rec)" but it does not work
I'm using a DataReader to display informations stored in a table.I created Two button to go to next record and to go back. [code] In ASP.NET I didn't find a way to do like it, because DataReader hasn't the EOF property.How can I convert this last code (VB6) to ASP.NET ??
View 2 RepliesI have an SQL statement like:
SELECT FNAME, LNAME, CITY from EMPLOYEE
How do I create a multi-dimensional array from a datareader which should store values like:
John, Doe, LA
Mike, Johnson, PASADENA
Freddy, Kruger, Long Beach
I have run into this problem a few times and have never come up with a good answer. I figure others must have dealt with this already.I have a datareader returned from the database and I want to use the values therein however values may or may not contain NULL. I would like to have a unction that takes in the value from the datareader and returns the value if it is not NULL and blank space if it is NULL.The problem I have is that the data-type of the variable I am testing is variable. It can be a String, and Integer or a DateTime. Can anyone suggest a simple way to test the value and then return the original value (as same data-type if possible) or something else if it is NULL
View 5 Replieshow to find out the total number of rows in a database through datareader
View 3 RepliesI am trying to populate a listbox from an access database. It is a scheduling database. First my users pick a room they would like to add an event to, then a date. after the date is selected, id like the listbox to populate with meeting titles corresponding to the date they selected. The code so far looks like this:
[Code]...
I'm building application that will heavily use database (about 25k query's in few hours) , what is the best way to go:
A) use datareader and open new connection to the database on every client query.
B) load all the needed tables into dataset once the program loaded and use that dataset for the query's?
i have a form with one combobox and textbox now on other hand i have a sql database named balance with two column one as customername and and another as obbalance now i had binded all the customer name to the combobox now what i have to do is wen user selects a customername from the combobox the textbox should show the obbalance of the selected?
View 1 RepliesI have Search form where I display the searched content on a datagrid. What I want is to display the content that I have on the datagrid on a crystal report.
View 15 RepliesI have created a windows form application which goes through Internet Explorer index.dat files and extracts various information (URL's , date they were last accessed etc). I then display this information in a data grid view. From here i would like to be able to click on a URL link and open the web page without activating any active content (such as java script, activex, viruses etc). I have tried to do this using Internet explorer in 'offline mode' with the problem being if the web page requires an online connection it automatically changes Internet Explorer from 'work offline' to online mode. Is there a way around this problem? Or does anyone have any suggestions on a better way to view the web pages with no active content?
View 2 RepliesI have created a windows form application which goes through Internet Explorer index.dat files and extracts various information (URL's , date they were last accessed etc). I then display this information in a data grid view. From here I would like to be able to click on a URL link and open the web page without activating any active content (such as java script, activex, viruses etc). I have tried to do this using Internet explorer in 'offline mode' with the problem being if the web page requires an online connection it automatically changes Internet Explorer from 'work offline' to online mode. Any better way to view the web pages with no active content?
View 1 Replieshow can i use for example, 1 or 2 forms but still be able to display the same amount of content. Similar to a web browser using tabs, its all still inside of the same "form/window" but has different sections.
View 4 RepliesI want to be able to display a textbox but not allow the user to edit the content.
View 4 Repliesi need code for chose any txt file and opening it from open file dialog (if thr user click in open button)and display the content of chosen txt file in textbox
View 2 RepliesI have created a windows form application which goes through Internet Explorer index.dat files and extracts various information (URL's , date they were last accessed etc). I then display this information in a data grid view. From here i would like to be able to click on a URL link and open the web page without activating any active content (such as java script, activex, viruses etc). I have tried to do this using Internet explorer in 'offline mode' with the problem being if the web page requires an online connection it automatically changes Internet Explorer from 'work offline' to online mode.
View 1 RepliesI have a quick question I have 10 picture boxes 5 on left side 5 on right side of screen and basically I would like for when I click on lets say picture box 1 it will display content in the center of the application. Where would I start to add the content as well? Would I have to create a separate form to be able to do this?
View 6 RepliesWhat I am attempting to do is make a form for a tire shop. I want to put comboboxes on the left side of the form that the employees make choices from. I then want to put some kind of a table or grid looking thing on the right side of the form that will display their choices so that everyone in the shop can look at it see that "John is on bay 5 until 3:00pm". At the end of the day I want all of the combobox choices to save to a file..I dont really need the table or the grid thing to save..just the choices. If I want to do this, do I need to use that gridview tool? or can I make my own table thing to display the choices in.
View 9 RepliesI have a problem with my project. here is the problem:
My code for login is as follows:
dim conn as SqlConnection = New SqlConnection("Data Source.................)
dim cmd as SqlCommand = New SqlCommand("Loguser",conn)
cmd.CammandType = CommandType.StoredProcedure
[CODE]...
Now the error i get is that "there is a datareader associate with this connection that need to be closed"
I would like to open 2 and more files(txt format) through openfiledialog and display all content in richtextbox.
[Code]...
I was given a task to actually to develop a application where it will automate the process of extracting data values from excel files and add in into access table. Is there any online examples or any advices on how to go about developing this?
View 1 RepliesI am new to using databases in applications and i have a code to select data from the database. However, the first time the application starts, new data is inserted into the database which is needed after. But, the data does not appear until the whole application is restarted. How I can refresh the database content.
The current code for selecting the data is:
Imports System.Data.SqlServerCe
Public Class MSSUI
Dim con As SqlCeConnection = New SqlCeConnection(My.Settings.DB1ConnectionString)
Dim cmd As SqlCeCommand
Dim myDA As New SqlCeDataAdapter
[Code] .....
I am trying to create a console application that does the following:
1) read a text file
2) Save the content over to a SQL Server database
3) Use command line arguments to allow user to specify any delimited file
how is she can import content of MS Access database into combobox in vb..
but i don't have visual studio
I have to do some maintenance on an old VB.NET application (Visual Studio 2003) that uses Infragistics NetAdvantage 2006. I have a UltraCombo control binded to a DataView.
How can I refresh the content displayed after a change in the database?
I'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt.How can I save this dt content into another table of the same database.I'm not ussing stored procedures and dont understand much of parameters.
CODE
Dim cs As New SqlConnection("Data Source=myserver;Initial Catalog=mydatabase;Integrated Security=True")
Dim da As New SqlDataAdapter
Dim ds As New DataSet("Chosed")
[code]....
How to save DataGridView content into a database?
View 10 RepliesI looked everywhere online and I couldn't locate an equivalent VB2008 code for this php code.
$field = mysql_fetch_assoc($result);
$field_title=$field["title"];
I'm trying to read the content of a field in a mysql database. I found this code below that does it but you must select the position of the field (column 0, 1, 2 etc) myData.GetString(1) instead of the name of the field. In the php code above it is "title". I'm looking for a command like myData.GetString("title")
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim myData As MySqlDataReader
[code]....
I am trying to create an application which reads an xml file and copy the data in an sql database TEMP table, which has the same format.
XML file format:
<?xml version="1.0" encoding="iso-8859-7"?>
<prices>
[code]....
I am trying to create an application, which in first phase will read the content of an XML file, count the products, and copy the content of the XML to a sql server database TEMP table, which i have already created. I have already created the code to read the content of the XML file and view it in a datagrid view. But i dont know how i should copy the content to the database i have created....
The code i wrote till now:
Imports System
Imports System.Xml
Public Class FrmXMLRead
[code]....
I need to copy each product (code, category, subcategory, part_no, titlos, timi, availability, anakykl, lianiki) to the TEMP table of ABC databaseHow should i proceed to copy the data to a database ABC and table TEMP?