there any workaround with this one?
SELECT invoices.no, customers.name, invoices.mdcode,
SUM(iproducts.unitprice * iproducts.quantity) AS total,
SUM(iproducts.unitprice * iproducts.quantity) - SUM(rinvoices.payment + rinvoices.discount)
[code].....
Giving it a go at LINQ to SQL.
Tools: VB2008 Express to SQL Compact Northwind DB
I am doing the following walkthrough: [URL]. I did the walkthrough step by step although I get the following message ...... The column name is not valid. [ Node name (if any) = t0,Column name = CustomerID ] ....... on the first line of the following code.
' Execute the query.
For Each custObj In custQuery
msg &= String.Format(custObj.CustomerID & vbCrLf)
Next
I have enabled all that the walkthrough indicates but to no avail.
[URL]..But I can't design a solution. Could anyone try to help me out here? I know there are some workarounds to be found, but either the links are dead (check above link) or it's writter in a language I still can't read. Here's my code.
[Code]...
I am coding a VB.NET application which heavily deals with a collection type. See the code below:
[Code]....
I have to type the above line for so many times. If I changed the collection type, then I have to make the change for all the instances. So if there is a way to use "a typedef equivalent", then I can get rid of all these problems. I tried with imports, but it is only for namespaces and it can't be used for classes.
Note: I am using VB 2008, windows XP. The application type is windows forms(VB). EDIT: I made some tries based on code_gray's below answer. This is the first try.
[Code]....
I have a legacy COM-component with an interface declaring a property like this (IDL notation):
[Code]...
This interface is implemented in a calling application written in VB6 like this:
[Code]...
Everyting works fine until I try to do the same in VB.Net. VB.Net refuses to compile code where a parameter of a property is passed ByRef. MSDN says VB.Net doesn't allow such parameters. Is there any way I could implement such a property in VB.Net?
I'm trying to integrate with an API that requires the "Date" header in a web request. As you may well know, .NET has removed the ability to append or even display a default Date header in your request, so I was wondering about a workaround.Here's the catch: you can't use TCPClients because I don't have "permissions" on my server for such a thing as sockets. Is there some way to "cheat" the system to fake a date header or to trick it into posting a Date header? Or should I just give up on this API?
View 3 RepliesI know CodeDom doesn't support partial methods, but is there a workaround? I found a workaround for C#, but I need one for VB.NET.
View 2 RepliesI have a .Net 2 solution with some asp classic pages.I get a specified cast is not valid error when I access the page on my local. Below is the vb function where I get the Error:
Public Function Retrieve(ByVal vntSeqId As String, ByRef vntPart As String, ByRef vntPartKey As String, ByRef vntEntDate As String _
, ByRef vntStatus As String, ByRef vntOrigGblId As String, ByRef vntOrigNetId As String,
[code].....
MVC3, VB.NET, using EF. I am working on coding up a simple function to handle checking for a valid MySQL connection. If the connection fails the test it will use the secondary server connection. This is required because our hosting provider does not provide failover or redundant MySQL servers. The problem is I tried to use a simple try catch method in the HomeController. This fails early because the Entity Framework is looking the connection that was set up when I set it up... Is there anyway to control that connection dynamically?
View 1 RepliesI need to valid the user credentials connecting to server using TCP communication. How to conver the following code compatible to VB.NET 2003.[code]
View 2 RepliesI know that there is no DESIGN, DESIGN_MODE, DESIGN_TIME, etc preprocessor directive value. However, I need something that can do the trick. I can't use a normal If statement, because in my case I need to change the inherited class so that the control renders properly at design time. If not, I'll receive an exception due to the fact that the inherited class is an abstract class.Here's what I'm looking to accomplish:
Partial Class MyCustomControl
#If DesignMode Then
Inherits UserControl
#Else
Inherits WidgetControl
#End If
I'm downloading a bunch of files from a URI but when they get big, I get an utOfMemoryException. I thought at first it was MemoryStream error but I'm pretty sure now that the error is rooted in the declaration of an array of Bytes that's too large. (Half a gig is fine, 1.7 gig is not.)
View 1 RepliesI am Working on Teghax Component.Using This Component we want to find out Block title attribute of dwg file in a client server socket application.
1> We get Block title attributes properly of dwg file in windows application form using the getattribute function().
2> We get Block title Attributes properly in that way:-We take a class library where we take a class.in this class we use getattribute function().Then We access the particular class from another project
But when we use the same class(Keep same structure) in client server socket program.Then it gives an exception.i.e ,"Spaicfied cast is not valid"I am Not getting any reply form teghax developer..I attached exception screen sort.Give me Suggestion How to solve this Exception
Code given Bellow :
Public Function Get_DwgFileAttribute(ByVal Sender As ClsTcpConnection, ByVal msgTag As Byte, ByVal message As String) As String
Dictionary = GetHashtable(message)
Dim varfilepath As String = CStr(Dictionary.Item("filePath"))
[code]....
what's a Class, and Object, a Method, a property and thins like that, but I have this doubt:Let's supppose I have a class "Laundry" this class has (just for this example) 3 propierties:
1.- laundryID
2.- Name
3.- Washers
Id and Name are "primitive" types or simple types (integer and string), but Washers, represent a list of object of type "Washer", that has 3 properties:
1.- washerID
2.- laundryID
3.- capacity
4.- brand
All of them (for this example) simple/primitives types (integer,string,string).So this my dilemma, it is correct to have a constructor like this (VB .net)
public sub new(ByVal laundryID as integer)
'' Here I'll query for the data of the Laundry on DB
'' After that I will query for every washer that belongs to this laundry
[code]....
And inside of that constructor query for all the washers that belongs to the laundry with id=laundryID parameter, and create objects of type "Washer" and add them to the list of Laundry ?I'm not sure If I explain myself, any comment I'll be really grateful, in less words, what's the correct approach (or good practices) to work with class/objects that has properties which are complex (other class/objects).I usually work with ADO.net probably ADO/LINQ/Entity solve this thins in an transparent way, but if they do it I don't really know it.
Note: I'm familiar with VB.net, C#, PHP, so if you prefer explain/help me using examples with its syntax, it's ok
It's kinda overkill (i7, 8GB, SDD, W7 x64) for what I actually need but it is supposed to last for a few years.For maintenance issues I had to install Visual Studio 2005 and it turns out that "Edit and Continue" wasn't working . I found a thread here HTML Code:[URL] in which I read that E&C is not supported in 64-bit OS.
View 2 RepliesI'm trying to make a label transparent. When I set the BackColor to transparent, all it does it take the color of the form it's sitting on, i.e. It's not truly transparent. I've googled it and found this in another thread (from a MSFT MVP)".NET controls do not support true transparency. You can set their BackColor to Transparent (in some but not all cases) and the parent control will show through, but only the parent control. If there is some other control behind that is not the parent it will not show through. That's because the control is not truly transparent. It basically copies its parent in the area behind it and uses that as its background, but that doesn't include sibling controls that may be behind it as well." To me, this is completely unacceptable. Why even include the transparency option when all it does is set the control's backcolor to the form color? I'm trying to add a label over a progress bar to give my user some feedback (because the Visual Studio progress bar doesn't support text, which is also a horrible design shortfall by the way), and have yet to find a way around this.
View 6 RepliesI have created player to stream(broadcast) a video from server to clinet in Lan network,my problem is when I send URL of the video to client it take it and add to playlist but when I want to play it message box show's "InvalidArgument value of 0 is not valid for selecteD Index parameter name:selectedIndexSystem.windows. form" I will but the code of client and server but the I have determine the video which will be broacast in client side. [Code]
View 3 RepliesI found using AndAlso/OrElse, all the time, VERY annoying. It reduces code readability, especially when conditioning get complicated.
View 2 RepliesUsing VB.Net If the grid cell value is empty, i am getting error as "Conversion from string "" to type 'Double' is not valid"Code (gridview_CellLeave)
Dim z1, z2, z3, z4 As Int32
If grvList.CurrentRow.Cells(1).Value <> "" Then
z1 = grvList.CurrentRow.Cells(1).Value
End If
If grvList.CurrentRow.Cells(2).Value <> "" Then
[Code]...
This is a UPD server code to receive from any ip address but when i run it its shows "Cross-thread operation not valid".
Imports System.Net.Sockets
Imports System.Text
Imports System.Net
Imports System.Threading
[CODE]..................................
i mean, if i have an update button for inserting images and i have got another navigator which adds information to the database, how could i delete a selected row in sql server database...In dataset, i used to remove a specific row in database by doing:
me.customersbindingsource.removecurrent()
So, this one doesn't delete anything when the image is included.
1.
[code]....
I'm trying to write some generic code in VB.NET that determines whether or not a SQL server database table contains an identity column and, if so, to return the name of that column.I'm working in Visual Basic 2008 Express and have created a SQL database, "MyDatabase" with 1 table called "MyTable". Within that table, I've got 3 columns, "ID", "Column1" and "Column2". I know, I know... inventive names. Under column properties in the Database Explorer, I've set the "ID" column "Identity Specification" to "yes" and have set the "Is Identity" value to "yes"
View 3 RepliesHow to save a PDF file in a SQL Server column using vb.net code,by memory stream ?
View 2 Replieshow to work with XML.I need to create an multilingual application and need to save the controls captions in sql table with xml data typei started the following:[code]I know this is not very professional but thats all i did until know in SQLNow i have a problem in VB.NET i don't know how to read an xml data type (How to get the value from variables).If somebody can give me an exmaple how to read the xml than i would continue translating for each objects in the form where name is like the variable "btnLogin" and give it the controls.text property to the variables value.
View 5 RepliesI have a property active to indicate status of an employee. Along with all the details, i extract the details from an employee table into a dataset, but however i am not able to get the value present in active as i get an invalid cast exception.
This is the property declaration.
CODE:
Reading bit type sql server db column from dataset
View 3 RepliesI have 2 tables that are related,both have identity columns for primary keys and i am using a vb form to insert data into them,My problem is that i cannot get the child table to get the primary key of the parent table and use this as its foreign key in my database.the data is inserted fine though no foreign key constraint is made.I am wondering if a trigger will do it and if so how. All my inserting of data is done in vb.The user wont insert any keys. all these are identity columns that are auto generated. If a trigger is my way out please illustrate with an example.
View 2 RepliesHave to say that, i managed to create a code which inserts image into the sql server atabase from vb.net program and its working but doesn't meet my requirments:1. when i run the application, select the image file location, it just saves directly to the db. in this case, i would like to import the image in a picture box control prior saving it in the database.2. whilst i have a navigator toolbar which has things like save button and add new infor buttons, i want to leave other details for that tool bar then the imagebutton should only do one task..thats storing image in database.hers the code i wanna share with you:
Private Sub Imagebutton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles imagebutton.Click
[code].....
I am using sqlserver2005.Table1 has a column named bill_no and its type is textNow I want to change its type "Numeric"When I do this the it displays this error message
View 3 RepliesI have this database with a table which has the the following but I have no way to decypher it
DATA, TYPE, FILE TYPE, SIZE, DOC TYPE
0x15234324 , Word.Document.8 ,DOC, 19968, WORD.DOCUMENT.8
The field seems to contain a word document stored in a SQL Server IMAGE column
Has anyone come across this before or a way to extract this data in a readable format?
So far I have tried using PHP to extract the file and write it to a word document but not had much luck.
UPDATE: I now have Visual Studio Express and would like a way to extract this data and save to a word document
UPDATE2: This is what I have in VB sofar
Imports System.Data.SqlClient
Imports System.IO
Public Class Form1
[Code]....