I am working on a database for a program. I used the .mdf file, created a table, and tried to store data in it.I did not build the program yet. I am still using it on a test drive or debug mode.I added three records to the database.I closed the program for 10 minutes and went back to writing code for it.When I opened up the program again, the database only showed that I had one record.This happened before and after I wrote other code for my program.I only started having the problem today?Is it possible that there is not enough room in the database to store all the records? The variable sizes for 3 of the fields are 400, 500,500, and 1000 and the other fields are like 50 each.All together there are 7 fields. I encountered the error after i had made one of the fields a look up field.In this field, basically I loaded categories stored in an extra files into the comboBox so users can select values without having to retype it.
Can you tell me what the error is and how I can fix it or what I am doing wrong in the program?How do I set up another table and query it to pull the values I want for the comboBox field?
I have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
I created a database (.mdf) file. I added data to it after running the program in debug mode. When I closed it and opened it up again, the data I got was stored and loaded again.I closed my whole Visual Basic Express program. When I opened it up again, all the data had disappeared.
Can you tell me what I am doing wrong with the program? I can't get queries to work either. It worked when I used the NOrthwind dataset this past weekend but it is not working when I use my own or empty dataset.
I have this code which displays a login form, i want to encrypt the password before it stores into the sql database and should also be able to verify the pwd when a user logs in.
how to temporarily save the user input to the pc he is using then save to another pc in the network later. Our LAN sometimes disconnect or there maybe power interruptions and I don't want that the input of the user disappear due to disconnection or power interruption. What is the easiest way to accomplish this?
Here's what I'm working so far. The data saves to another pc.
Imports System.Data.SqlClient Public Class formGrammarI_Page01to04 Dim db As New EPTR_DataDataContext
I have a sub that i wrote only to temporarily fill the database in during run time to be able to test a few other functions that i wrote as well ... weird thing is by the way i wrote it it should only look 100 times... but by the unique ID in the database and the information it pulls back into my list box it loops 700 times before actually stopping the loop ...
Public Sub Fill_LeftOvers() Dim x As Integer = 0 conn.Open()
[CODE]...
Now i used step debugging and sure enough it only loops 100 times during stepping but in the database it looped like crazy ... i have also tried while x < 100 instead of the do loop but it did the same thing ... i know this may be considered a double post i mistakenly posted originally in the PHP forums earlier today ...
create a message box that stores my user name, message, and post datetime into the database as messages are sent. Soon came to realise, what if the user changed his name? So I decided to use the user id (icn) to identify the message poster instead. However, my chunk of codes keep giving me the same error. Says that there are no rows in the dataset.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim name As String Dim icn As String Dim message As String
Ok, so I`ve been studying a bit of VB lately.. bought a few books and read lot`s of articles and seen hours of instructional videos, and I slightly start to get the hang of a few things.. :) I`ve recently started a fun little project, but I seem to lack a bit of knowledge to reach my goal. I`ll first try to describe my project:
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
i have a Windows service that is hosting a WCF service through net.tcp and this is working great. I have also created a WCF service application. I am trying to add the net.tcp service reference to the service application. Then I add it to the GAC that goes ok but if I try to RegAsm the WCF service application to allow it to be called from Server.CreateObject I get the error:
Warning: Type library exporter encountered a type that derives from a generic class and is not marked as [ClassInterface(ClassInterfaceType.None)]. Class interfaces cannot be exposed for such types. Consider marking the type with [ClassInterface(ClassInterfaceType.None)] and exposing an explicit interface as the default interface to COM using the ComDefaultInterface attribute.
It does not work. I have tried to call it through a class library but this does not work either as the end point is not set correctly.
good tutorials where i can read about the actual object oriented concepts which we use in real time scenarios. Not the "class is a container. fruit is a parent class and apple is a child class" kind of stuff.Recently i was developing a multithreaded GUI application in vb.net and found out many obstacles like using one form's element in another form, changing form property in other class, when to create objects to access elements and many other stuff stumped me.
I'm trying to pick up some simple object-oriented programming skills so I am trying my hand at beginner's problem - and I am totally stuck...I'm trying to write a program that will print to a label, the area and perimeter of your shape of choice, dependent on the Length and Width (for Rectangles and Triangles) or Radius (For Circles) you input and the shape you select.
I know how to do this easily with simple event-driven programming, but I'm trying to do this by using classes and inheritance.The idea I have is that you enter in length/Radius and/or width into text boxes (txtLen, txtWid) and then you can click a button to display the Length, Width and Perimeter or Radius and Circumference, and Area.
I'd create a Super-Class: Shapes to define my overarching parameters - all shapes have area and perimeter. Then I would create sub-classes for each shape inheriting the overarching "Shapes" class - dim'ing all of their respective extra pieces. Then the buttons would display the appropriate info when clicked.I understand this seems like a lot - but really I just need help getting my feet on the ground for this.
So having read some of the PostSharp documentation presented as an answer to my previous question regarding passive logging ([URL]), I am led to my next question: Where is a good place to start learning about Aspect Oriented Programming - I've done some searches on Google and I've read some articles - including the article regarding the topic on Wikipedia, but a lot of the material seems to assume you have a basic understanding of some of the terms which I seem to be missing, and that which doesn't just dives straight into integration leaving me not understanding what exactly it is I'm integrating.
Does anyone have any decent material targeted at someone who's never heard of Aspect Oriented Programming before today learn about the core concepts, terms/keywords etc? Even a birds-eye - i.e. These are the core concepts, keywords to look out for, what they stand for and how they fit together. After that, I can probably make some decent headway on my own. I'm most interested in AOP in relation to .NET development,
Our company currently uses an APL model to illustrate our life products. We are in the process of converting this to Excel/VBA because the APL system is extremely difficult to maintain.APL is difficult to maintain because the code has become over the years (~15yrs) spaghetti and only a select people (who have worked here 5+years) really understand this to make updates when new products come out. APL is also not well known and difficult to understand. I just would like help on designing the system, my main career is not a programmer, and the design I was envisioning was a "Procedural" approach. (the APL is procedural rather then object oriented. I have not used object oriented code before)Basically the program illustrates a life insurance product. That just means it projects a fund out from the time the policy is issued to age 120. The illustration is given to the policyholder as a way of predicting what the value of their fund will be given some assumptions.The program does the following1.) Populate Variables2.) Calculate Premiums Types3.) Monthly processing4.) Output values to spreadsheetThe system has to illustrate different types of Products and we are adding new products to the system. Most of the main structure of the program (in VBA) is already written. It seems that (#3) monthly processing will vary by product, and I would like help with maintaining that part of the code. The other 3 parts of the program are not a problem maintaining.We will be continually adding products. We will start with about 5 products and maybe add about 5 per year.Here is the Monthly Processing code:... Call MonthlyProcessing(120, PremPayMode0, Assump0, True, DumpLumpSum0)
I need to write an program with two players rolling a pair of dice and the highest tally wins with an Game class having with two member variables of the type PairOfDice. I can not get it to work.
i am new to asp and am currently trying to get my head around the visual basic language and Object Oriented Programming.From what i have read you need to have a good understanding of these to create good ASP.NET webpages, but from reading about these in books and joining the website [URL]..i am getting fairly confused with the language and the OOP. Does anyone out there have any tips for me when it comes to learning about these. Is there a good way to learn about these as i just seem to be getting really confused from the start.
I have a problem in my program in VB I have a serial number and if you want to add a new registry stores Descending including what it means to become the first number in the second line and the second number in the first line and the meter, but I have calculated the last number and all that give me a new number # 2
I have some lines drawn in many different directions (2D y 3D enviroments). Is there any way to draw text oriented along the direction of each of these lines? It was an easy task in former versions of Visual Basic, but now it looks like a very tough -almost impossible- mission.