Selecting Data From One Sql Instance An Inserting Into Another Sql Instance?

Sep 1, 2011

I have no problem doing a select statement from a database and displaying it.An I have no problem inserting data into a sql database table. However with this issue I have to grab the data an insert it into a totally different SQL 2005 instance.

View 8 Replies


ADVERTISEMENT

.net - Save System.Collections.Specialized.NameValueCollection Instance To Hard Disk And Load It Back As An Instance?

Jun 24, 2011

I have following instance of System.Collections.Specialized.NameValueCollection:

Dim UserSelection As New System.Collections.Specialized.NameValueCollection
UserSelection.Add("D_Color1", "Black")
UserSelection.Add("D_Color2", "Green")
UserSelection.Add("D_Color3", "Purple")

I need to save this instance to hard disk and then load it back from hard disk as an instance. How do I do that?

View 2 Replies

Invoke An Instance Function Delegate On An Instance Of A Generic Type?

Aug 4, 2010

D is a dictionary whose entry values are of Type T..What I'm attempting to do is have a delegate like "Serializer" below that I can invoke on an instance of T, such as "Entry.Value" below.Please see the "return Entry..." line below for my wishful thinking.[code]

View 2 Replies

Make A Single Instance App And Showing The MainWindow When Another Instance Is Launched In .NET With WPF?

Aug 30, 2011

I am looking for a way to make my app running in a single instance mode and showing the MainWindow of the first instance when another instance is launched.I do a quick search on the internet but I did'nt find anything to open the MainWindow of the first instance or it was for Windows Form not for WPF.

View 1 Replies

Transfer Control To The New Instance In A Single Instance Application?

Jul 15, 2011

I have a single instance VB 2010 application I know how to communicate with the next instances run through the StartupNextInstance application event. The usual way of working with this is parsing command line arguments of the new instance and continue execution of the old instance. What I would like to do is replace the running instance with the new one. Is there any way to do this other than disabling the single instance property ?

View 1 Replies

Getting The Local Instance Of SQL Server Rather Than A Named Instance

Jul 29, 2010

A while ago, I wrote a web-based guestbook application that wrote it's own database.

My code was very amateurish, but, as it was my very first publication, I was very happy with it. Only about a month after I'd published it did I realize I'd made a huge mistake in the code.

I've only ever connected to a specific named instance of SQL Server, and it occurred to me that, if the SQL Server instance has a different name than the one I specified, it wouldn't work.

So, since my users will probably not know what the name of the instance of SQL Server that's running is, I thought adding a field where the user can specify it would help if they do, but what if they don't? My answer was to get the local instance, regardless of name.

I tried Data Source=.local;, Data Source=.; and other variants, but nothing worked.

View 2 Replies

Is There Function Takes Name Of Instance And Return Instance

Feb 29, 2012

I was trying to fill 10 checkedlistboxes with items..So I made a sub with 2 arguments like this Private Sub fill_checkedlistboxes(ByVal items As String, ByVal checkedlistbox As CheckedListBox) End sub the first argument items is a long string whitch splits in the sub into many strings and added them all into the second arguments (thecheckedlistbox) I want to make for next statement to fill all the 10 checkedlistboxes in my form with an 10 long strings held in an array called strings, so i write something like this [code] What i have to write in the "?????" area to have the checkedlistbox that i want? the checkedlistboxes names are checkedlistbox 1, 2 , 3 ....10

View 12 Replies

Creating Single Instance Form In MDI Application - Check Whether Form's Instance Created Or Not?

Feb 8, 2012

creating single instance form in MDI Application. How to check whether form's instance created or not?

View 6 Replies

Instance Of IE And Be Able To Populate Instance Of IE?

Sep 2, 2009

Currently I am useing the following code which I found on these forums. I get pretty good use of it. I would like to be able to open my own instance of IE and populate it. I am trying not to populate any other minstances of IE that may already be open.

[Code]...

View 1 Replies

Add Instance Of Class That Contain Data

Jul 16, 2009

I have been asked by a code snippet to add the instance of class that contains data i want to add to an XML file, the only trouble is i am not sure what an instance of class is. Is it something that looks like this: [Code]

View 2 Replies

"Object Reference Not Set To An Instance Of An Object" When Selecting Text On Richtextbox

Apr 14, 2012

I have been getting some nullexceptions on the following lines of code...:

[Code]...

Its a text editor that i am working on. When a text is bolded and i have selected it, the button for bolding text becomes checked and same goes to the other ones like italic,underline and strikeout. but if I have selected a text with bold and italics and multiple ones, it gives me a "Object reference not set to an instance of an object." How could i solve this?

