So what i am trying to do is get what i query to write to a text file i am having trouble getting my variables right so th at i get my "smessage" format to spit out so called data[code]...
View 1 Replies
Im trying to get some particular content from a site and place it in text file. i have used a listbox for loop of urls i want to process and another to see output of data. now i want all data in text file each item seperated by "~" sysmbol.
Exmaple Link i used in my.txt file: [URL]
Data expected in text file:
Abbeville High School Basketball Stats ~ Team: Varsity 11-12 ~ Colors: Maroon, Gray, White ....
Imports System.IO.StreamReader
Imports System.Text.RegularExpressions
Imports System.IO
[Code].....
I want to write the data to a file which in an format that is only understandable by my program, and if any one opens it in notepad must not be able to read(understand) it.
View 8 Repliesi Have Used Database file for storing Data in my Application.Now I want to take backup of data in Access, Excel or in Any other Format.
View 1 RepliesIs it possible to output a graph drawn in vb.net and plotted with data to a pdf file format? or any microsoft office format?
View 3 RepliesI work in an engineering design house and programming is not my actual profession. And I am relatively new to VB .net (previous i had worked in vb 6)
I am working on an in house application. I am coding a simple application in vb .net. This applications takes a few inputs from user and calculates a result. Now I want to implement a simple functionality that user should be able to save the input and results just like most of the windows programs can in a new file format. And user should be able to open the save file when desired.
I have a DGV that is getting data from a sql db. The dates in this db are stored as doubles ie 40025.708681
How do I format this column as Date/Time?
I tried but this doesn't seem to work.
how to do this? DGV1.Columns("HostDate").DefaultCellStyle.Format = "d"
I'm new to .net. I would like to know how to convert a text data in string or in a file into a simple byte array[ ] format.
View 3 RepliesThis the test example.
Dim dt As DataTable = New DataTabledt.Columns.Add("StartTime")dt.Columns(0).DataType = System.Type.GetType("System.TimeSpan")
[code]....
i just write code for application, in which data is get by user and entered data is to print in a particular format?give me a code for vb.net button by which after click on it will print entered data?
View 1 Repliestrying to find a decent answer for my question; I do have a utf8 file which I (down)load, manipulate and wanting to save back again.The result always is that the file I produce is not in utf8 format;
Dim fs2 As New FileStream("c: est.dat", FileMode.Create, FileAccess.Write, FileShare.None)
Dim w As New BinaryWriter(fs2, Encoding.UTF8)
[code].....
how I could check if a certain file is in text or binary format?I'm using VB.Net 2008 Express.
View 2 Repliesin one of my table i use some date which has quantity and unit in it
for eg
"quantity" "unit"
10 pcs
[code]....
( for both quantity and unit i am using two different columns)now the thing is that i want to the total quantity as per units in one text let say textbox1 in this format
"64 pcs , 27 mtr, 12 sets"
how to get data in this format.
i have a structure of;
name
age
gender
location
then i need to read in a file into an array on the structure above, and pretend this is the file which has 3 people
george
45
m
usa
[code]....
so basically i dont get how to read in a file then put it in the array in that structure then make it into a csv file?and whats the difference between streamreader and streamwriter?
i am a beginner and trying to write a program that can convert .dwg file into .xml file format.i am familiar with visual studio 2008, vb.net and autocad 2007.my question is what do i need to do or learn to start this project?
View 2 RepliesI am implementing RFC 1350/TFTP in my application. I've got everything figured out and working as expected except for NetASCII transfer mode.
"A host which receives netascii mode data must translate the data to its own format."
That's the part that has been bugging me for a while now. get NetASCII mode working correctly?
i am doing a VB program using four for loops to generate a set of numbers using the following code.[code]i need to export the output of this program to CSV format.
View 3 RepliesI'm playing around with the Select Case structure and have the following code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim colour As String = InputBox("Please enter the name of a colour.", "Colours")
[code].....
my code is working fine, but the output shows for example 12345.000 i would like to only show the data before the .000 is this posible?
[Code]...
does anyone know a simple code that would save data in zip format ?
View 3 RepliesI am wanting to develop a VB program that will access a web page containg XML format data and pick out one number.I have opened the web page and see the number between tags <*> <*> how do I point my search to the web address, I have found XML examples of data being searched when the file is on your hard drive, how to point my program to a http:// web address and then how do I scan or search for my number?
View 1 RepliesI have a large data.DataTable and some formatting rules to apply.For example, the LASTNAME column has a value of "Jones" but my formatting rule requires it be 10 characters padded with spaces on the right and uppercase only. Like: "JONES "My initial thought is to loop through each row and generate a string. But, I wonder if I could accomplish this more efficiently with a DataView, LINQ or something else.
View 1 RepliesI have a label that displays information from my database and I need to format it. It displays a number format like so: (53389) and I just need it to display (53,389)it uses the SQL to COUNT or SUM the data from the datasource. is there a way to have it format like I want when it is displayed, or do I need to change the data format in the database?
here is my code:
Try
Me.MAINTableAdapter.Fill(Me.MainDataSet.MAIN)
Me.MAINTableAdapter1.FillByExceeds(Me.BurnListingDataSet.MAIN)
[code]....
I am currently reading a table from Access database and displaying it a DataGridView. Here is my
Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ....db1.mdb"
Dim SQLString As String = "SELECT Cost, Average, FROM expense_summary"
[Code]....
All the files in my access data base are numeric (database cannot be changed) but I need to change the value formats in the table. I want to convert one particular cell in the table to a percent with one decimal and also display the '%' symbol. Similarly, I want to round and display a '$' symbol in another cell. How would I do that? How would I select a specific cell in this table to change?
I am developing windows application. Now I have got the data in the data set . Now I need that to be displayed in the table format, not in the grid.but in the table format as we get in web applications.Is it possible to achieve it? If so how could it be archived?
View 1 RepliesI'm looking to get the following code converted to working VB.NET code. I need to export data from a datagrid into the CSV format that the user can save off, and the code below from David in Dakota would work great, but it's in C#. This is for a Silverlight 4 site we're working on.
private void exportHistoryButton_Click(object sender, RoutedEventArgs e)
{
string data = ExportDataGrid(true, historyDataGrid);
[Code].....
I have a string like the following.
<td>aaa</td><td>bbb</td>...
Now, I want to extract each of the <td>...</td> group. How shoud I do this?I tried to use xml to do this. However, since xml doesn't support < and & in the content area and I can't guarantee there is no such two characters.
I have a dgvAssetsSummary which holds data queried from the database, it hold's the AssetType column and Total column, it's grouped by AssetType, giving a summary of all the totals and what assettype they belong to.I'd like the Total column to be formatted so that there are no decimals and with commas, at present each total has four decimal places and no commas, this needs to be able to be read easily by clients. I've tried using the following code to format the column after I query the database, but to no avail.
dgvAssetsSummary.Columns("Total").DefaultCellStyle.Format = "#,#"
how to do this, I've had a bit of a look around but I can't find much. I'm currently looking at a couple of pages from the msdn library about it.
Back on my form with a ton of financial data entry textboxes but I want to have the data formatted at runtime, as I enter the data.I have a format declared as Public Const cFmtCurrency = "##,###,###" ' don't need decimal for the local China currency What would be the least compicated way to have these textboxes (19 of them) format the Long Integer values as I enter the data. I think a Lost Focus event would be silly; there must be a better, more efficient way.Also want to use this format when I retreive records from the db (don't see a reason to mask data in db)
View 7 RepliesI am using VB2010 and have a project set up with a DataGridView that is to display a table of data selected from a SQL 2008 database using a pre-defined dataset. My question is simply how to display the data in the intended format as seen in the attachment. I am attempting to merge rows in the first two columns of like-data. Addtionally, if that can be done, I would also like the user to be able to double-click on a name that would open an editing form.
View 5 Replies
