I have an App.conf file which contains:
<?xml version="1.0"?>
<configuration>
<configSections>
[Code].....
As you can see an CrystalReport section is defined in the configSections.
But when I do: config.GetSection("CrystalReport") its returning an DefaultSection object in stead of an SingleTagSectionHandler.
How do I retrieve the Database attribute from the CrystalReport tag using the ConfigurationManager?
How can i get the scope identity parameter in my vb code. I have this so far....
[Code]...
How can i retreive this ID, in the DetailsView1_ItemInserted?
I know this topic is all over the place, but I am not doing an INSERT, UPDATE, DELETE. My statement is a plain and simple SELECT statement and so far has worked with 116 different items in my database until I got to one.
I have a search engine and am going through every single product in our database to add information to it. This is all done through the website, but when I search for ProductID 331 and click on it, it goes to the error page that says Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
It doesn't make any sense to me that the website would error with only this one product. This is the statement I am using. Does anyone know why 1 product would be causing this error?
WebService:
Public Class ProductSearch
Inherits System.Web.Services.WebService
<WebMethod()> _
[Code]....
what i'm aiming at doing here is returning every file on my drive that hasn't been accessed in 90 days. The first listbox has all the directories and the second works off that to return all the files... [code]
View 3 RepliesHow to give another function's returned value in LINQ.[code]but in above query I should write code to store the return value of GetObjProperty Value(p) and add obj-p and returnValue combination to the dictionary.The last line below code is wrong. but please suggest me how to correct it. My intention is, I want output collection(say dictionary) of each fruitname and its color(returned by other function call) for all the fruits which the GetFruitColor is not nothing(it can be empty or valid string).[code]In above code last line is wrong. So how to put getFruitColor in k, how to correct it to save the k value and give me output as dictionary of fruit and k value.
View 1 RepliesWhy this code doesn't work? It returns an unexpected value actually total = 0.
total = Cscore(TextBox1.Text) * CDbl(TextBox2.Text)
When trying this
total = TextBox1.Text * TextBox2.Text
It returns the expected value but I need to pass textbox1.text to the function to get the desirable value
The function is this
Public Function Cscore(ByVal score As Integer) As Double
Select Case score
Case score = 100
Return 5.0
Case score >= 95
[Code] .....
I get the following errors: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. If the subquery only return one result,then it works fine,but if the subquery return more than one results, then the error occurred,how can I resolve this error?
View 3 RepliesI have an SQL Query that looks like this [code]I get two results. The first is the correct one which is -0.0060 and the second @return_value which is 0.This is also the case when I call the stored procedure from my code, I get a 0 back instead of the -0.0060 that I want. This is how I am calling the stored procedure from my code:[code]
View 3 RepliesI have many functions that perform mathematical calculations.
Here is one for example:
Public Function internaldiamofcasingpipecalculation(ByVal Externaldiameterofcarrierpipe As Double, ByVal insulationthickness As Double) As Double
[Code]....
i m working on vb.net and wht i want to do is return some value from the popup window to the page from where popup generated.
for example
i have a multilined text box populated with the names of product categories.
now i want to add more categories to that textbox.
for this purpose i have a link button which triggers popup window from where i can add more categories.
now when i clicked on done in popup the newly added categories should be in the textbox of that page.
I need to check the current date and month to see if they are only 1 character long (1 - 9 - January to September) and if so I need to insert a 0 before the value in a string.Now the code I have been using is Len(Now.Month) which for some reason is returning 4 even though the current Month is February (thought this would return 1).I I use Len(Now.Month.ToString) it comes through as 1, which is what I want.
View 1 RepliesI would like to define Sorted to be of type ErrorProviderMessageCollection, which is what unsortedCollection is defined as.
[Code]...
I'm new to VB.NET and want to parameterise the SQL Connection Strings in my VB.NET App. I've added a function to my Main Form to retrieve the App.config File like:
Imports System.Configuration
Imports System.Configuration.ConfigurationSettings
Public Class MainMenu [code]....
In my other forms when i want to reference the Connection String, i get an error saying getConnStr is not declared?
Private Sub UpdDept_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
myconnection = New SqlConnection(getConnStr()) <=============
Dim mycommand As New SqlCommand()
why i get this when i've declared the Function as Public?
I have a model that returns a dataset to a view and builds a list. The crazy thing is that I have tested this code with IE, Safari on Mac and Windows, Chrome and Opera and all return data. However, on the iPad or iPhone, zero rows are returned from the dataset object. It seems that the model is in fact passing the dataset to the view. I am using jquerymobile to render the view for the iOS devices and have taken that out of the mix to test and it still doesn't work.
[Code]...
Im still doing some amatuer programming, but now in .net and Ive come here with a question that I cant seem to find an answer to... Basically, Ive got a program im writing to interface into my companies AD and return some values, which then trigger other events etc..
The problem Ive run into is trying to find and easy way to compare the returned value when against a list of possible combinations (16 possibilities to be exact), and if its one of them then all good continue on but if not then I need to throw an error and exit sub.[code]...
I am confused which data type to define for my variable which stores value returned by LINQ Statement.
Currently I am defining it as some data type but its generating error like: ""Unable to cast object of type 'WhereSelectListIterator2""`
[Code]...
Here i want myBase to hold the data which has UIN = 4
I have a problem with a For Each Loop that doesn't make any sense. The For Each Loop returns values from a list which are Memory Ranges for a given device. When I check the count in the list it returns 3. The For Each only returns 1.
Here's my code:
Private Sub DisplayDeviceResources(ByRef lvwResources As ListView, ByRef intClassIndex As Integer, ByRef intDeviceIndex As Integer)
Dim curDeviceClasses As New DeviceClasses
Dim lvwItem As ListViewItem
EnumerateResources()
[Code] .....
Just finished reading a book on visual basic "Imports System.IO" and "FtpWebRequest". I double checks this code and tripple checked it but I can't seem to find anything wrong with it, bare in mind I did write it from scratch with help from the book so maybe its full of mistakes.[code]
View 2 RepliesI have been playing around with datareader for a little while, and I can't figure out how to get the number of row returned? [code]...
View 7 RepliesWhen the AlertsSettings.xml is not present the Appsettings is assigned to nothing. The variables that follow that definition rely on the existance of that information which will normally be set by the load method. But when there is a problem and either of the variables do not get a value how do I handle that in the code that relies on those values. The Settings class deserializes an xml document and assigned values to properties.
Sub Main()
Dim Appsettings As Settings = Settings.Load("AlertsSettings.xml")
Dim AlertsServer As String
[Code].....
I use in my Project the IfExistsTable function; in order to see the existence of a table.
For this purpose I use the Select statement as follows.
MASQLComm = New SqlCommand("SELECT COUNT(*) AS [RecCount] From sys.tables WHERE name Like '%" & tName & "%'", SQLConn)
RecCount = CInt(MASQLComm.ExecuteScalar)
After that I take the number which returned in RecCount. Until now the numbers was 1 and 0
And so I was turn the numbers in True or False.Now suddenly the returned number is 2 which I can't understand what it means.
I am using Enterprise block and not able to figure this out.
I am using oracle procedure for inserting records into the database from my asp.net application in VB.net
Though it is inserting records as it should When I try to access the dataset returned I am not able to see the just inserted record details.
In my Oracle procedure I have Output Cursor which should return several column values from the just inserted record.
I am returning to VB and coding after several years of trying to be out of coding :)
I would like in grabbing data retrieved from a SQL database call into an array of sorts so that I can quickly close the database connection. I am having some trouble remembering how to do this. Most of the posts I've found say to use the dataSet() functionality, but I do not have a table name for the structure to mimic. I am selecting from several tables on a remote server.
Im a noob to sql query ,can anybody point to what table would be returned from ths sql Query. [code]
View 1 RepliesI',m using a method in a COM component. The method looks like this [code] 'What to do now to read the different strings returned? Next i've worked with simpler types but not **BSTR.
View 1 RepliesI wrote a program that uses the system.io namespace.It parses through files in a folder and renames them. It does so in such a fashion that it could create dups.
Dim di
As New IO.DirectoryInfo(fbdBrowseFolder.SelectedPath)
Dim aryFi
[code]....
I am working with an XML web service using VB.NET, created using VS 2010. One of my web methods returns a collection(type that inherits from list) of custom objects. It's a simple return statement, it is my understanding that .NET handles most of the tricky protocol stuff as well as serializing/unserialzing of objects.
The issue is in my consuming application when I get the the return value of the web method that returns a custom collection I get an array of the custom objects. Is this normal behavior? It will be easy enough for me to take that array and insert it into a custom collection object but if I could I would like to skip this step.
In my webservice I have converted the ado recordset to xml and returned a string.In my application I managed to convert it back to the ado recordset but now I need to convert that recordset to dao as I need to use some of the functions provided by dao that ado does not have.
View 1 RepliesI am returning a date from my database table:
objSQLDataReader("date")
Which gives me:
31/05/2011 16:00:50
How do I change this to:
31 May 2011
First off, I am new to ASP.net, so this is new territory for me.I am using Telerik controls on a VB.net project. I get the following error as a javascript error for every action on the form. Changing any value, whether its a telerik slider, a radio button, asp:button, submit button, telerik rating. Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500
I understand that the 500 error is an error thrown when the server doesn't have any more details, however I was hoping someone might have had a similar situation and can point me the right direction as I have a good feeling it has something to do with the Telerik controls.
I was able to submit the form using javascript however then I get the following error, and I don't know if they are related or not.Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
