in an sql table there's an id, first name and last name field. i'd like to concatenate the first and the last name fields and display it as one in a dropdown control. this is the vb.net code: con() sqry = "[SELECT QUERY]" sqcom = New SqlCommand(sqry, sqcon) da.SelectCommand = sqcom ds.Clear() da.Fill(ds) ddl_a...
Hello, I need to create a keyed hash for a string of XML to send to a 3rd party. This is the code I am using but it is producing a different hash then the example the 3rd party has sent me. I have been through all the tutorials I can find and re-read MSDN again and again, what am I doing wrong? Or should I suspect a problem at the other...
We have an application that has a coulple of .ashx files used to upload files to the server. The problem we are having is what we we make changes to these files and republish the app, it does not update the .assh files. Really it does nto make the changes in the code behind. Everything else is updated. We are using Visual Studio 2008...
I have been tasked with getting a asp.net (vb.net) talking to an analysis services engine on our production servers. The web server is a separate machine from the web server. The web server runs as the IUSR_ user. The application (of course) works on the development machine which has both IIS and Analysis services on it. The problem I se...
My application (vb.net) sometimes throws an "access denied" exception when attempting to delete files in the AppData folder and I'm not sure why. I confirm that the file exists before attempting to delete it and have not done anything to make it readonly, etc. The interesting thing is that it seems to go okay when I'm logged in with Ad...
Are there any way to do so? I prefer to use VB.NET or Java and try to avoid to use VBA. Thanks! ...
I have a gridview and in that gridview i created a list of imagebuttons programmatically with an addhandler as follows: Dim deletecshr As New ImageButton deletecshr.ImageUrl = "\images\bttnDeletemini.gif" deletecshr.ToolTip = "This Will Delete All Cashiers" AddHandler deletecshr.Click, AddressOf deletecshr_Click deletecshr.Attributes.Ad...
I have a bunch of Excel workbooks that contain multiple worksheets. I want to loop through each workbook and export each worksheet into it's own new workbook. I want one worksheet in each new workbook. Here's what I've got so far: Sub ExportWorksheet(ByVal worksheet As Excel.Worksheet, ByVal filePath As String) Dim xlApp As Ex...
I am converting DataTables to a generic list and need a quick and easy way to implement a Find function. It seems I am going to have to use a Predicate. Upon further investigation, I still can't seem to re-create the functionality. I have this predicate... Private Function ByKey(ByVal Instance As MyClass) As Boolean Return Instan...
Dim tenItem = From t In _InvalidFeeList _ From i In ItemCount _ Where t.FeeCode <> i.FeeCode _ Order By t.Description _ Ascending Take (10) Dim feeList As List(Of AccessorialFee) = tenItem.ToList() I am getting "Can not convert to System.g...
I'm working on becoming as familiar with C# as I am with VB.NET (the language used at my workplace). One of the best things about the learning process is that by learning about the other language you tend to learn more about your primary language--little questions like this pop up: According to the sources I've found, and past experien...
Okay, some background first. We needed an inter-process reader/writer lock. We decided to use a file and lock the first byte using LockEx and UnlockEx. The class creates a file in the system temp folder when it is created. The file is created with readwrite access and share read|write|delete. We also specify DeleteOnClose so we don'...
I need the intPtr for a form. Control.FromHandle(control) gives me the control from a handle, but I need the opposite--get the handle from a control. How do I do this? ...
I need to validate a basic authorization header that is being sent to my HttpListener in VB.NET. I'm grabbing the header like so (feel free to point out better ways to do this as well): EncodedAuth = Context.Request.Headers.GetValues("Authorization")(1) Now how do I decode them? I understand the theory but I can't seem to find the r...
I've read that it's unwise to use ToUpper and ToLower to perform case-insensitive string comparisons, but I see no alternative when it comes to LINQ-to-SQL. The ignoreCase and CompareOptions arguments of String.Compare are ignored by LINQ-to-SQL (if you're using a case-sensitive database, you get a case-sensitive comparison even if you a...
I have a table and I need to select the record based on an Id. I only want to return the record that has the Max(Date) on a date field. How do I do that? In SQL Server I use this SELECT * FROM dch WHERE EffectiveDate = (SELECT MAX(EffectiveDate) FROM dch WHERE ID = 99) AND ID = 99 How can I do this in Linq. Unfortunately this app is ...
Anyone know of an HTML parser for VB.NET or C#? I know .NET has a lot of XML support, like XMLReader and XMLWriter. Is there an HTMLWriter or HTMLReader? Ultimately what I'd like is a library that will parser an HTML file and raise events based on the tags it finds. Anyone know of a library to do this? ...
I have a Search Form that can search by a few different fields. The problem field is birthDate. On the form it is a string. In the SQL 2005 db it is a DateTime that can be null. The code below is sequential as far as declaring the variable on the form and then setting it. Then the call to the BLL and then the call to the DAL. On ...
Is there a more elegant way to structure the following code, which takes a comma delimited string containing certain values in specific positions and assigns the values to the properties of an object? // split comma delimited items into a string array Dim items As String() = myList.Split(CChar(",")) // Assign my...
Hello, I have a library that interacts with our phone system, ie, Hey phone, call this number for me. This library is used in one of our in house products. I would like to put this instead in a service, so that any of our in house products can send the service a message to place a phone call. So basically I want to communicate from a ...