I've got a problem with Linq in VB.NET.I've created a .dbml file from my db, and everything looks good - relation "arrows" between tables are visible, etc.But when I want to use simple query (taken from 101 Linq Samples by MS):
Dim q = From h In dc.Hours, w In h.WorkType
I receive an error:
[code].....
I get an error when updating a related table, the main table can be updated but the related gives me a concurrency error but I don't know why. Btw I'm the only one using the program and it's connecting to sql server 2005 express.Inserting works like a charm.My piece of code, I hope you get it. The concurrency error is given on Me._objtblOrderinformatieA.Update(Me.objdtsOrders.orderInformatie)
If MessageBox.Show("Bent u zeker dat u deze record wilt wijzigen?", "Orderbeheer", MessageBoxButtons.YesNo) = 6 Then
update_dataset()
Me._objtblOrdersA.Update(Me.objdtsOrders.orders)
[code]....
Processing an XML file with LINQ to add records into a table in a SQL Server database via a data context. As we are adding records we need to assign the parents in various other tables. Most of the time we can find the existing parent and use it but sometimes we will need to create a new parent.Thought we could do this like this:
Dim defaultPub As publication
defaultPub = New publication With {.name = e..Value}
Dim pub = _Data.publications.Where(Function(s) s.name =
[code].....
i two tables named tblaccess(nID,nRoleID,nModuleID,cAccess) andtblmodule(nModuleID,cModuleName) and i have a datagrid which is bounded to tblaccess. the problem is, I want to display cModuleName from tblmodule instead of nModuleID. please tell me how.
View 1 RepliesDim total = (From item In dgv1.Rows _
Select CInt(CType(item, DataGridViewRow).Cells(3)) _
).sum
i'm trying to sum a dgv column with linq. is it possible?
The way it works is for each event, there can be multiple 'disciplines'. So I have a disciplines table related to my events table.
I save an event and save a discipline within it, when I open the application again, the event has saved but the discipline hasn't.[code]...
I have built a database structure that represents a category tree to help classify some of the data we have stored. The implementation is that each record in the Category table has a nullable foreign key back into the Category table to represent the parent Category of this category (one-to-many), essentially allowing for subcategories within a broader parent level. There is a CategoryMembership table that links a record in the Item table to its respective Category (many-to-many). I have created the DBML for this database, and it has a member access structure that includes the following:
[Code]...
I've created a combobox for navigating orders in a grid view.
[Code]...
Is there a way to clear all the textbox and combobox in a form without looping through panels and tabpages, because those textboxes and comboboxes were place in a tabpages and panels.
View 7 Repliesi have a GridView bound to a DataView. Some columns in the DataView's table are foreignkeys to related tables(f.e. Customer). I want to enable sorting for these columns too, but all i can do is sorting the foreignkey(fiCustomer) and not the CustomerName.
I have tried this without success(" Cannot find column ERP_Customer.CustomerName "):
<asp:TemplateField HeaderText="Customer" SortExpression="ERP_Customer.CustomerName" >
A tried also the DataViewManager, but i've a problem to detect the table to sort:
Dim daCharge As New ERPModel.dsERPTableAdapters.ERP_ChargeTableAdapter
daCharge.Fill(dsERP.ERP_Charge)
Dim viewManager As New DataViewManager(Me.dsERP)
[Code].....
I have a jump table to relate the Customers and the contact, I want to load all contacts by a customer name.
Dim Q = From Cust In EnData.Customers Where Cust.CustomerID = ID Select Cust
ContactRow = Q.FirstOrDefault.CustomerToContacts.??? here I'm stock...
I have a data table that I am updating. The table has 5 rows.The first row in the data table that has an ID of 1 will not update with new values, but the rest of the data table does update, I can't figure out why.
It is an access database I am updating, Is there a problem with my Update String? Because it updates all of my table except for the first row that has an ID of 1.
Dim sqlSSRTotalUpdateParameters As String = "UPDATE [SSRTotalChecker_" & FullName & "] SET [Totals]=@Totals,[Category]=@Category,[Materials]=@Materials, [Labour - Field Effort]=@LabourFE," & _
" [Labour - PMO]=@LabourPMO, [Labour - Supervision]=@LabourSuperv, [Labour - Administration]=@LabourAdmin," & _
[code]....
I have a typed dataset with 2 tables and a relation between the 2 tables. The relation is a 1 to 1 relation.First, who cane help me how to bind both the fields of the parent and the child table to a textbox.And second, in the dataset designer you cane preview the data. There a see for each record 1 row with all fields of the parent and also the fields of the child table. How cane i have the same result in a datagridview?
View 1 RepliesI am facing prblm in selecting compbobox...I have a 2 combobox...cboxSelunits and cboxseldept
In selected index change of Cbxunit i am filling CbxDept.and in selected index change of cboxseldept i need to populate the treeview
[Code]...
Below error is thrown in a already opened program which connects to different database
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Program details: code done using vb.net with SQL Server 2008 as back-end
Two instance of same exe where running simultaneously in same PC but error was thrown only by one instance
Program uses both SqlConnection (ADO.NET) and ADODB connection (upgraded from VB6) and the error is thrown by both types of connection If the error is due to network problem with the server then why few programs work fine? I am not able to trace the reason for this behavior of the program
Can I know why this error occurs and why only in few programs of same instance
New Introduction to Programming Vb.NET I did. Says the problem that I have been living in the code example below. Code Example:
[Code]...
The problem is not changed it to a text column in the database MNO. But I had to use as a MNO Numeric Column
trying to get my hands wet on vs 2010 and i downloaded samples from ms site but when i tried to run some of the DB samples i received this sql error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) any ideas how to get around on this?
View 5 RepliesI have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName
CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _
Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _
Select log.LogId, emp.FirsName, emp.LastName, log.Value
i am facing a problem that is frustrating i have a VB.NET application that i need to connect to an sql 2005 server .its giving this error when i publish the application "a network related or instance-specific error occured while stablishing a connection to sql server . the server was not found or was not accessible .verify that the instance name is correct and that the sql server is configured to allow remote connections" the pc has windows xp on it i configured my sql to allow remote connections its working on one mashine but not the other ??
View 5 RepliesI got an error message saying "Network-related or instance specific error occured while establishing a connection to SQL server............" when opening a connection in form_load event.Tried restarting computer it worked few a times,but still would get the same message again after sometime.How can i fix this error?.
View 3 RepliesI've developed a small HR program that connects to the SQL database which is on the local PC. I've created an ODBC connection to connect to this server and the program works fine. I've used VB 2008 Express edition to develop.
My concern is now I want to install this EXE on a server. ON the server, I've created the same databses and successfully created an ODBC connection on the server as well. Also created one shared folder. I copied all my EXEs and DLLS on to this folder. On the server I was able to execute the program without any problem.
From a remote client, I opened this shared folder and try to execute and it was giving me an ODBC related error, basically it was not able to detect the SQL connection.What I want to achieve is to have one EXE. The program did not throw any other errors.
Using a datagrid, binding to one table, and related to one combobos, I cant update records, cause gives me a violation error. I'm not changing the primary key, so, I dont undersatnd cause this happen. I prepair a example of this error, and it was attached to this message.
View 5 RepliesI have 2 Tables Table "A" and Table "B". Here is little details.
Table "A"
---------
ItemID (Primery Key)
ItemSKU
[Code]....
I made a program a month ago and i gave it to the customers.recently they report some bugs and i fixed them. when i send the new version installer to them, they have some problems running it.i used vs 2008 to write it, but i removed vs 2008 and installed vs 2010 last week. when i opened my project to start fixing program bugs it asked for convert wizard so i did it.i made changes and build it. i use installshield and i add framework 3.5 Sp1 as prerequisites.
note : i was using inno setup first time. so i changed the installer too.so i tried installing the program on my machine.i just noticed that i have only .net framework 4 installed my own system. so i have no idea how the program runs without any problems on my own system. i have even tried installing it on another machine who had framework 3.5. it it work on that too.the error shown on customers machines is related to framework version. everytime i send them a new version they have some problem installing/running it.
I have two data tables. the second related to the first. Using a datagridview for the first table I am able to enter and save data ok. if I run the code twice in a row the data is still there. When I edit the data in the related table in it's own datagirdview the data is there and displays correctly, but on running the code a second time the related data is lost. In both cellendedit events I am using
Me.table.Update(Me.FigsDataSet.table)
Me.Validate()
I have two tables Products and Categories with a many to many relationship. I am trying to copy the categories linked to one product (OriginalProduct) to another product (newProduct). The problem is when I execute the SaveChanges() method, I not only get the records in my linking table, but it also creates another copy of the categories in the categories table. I've tried this in many ways but here are the last couple that I've attempted:
' Copy Product/Categories
For Each oneProdCategory In OriginalProduct.Categories
Dim relatedCategory = _productContext.GetObjectByKey(New EntityKey ("ProductInfoEntities.Categories", "RecordId", oneProdCategory.RecordId))
[code]....
I have a VB project with a form where user adds/modifies the data, data are stored in SQL. On the form there are 2 tables that are linked by employee ID. When I test the process and insert a new employee record and add new comment for this new employee in DataGridView - when I save it I get an error that "Object reference is not set to an instance of an object". During more detailed debug it says that CurrentCell is set to Nothing - even that I do have values in all fields.I do set employee ID in the related table in the Grid to the value from the employee record - so all primary keys do have value and the comment is saved after all but I get an error and saved comment dissapears from the screen right after saving. When I pull the same new record again - everything is saved. What am I missing and how to avoid the error and dissapearing of the saved comment?
Also - I tried to save the new employee data in the first table first and then add comments - it didn't solve the problem. But if I add first part of information in the main table, save and close the form, then go back and add comment - it works fine. The problem is - it's not convenient for the user - they'd like to enter everything at once.
Private Sub TblCommentsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblCommentsBindingNavigatorSaveItem.Click
Me.Validate()[code]....
I am working on a project using VS2010 SQL2008 and I saw an ODD behaviour , First let me tell you that the app runs without any problem in my developing pc (Windows Xp sp3 32bit)But when I was trying the application in another pc (Windows 7 32bit)I got this exception: A network-related or instance-specific error occured while establishing a connection to SQL server.The server was not found or was not accessible.Verfiy that the instance name is correct and that SQl server is configured to allow remote connections.
Now what is weird in this exception; Is when the application reaches the DataAdpater.Fill(dataset) line I got this exception but when the app reaches the DataAdpter.Insert(....) It runs without any problem .
And what is more weird is that I noticed that the dataset that is used in the previous insert procedure can later be filled with dataAdapter.Fill(...) procedure which it was giving me an exception before .
I tried these things as a solution:
1)Checked SQlBrowser running..
2)No aliases to Sql server at all to remove...
3)remote area connection--OK
4)TCP and UDP port 1433,1434 exception in firewall
5)Unistalled my only antivirus Norton
6)Added Tcp/IP ports in Sql protocols
7)My connection String is : onnectionString="Data Source=ALISQLEXPRESS;Initial Catalog=PALMSDATABASE;Integrated Security=True"
8)Also tried using Sql Server authentication (user Id and password)
what is the difference between fill and insert? My app. runs smoothly on the original pc ,What should I do?
I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site ...
[URL]
Then following error occurs ....
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network
Interfaces, error: 26 - Error Locating
Server/Instance Specified)
i have changed my connectionstring in web.config file and all webpages to :
<connectionStrings>
<remove name="ConnectionString"/>
<add name="ConnectionString" connectionString="Data Source=69.16.253.19,1433; Network Library=DBMSSOCN; Initial Catalog=database;
[code]....
...before publishing and uploading my website to webserver ...I m confused the problem is from my local computer or the webserver ....and how to fix this error ?
i downloaded samples of vb 2010, i tried to run Create DB (Data Samples) but i'm receiving this error. I have MS SQL Server 2008 installed.a network-related or instance-specific error occurred while establishing to sql server. the server was not found or was not accessible.Verify that the instances name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)
View 3 Replies