I have a query that executes fine in TOAD, but when bringing back the results with either an ADO.Net DataReader or DataAdapter/DataSet, it's not recognizing a column in the select statement. See the query below... the column in question has its data coming from a dynamic table or sub-select or whatever you call it. I don't see why this...
I have a two-column ListView linked to a Datapager. The ListView lists all files of a particular type in a particular directory, so the data source is an ArrayList of type FileInfo. Consequently, I had to create a Comparer class to use in the ArrayList.Sort method. FileInfoComparer.vb: Imports System.IO Friend Class FileInfoDateCompar...
i. I am using visual studio 8 using vb.net. I am trying to make a post request that complies with the following schema, but am failing miserably. <?xml version="1.0" encoding="UTF-8"?> <postBetOrder xmlns="urn:betfair:games:api:v1" marketId="2568540" round="1" currency="GBP"> <betPlace> <bidType>BACK</bidType> <price>2.5</price> <size>...
I have a SQLClient.DataSet in VB.NET, and I want to insert the entire thing into a SQL Server table without having to do the following: For Each dr as Datarow in MyDataset Dim sc As New SqlCommand("INSERT INTO MyNewTable " & _ "VALUES (@column1, @column2)", MyDBConnection) sc.Parameters.AddWithValue("@col...
I am developing a Windows Forms application. I have four forms which is inherited from Baseform in another project. In all four forms I am using a label to show some transaction count based on network status. I have implemented a thread which gets the active form of application and setting up the text. The code works fine if application ...
I’m new to visual basic.net. I have experience in C++ programming, but never created gui with it so learning vb.net for some quick gui development. and i want to learn vb.net. I can’t install visual basic express on computer cause i’m on shared computer and such huge install is not possible on that computer. So i picked up sharpdevelop. ...
This desktop app written in VB.Net within VStudio 2008 fails when one of our "power users" tries to run the program: Select permission denied on object 'AcctLogon', database 'MDS', owner 'dbo'. The author of the app is out for a few weeks and I am the "fixer" while she's out. Both of our logins for SQL have permissions for db_owner i...
I'm dynamically creating a RadioButtonList and can't figure out how to add additional text to show up under the radio button. My basic code is as follows and I want sURL to show up under each resultant radio button. For i As Integer = 0 To ds.Tables(0).Rows.Count - 1 Dim iLocationID As Integer = ds.Tables(0).Rows(i).I...
I'm new to vb.net and having quite a challenge with updating a field in a table using the For...Next construct on a data set. Sample code below - can anyone tell me what I'm missing? I know this particular example could be accomplished with a simple SQL update statement, but the actual use for what this code will become requires steppi...
I want to find out the X and Y position of a point which is halfway between a point and another point, in VB.net. Since there is no "direction" property (which would make this much easier...), I have no idea how to do this. C# code is acceptable as well, though I would prefer vb as it wouldn't require a port. Thanks for the help, this ...
I cannot imagine how this is anything other than a bug, but since I do not currently have a login for the MS Connect website I will ask here first. I have Visual Studio 2008 SP 1 with all post SP1 hotfixes I could find relating to the crash installed. Can you reproduce the following crash? Create a new "WPF Application" project using...
After editing some fields, clicking on Update doesn't show the new values. I have tried two ways to retrieve the new values as you can see from this shortened version of the ItemUpdating event (and both return the old ones) :- Protected Sub DetailsView1_ItemUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsVi...
I am converting an application that connects to Quality Center via the OTA API from VB.net to C#. The application makes extensive use of recordsets, but I have not been able to get them to work in C#. Specifically, I have trouble casting Command and Recordset to the correct format for C#. Everything I have tried has failed. Following,...
Hi, I am using a com DLL in the following manner: #Region "API Function" <DllImportAttribute("abc.dll", EntryPoint:="optcntl")> _ Public Shared Function optcntl(ByRef pBlocks As blocks) As Integer End Function #End Region This DLL using the other four dlls to complete its processing. If I change the current directory path ...
Before LINQ I would have my main application return the results of a SQL query into a dataSet. I would then transfer the dataset as a parameter to the external dll. Now I am bringing through a LINQ to SQL query that is returned as an IQueryable(Of vClientTable) object. I want to be able to transfer that set of vClientTable results to my ...
I've created a couple of Comparer classes for FileInfo objects to allow sorting by Name and LastWriteTime properties, but ideally I'd like to combine them into once class, so that I can compare/sort by any property simply by passing through the chosen property name. However, I don't know how to go about this. My comparer class current i...
I'm doing an experiment on WPF and MVVM, and while coding the ViewModel on Vb.net I noticed this red wavy lines under my ObservableCollection(of T)s T_T Anyway, the application is in WPF & VB.Net, under the .Net Framework 3.5 (I checked) and I have an 'Imports System.Collections.ObjectModel' on top of my class. Intellisense shows the ot...
Trying to write a list of oracle commands to XML but keep getting this error. This is driving me crazy. Thanks in advance. "There was an error reflecting type 'System.Data.OracleClient.OracleCommand'." Friend Sub WriteDataToFile(ByVal Commands As List(Of System.Data.OracleClient.OracleCommand)) Try Dim PathName As String...
I have a BLL class which contains properties for the fields in a Country table (CountryCode, CountryName, etc). It also has a property ioDAL, which is a reference to a DAL class (created with SubSonic 2.2), which has same named fields. I have a LoadRecord() method which calls the DAL's FetchById() method that populates the DAL properti...
Hi I'm trying to execute a SQL command, but I just can't find out why this is not working. This is how I defined the "execute" function in my class named "clsSQL": ''#... Private m_sConnectionString As String = String.Empty ''#... Friend WithEvents m_objConnection As SqlConnection Friend WithEvents m_objCommand As S...