I just got put on a new project to design an app that will retrieve data from an excel data sheet that holds information from our VoIP server's call log. Conveniently, this call log is stored in a fixed location on the local drive that this app will be running on. After working on this for a bit, I knew right away I'm going to need someone smarter than I am...I got to the point where I can show data but heres the issue : Every time I am retrieving the date it shows it as, "08/27/2009 12:00:00 AM", how do i remove the unrelated time stamp? Here is my code in Visual Basic 2008 Express Edition:
Public Class Form1
Dim cn As System.Data.OleDb.OleDbConnection
Dim cmd As System.Data.OleDb.OleDbDataAdapter
Dim ds As New System.Data.DataSet()
I am pulling urls into excel, but excel formats the data. if a website displays 000.4500 excel formats it to .45.... i need everything exactly like displayed on the webpage, so excel should not do anything with it.
I tried formatting the worksheet to text (keep everything as entered exactly) and that did not solve the problem.
I can show code, but i'm not sure if this is a coding problem at all. I am just confused and can't seem to find any good information on this problem.
here's what I'm doing. I'm putting together a program that will allow employees that work under me to all submit shift reports in the same format instead of getting multiple different formatted text files.
I have a list box that they add "actions" they've performed throughout the day. It's populated by a combo box and some text boxes.I've got it all functioning minus one aspect...
[Code]...
Here's my problem... it's only outputting the FIRST set of items. The "Upgraded" accounts all list but the "Downgraded" and "Canceled" are not there.In a perfect world, I wouldn't ever need to worry about "Canceled" or "Downgraded" but... the world isn't perfect so,
I am trying to pull wind direction, temperature and speed, data from this webpage, I have had not much success with it at all, I think that I have the correct method but get stuck on the HTML coding. the webpage is: [URL] I sort of know how to get to the HTML code, but get lost on how to define the ellements that are required. I have a screen capture of where I get up to.
This is in ASP.net iwth VB.I have a quiz project that I've been assigned for work.This quiz project contains two main SQL Databases it pulls the info from. First is a Quiz table, which contains three columns: QuizID (Pri Key), Title, Description. This is where I declare the quizzes, indicated by the QuizID (1, 2, 3....etc)
The second table is the Questions table, containing the following columns: QuestionsID (Pri Key), Title, Answer1, Answer2, Answer3, Answer4, Answer5, CorrectAnswer, QuestionOrder, QuizID....The QuizID in the Quesitons table matches the QuizID in the Quiz table.Thus for QuizID = 1, it consists of all the questions with the matching QuizID in the Questions table. The CorrectAnswer I want to assign a simple value (1, 2, 3...etc).I need a way to take a set of questions (based on the QuizID) put them in some sort of table and randomize them (or rather shuffle them) so that each time this quiz is taken, it pulls all questions randomly, but not repeating any)...I then want the code to pull the question and coorepsonding answers to pick from in a radiobuttonlist. However, It only needs to pull the number of answers. Example, a True/False will only have Answer1 and Answer2. The other Answers will have the NULL value in it.
There needs to then be a way to go through each one of these questions that have been placed in the table (in that random order) using a "next" button. When a question and possible answwers are displayed, I alaready have code to keep the answers in the session to grade it at the end (using correctAnswer and selected answer.I have no specific way to bind the data to the Database. I have used SQLDataSource to make other connections before, but I don't know if this is the best way.
I was wondering which way would be the easiest in VS2005 to connect to and pull data from a MS SQL database. I have already setup the database connection by choosing the datasource for a DataGridView but I'm not able to retreive any information.
The steps I have taken so far:
1. Make new form
2. Drag and drop DataGridView onto the form
3. Setup the data source and respective username password
I am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click Dim SearchPatient As String = txtNPatientID.Text
When it is installed on a machine, it will run for all users. But for some users, it is unable to get some data from the database. I have found out that if it is run-as either administrator,or in winxp compatibility mode, it works. But if not, then some users have the problem.The database is in the same C: drive location as the exe, and it doesn't change from user to user.The computer is using windows 7 professional 32-bit.
when I try to publish my project, I have this error: Cannot continue. The application is improperly formatted.Contact the application vendor for assistance. [code]
I have wirttend a code in VB.NET 2005 where i fetch the data from DB and this data has date also. I read the date format of excel and the change the date format accordingly in my VB.NET code. I have set the date format in regional setting is dd/mm/yyyy and while reading the date fromat of excel in vb.net code there i find that the format same i.e. dd/mm/yyyy and then i change the date in this format accordingly. However the result which i dispalyed in Excel 2007, found that the date still shows in mm/dd/yyyy. I am surprise how it happening.
I am trying to pull sql data into a text file. The code works just fine, until some new data comes in from lazy employees and a couple fields (used for notes/comments) are now left blank. Originally I've never seen them blank so I didn't think anything of it. col2 = myreader.GetString(1) It will error if the field is ever null - I even tried using a case when: case when note is null then '" & empty & "' else note end and set the variable emtpy = '', but vb still thinks that it's null and errors?
I'm trying to weave a .NET performance counter into an application. When I call the incrementBy(value) method on my avg performance counter it is changing the RawValue of my base counter by value as well. I checked the variable names and think everything is correct. Then when I call increment() on my base counter it adds 1 to the rawvalue of the avgcounter as well as incrementing the base counter... adding insult to injury!
In code I'm using two different counters to measure the time a merge sort I wrote takes. I have a instantaneous counter for the elapsed time of the sort and an average counter. Dim timePiece As New Stopwatch() timePiece.Start() MergeSort() timePiece.Stop() [Code] .....
I think I may be using the counters wrong, but why does changing the rawvalue of the average seem to also change the rawvalue of the base? i dont think that's supposed to happen.
I am having a bit of trouble with a countdown timer I am creating. I work in a call center and the average handle time of each call is important, so I created a countdown timer for the agents to use to help them manage their call time. Along with a tab for the average handle time (AHT), there is a countdown timer for their break time, and also a stopwatch tab. It functions well, there is only one snag I am encountering. When I am on the "AHT" tab for example, the timer counts down from 8 minutes in the format of 00:08:00. (hours, minutes, and seconds are all in separate text boxes) When I click start to start the timer, rather than counting down from 8 minutes in this format, it goes to 00: 8: 0. Then it goes to 00:07:59 and counts down properly.[code]This isn't all of the code for the program, but it is the code for Timer1 for the AHT tab, and the code for the start button for the AHT.
I generate a print preview, the only thing is, if there is enough data to fill like 2-3 pages I don't know how to generate a new page. It only fills the first page and that's it....
Private Doc As New PrintDocument() Private Sub btnPrint_Click(sender As System.Object, e As System.EventArgs) Handles btnPrint.Click[code].....
most of the code it's just pulling data from database and printing necessary charges to the invoice, but if the invoice is more than 1 page then I don't know what to do because it only generates 1 page.
I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,TimeoutI want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them.[code]
I'm having a weird problem with a custom Web Control in an ASP.NET forms application. For a web application, I figured that it would save me a lot of time to create a class which inherits from CompositeControl which combines a label with some other control such as a TextBox or DropDownList. This composite control has several properties that wrap properties of the underlying properties (e.g.: EnteredText wraps TextBox.Text). The controls can be used for databinding in the same way as the regular ones, but instead of txtBox.Text = someObject.someProperty you use compositeControl.EnteredText = someObject.someProperty. These controls are then used on ASPX pages and ASCX user controls.
it shows up correcntly on the datagrid view though with the same code above expect the bit in bold changed. How would I get the data to show on the listbox?
Ok I have a datagridview that shows a bunch of data through a Database. So I have the script connect to the database and I have a while loop going so that it keeps searching through the database to make sure it "publishes" all of the data in there. My problem is, it doesn't show the first set of data. For example: I have 2 columns, one header is Name, and the other is Y/N. The data in the database:
Jim, N Alex, Y Pat, N George, Y
When I run the program, and it populates the datagridview, the first set of data is removed, so it only shows Alex, Pat, and George. Does anyone know why this happens? Does it perhaps have something to do with the column headers writing over the first set of data?
i add a rectangle and label to datagridview...my problem is that when i load the form the rectangle only shows on the last add data..how can i make all the data display in rectangle not only the last add data.[code]
I have the Timer set at 2 seconds for now. It pulls the data in fine, sets the text for the label fine. But it only shows the last row of data and does not rotate through the rows.
Public Class MarqueTest Private Sub MarqueTest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.AdminMessTableAdapter.Fill(Me.MarqueDataSet.AdminMess)[code]....
I've been trying to highlight a search result in DataTable. First, I loop through rows of DataTable and call a function to look for a matched keyword to highlight those words, then update DataTable row with a new string with highlighted keywords.I bind the DataTable dtResult to the DataList. It worked fine until I added this code block to SearchDemo function to highlight the keyword :
For i = 0 To dtResult.Rows.Count - 1 Step 1 Dim strTemp As String = dtResult.Rows(i).ToString strVerse = blHelper.Highlight(s, strTemp)
I've got an xml file that i'm trying to bind to a combo box. i'm trying to save the selected value of the combo to another text box. when my form initially loads, the text box shows System.Data.DataRowView instead of the currently selected value.i've read on other posts that this can happen if you don't have the right column names specified. but i'm pretty sure that's not my problem... because i'm not using string values for names, but referencing them by index. also, the actual combo boxes do display the list of values.[code]...
