1. I having a project dealing with MsAccess database.
2. Currently the project connect the db using table adapter/data adapter method.
3. When I called a Me.SubjectCourseTableAdapter.Fill(Me.ProgrammingDataSet.Subject_Course) at frmCourse, it return me error message "System. NullReferenceException was unhandled Message="Object reference not set to an instance of an object.""
4. This line of code is just the same at frmA. Wonder why it will cause error at frmB.Besides, which is the better way to connect access? data adapter or ado.net?
I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc.One table will have data representing 47k reps that currently have credit for a transaction. The other table will be a mirror copy of the 1st table with 47k reps that were supposed to get credit for a transaction. This application is going to take credit from one rep. and give the credit to the other rep record in the 2 mirrored datasets. It's taking 30 seconds for the data adapter fill method to return records to my application. I would like to reduce the amount of time it takes for this request to process.
I am making an inventory program in which there's an ItemMaster and Sales Form. Currently there are 15000 records of items(increasing daily). I want to display all the items in the sales form so that the user can select an item from the list for billing, and also in the itemmaster so that if the user wants to edit any item then he can select it from the list.
I can make a common list form for both sales and master, but i have to load the data from the database into the list every time the list is displayed(which is taking lot of time), so is there an better way to do it.
I want to compress an ms access database using vb.net. If the database is open this fails. How can I close the database, compress it, then reopen the database using vb.net code to accomplish this. I've already successfully written the code for compression, but I can't find anything on closing the database while leaving ms access open.
VB 2005 Express Visual BasicI want to move (part of) projects to different projects/ computer.I used File - export template- and was able to save templates of whole project or item(s).They saved nicely in a subdirectory called "templates" as zip files.How do I import to 1/ other project on same pc?2/ To a different computer?I tried copy zip files into corresponding folder on new system. No luck.
Is there a tool to convert a VB.NET 2005 project to a C# 2008 project. I am trying to convert our project to VS 2008 and mostly port all the vb.NET code in some projects to C# 3.0/3.5.
Just copied a saved VB 2005 project to a new machin which has VB 2005. When I build or rebuild this project I get one error and 14 Warnings...Warnings and error are:Warning 1 The referenced component 'LCC11' could not be found.Warning 2 The referenced component 'Microsoft.Office.Core' could not be found. Warning 3 The referenced component 'Microsoft.Office.Interop.Word' could not be found.
How do I fix this error in Visual Studio? "The project file cannot be loaded. The application for project ... is not installed" I have copied a whole project onto my PC, both into My Documents/Visual Studio and into inetpub/wwwroot, but when I try to open the project in Visual Studio, it tries to open just 1 file .vssproj and gives me error messages, like : "The project file cannot be loaded. The application for project ... is not installed.". What am I doing wrong? The VS edition is 2005 as are all the projects aI am trying to load.
I had made a project in VB.NET 2005 with SQL SERVER 2005 used as database. Now i want to make a setup of this project but i am unable to integrate sqldatabase and .net framework in this setup project. Is there any way to do this. Because it is assumed that the client does not have .NET Framework installed nor he has SQL Server on his system and the worst condition would be he does not have even internet connection from where these two setups can be downloaded if we give the condition for downloading these programs from the net if the client does not have these programs installed on his machine.
I'm attempting to copy a rather complex form from one part of my project and use it (modified) within another part (ie, depending on whether it's maintenance or an outage, you'll get a slightly different email screen).
My first attempt failed miserably, as I had simply right-clicked and pasted the form within the project, assuming renaming the controls would work. nope, I didn't realise that there was stuff in the original form that was renamed as well, and that created a monstrous pile of errors.My second through fourth attempts also failed, generating errors in forms that (I thought) weren't related or connected. Once I deleted the copied form, all was fine.
So, short of trying to rebuild the form from scratch (using a different naming convention for my controls etc.), is there a simple way of doing this? This seems to be such a simple task, but alas I was wrong....(or, at least it's not easy with the information I have right now.
I recently found myself in a thread deling with convertions from decimal number to fractions... Being a bit too brusk and dismissing the idea at first.I have now implemented a structure based on code frm Javelia whithc can be seen in this thread.Solitare also proveided code that I eventually understood and was working.[URL]...it a step longer and developed a structure that can also implement calculating with fractions... My first try is also posted in the tread above...
The implimentation is far from perfect, as it does not deal with POW of fractions.. So if anybody has some ideas on hoe to do this with squer root and all pleas let me know and Ill update the code..
So I am making a file crypter so that I can encrypt my VB.NET Application that I am making so that people can't decompile it. I had made this in C# and am transfering it to VB.NET, Everything worked fine in C# but once I had re-written the code in VB.NET i get this error inside of my RC4 Encryption method:
'Arithmetic operation resulted in an overflow.'
The error is occuring here:
Dim t As Int64 = (s(i) + s(j)) Mod 256
This is the same code above in c#:
int t = (s[i] + s[j]) % 256;
Is there anyway to make that calculation with it erroring? And why does it work in C# but not VB.NET?
I have a function called Modify. It is delcared like so:Public Function Modify(Of SIMType As {New, DAOBase})(ByVal obj As DAOBase) As Boolean
You can see that this function is generic. It takes as a paramer a object that is a DAOBase or subclasses of DAOBase.Inside the modify function there is a call like so:
DAOToGP(obj)This is where the polymorphism comes into play. There are four or so subclasses I have created of DAOBase. I have written a DAOToGP() for each of these types. So in the Modify() function, when it calls the DAOToGP(obj), polymorphism should kick in and it should call the correct implementation of DAOToGP() depending on the type that I pass into Modify().
However, I get the following error:Error 20 Overload resolution failed because no accessible 'DAOToGP' can be called without a narrowing conversion:'Public Shared Function DAOToGP(distributor As Distributors) As Microsoft.Dynamics.GP.Vendor': Argument matching parameter 'distributor' narrows from 'SierraLib.DAOBase' to 'IMS.Distributors'.'Public Shared Function DAOToGP(product As Products) As Microsoft.Dynamics.GP.SalesItem': Argument matching parameter 'product' narrows from 'SierraLib.DAOBase' to 'IMS.Products'. C:Usersdvargo.SIERRAWOWIRESDocumentsVisual Studio 2010ProjectsSIMDev_2SIMIMSDVSIMLibGPGPSIMRunnerRunnersRunnerBase.vb 66 39 IMS
I am kind of at a loss here. I am not sure why it cant figure out which function to call.
my code works fine in JavaScript but doesn't work correctly in Firefox or safari and wondering why. What I'm doing is I have a loop going through each element and depending on the variable inside a text box just want to alert something. Like i said earlier this code works fine in IE. Here is the code below:
Here is an example of text box:
<asp:TextBox ID="txtMac" runat="server" req="yes" errMessage="Mac"/> for (a = 0; a < theForm.elements.length; a++) { if (theForm.elements[a].type == "text" && theForm.elements[a].req == "yes") { alert("Made it here") } }
I've been messing around with prime numbers for a while now, but I now want to use massive numbers, say a few million digits in length. Is there a way of storing and performing mathematical functions with such large numbers? Is it even possible on my home computer? I read on another old thread, something about a big number library, but the links he gave are now dead.
I have a website and say a user comes along and fills out the form with bogus data. Then after he fills it out, he enters another one and another one and another one of bogus data. He's basically just trying to clog up the data base.
How is the best way to combat this? Would it make sense to when they submit the data track the IP address?
I sure this has been asked more then once... New to vb.net and I have been experimenting with a datetimepicker and how it looks at and deals with time. What I am trying to do is to add up my time (not worried about the date at all). I have it figured out and can get it to work so long as I do not go over 24 hours... and that is where my issue comes into play.
How do I display my total time in hours once it has gotten over 24 hours ( I do not want days.. just hours) for instance, a 40 hour work week, not 1 day and 16 hours.
A partner of ours is making a call to a web service that includes a parameter called token. Token is the result of an MD5 hash of two numbers, and helps us authenticate that the user using our partners system. Our partner asks the user for two strings, concatenates them, runs them through MD5, and then calls our web service. The result of the MD5 is the token, and it is submitted to us as a string.
We store valid tokens in a DB - since we use the SQL Server to compute the tokens on our end, SQL seemed to be happiest storing the tokens as a varbinary, which is its native result for an MD5 computation.
We have two pieces of code that attempt to do the same thing - run a select query that pulls out a value based on the token submitted. One uses a dynamic query (which is a problem), but it works. The other one attempts to do the same thing in a parameterized (safer) fashion, it does not work - it is unable to locate the token.
Here's the two competing attempts. First, the parameterized version which fails:
byteArrayToken = System.Text.UnicodeEncoding.Unicode.GetBytes(stringToken) scSelectThing.CommandText = "select thing from tokenstable where token=@token" Dim param As SqlParameter = scSelectThing.Parameters.Add("@token",
Some tables I am dealing with have null values and are throwing errors. So far ive tried a few solutions to deal with the nulls with no success.Here are the code samples from my efforts so far;
If (r("datemodified").Equals(DBNull.Value)) Then datemodified = String.Empty Else[code]....
i have ran the query and it is working ok (i.e all the cols exist)
Dim myreader As SqlDataReader = cmd.ExecuteReader 'read information from the database and give the values to the arguments(column_1, and column_2) While myreader.Read column_1 = myreader.GetString(1) column_2 = myreader.GetString(2) ..... I get an error when the data returned from myreader.GetString(2) is NULL. How do I check for nulls before assigning column_2 a value?
I'm trying to test a varbinary(max) field to see if it's null. I'm trying to figure out if it's a null or not in the select statement, hoping to avoid having to do this locally for every row of the returned dataset. This is the SQL I'm using,
Is there any way to convert null terminated string to normal string.I mean I can easily make a program to find the location of vbnull but there has to be a built in function for that.
void Exec1() { WorkMethod( x => File.OpenRead(x));
[CODE]...
Can I do something like this?:
Private Delegate Function StreamOpenerDelegate(ByVal name As String) As Stream
Private Sub WorkMethod(ByVal d As StreamOpenerDelegate) '' End Sub
[CODE]...
I'm trying to write some documentation, but I don't know VB syntax. Often I use Reflector to translate it, but I'm not sure it's working in this case. I'm also not clear on where I would need line continuation characters. In VB9, it's not possible to have multi-line lambdas (or Sub lambdas, which I did not ask about). In VB9, all lambdas return a value, and must be a single expression. This changes in VB10. VB10 will allow the above syntax, but VB9 will not. In VB9, if the logic involves multiple code lines, it must not be a lambda; you must put it into a named Function and reference it explicitly.
Like this:
Private Delegate Function StreamOpenerDelegate(ByVal name As String) As Stream
Private Sub WorkMethod(ByVal d As StreamOpenerDelegate) '' End Sub
I want a method of dealing with very, very, very big numbers (potentially a million digits). It is very cumbersome to deal with very big numbers in VB, would another language perhaps be better for that?
I have a main form which contains a few buttons...some of those buttons open up smaller forms...there is also a button for each of those smaller forms, which should let me bring the chosen form to the front and give it focus...basically like the tabs in your task bar let you switch between which program you are using...but I'm having trouble with this...I need to click the button 2 times before the form I want comes to the front...the first click removes focus from the currently activated form the second click then moves the form I want to the front.I need this to happen in one click..I[code] figured out the exact cause of the problem.it's due to the fact that the first click doesn't actually take effect since the child form has focus...so the first click actually just transfers focus to the main form...the second click does what it should.I knew it was going to be extremely obvious.so the question now becomes...how can I overcome this if that is possible at all...I know I've seen applications where I can still activate functions of the parent form in one click even if I have a child form open and focused.And it's basically what I need...it does what I want and lets me switch between child forms in one click...but it stuffs up the entire look of my parent form...the layout and colors get wacky...the transparency of certain things don't seem to work and my background image is gone..
I have a VS 2005 project. I want to create a project that is exactly the same except for the back end database name. Table names and structure, form names, etc., would not change.What is the easiest way to accomplish this? Copy the project? Start a new project and copy all forms, datasets, etc.?
I am hoping that someone from the forum is familiar with the Doing Objects in Visual Basic 2005 book so that this question makes a little more sense. I have completed the sample project and understand most of what I have done. There are some holes in my knowledge but I am sure I will pick up those pieces as I become more familiar with object orientated programming.
The sample project is an almost complete application where you view and edit Objects that are stored in a database. The author leaves the remaining features needed up to the reader, which is great because I have been able to put new knowledge into use. However I am having trouble saving a new object back to the database.
[Code]...
By looking at this code it appears that I can save the data that is in the bindingsource by changing the EntityState to the Enum added. However I am not sure where to set it. I am pretty confident that I have the rest of this correct because when I try to do the save I get an error that the stored procedure is expecting the GoalID.
I am just a newbie with VB.net, though i have experience in c# .net environment.Now I was just wondering how to start a vb.net project in VS.2005? its the version installed here in my assigned PC.
