I am at a loss to figure out why this code results in 2 errors when I try to Parse it inthe SSMS.
@Collection varchar = Books,
@Title varchar = 0,
@Authors varchar = 0,
[Code].....
I think that I re wrote this query ten times todaday and continue to get errors and don't know what my problem is
There are underlines in red under the 0 in the BookLoanStatus and under all of the parameters in the SQL.
I'm new to SQL Server but have been using Access with Visual Basic for quite some time.I am moving an existing project from Access to SQL Server 2008 Express R2. Using the SSMS I redid a number of Queries and SSMS puts the queies in a folder entitled "Project" which is not pointed at any specific database on the server.When I try to call a query in Visual Basic I get the error "Could not find stored procedure...".
Obviously there is something that I am missing, but I don't know what. Can anyone tell me where I should have these queries filed in SSMS?
Does the memory used in declaring variables are reclaimed by the OS when these variables go out of scope?Does the memory used be released by setting thier value to nothing? if not, then how can I force the garbage collector to run or excecute at a certain/desired time..How about in Windows Forms..How can we make sure that the memory used in initializing and showing forms be released if those forms were closed?
View 13 RepliesI actually came from VB6 and starting to learn VB.NET. I saw this line of code which I cannot understand how it works nor how it goes.
Private MAX_VALUE As Integer = (1 << 14)
I have just been experimenting with nesting classes within a User class I had already created.
E.g.
Friend Class User
[Number of Properties...]
Friend Class Address
[code]....
I get the same error message!!! "Declaration expected". Also I notice the variable's name is not coming up in intellisense. I have not come across this before as declaring an using variables and objects has been straight forward up until now.
The user clicks a button, a new form is generated where the user enters his/her password? How can I keep an in-memory copy of the username?
For instance in web forms, I can just use Session ("User"). How can I replicate this with winforms?
I've created a 30 point wizard. Every step gathers between 1 and 3 variables. I've created a module and publicly declared the variables there. At the end of the wizard, one master form opens, gets all the variables, and displays them on one form. At this point calculations are run too which populates more variables. This works fine for one instance of the process.
the user may want to be running two instances of the wizard at once. Obviously, if the previous wizard is part complete and they start a new one, the variables are going to get crossed or replaced by the new wizard.Is there a way for the variables to be declared publicly but used in multiple instances?
OK, I'm working on a project and i need to access the property of a usercontrol which I have set.Here is the code in the UserControl
Private Color As Color = ColorTranslator.FromHtml("#000000")
Public Property InkColor() As Color
Get
[code].....
What's the proper way to declare variables in a class? I've been doing something like:
'in a class
public shared teststring As String = "first"
'on a code behind
[Code]....
with shared variables loading a second window or reloading the page (without clicking the button) renders the hello world string. so how do I declare variables in a class but make it per instance?
When I am writing a sub or function that does some calculations etc. I often need a loop or a integer variable to count.
An example:
''' <summary>
''' Compare elements with the new data and perform all necessary actions.
''' </summary>
[Code]....
As you can see, variables like timespan, nullCount and seconds are declared within this sub.
My question is, is it better to declare these in the class? I can imagine that would boost performance.
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
Dim chatters As List(Of Chatter) = New List(Of Chatter) chatters.Add(New Chatter(New Guid("CD863C27-2CEE-45fd-A2E0-A69E62B816B9"), "Me")) chatters.Add(New Chatter(Guid.NewGuid, "Juan")) chatters.Add(New Chatter(Guid.NewGuid, "Joe")) Application.Add("Chatters", chatters)
[code]....
I am unable to understand last 3 lines that are bold and underlined. Please what is hppening here. Chatter and Chat are two classes defined in App_Code folder. Is there any sight that contains all possible ways to declare and initilaze variables and data structure:
Dim chatters As List(Of Chatter) = New List(Of Chatter)
I need to write a simpe calc. program to add, mutiply, subtract and divide. I want to have two textboxes that I enter numbers in and when I click a button, +,-,/ or * a third text box will display the result.Rather than declaring my variables inside each instance of a click event I would like to declare them globally so I just need to perfom the calculation on them and display result. However declaring them globally doesn't work for me. I;ve tried the variables inside the btnAdd click event which works, but as I said I'd prefer to declare them onece globally.
Public Class Form1
Dim number1 As Double = CDbl(txtNum1.Text)
Dim number2 As Double = CDbl(txtNum2.Text)[code]...
recently started converting our project from 1.1 to 2.0
It was fine with the following:
Public ghtAllAppMsgs As New Hashtable(300)
Now it is complaining to change to the following is this the right way:
Public ghtAllAppMsgs As New System.Collections.Hashtable(300)
This is under global.vb class file: here are the imports i already had in this file:
Imports Microsoft.Web.UI.WebControls
Imports Microsoft.Web.UI.WebControls.MultiPage
Imports System.Web
[Code]......
I am writing a program and i need to declare matrices but there will be a different number to declare everytime the program is run so I was wondering if anyone knew how to declare them inside a for loop
eg.
For i = 1 to NumberOfMatrices
Dim matrix i (5,5) As Double
Next
I am new to the forum and new to the visual studio set up and have been working at a practical at home and have ran into some difficulty. The notes say that I am to declare several module variables below the section entitledI have the rest of the form complete but have been unable to locate where I am to place this code
View 1 RepliesI'm developing the skill to create addin for SSMS and I've develop a sample addin for Microsoft SQL Server management studio express using a tutorial[URL]..I tried similar addin with all the needed references in project specified in tutorial code, its not showing anything in the Miscrosoft SQL server management studio.
I've SQL Server express 2005 and Microsoft SQL Server management studio express installed on my machine. and I've created the add in by using VS 2008. Please anybody let me know whether there is wrong in the development environment. I've created thread in this section as project is related to VS 2008,
I am new to Visual Studio.NET but very familiar with the old ASP (using DreamWeaver).I am unfamiliar with this system of having seperate files for VB code and HTML, in my Visual Studio project I have a Default.aspx file and a Default.aspx.vb file. Now I want to declare a variable that will be accesible to all my functions on the Default.aspx.vb file. I.e. if a user clicks on one button and it launches a Protected Sub called Button1_Click, I want that button to be able to read or write to that variable and then if a user clicks on another button, I want it to likewise be able to read and write to that variable.So where should these variables be dimmed?
At the top of the aspx.vb file? Before or after the line that says "Partial Class _Default"?Or at the top of the aspx file? (Within <% %> brackets?)
Is it possible for a class of exposing a type for function returns, without allowing users of that class to create variables of that type? A couple usage scenarios:A Fluent interface on a large class; a statement like "foo=bar.WithX(5).WithY(9).WithZ(19);" would be inefficient if it had to create three new instances of the class, but could be much more efficient if the WithX could create one instance, and the other statements could simply use it.A class may wish to support a statement like "foo[19].x = 9;" even when foo itself isn't an array, and does not hold the data in class instances that can be exposed to the public; one way to do that is to have foo[19] return a struct which holds a reference to 'foo' and the value '19', and has a member property 'x' which could call "foo.SetXValue(19, 9);" Such a struct could have a conversion operator to convert itself to the "apparent" type of foo[19].In both of these scenarios, storing the value returned by a method or property into a variable and then using it more than once would cause strange behavior. It would be desirable if the designer of the class exposing such methods or properties could ensure that callers wouldn't be able to use them more than once. Is there any practical way to accomplish that?In formulating a question, it's difficult sometimes to draw the line between complicated usage cases, and simpler usage cases which aren't quite so important. Here's another usage case, and one closer to the one I'd be most interested in (though I'm also interested in Fluent chaining; being able to have something behave like a C++ reference to a value type would be nice, but probably too much work to bother with).I have a type which is somewhat like the Windows registry, in that it is a hierarchical collection of items, each of which may have a string value, an integer value, and/or a nested collection of items. I wish to be able to support the following types of usage:[code]As for the Fluent interface, my thought would be to have the WithXXX properties return a new instance of a derived class which shadows (not overrides!) the WithXXX properties with versions that simply modify the current instance. The return object from WithXXX would be known to be of the derived class, and would thus use the shadowed WithXXX methods, but once it was assigned to a variable, it would be regarded as an instance of the base class, so the next WithXXX would create a new instance.
C++ a stronger concept of value types than C# or vb.net, including the very useful concept of references to value types; it ensures that references to value types cannot be persisted outside the scope of the type in question. Unsafe code in C# can use pointers to value types, but they don't have the protections offered by C++ references.
I'm wondering about the performance differences between imports and inherits in a .net app.I currently program by creating multiple classes that logically define my objects. e.g. a class for customers, users and product.When i want to use these classes in a page i have to import them eg. "Imports Custmomers" and then later in my code i have to create a variable and datatype it before i can use the sub routines and functions from class.I understand from a coding perspective this keeps it all neat and tidy.So my question Would it be not better to combine all my classes into a base class, inherit that base class, rather than import it, when i want to use it and so cut down on the extra declarations and associated code that come from importing a class; and if i did this would it aid performance?
View 1 RepliesI am trying to write an add-in into the SSMS 2008 R2 IDE. I believe it is possible, though maybe not fully supported by Microsoft. I have created a new project in Visual Studio 2010 of type Extensibility - Visual Studio Add-in. This has created my project and all of the relevant code to get the add-in loaded onto the Tools menu. The only line of code I have added is in the OnConnection method to display a messagebox so I know it has at least loaded.
When I build this as is, it will load as an Add-in into VS 2010 onto the Tools menu - which is fine - at least part is working. But when I try to add this as an Add-in into SSMS 2008 it keeps giving me the error message:The Add-in 'DataFollower.Connect' failed to load or cause an exception. Would you like to remove this add-in? ... Error Message: No such interface supported.
Below is a top half of the code in question. This code was created directly from the VS Add-in template - nothing has been altered. The error occurs on the line:
_applicationObject = CType(application, DTE2)
This is running on a Windows 7 64bit machine, SQL 2008 R2 64bit and VS 2010.
Imports System
Imports Microsoft.VisualStudio.CommandBars
Imports Extensibility
Imports EnvDTE
[code]....
I am building an application that has several forms to it and on my first form, I declare 2 variables that I will need to pass to at least 2 of the other forms. I call them
Public payPeriodStartDate, payPeriodEndDate As Date
on form2, I am needing to pass those variables to a datagridview to present to users. I have the following query that I'm trying to run from that form but I'm given an error that SQL is unable to parse the query:
Code:
SELECT Employeenumber, Exceptiondate, Starttime, Endtime, Duration, Code, Approvedby
FROM Exceptions
where [Exceptions].exceptiondate between '" & payperiodStartDate & "' and '" & payPeriodEndDate"
The datagrid is bound to the form and I'm using SQL 2000.
I have been banging my head against a brick wall for 2 days on this one. Someone please help, I am sure I am doing something stupidly wrong.I have a stored procedure that accepts 2 inputs and has 4 outputs. The SP checks the users database against a given username and password.
[Code]...
I've been using VBA quite a bit in the past to build userforms in Access, that used user-supplied data to custom-build sql statements on the fly, query data from a linked table, read that data into variables, perform calculations and spit out results onto the userform. Now I'm wanting to do some similar things in vb.net 2008.
I would use some code like this:
Set MyRecordset = New adodb.Recordset
MyRecordset.Open "SELECT * FROM Table1", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
MyRecordset.Filter = "ID = '" & Me.cmbAgentName.Value & "'"
With MyRecordset
[Code] .....
Whenever I try this, I get an error message along the lines of "Conversion from type 'Field' to type 'String' is not valid."
What is the impact of creating variables using:
Dim ds as New DataSet
ds = GetActualData()
where GetActualData() also creates a New DataSet and returns it? Does the original empty DataSet that was 'New'ed just get left in the Heap?
What if this kind of code was in many places? Would that affect the ASP.NET process and cause it to recycle sooner?
Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
Let us start with...yes I am new to SQL and really only a lightweight programmer. So I am assuming that I am doing something horribly wrong. I have spent days on the MS forums looking for an answer to no avail. So I am going to give as much info as possible. Application language is VBExpress 2010 and using SQLExpress 2008. The Database contain basic tables, no stored procs, no views, no diagrams. The Application has configured diagrams where one of the tables has inner joins... Tables origninally built in SSMS, but have been altered in VBE.
[Code]...
how many of you out there in the VB.NET community have installed VS2010 SP1 and are experiencing this issue with the loss of intellisense in SQL Server 2008 R2?I'm holding off installing SP1 because I kind of like the intellisense thingy (though RedGate's SQLPrompt 5 is way better - have it at home).So is this pee-ing you off, have you explored workarounds, tries the hotfixes (that apparently don't work for many setups)?url...Please note that even though Cumulative Update 9 (CU9) was released the month there are still people it does not work for..including a coworker using a similar setup as mine (Win7 Pro, x32) This is a disaster and embarassment for MS IMO
View 2 RepliesI've got
Option strict ON
Option explicit ON
How should I declare the variable:-
Dim bounds as? = (From item In xml...<bounds>
[Code]
If I were to execute five different SQL-commands, wich of these way would be the best/most effecient?
Dim sql(4) As String
sql(0) = "SQL-string 1"
sql(1) = "SQL-string 2"
sql(2) = "SQL-string 3"
sql(3) = "SQL-string 4"
sql(4) = "SQL-string 5"
[Code]...
Is there a way in which I could declare an array of labels in VB 2008?
View 7 Replies
