VS 2010 Data Sources Versus SQL Commands

Apr 19, 2011

I prefer having total control for data access, populating recordsets (now datasets) precisely via a connection string and SQL select (or stored procedure call), etc.Now I wonder whether I really should be using the Data Sources option which just popped up on my radar? From the little I've seen so far, it seems to bind an entire table to a control, whereas most of the time I only need a small number of records from large tables.Before I spend a lot of time investigating, I hope a quick word from you might help me feel happier continuing as I am, or whether I need a kick up the backside towards a Better Way.

View 12 Replies


ADVERTISEMENT

VB 2010 - Array Versus Data Table?

Mar 22, 2011

I am interested in the pros and cons of data tables and arrays in VB 2010. I programmed decades ago in FORTRAN and used arrays extensively.However, I frequently see data tables in code snippets and don't know when they should be used in lieu of an array.

View 4 Replies

.net Express And Data Sources?

Aug 17, 2010

The company I work for has gone to great expence in getting me Express to code in.Tring to use the datagridview and attaching it to a source has me stumped.I can start the wizard, but it only shows Access and SQL express file locations.I need the connection to get to the actual SQL 2008 database.

View 8 Replies

Connecting To Data Sources In VB?

Mar 10, 2011

I am a novice to programming and am working my way through one of the more popular books on VB in VS 2008 Pro. I am havng a probelm setting up to add dataset controls to a form. I can establish a connection to the data base (a dataset is created and I can preview the data), but the table adapters and binding sources are not being automatically added to the form by the IDE. This seems to be verified by the fact that I cannot drag and drop controls from the data source window to the form.

View 4 Replies

Data Sources Non-visible?

Sep 7, 2010

for some reason my "data sources" window is empty when I open my project.Worked last night ,but this morning it's blank.Reads:Your project currently has no data sources associated with it.Add a new data source ,then add a new data source by dragging from this window onto forms or exsisting controls. What happened and how do I get this back to how it was.I can no longer open any project forms.

View 2 Replies

Where To Find Data Sources Tab

Sep 16, 2009

where can i find data sources tab?

View 1 Replies

Getting Data From A Data Source Using Binding Sources?

Aug 14, 2009

I have a bit of code that reaches out and grabs a series of rows from SQL Server DB. I perform an inner join to get some related table data. In the process I get returned the user id of the creator of the data. I then want to pass this into a query to get back a full name. I am having no luck figuring out how to do just that. If I use the data visualizer I can see the name I am after, I cannot figure out the call to extract it

Bindingsource1.DataSource = GetData("Select * From PURCHASE_ORDERS WHERE PURCHASE_ORDER_NUMBER =" & REQ_NUM.Text)
.DataSource = Bindingsource1

[code].....

View 4 Replies

Add Multiple Data Sources To ListView?

Sep 15, 2011

Currently, I am trying to make a table, which retrieves failed products and passed products from an Entity with LINQ.

Lets assume I've done that, but have 2 lists, A regular List(Of String), and a SortedDictionary(Of String, int32) (To hold the product, and the number of times the testpoint has failed).

Now, when I want to output them to ListView, in a Webform, how can I make it, so that List(Of String), will be output on the listview, and the SortedDictionary, be output after the List(Of String)?

EDIT: Although I could just add the SortedDictionary values to the end of the List aswell, but how would I go around doing so? Because I will create a listview with 2 columns, one which holds the descriptive text, and then a List(Of String) value. And the SortedDictionary would follow, requiring two columns.

View 1 Replies

Bind Multiple Sources Of Data?

Jun 13, 2012

It's been a long while since I've done any VB.Net coding and need to bind some data to a form. I have multiple tables that share some common primary/foreign keys and need to easily be able to update them.

For example, I have a table with an ObjectID, TypeID, AreaID, and several other fields. When doing my layout, I need the TypeID (found only in the main table) to be a distinct value in a comboBox, and in the ComboBox which contains the Area to be the Area Description (from the main table tied to the Area table via the Area ID).

View 1 Replies

IDE :: Creating Form From Data Sources

Jun 25, 2010

I designed a form from dragging across tables from data sources. All in all, bindingsources, tableadapters, dataset & tableadaptermanager, I have about 40 objects in the component designer tray.I found out that on a few occasions, Im not able to view the form design because of corruption or something. Sometimes, I even lost a bindingsource object or even a dataset object which caused errors. Has anyone come across such incidents? Is it advisable to have too many objects in the component designer tray?

View 4 Replies

IDE :: Data Sources Window Very Slow?

Feb 10, 2010

I'm developing a windows forms app, just upgraded it to use .NET 4.I'm VS 2010 ultimate RC.I'm running it in a virtual PC with 2GB of memory allocated to the virtual PC. I have windows 7 32 bit inside the VPC.I'm running win 7 64 bit with 4 GB at the host OS.Have a business DLL with about 300 of typed data tables.NOTE: The data tables are not in DataSets, we have generated the code for the DataTables using our own code generation mechanism.The data tables have been added as an data source (Of type Object)I'm running VS 2008 in my main OS. (Not a VPC)When running VS 2008 it takes 30 seconds to open the Data Sources window, the first time I open it.About 15 seconds subsequent times.Also when on a form and setting a binding expression it takes 10 seconds before the drop down list of available object to bind to comes up.

I have quite a powerful PC (5 experience score) relative to other developers at my company.This performance is a very serious productivity issue and makes developing windows forms apps very tedious.As a result of this VS 2008 is not very popular.The exact same slow performance seems to still exist with VS 2010. (Similar times)It could be the VPC but I don't have a machine to test this on and I don't want to put the RC on main main development machine.Did you expect a lot less than 300 data sources? 300 seems quite low to me for any real workd business application.

View 4 Replies

Show The Data Sources Window?

Apr 21, 2010

im using VS2008.I need to see both the Server Explorer window and the Data Sources Window.However I can see the Data Sources Window and dont know how to get it back.

View 1 Replies

VS 2005 How To Use Data-sources Have In Project

Jun 1, 2009

Im currently making a program for a WM6 phone.. however this question applies VB.net programming in general.How do I use the datasources i have in my project... I currently have a datasource and a database file in my project.how do I connect to the datasource do i need to connect? when I deploy my application will my database file be carried over?

View 2 Replies

DataGridView ComboBox With Dynamic Data Sources

May 25, 2010

I need to do in other platforms but seem to be having some issues with VB .net 2008.I have a datagridview bound to an SQL table that has several comboboxes.the rowSource (is it called that still?) for each of the comboBoxes are SQL lookup tables that I've created and based on the the users selection in ComboBox1, comboBox2's datasource may change.What I want is, if the user picks "Dental" from ComboBox1, I want comboBox2 to load Dental plans (Which I have working, no problem here I think).And if they pick "medical" in ComboBox1, comboBox2 loads medical plans in comboBox2 dropDown list, which, again that part seems to be working.If in the first row in the DGV,the user selects "Dental" for comboBox1 and then a Dental plan in ComboBox2,on the next row, if the user inputs "Medical" in ComboBox1, the first rows ComboBox2's "Dental plan" info disappears.

The medical plan can still be selected and displayed in row 2's comboBox2 (so the changing of the datasource is working)If you then click anywhere in the first row, ComboBox2's dental plan appears again but Row2's combobox2 now no longer displays the medical plan.Becuase whatever value you choose, no matter if it's a medical or dental plan, the info gets saved in the DGV bound table, shouldn't it display the saved information from the DGV's source and not the shifting comboBoxes datasources?

View 1 Replies

IDE :: Data Sources Window - All Objects Expanded

Nov 26, 2011

I have a VB project with a large number of data sources in the data sources window. While the datasets behave well, the objects constantly expanded themselves to show all the properties. This means a lot of scrolling to find one.

View 10 Replies

Installing ODBC And MySQL Data Sources?

Jun 23, 2010

I've downloaded the ODBC driver and the MySQL driver and installed them on my system (Win XP SP3). However, the only data sources that are showing up when I try to add a data connection are Access & 2 SQL Server objects. Is there something else that needs to be setup in order for Visual Studio to allow additional data sources? I'm currently running VS 2010 Express.

View 1 Replies

Missing Other Data Sources For Configure DataAdapter?

Feb 2, 2009

In Microsoft Visual Basic 2005 Express Edition Version 8.0.50727.42 (RTM.050727-4200) and Microsoft .NET Framework Version 2.0.50727.

Right Click Toolbox--Choose Item--.NET Framework Components--Check on OracleConnection and OracleDataAdapter--Ok

Now double click OracleDataAdapter1 in the toolbox.Data Adapter Configure Wizard appears. Click on New connection.Add Connection dialoge box appears.Click on change.Change Data Source dialogue box appears.Here i am getting only 2 items:

1.Microsoft Access Database File
2.Microsoft SQL Server Database File

And in Data Provider combo box; only ".Net Framework Data Provider for SQL Server".I am not able to configure my OracleDataAdapter1 control by choosing above method.Machine have Oracle 10G Client and Server well installed. I am able to use Dim oda As New System.Data.OracleClient.OracleDataAdapter() and it is working fine; but i wish to configure oracledataadapter by using above method. Moreover, it is possible for me to configure oracledataadapter in Web Developer 2005 by above metohd, but not in VB.NET.

View 3 Replies

Data Sources Keep Dissapearing From The Project When Have Shut Down Computer?

Jul 14, 2009

I've recently started using visual basic express 2008 and am having problems with saving my project. Basically, the data sources keep dissapearing from the project when i have shut down my computer and come back to the project at a later time. This has happened to my project several times now and is getting quite irritating as i don't seem to beable to find a resolution to the issue.I could continue developing my application without having to re write the code constantly.

View 5 Replies

Database - How Data Sources Are Linked In Compiled .NET Applications

Jun 18, 2009

When I try adding a new data source to my project I get a prompt saying "The connection you selected uses a local data file that is not part of the current project. Would you like to copy the file to your project and modify the connection?"This sounds rather obscure to me, as I'm new to VB.NET and programming non-script apps in general. The data source in this case is a .sdf SQL CE file.

Question 1: If I say that I want to copy the database to the project, what will happen after I compile the app, where the database will be? (how will I edit it from another app?)

Question 2: If I do not include it, how the data source will still keep linked? Can I link using filesystem enviroiment variables like %ProgramFiles%MyAppDir?

Question 3: Can I just tell it to use a read-only (Just needs to read it) data source on the web, like on an FTP?

View 1 Replies

Using Single Binding Navigator With Multiple Data Sources

Feb 10, 2010

I have a winforms app access a database with 6 tables. Out of 6, I am showing 3 tables on three different tabs on my Form. However, I want to do it using a single binding navigator that will use / change the respective binding source dynamically, depending on the tab that is activated by the user. I have separate binding source for each of the three tables.

View 3 Replies

Datasource Window - Make The Data Sources In One Project Visible To The Others

May 16, 2009

I am running VS2008 and am using VB2008. I have created a solution file with a Windows Form Project. It contains one form. I created a class project called DataAccess. I selected that project and created a data source. Now I see the XSD for that data. If display the "Data Sources" window I see the datasource. So far so good. If I select the Windows Form project, and then display the "Data Sources" window I get an empty window with a "Add New Data Source" button/link. How do I make the data sources created in the second project available to the first one?

I have been watching the videos for creating n-tier apps that suggest adding a third project to the solution called DataEntities. I did that. I then click on the XSD in my DataAccess project. Then in the properties of the XSD I change the "DataSet Project" property to point to my new DataEntities project. When I save the DataAccess project the DataEntities project gets a file added to it as expected. But then the Data Sources window is empty no matter which of the three projects I select.

Clearly I am doing something wrong. The videos all show the ability to see the data source in the "Data Sources" window after setting up this three project structure. One other thing I noted. In most of the pictures in articles showing the Data Sources window. The top most entity in the window is the project file itself. Then in a tree structure you would see the various data sources under that top most entity. When I was able to see something in the data sources window, the top most entity was a data source NOT the project file, with the data sources under it.

Any idea what I am doing wrong? It seems like I need to do SOMETHING to make the data sources in one project visible to the others. And possibly something to make a datasource visible once split apart using the "Dataset Project" property.

View 10 Replies

Join - Added Three Tables To A LINQ To SQL Class - Then Connected To The Data Sources

Jan 23, 2012

I have three tables: BOOKS(BookID, Title, Author) CLASSES(ClassID, Title, MajorID,BookID) and MAJORS(MajorID, Description). I added these three tables to a LINQ to SQL class (UBooks.dbml) and then connected to the data sources. Then declared DataContext.

Using LINQ, my goal is to display all books in a grid which I have done with:

Dim allBooks = From Books In db.Books _
Order By Books.BookID _
Select Books

Me.BookBindingSource.DataSource = allBooks

Next I need to display all majors in a listbox. I would like the description to be shown however I am only getting the majorID to display with the code

lstMajors.DataSource = db.Majors

I have tried db.Majors.Description, however I am told then that Description is not a member of the LINQ table. and my final goal is to display all the books for whichever Major is selected in another data grid. This is what I am primarily concerned with right now. When using the SQLClient classes, I was able to create a string joining the tables (also had the description properly showing in the listbox, but that is of little importance right now to me). In the video tutorials I was able to watch whenever the tables were dragged from the database into the OR designer of the LINQtoSQL.dbml class file all of the associations were already there and the narrator only really had to do some drag and drop. Not only is drag and drop not working without these associations, but I'd much rather learn the code behind it.

View 4 Replies

Organize Projects Custom Controls In Toolbar As Well As Data Sources Panel?

Jan 31, 2010

I have a project with 150 (i counted) Items in the "MainProject Components" area of the toolbox panel.These 150 classes are mostly database related objects like table adapters, and datasets that i hardly ever use. I also have about 10 custom classes that i use often.When i need to access the toolbox, I have two issues that i would like to resolve.

1.How do i organize the toolbox to separate my custom controls from the table adapters and datasets?