View 1 Replies

A Data Source Instance Has Not Been Supplied

Mar 8, 2008

I am linking a report within asp reportviewer to a drop down list, but keep on getting an error 'A data source instance has not been supplied for the data source 'DataSet11_NewSelectCommand'. I cannot see anything wrong in the code though,

Imports System.IO
Imports System.Web
Imports System

[Code].....

View 2 Replies

Allow More Than One Instance Of VB App To Access Data Files?

Jan 1, 2012

I have just completed an upgrade of a VB6 app to VB.net (2008). Everything works as it should except for one (essential) part. I cannot open more than one instance of the built app without getting a file access error. Now don't laugh but my program uses Random Access files to store the data (i know, i know the 1990's called and they want their programmer back). Anyway I've been using this method since the early 90's and it's never let me down. Until now that is. VB6 allowed any number of users to access the files but for some reason VB.net gives the following error: The process cannot access the file "C:lah blah" because it is being used by another process.

View 2 Replies

Object Not Set To An Instance When Insert Data

Jul 21, 2009

How can this statement give this error "Object reference not set to an instance" what is this means for0.?[code]...

View 17 Replies

Get "Object Reference Not Set To An Instance Of An Object" Error When Trying To Find An Instance In A String?

Jan 23, 2009

I am using the IndexOf function of the string class to find a specific instance of a string. And based on that I have a logic to do something. Below is the example of what I am doing. The code is in production and is working fine. But for some instance I am getting an "Object reference not set error". Yeah its intermittent.The requestXML is a string of xml data passed in as a paramter to a subroutine. I am fetching the xml string as a form post in a request object. The only thing I could think of getting this kind of error is when the requestXML string varia

requestXml = Request("requestXML")
SubmitRequest(requestXml)
Private
Sub SubmitRequest(ByVal requestXml

[code]....

View 5 Replies

Share Data Tables For All Applications (only One Instance)?

Feb 25, 2012

I have 5 websites running on same server and I have some sql tables that I access frequently. that was time consuming and by defining them shared I pumped them in memory. So my application is accessing those static data tables from memory quite efficiently.
But I realized I did a mistake and I occupied my memory unnecessarily while I keep same tables 5 times for each web application. Now I need to find the best way to share that table only 1 time. my options are;

1) using a local database - sql CE. my original sql database is on other server. so it makes the access slower but I can add a sql CE database(to be honest I never used it and dont know if it gives me anything) to access only these tables while they have static rows.

2) I read over forums that making a WCF using tcp binding. not sure if it will give me any advantage.

3) windows service: is it faster than wcf? programming is defiantly faster as i have experience with winservice but nor sure about performance.

View 2 Replies

Split Function; Discard All Data Before The Last Instance Of A Delimiter?

Nov 29, 2010

Okay so what I'm trying to do is get the filename from OpenFileDialog/SaveFileDialog, only without the full path, and dump said filename into a variable so I can use it for other things.

Using the Split function, I can get any part of the array between the delimiters (""), but what I'm trying to do is get all the information after the LAST delimiter in the string.

View 2 Replies

VS 2008 Program Transferring Data To Another Instance Of Itself Over The Internet

Apr 16, 2009

I'm developing a management program for a driving school, where information about all students is stored and accessed.

The thing is, this school has got two branches, so I need some way for those two computers to share files with each other in order to keep a common database. I would like to use the same program in both computers, to keep simplycity to the maximum.

I know it's using TCP, but I haven't got the lesser clue of how i can achieve that. I've looked around, but I haven't found much of how to acchieve something like that. The files both computers would be sharing are text files.

About the IPs, I'm thinking of using NoIP or one of those to always know both IPs.

View 1 Replies

C# - .NET Generic Class Instance - Passing A Variable Data Type

Jun 2, 2010

I'm tyring to pass a variable data type to a template class. Something like this:

frmExample = New LookupForm(Of Models.MyClass) 'Works fine

Dim SelectedType As Type = InstanceOfMyClass.GetType() 'Works fine
frmExample = New LookupForm(Of SelectedType) 'Ba-bow!
frmExample = New LookupForm(Of InstanceOfMyClass.GetType()) 'Ba-bow!

[Code].....

I'm assuming it's something to do with the template being processed at compile time but even if I'm off the mark there, it wouldn't solve my problem anyway. I can't find any relevant information on using Reflection to instance template classes either.

(How) can I create an instance of a dynamically typed repository at runtime?

View 4 Replies

