Trying to create an ASCII table using vb So far i have
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
sCalcASCIICharacter30to54 = lblcalcASCIICharacter30to54.Text
For iCounter = 1 To 24
sCalcASCIICharacter30to54 = Chr(iCounter)
[code]....
It does not output anything.
I am using Microsoft.VisualBasic.Fileio.TextFieldParser to parse a CSV file that was created with Excel 2003. The parser is working great with the exception that it is converting extended ascii values to question marks! So if the file content was:
± 3
The TextFieldParser is returning
? 3
I have tried all of the encodings in the System.Text.Encoding package with no luck. I thought I had it with UTF7 but it was dropping other characters like replacing the + sign with a space.
I'm working on decoding a NMEA sentence that is a compressed 8-bit string. I'm having a very hard time of wrapping my head around the bit manipulation needed to convert this string. If someone could get me started with this it would be great.
Here is the incomming string:
!AIVDM,1,1,,A,14eG;o@034o8sd<L9i:a;WF>062D,0*7D
and here is the expected output:
[code]...
I need to create a Digital terrain model from ESRI ASCII grid format into an array. First I need to use the column and row values (from the header information) to read into my file to specify which values to put into the array. I think i have to use both counters simultaneously, and although Ive read in the first line (columns) I can't get the next line in. Do I have to use a counter under a different name, and can I do it in a nested loop?
vb.net
Private Sub Input_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Input.Click
dlgOpenASCII.ShowDialog()
filename = dlgOpenASCII.FileName
[code]....
The latest assignment from my teacher was to create a console program where the user enters a character and the respective ASCII value in Denary, Hexadecimal and Binary, Even Parity, Odd Parity and Hamming code is returned.I've managed to implement all of them except the latter with relative ease, I am familiar with the concept of Hamming code and can compute it easily by hand, but don't really know how to implement it as a function in my program. [code]
View 1 RepliesI would like to pass a whitespace character by using the System.Text.Encoding.ASCII.GetBytes(" "), and System.Text.Encoding.Unicode.GetBytes(" ") , where " " is the whitespace Character required. What do I need to type (" ") to get a whitespace character passed.?
View 6 RepliesSo I have an ASP.Net (vb.net) application. It has a textbox and the user is pasting text from Microsoft Word into it. So things like the long dash (charcode 150) are coming through as input. Other examples would be the smart quotes or accented characters. In my app I'm encoding them in xml and passing that to the database as an xml parameter to a sql stored procedure. It gets inserted in the database just as the user entered it.
The problem is the app that reads this data doesn't like these characters. So I need to translate them into the lower ascii (7bit I think) character set. How do I do that? How do I determine what encoding they are in so I can do something like the following. And would just requesting the ASCII equivalent translate them intelligently or do I have to write some code for that?
Also maybe it might be easier to solve this problem in the web page to begin with. When you copy the selection of characters from Word it puts several formats in the clipboard. The straight text one is the one I want. Is there a way to have the html textbox get that text when the user pastes into it? Do I have to set the encoding of the web page somehow?
[Code]...
I created a function that creates a global temporary table to stage data from a excel sheet I need the table to persist for me to map the columns using a form. The table is still there when the code goes back to the sub that calls the function until I call the form where I do the mapping. I am trying to avoid create/drop table scenario with a perm stage table.How can I get this table to persist until the data gets loaded into the perm table?
View 8 RepliesI am working with a Vb.net 2005 application. On the application I have a Create table button which when clicked creates a table in Sql server with the code shown below;
Code: Private Sub BtnCrtTable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnCrtTable.Click
[Code]...
This is really a pre-defined table and the data is already specified to be inserted to the table. However, my primarily task is to read a flat file which has the data and consider the first line as the column to be column names.
Therefore, initially I created an open dialogue to browse for the text file and store the path such as E:Datafile est.txt, in a TextBox1 visible at run time. Now the task is to change the above "create table" to read the txt file (column names are on the first line) and then create the table in the database.
I'm trying to create table in my database, that would have name like i type in Textbox and than i have to click the button With code like this :
sqlCmd.CommandText = "CREATE TABLE NAME = '" & TextBox1.Text & "' (First_Name char(50))"
I'm getting erorr : Incorect syntax near "name that i type"
i am using visual studio 2005 and database sql server 2000. i want to read table of database and readed data insert in temporary table again update that inserted record.
View 3 Repliesin my application I have 2 different dataset.[code]How I can accumulate all content of second table in the first table (table_completa should store the result of all query) table_ Completa = table_completa + table_query..Remember that the table are in 2 different dataset
View 11 RepliesI am working with VB.net and Sql server 2005. I am creating a mini application to load data to a database in SQL.Presently, I have a form with a browse button where you can select the file you want to load. This file extension for example is E:DatatobeLoaded est.txt. This file extension is then shown on a text box (TextBox1) on the form.
I have another button called BtnExport. What I want to do is when this button is clicked the code reads the data in the table test.txt, and connects to SQL and creates a table. Now, by default the first line will be column names. (It is similar to the create table option you have when you import data to SQL).
The sql Connection is :
[Code]...
I have the follwoing code which reads a .txt file on my form and shows the path on a textbox called "TextBox1".
Private Function GetDBName(ByVal filename As String)
Dim MyStreamReader As StreamReader
Dim pathfile As String
[Code].....
i am designing an invoice billing software using vb.net. i need to add the products, rate and quantity. how can i set a table for this?
View 6 RepliesI do not know what happen to my program. there is one table, if i want to view its properties, .net get frozen...try to create new table..it also gets frozen..
View 3 RepliesI am using vb.net to create a Word table. Everything works fine, except that it is very slow. It takes about 0.34 seconds to create each cell in the table. I am using an HP machine with i7 processor and 12 GB of RAM. At 0.34 seconds per cell, times 7 columns, times 189 rows ~ 7.5 minutes to create a small table! I must be doing something wrong, but I have no idea what it could be. The table looks looks fine.
My code looks something like this:
oWord = DirectCast(CreateObject("Word.Application"), Word.Application)
oWord.Visible = False
oDoc = oWord.Documents.Add(ClsGUIGlobal.TIMBERSCHEDULEWORDTEMPLATEPATH)
[code].....
I want to create an index on my table. I used the following command Code:
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:database.mdb;Persist Security Info=False")
cn.Open()
cmd = New OleDbCommand("Create INDEX itmno_idx ON INVENT (ITEM_NO)", cn)
cmd.ExecuteNonQuery()
Now I want to use this. Is there a file created with some extension when i do an Indexing?. Is the above statment actually index the field, ITEM_NO or do i have to use ALTER TABLE command? Currently I am getting error "Cannot execute data definition statements on linked data sources"
I have no problem creating it. I have created a yes/no (bit) field and set it's default to False. once created if i open the database this column shows data as 0 or -1 as expected. If i created it in Access it would display as a checkbox
View 3 Replieshow to create a table on a panel at runtime
View 3 Repliesi wan to create a table to show my sales report in vb,but we are not allowed to use datagridview what type of form we can use to show our sales report without using datagridview...?
View 2 RepliesIs it possible to dynaically create table name in MS Access:
Below is my CODE:
strSQL = "CREATE TABLE" + Me.Text + "( ID Counter," & _
"Name TEXT(50) NOT NULL," & _
"PRIMARY KEY(ID) )"
But, I am getting a run time error that syntax is wrong.
How to Create a Table from the recordset value
sqlCardEvent1 = "select * from tmp_CARDEVENT"
If rsCardEvent1.State = 1 Then rsCardEvent1.Close
rsCardEvent1.Open sqlCardEvent1, Cn, adOpenStatic, adLockOptimistic
cmdCardEvent1.CommandText = sqlCardEvent1
Set rsCardEvent1 = cmdCardEvent1.Execute
[Code]...
[code] .i am using oracle as database. i want to create table at run time that will remains in database to store info permanatly later.
View 1 RepliesIm trying to do an assignment at uni and it requires me to create a database and search the table?Ive created a table CustomerContact I want the user to input AccntRepNo and click a search button.ill use this number to search (query) my table dispaying all the records related to the AccntRepNo?Ive been reading alot about connections but i already have a database setup
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim repNo As String
repNo = AccntRepTextBox.Text
[code].....
i have a datagridview with (a lot of) rows. With a click of a button I add them into a table. Everything works fine. I want to create a log of the records that have been added into the table.
[Code]...
I have an App written in VB.net that creates an excel workbook.I fill the first sheet (1) with data, now I want to create a pivot table on sheet(2).
Dim Rstr As String = Rx - 1 & "C8"
ObjExcelB.ActiveSheet.PivotTableWizard(Excel.XlPivotTableSourceType.xlDatabase, _
ObjExcelB.Sheets("Data").Range("R1C1", Rstr), _
ObjExcelB.Sheets("PivotData").Range("A1", System.Type.Missing), "PivotTable1")
This throws a COMexception:Exception from HRESULT: 0x800A03EC
I have one problem in which i simply want to know how i can create a table that can easily Used as a back end for my solution that is in Vb 2010.
I also want to know that when we choose a data source in a vb.net that is for sql server Which we want to choose....simply which can be used Because there is 2 or 3 with little different name...
I am trying to do a home project and after many hours of failing to complete what seems to be a simple process I have decided to ask for some help. None of the examples I have found on over 20 websites is complete or works as the author suggests. (Im sure because of version differences)
I want to make a Visual Basic Program that, by means of clicking on a radio button and then clicking on a button named "create" will add a blank table to my db named by the string variable connected to a listbox where this name can be first entered before clicking on button1. Can someone help guide me in the right direction? The table needs to have three columns; Col1, Col2, Col3 -my database is named "Database.sdf"
Form/Interface info radiobutton1 'an option that if selected = true in the button1 click event will process the data that creates the table. textbox1 'table name input button1 to create table 'to run the process combobox1 'shows available tables that exist in the db button2 'click event shows the combobox (table) in the datagridview window button3 to delete 'to delete the selected table button4 to reset 'to clear radio button choice,textbox1, and combobox1 datagridview1 'to veiw the selected table Note: if also possible I would like a datagridview of the new table on the same form after it has been created.I am using Visual Basic 2008 Express, It is a microsoft SQL Server Compatct 3.5 Database
I am creating a roulette wheel using microsoft excel visual basic. I want to create a table with the amount of money you have that goes up or down based on wheter you win/lose. This is what I have so far:
Public Sub spin()
Dim speed As Double
Dim spin As Double
Dim maxspeed As Double
[Code]...