Written Which Accesses An SQL Database?
Jun 23, 2009
I am redesigning an application that I have previously written which accesses an SQL database, pulls records, creates an object hierarchy based on a bunch of custom classes that I created, and displays them in a TreeView control. When the user selects a node, a tabbed page displays the information about the object underlying the TreeNode selected.
I have since begun experimenting with Databinding to my Objects as I have recently redigned the objects to communicate directly with the datarow that each object is based on instead of storing the values in a private variable thus:
[Code]...
Allowing the databinding management objects to do the heavy lifting of getting the values, displaying them in the controls and writing new values as needed back to the objects (and thus the DataSet) i think is preferable. How can I accomplish this? I have added the Objects as datasources to the DataSources window, added the objects elements to the tabbed pages. How do I bind those controls to the item that is specified by selecting the TreeNode?
View 7 Replies
ADVERTISEMENT
Mar 9, 2010
i have a program that accesses an access database but i have a problem with this line
-'dbSkillCommand.Fill(dsSkillPageData, "skill")'giving this error message
-'No value given for one or more required parameters.' [code]
View 1 Replies
Sep 16, 2011
I have a VB Function (in Visual Studio 2008 with .NET 3.5) that opens up a connection to an Oracle database and queries the database for information. Apparently after some trial and error, I discovered when the SQL statement is being processed and filling the dataset, it apparently is taking up too much memory trying to complete the task. I'm running into System.OutofMemory exceptions and other unpleasantness.I'm wondering, is there some sort of program out there to measure memory consumption of your SQL code that is being processed in a Visual Studio application?
View 1 Replies
Aug 25, 2009
I have a VB Function (in Visual Studio 2008 with .NET 3.5) that opens up a connection to an Oracle database and queries the database for information. Apparently after some trial and error, I discovered when the SQL statement is being processed and filling the dataset, it apparently is taking up too much memory trying to complete the task.I'm running into System.OutofMemory exceptions and other unpleasantness.I'm wondering, is there some sort of program out there to measure memory consumption of your SQL code that is being processed in a Visual Studio application?
View 2 Replies
Jan 7, 2009
I am about to commence coding (actually recoding) on a project that accesses 100 tables of a database, more to added at later time. About half of the accesses are queries with joins and unions. I am more of a coder to not use wizards such tableAdapter, but code more by other methods. I have read some post of this site that suggest avoiding tableAdapters, not to use them in an Enterprise environmentl, but no reasons. I would like to hear from willing to bend my ear, pro or con.
View 1 Replies
Jan 9, 2012
I have a lookup table that contains a label that describes the data to be written back to my database. For example:Label = Manufacturing Repair Issue (This is what the user see's in my front-end windows app)Data = Mfg_Repair (What I want to save to the database when the user choses the label)
View 13 Replies
Aug 6, 2010
I have a VB.NET solution, just upgraded from 3.5 to 4.0. One of the classes has a private field:
Private _Projection As ICalculatedPath.At runtime, any time the class containing that field accesses that field, I get a FieldAccessException. The first time that field happens to get accessed is a null check in a method, and one of the things I randomly tried is changing the above line to:
Private _Projection As ICalculatedPath = Nothing.When I do this, I get the FieldAccessException on that line saying that the class's .ctor() cannot access that field. I've also tried making the field protected and public, clean/rebuild solution, restarting VS, targeting x86 and .NET 4.0 specifically on every project in the solution, and other non-sensical measures to get rid of this Exception but to no avail. This code worked fine before the upgrade, of course.
View 2 Replies
Dec 9, 2010
There are problems installing an application developed in VB6 that accesses SQL Server on Windows 7?
View 1 Replies
Mar 18, 2010
I have written a multithreaded crawler and the process is simply creating threads and having them access a list of urls to crawl. They then access the urls and parse the html content. All this seems to work fine. Now when I need to write to tables in a database is when I experience issues. I have 2 declared arraylists that will contain the content each thread parse. The first arraylist is simply the rss feed links and the other arraylist contains the different posts. I then use a for each loop to iterate one while sequentially incrementing the other and writing to the database. My problem is that each time a new thread accesses one of the lists the content is changed and this affects the iteration. I tried using nested loops but it did not work before and this works fine using a single thread.
Here is my
SyncLock dlock
For Each rsslink As String In finallinks
postlink = finalposts.Item(i)
[CODE]...
Finallinks and finalposts are the two arraylists. I did not include the rest of the code which shows the threads working but this is the essential part where my error occurs which is basically here postlink = finalposts.Item(i) i = i + 1
ERROR: index was out of range. Must be non-negative and less than the size of the collection. Parameter name:index
I tried copying it to a new list but dosent work.
View 9 Replies
Oct 31, 2010
My routine to check for updates is run as a separate process. Exiting the application is required to update, so a dialog asks the user, when an update is found, if they want to exit now. f they do, the code (from the update thread) calls Application.Exit().However, if the FormClosed event of any form that needs to be closed needs to access its controls, an invalid cross-thread operation is detected (which sounds pretty logical).
View 1 Replies
Nov 22, 2011
I have question to ask.
I have a dll file written for reading&writing data on USB.To use dll in VB.Net, one needs to integrate a .vb file which interface to that dll file to use its functions, properties etc..
What I need is to use this dll in a C# project. is this possible?[code]...
View 3 Replies
Jul 16, 2009
I am little bit confuse about using properties(Get and Set) in ASP.NET that when these Properties is used.Means How I come to know the exact use of Properties in application. And what is the advantages of using it? [code]
View 2 Replies
Jan 24, 2012
I found a very useful source code on how to make a fud cryptor, but the author didn't mention which coding language / software he used, please follow the link below, to see the full source code.
View 5 Replies
Aug 2, 2011
In java I would Write:
if (something != bla || something != bla){}
How is this written in visual basic?
View 3 Replies
Apr 14, 2010
iam trying to write information about customer from textboxes to a file.txt.when iam clicking save button, stream is opened, then i used method writeline(txtboxevalues)but no information are written to the txt file any help in that??
View 2 Replies
May 18, 2010
I have written a program and it seems to work fine when i am running it in the environment.When I create a program to distrubute to another computer it will not run.I thought it might be a problem with the other computer but I tried to install it on the same computer I designed it on and it will not run there either.When I run it a message box pops up saying "Application cannot be started. Contact to application vendor."[code]
View 5 Replies
Sep 21, 2011
I want to access a socket that has been opened for me by my service providers. Their socket is written in PHP and I don't understand PHP at all. Themselves they don't understand VB.Net
The Code in PHP as as below
<?
$num = $_GET['num'];
$ext = $_GET['ext'];
[Code].....
View 2 Replies
Jan 2, 2010
I just want to know whether I can use "Reflector" to disassemble a Program written in DOS and go through all the Codes of that program to learn how that program was made? If the "Reflector" is not the one for DOS Program, could you recommend a Free Disassemler for DOS Program?
View 5 Replies
Dec 8, 2009
Trying to dissect a very badly written ASP.NET app. Can someone tell me what this assembly (ProAspCompLib.dll) is used for?
View 1 Replies
Oct 3, 2011
I'm using JdSoft's APNS-Sharp library in my ASP.NET web app. The library is written in C#, and makes extensive use of Delegate Functions and Events for threading purposes. My application is written in VB.NET, and I'm a little confused on about how to translate the following sample code' [code....]
View 3 Replies
Sep 10, 2011
I want to check at runtime if an assembly was probably written in VB. It doesn't have to be a bullet-proof method. Maybe call GetReferenced Assemblies() and check for an assembly that all VB projects reference?
View 2 Replies
Jul 23, 2010
I have a class (e.g. MksMath) written in IronPython using SharpDevelop 3.2. After compiling it for class library, it produced the following output:
IronPython.dll
IronPython.Modules.dll
Microsoft.Dynamic.dll
[code]....
View 2 Replies
Jun 9, 2011
I've got a C#.NET background and due to circumstances I'm trying to make a plugin written in VB.NET. I've created a new class project which gives me a DLL. This class implements a C# interface which all works.My only question is this... In my C# code I've got an implemented DLL (which loads at runtime) with the following declaration before the class...
[Plugin(PluginType.Storage)]
public class XmlPlugin<T> : IStoragePlugin<T>
{
[code]....
How do I write [Plugin(PluginType.Storage)] in VB syntax?
View 2 Replies
Jan 11, 2010
I have an OCX that I wrote in VB6.I added it to the vb.net toolbox and can drag the control onto a form and use it in code without any problems and it works just fine.But I can't see the control's design-time properties. In VB6 there's a small window on the right where I can set the properties of a control. In VB.Net I can see the standard properties such as Location, size, name etc but none of the control's own properties.
Do I need to register msstkprp.dll or a property page or something ?
Can I see design time properties of a vb6 ocx in the vb.net IDE ?
View 1 Replies
Jan 19, 2009
I'm trying to read a *.txt file and see if it has anything written on it. This is my
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim line As String = Nothing
[Code]....
But when i use it doesn't pop the MsgBox. What's wrong with it?
View 15 Replies
Dec 21, 2011
I want to check at runtime if an assembly was probably written in VB. It doesn't have to be a bullet-proof method. Maybe call GetReferencedAssemblies() and check for an assembly that all VB projects reference?
View 3 Replies
Feb 17, 2012
I have a function written in vb Public Function abc (ByVal x as Integer, ByVal y as String) As String
End Function
I want to call this function on click of a button in C# applcation.
View 2 Replies
May 31, 2012
I need to add quotes to a line that is being written to a vbs file WriteVBS("filesys.CopyFile " & OldNFile & "" & My.Computer.FileSystem.GetName(nfile) & "," & NotesFile & "," & "True")Old Nfile is a variable defined: Dim OldNFile As String = ("\" & OldPCTxtBx.Text & "" & NotesSource.Replace(":", "$"))NotesFiles is defined as
Dim NotesFile As String = (NotesTgt) & "" & My.Computer.FileSystem.GetName(nfile) I need to add quotes before and after the OldNfile Variable and the NotesFile variable I dont want to change the variable just the WriteVBS line not sure how to do it since intellisense does not suggest a better way
View 2 Replies
Jan 1, 2011
I have a question about the AddNewItem method. From what I understand, then this event occurs, the EndEdit() method is called and a new record is created IN MEMORY (or a buffer). The user fills in the form that is presented and when the Save button is pressed, the record in the buffer is actually added to the table.
In my application, a form is displayed and some of the forms databound text boxes have DEFAULT values (see the property for the textbox under the Data Bindings, Advanced and NULL VALUE). For example, I have a text box that holds a number and the NULL value is set to 0. When the form displays, the ZERO is in the text box. Assume the user NEVER enters the field or changes the ZERO to something else (which means the field is never validated).
Here is the problem. When the SAVE button is pressed, the ZERO that was the default value is NOT WRITTEN to the table. The field in the table is DBNULL. That is not the desired outcome. So - How can I check the fields in the BUFFER BEFORE they are written to the table?
View 1 Replies
Dec 22, 2011
I've set the XMLWriter to use the UTF8 encoding, but the WriteStartDocument method still writes a UTF16 tag. This is the part of the code:
[Code]...
View 1 Replies