Class Library (dll) Single Instance To Pass Data Between Processes Or Exe's DESIRED BADLY

Oct 20, 2010

The "named pipe" seems rediculous to pass data between processes (exe's). Is it possible to run a single instance of a VB.NET Class Libary (dll) such that two programs can access the same memory resident dll, thereby passing data via functions and or subs?When I try to make the class library as single instance, the "Enable Application Framework" is greyed out, and thus the option to "Make Application Single Instance" is also greyed out.When I try to call the dll from two processes, I simply just create two instances, so storing data in a module doesn't work

View 2 Replies

Get The Instance Name Into One Combo And The Databases On That Instance Into The Other Combo?

Feb 15, 2012

I have two combo boxes and I am currently using MicroSoft SQL Server to get the instance name into one combo and the databases on that instance into the other combo. I am wanting to switch to System.Data to get these values and I am able to get the instance through enumeration but am having trouble finding where to get the database name values assigned to that instance.Does anyone know the equivalent of SMO Server.databasename is in System.Data?

View 5 Replies

Format Date In Data Grid View Object Not Set To An Instance Of An Object?

Jan 29, 2012

I'm trying to set the format of a column in a datagridview.When I put the format statement in the on load event for the form, it has no effect. When I put it in the cellformatting event I get the "Object reference not set to an instance of an object" error. I checked the column name. What I am doing wrong?

This is the code:Private Sub MeetingTblDataGridView_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles MeetingTblDataGridView.CellFormatting
Me.MeetingTblDataGridView.Columns("Starttime").DefaultCellStyle.Format = "HH:mm:ss"
End Sub What I'm trying to do is get rid of the date part of a Date/Time field (stored in an Access database) in a datagridview column.

dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('09dde30f062e451a854266e66205b1cf')

View 10 Replies

Getting Error "Object Reference Not Set To An Instance " With Data Gridview In .net

Jun 8, 2011

[code]
Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
frmUpdate.Show()

[code]....

View 1 Replies

VS 2008 Object Data - Create A Class And Create A Instance Of CarData?

Nov 28, 2010

I want to create a class is it where I can do...

[code]...

How do I do this? Do i create a class and create a instance of CarData? but how do I add Color and Year etc to it?

View 3 Replies

Failure To Create Data Controls To Access Database Object Reference Not Set To An Instance Of An Object?

May 3, 2011

I was create Access database with Access 2003. I create VB project with Visual Studio 2005 Standard With connection wizzard I create coonect with this Access database, select all tablesI see this database inside Data sources and inside Server explorer Test connection is OK When I drag and drop table from Data sources, Wizzard don't create DataGridView, DataSourceBinding etc .. and I see popup window with mesage: Object reference not set to an instance of an object and then "game over"

View 2 Replies

Selecting Text To Format - Inserting Pages In Word Processor?

May 6, 2011

I am doing word processor but I cannot do the font it is not select fonting text in textbox what shall I do?
Font code=
fontdailog.showdailog
fontdailog.font=textbox.font
textbox.font=fontdailog.font
In this case it can not do select text to format
2. In word processor how do insert many page?

View 4 Replies

Create A New Instance In MEF

Aug 29, 2011

I am using MEF for Plug-in, I made one class PluginManager which has propety<ImportMany()>Public Property Plugins() As Lazy(Of IPlugin, IPluginExport)() Now want to create a new instance of when i query from plugins, I have already set PartCreationpolicy as Nonshared, but still its not working.

View 1 Replies

Get Class Name Of A Instance?

Aug 20, 2010

Is there a way to get the instance's class name with VB.NET?

View 2 Replies

Access Instance Already Instantiated?

Mar 31, 2010

I create an Instance of Access to view a report through my app.I would like to check if an Instance of Access has either already been opened by the user, or by the app. If so, use that instance.

Dim oAccess As Access.Application
Public Sub CreateAccessInstance()
Try[code]...

As it stands now, It creates multple MSACCESS.EXE processes which are running until I exit the app.

View 9 Replies

Add 4 Items In A Row In A List Box, For Instance?

Jun 21, 2010

I've made a program that can add 4 items in a row in a list box, for instance

Item Make Guarentee qty Price
toy car rover 1 1 £45.00
monkey monkey 2 1 £65.00
total: £100.00

The problem is I can't get the price to total up in a lable or textbox, however,I can make it work if i seperate the box and make two, listbox1 for item,make,gtee, qty and listbox 2 for price only.I don't want this because i want the row to delete in one go instead of deleting it from two boxes which is a time taker. code below

[Code]...

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved