when i try to add new data source aftre selecting the table & befor finishing i got the message..An error occured while creating the new data source
An error occured while generating the data source and in error window following error does come Custom tool error: Failed to generate code. Failed to generate code. Invalid access to memory location. [code]
Iam having a problem with string menipulation befor updating a table,I have a string containing chr(39): "'" and have to keep it the way it is. the string represent a note field.
View 5 Repliesi have a combobox on the form and a datagrid viewer .no i want to display the table which selected on combo box..
View 1 Repliesi know how to generate the Datareports through Data Environment by Firing a query
View 1 RepliesI have a datasource linked to a table in a database.When I wnated to display this data on a form, I just dragged the datasource onto the form and it did everything for me, including the code to fill it;
Me.ProjectFileTableAdapter.Fill(Me.ProjectFileDataSet.ProjectFile)
My problem, is that this program will have multiple users, and I don't other users to be able to see each others data. So the problem with the above statement is that it fills the table with ALL the data in the datasource. How can I make it only display data that is for a specific user?Here's the code that is used to fill the tableadapter:
Private
Sub
frmViewCurrent_Load(ByVal[code].......
Resources: Visual Studio 2008 Pro (currently in 90 days trial)
Platform: OS - Vista Home Prem 64-Bit
Language : Visual Basic
I'd like to bind my textbox into two (column)from different table is it possible to do this? I already know how to bind (one-to-one) controls and table.
I want to change the source data for my pivot table in Excel using VB.Net to a named range.
I have : table.ChangePivotCache(wb.PivotCaches.Create(SourceType:=Excel.XlPivotTableSourceType.xlDatabase, SourceData:=sheet.Names("name_of_NamedRange").RefersToRange))
Exception : The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
I have inherited an application at work that someone else started creating, right now about 1/2 of it is functional and is in use. My problem is that it is all done in 2.5 ?? and I am trying to step through it all to figure out how it works. I have always created my own binding sources, adapters and data tables.
One of the things I need to do is add a field to the fm_fieldman_master data table. I add the field in the db (SQL Server 2005)table, I come into VS and refresh the datasource, I then add the field to the fm_fieldman_master data table and the Fill,GetDAta() query I go into the designer and create all the attributes for the combo box
[Code]...
I have a data table (mdf). I want my text box to show suggestions from a column of that table.
View 3 RepliesI have several combo boxes that have a single Dataset and separate Table Adapter and Binding Sources to fill them.One combo box I have lists the Hispanic Origin of the client.The Data Source is bsCSpopup_HispOrg, the Table adapter name is taCSpopup_HispOrg.Below is the Table Adapter query if you can call it that and selects only the codes I want to fill the combo box
SELECT fcpopkey, fcpoptext, fcpopval
FROM cspopup
WHERE (fcpopkey = 'hispanic.origin')
[code]....
I am doing just fine loading the dispay text when the form loads, and saving the data to the client table, but, when I load the clients values, how do I cross reference the Source data value e.g. 1 to display the text "Not Hispanic" from the cspopup table.
Im using a combo box...i've already created my table in the database called Gender. but im trying to
use data bound items to select the database source, display member and selected value im nt finding
the Gender table...why is that?
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesMy program lists all my home movies filmed with various video cameras.When I select the video from the listbox, Windows media player plays the video.However, I would like to know the dimentions of the video before it is loaded.I could,therfore, tell which camera was used to film it.Some video is 1920 by 1088 frame width/height Some is 1280 by 720 and some various other sizes Is it possible for VB 2010 to give me the dimentions ??
View 2 RepliesI have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
I am selecting the max value of a column from a table. If the table does not have any rows i need the result as zero. how can i achieve this
View 6 RepliesI am selecting two table schema in a single adapter.
da=new sqldataadapter("select * from emp;select * from emp1",con);
da.fillschema(ds,Schematype.mapped);
then i am inserting some rows manually on both tables.i want to update the dataset. so that each data table in the datast will be updated in database.how to do this? since i am facing problem that it is updating all the rows in single table.
i have a listbox, that i want to make sure the value im about to add to it, is not already in the list, here is what i have but it dosent put anything in the list box.
For Counter As Integer = ListBox1.Items.Count - 1I To 0I Step -1I
If InStr(CStr(ListBox1.Items(Counter)), hyperlinked(0)) < 1 Then
ListBox1.Items.Add(hyperlinked(0))
[code].....
I want to insert existing tables in new table stock by selecting from date and to date ..I tried this
cmd = New SqlCommand("INSERT INTO Stock (OpeningStockdate,Productcode,Openingstock,Despatch,Receipt,ClosingStock) (SELECT A.OpeningStockdate as OpeningStockdate, A.PC as Productcode,MAX(A.Openstock) AS Openingstock ,SUM(C.Qty) AS Despatch,SUM(B.Qty)
AS Receipt,MAX(Openstock) + ISNULL(SUM(B.Qty),0) -ISNULL(SUM(C.Qty),0) AS ClosingStock FROM Product A LEFT JOIN Receipt B ON
[code]....
i got this error" Incorrect syntax near the keyword 'Where' "
Assuming this schema:
Table1 (Col1 int, Col2 str, Col3 str, ...)
Table2 (Col1 int, Col2 str, Col3 str, ...)
[Code]....
I need to select all records from Table2 where there are NO records in Table1 having matches of both Col2 & Col3. For instance, Table 2 records where Table1.Col2 <> Table2.Col2 AND Table1.Col3 <> Table2.Col3.
i am trying to make a vb.net project for a travel agency ..... i have make all of the content of it but i got stuck in listbox .... i have added onnfiled of sql table into the listbox and now i want that when i select the list box content then all the other fields of a the row will automatically come in the rest of the textbox so i can add and delete it manually....... here is my code..... of one form(i have made 13 forms like that)
[Code]...
I'm trying to select a 'Username' value from a table called 'tblUsers' where the 'UserID' is 1 and assign it to the 'Text' property of a field. The SQL command is fine, but I don't know how to assign the value to the file. I've changed the SQL command to select the value I want. I just don't know how to assign it to a field:
'Use these import statements, so you don't have to fully qualify the Oledb Object names:
Imports System.Data.OleDb
Imports System.Data
Public Class Register
Function Register()
[Code] .....
When I start typing a variable (or whatever), VB pops up a little box with all possible variables starting with the letters I already typed. It's really smart!
However this option has somehow been disabled. How do I enable it again?
I have a line shape which I am using as a straight 'finishing line'. As the program runs an identically shaped line shape appears. I am a little confused from where and how it is appearing, as I only have the one line shape. Also, on some runs of the program 'trails' of the cars that are racing across the screen remain.Are these issues something simple I can fix?
View 5 RepliesI created a new query in the dataset designer. There are now 2 queries there. The original one and the new one.I also added named parameters in the Where clause of the 2nd query.This is the query in the new one:
SELECT ID, FatherName, MotherName, EmergencyContactName,
EmergencyContactRelationship, Address1, Address2, City, State, Zip,
PrimaryPhone, SecondaryPhone, Emaile.
[code].....
[Code]...
i cant figure out how to tie it all together, just trying to find a way to include all of the numbers rather than the ones i listed without writing them all out..
I've been applying some recursive techniques to the second version of my app. This recursive procedure simply iterates through all nodes in a tree view and tests whether the text in the "department text box" matches the text name of a particular node. If there is a match, then the user's name, stored in the "name" variable, is added as a node to the node that has the same name as the department text box text.
[Code]...
I'm trying to finish an assignment for my Introduction to Visual Basic class. I have to program an application that will determine if a word entered has consecutive letters in the alphabet as a substring of itself. Three examples are T"HI""RST"Y, AF"GH"ANI"ST"AN, and "STU""DE"NT.This is what I have so far:[code]....
However, it doesn't run properly. It says I'm trying to refer to a location that is out of bounds, although I don't see why.
In the process of finnishing up the application. Some NOT all beta testers have had the same problem.
An error box that states: Unhandled exceptions has occurred in your application. If you click Continue, the application will ignor this error and attempt to continue. If you click Quit, the applicatiob will close immediatly.
An error occurred creating the form. See Exception.InnerException for detailes. The error is: Could not load file or assembly "Microsoft VisualBasic PowerPacks vs, Version = 9.0.0.0, Culture=neutral, PublicKeyToken=b03f50a3a' or one of its dependencies. The system cannot find the file specified.
The details displays this: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
Exception Text
CODE:
JIT Debugging
To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled.
For example:
CODE:
When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
This does not happen on all the forms within the app, just some. This happens on some systems running XP and the app runs fine on others running XP. So foar it has run on all systems running Vista. It happens some of the time on Windows 7
What code I need to search a whole table (not just one column). I can already search a column but how do I search the whole table for a string .
source1.DataSource = ds.Tables(listboxselect)
Grid.DataSource = source1
source1.Filter = "id = " & searchtxt.Text
I want my application to be able to print details from the databse. I hava a report already in the program but it displays the list off all persons in the database. I want to create a form where i can use a query and the result of the query would be printed on the report.
View 2 Replies