Updating an Excel file from a dataset seems to work fine. But if I have text that's longer than 255 characters then I get the error above.I've been working on this for a couple of hours and I haven't gotten anywhere. I've tried messing with the connection string and changing a registry setting, but no luck.
View 2 Repliesi am writing an application that will need to store less than about 1mb of data. this data will be read and edited by the user. this data will be very simple ascii data. the application is in vb.net on a windows-form. the data will be stored locally on the person's computer.i have several questions.what kind of encryption method should i use to store the data? the user wants something that is not too powerful, but not too simple either.how should i store the data? why not just write it to some file and encrypt it using some medium encryption method?is application settings data encrypted? perhaps i can store it that way? is it suitable to store about 1mb in application setting data? how would i do this? which variable would i use?
View 3 RepliesThis error has me completely baffled. There is no indication (that I ca FinD as to what field won't handle the information. Heres the situation:I am using an Accees query to insert a new record in a table with 49 fields. Of these fields, 1 is an integer, 7 are booleans and the other 41 are text fields. The text fields represent either Time of Day or a Timespan.
My field sizes are:
For time of day 8 digits(example 08:00 AM)
For a time span 5 digits(example 03:30) I will never exceed 2 digits for
hours
I have checked every field in the dtatbase and they are all as noted. I am at a loss as to how to proceed.
I have made a new form on vb 2010. I need a small box which updates itself automatically to show the amount of years,months,days,hours,minutes and seconds from the 25/6/09. How would i do this in visual basic 2010?
View 3 RepliesI have a field called PODate & TextBox txtPODate.text. It saves/updates fine when the txtPODate is filled. But when the txtPODate is blank, it throws an error. The problem is that I can't enter date for each record unless I got Purchase requisition converted into Purchase Order. Once it is converted to PO, I need to enter the date to update that filed. So, how can I make my program to accept blank date field.
View 6 RepliesIf I have a form that has a text field, and I want that field to only accept numbers or backspace, I can create a sub such as:
[Code]....
I am building a data based application using VB 2008 an SQL Express. I need to create textboxes on my form using code, (With & End With) method. I need a simple code string that will allow the app to check if the field to wich the textbox wil be databound is Nul, If so the textbox will not be created.
View 8 RepliesI have an application that uses Dataset.WriteXML to create a small backup before data is syncronized to a data store (less than a meg).This application has worked well for 5 years now, and all of a sudden with the installation of XML 6.0 SP2 the XML document is not working correctly.I have multiple tables within a Dataset (Company, Contact, Notes, etc...)When WriteXML is called, the first table should be Company, however, the first table is being named Contact with the Company Data in it. The Notes table is being called Contact and so forth. In other words it's not giving the correct names to the tables in the XML File.This appears to be a bug, which is causing great distress on all the companies who have been using this program.
View 3 RepliesI have written a small project that saves data in a data set, this part works fine, but I have some errors with the code I have written for importing excel data to the datagridview and exporting data from the data grid view.
This is a test project for me to learn how to do this stuff, so I will post the code for the entire project so you can see what I have done from start to finish.
[Code]...
i have a datagridview binded with the datatable via its datasource property....now i want to add the Amount column of the dgv and display the total amount in the textbox,if the amount is greater than a certain value then i want the cell to coloured red so i did this code and it worked great:
Dim i, j As Integer
For i = 0 To DataGridView1.RowCount - 1
j += Me.DataGridView1.Rows(i).Cells("Amount").Value
Next
[code]....
but my problem is that i want the red colour of the cell to blinkafter every 2 seconds....how to do this?i need to handle the timer tick event for this but i am not able to do this.....
I want to know how to accept data from user? I want to accept about 10 datas from user. Before this I use Input box, but it is not a best way for user to key in 10 times data that required. What should I do and what the appropriate way to accept 10 data from user in 1 screen?
View 2 Repliesim trying to make a simple program that calculates the time it takes to cover x amount off nautical miles at x amount off knots, the code i have so far is this :
Code:Public Class Form1 Private Sub Label2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label2.Click
End Sub
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
[Code]...
so if i say want to cruise 29 miles at 12 knts it gives me an awnser of 2 hours 24.6 mins instead of 2 hours 25. Although i do realise that 2 hrs 24.6 is technicaly right i was wondering if anyone here could help me with getting it into the correct format?
im trying to make a fast food program on which the user will input the amount that he has, then he will check on what he wants, by using check boxes. There are 7 different check boxes with 7 different amounts of money. I have the program somewhat finished (thanks for the people that helped me before) but theres still a couple of things that I still need to get finished but I dont know how to.I need to be able to get how much money the user has (this will be entered threw a text box, I think I accidentally messed this part up, because I cant get it to work right, (theres alreasy a permit amount of money in there and it needs to be what the user enters instead of the permit, 5.59, one) and this will be the maximum amount he can spend, then the user will check on the food he wants (and the program will add the sales tax also) then it will produce an answer saying if you have enough money or if you dont. But what im confused on is how do I get the users amount of money and make it the maximum mount he can spend and make sure it doesnt go over the amount that he has checked.[code]
View 1 RepliesI need to make a small programm for ticketing on a parking for a small hotel.So i have 2 Printers pariking In (for delivery of the tickets) and 2 Readers PArking Out.Both Printers and REaders are working Serial.So i need to poll the serial ports of the printers and readers every second.The data is stored on a SQL database so i need to read and write in the database.Can i do this with 1 PC and 1 programm or 1 PC and 4 programms that are runnning at the same time ?
View 2 RepliesOn form 1 , i have a number of buttons that open up different websites.What i want to do is when i click a button on form 1 , i want forum 2 to show ( Form2.show() ) , Form 2 will have a list (Buttons) of internet browsers.
View 4 RepliesI've found a scale, Detecto AS-350D [URL].. that hooks up to a computer. I was hoping someone could help me figure out how to get the information (weight) from it. I've looked around but can't seem to find any information on it. I've never wrote a program where I accepted data from a device likes this so kind of confused where to look.
Update: I'm coding in VB, and the device connects to the computer via serial port.
I just re did my question and added a few other scripts needed to pull everything together This is the small script I am using to receive the post and push the data into the SQL Server (2008 if that matters):
[Code]....
I am working in a point of sale system in Vb express 2008. I want to convert the Amount in Figures to Words like: How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.
View 2 RepliesI am working in a point of sale system in Vb express 2008.I want to convert the Amount in Figures to Words like:How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.Please advise how to code for that in Vb express.
View 5 RepliesI'm searching the same title "Large amount of data in ComboBox" last 1 and half years but I could not get what I'm expecting! Here is my case, I have 20 thousand unique products, I just fill into dataset & bind only two columns in the combobox for searching & validating the product if it is exist in the product list or not.
1) I read about dataset but all articles are described "Dataset only for few records because it is sitting in-memory". If I fill few records (100 or 1000 products) into the dataset, how can I search & validate REMAINING (NOT FILLED) products?
2) Is there anyother way without filling into dataset and bind to combobox? Can anyone suggest me which is suitable for me?
I'm wanting to put a random amount of data into an array, or an arrayList or some other collection.
Then say>
Dim myItem As Object 'It might be a string or a number or whatever. In this case
Integer or String probably.
' then say>>
[Code].....
I'm working on a project at the moment, where all the data being loaded is kept in an XML file which until now have been rather clean with structures such as
Code:
<Textures>
<Texture id="1">TerraingrassDirtNW.png</Texture>
[code].....
I'm trying to fill a ListView control in a VB2005 project. It works fine from underpinning (Access) database IF all the data is present. However, if a field is blank (in this case - a field called "Actual Date" which is meant to be blank for this record), the ListView will stop populating at that point.I thought this may have been the 'CausesValidation' property of the ListView but that doesn't seem to change the behaviour.Is this an inherent feature of the ListView - if so it seems daft - or is there a property I need to change or an override that I need to code?
View 4 RepliesIs it possible to use VB code to code an application that can merge Hex data from a small (50kb) .dat file with the hex data from another small (50kb) file? This would require designating specific offsets, which I can pre-program, but If I could have user input this would be preferred.
Example.
Hex_1.dat
00 00 00 00 00 11 11 11 11 11 (Offset = 5)
Hex_2.dat
22 22 22 22 22 33 33 33 33 33 (To offset = 5)
Result file
Result.dat
11 11 11 11 11 22 22 22 22 22
Is there another way to easily make a POST request in .NET other than the WebRequest class? I have a very, VERY small piece of data I need to post: password=theword but WebRequest randomly, and I mean randomly, drops the data when posting to my server. I've tested it by using a chunk of code from my server that dumps the request to a console, and I can that the client is sometimes sending and sometimes not sending the POST data.The code that I'm using that uses WebRequest works in another project, when talking to IIS. The server being talked to (a minimal web server in another system) responds properly every time I POST data to it through Firefox. I've got a function in the same project that fires off a GET request, and that works. It just seems like my POST function isn't completing the transaction...something I've noticed in the past when asking WebRequest to handle small strings.[code]
View 2 RepliesI tried to follow this advice, but I still run out of memory.
[URL]
Basically, I am reading all the bytes of a 1 gb disk and I want to try and do a md5 hash on it. However, when following this example, my cryptostream gets too large a System out of memory exception.
Is there another way to do the md5 hash over some much data?
I am currently reading it into 10 million bytes arrays at a time. Can I hash the first array, and then use it as a seed for the next array, and so one, like you might do to a CRC32 calculation?
I am trying to show a large amount of data in gridview but the problem is that everytime data increase the gridview row size increase automatically.
View 4 RepliesI'm at a compleate standstill with my homework here's what i have so far <summary> Validate the data from the Amount Invested TextBox. It must be at least $500 and no more than $2 million, including up to 2 decimal places. Set the MaxLength property to manage the number of digits entered.b.If Amount Invested is in the valid range, calculate the table and display it in a clearly-labeled, read-only, multi-line TextBox.c. display an appropriate message and calculate the table for an Amount Invested of $1.
[Code]...
is my code in VS 2008 (VB) to show Crystal Report. but crystal show saved data not my dataset:[code]
View 4 RepliesI have a value of: "2.54334881002458E-37" and i keep getting "overflow" exception when i'm using a double.what should i use to make this work?
code snippet:
Dim curries, act, cat As Double
For Each dataRow As DataRow In dt.Rows
curries = dataRow("Activity")
getting the error when i try to assign Activity to curries.but "activity" is a string in the database....