a.I have created a custom tab within the toolbox.
b.I have dragged and dropped my controls into this new area.
c.All is well until I exit my program and re-open it. Voila they're all back in the MainProject Components" tab.

2.How do I force the IDE to instantiate the toolbox panel as completely collapsed?

View 1 Replies

Settings In Crystal Reports That Modify Sort Order Of Data Sources?

Dec 3, 2009

I'm working with Crystal Reports in VB.NET in Visual Studio 2005.I have a List(Of Stuff) that I've sorted according to one of the object's members.I've verified in the debugger that the list is sorted correctly.When I define my list as the data source, as in

rptDetails.Subreports.Item("rptSubReport").SetDataSource(theListOfStuff)

and view the report, the list is reversed.So, looking for a workaround, I said, "OK, I'll sort the list backwards before binding it."The list still appeared backwards in the report.So something's happening, and I think it's within the report definition, because I don't know where else the sort order could be changed

View 1 Replies

Supported For External Data Sources Or For Databases Created With A Previous Version Of Microsoft?

Aug 11, 2007

Ok, most of my Visual Basic experience I admit was with VB 3 and VB 5. I'm just starting with VB 2005 Express, and get this error when trying to connect to a new database.

I'm using Windows Vista and have the latest Microsoft JET version, so I have no idea why I'm getting that error.

View 3 Replies

[2005] Today.date Versus Now Versus DateTime.Now?

Jan 16, 2009

just want to know what is the difference between these date values?Once some one told me that its difference is server date and client date but not sure which one he meant.Below is 3 type of date currently I'm using and don't know what is the difference between them.

DateTime.Now is from System.DateTime.Now
Now is from Microsoft.VisualBasic.DateAndTime
Today.date is also from System.DateTime

View 4 Replies

CHM File In VS 2008 Versus VS 2010?

Jul 16, 2009

I had a .chm file I used in VB2008 and I'm having trouble getting it to work for VB2010. I use the code below to reference the file.

vb
Module HTMPHelpAPI Public Const HH_DISPLAY_TOPIC As Short = &H0 Public Const HH_DISPLAY_TOC As Short = &H1 Public Const HH_DISPLAY_INDEX As Short = &H2 Public Const HH_DISPLAY_SEARCH As Short = &H3 Public Const HH_HELP_CONTEXT As Short = &HF Declare Function HTMLHelp Lib "hhctrl.ocx" Alias "HtmlHelpA" (ByVal hwnd As IntPtr, ByVal lpHelpFile As String, ByVal uCommand As Int32, ByVal dwData As Int32) As Int32End Module

I then call it from my menu using this:

vb
Private Sub HelpToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles HelpToolStripMenuItem1.Click HTMLHelp(IntPtr.Zero, "PE Files Help.chm", HH_DISPLAY_TOC, 0) 'Dim sHelpFile As String 'Dim sStartupPath As String 'sStartupPath = Application.StartupPath.ToString 'sHelpFile = Replace(sStartupPath, "in", "hlp") & "PE Files Help.chm" 'Me.hlpHtmlLocal.HelpNamespace = sHelpFile End Sub

I had found the commented out portion online and tried to get it to work, but nothing will bring up the file. Do I need to have it loaded into VB.Net somehow or point to it or does it need to be in a certain location?

View 1 Replies

VS 2010 Event Handler In VB Versus C#?

May 21, 2012

I've been fiddling with this for ages and can't get it right. If you have this in C#:

videoSource1.NewFrame +=new NewFrameEventHandler(videoSource1_NewFrame);
void videoSource1_NewFrame(object sender, NewFrameEventArgs eventArgs)
{
// stuff to do in here
}

How would write it in VB? My head is spinning with AddHandler and AddressOf and I can't seem to get it right.

View 10 Replies

Loop Versus Array - Retrieving Data?

Oct 7, 2009

Can I know which is better when retrieving data?

View 3 Replies

VS 2010 - Speed: WebClient Versus Socket

Apr 25, 2012

I make a lot of programs that require an internet connection to download things from the web.At the very beginning, I used WebClient, as I didn't know Socket & how it worked.But now, I use Socket all the time, altough it's more lines of code. It seems to work faster then WebClient.I am interested if this is really true & why WebClient is slower (so is HttpWebRequest) then just a Socket.I've setup 2 threads which starts on the click of a button (WebClient thread starts first), the Socket beats the WebClient by just some milliseconds, but still.Each way has it's advantages & disadvantages, e.g.: if you use Socket, you need to write the header yourself & parse the response header.My question is, which one do you prefer & why ?Do you know why WebClient & HttpWebRequest are slower then Socket, as I assume, WebClient & HttpWebRequest both use tcp to download the things.

View 2 Replies







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