Via VB.Net, is there any way to access the AutoSum feature that Excel has? I have a spreadsheet that I create and populate via a datatable using my application. I know how to sum based upon a predefined range (e.g., .cells(cnt + 1, 21).Formula = "=Sum(U3:U" & cnt & ")") but is there any way that I can just call a cell in my worksheet an...
Greetings Everyone..i just wanna ask is it possible to set a maximum length in my field in gridview? Below is my gridview sample that retrieve a formatted html in my database..All i want to achieve is to limit the maximum length of characters i.e "50" then automatically create a pagination for the succeeding characters..to be posted in...
When I try to connect to a database that was previously opening with a SQL connection I get a "File in Use" error. Process Explorer tells me that sqlservr is still holding the file. Any ideas on how to get sql to release the file from within the vb.net 2010 code? ...
When a user click the .msi, i want a folder called "Your Files", which comes with two small images by default, to be created in C:\Users\YourName\Documents. In short, MyDocuments. What i did is put the following code in program.cs: string myDocuments = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); string downloadAr...
I was just wondering if it's possible to create an app that interacts with a database hosted on a web server... or is it only possible using VB.NET? Also if it is possible, is there any good documentation or tutorials I could reference? ...
Private Declare Function CascadeWindowsNative Lib "user32" Alias "CascadeWindows" ( _ ByVal hwndParent As Long, _ ByVal wHow As Long, _ ByVal lpRect As Long, _ ByVal cKids As Long, _ ByVal lpkids As Long) As Integer calling: CascadeWindowsNative(Nothing, &H4, 0, 0, 0) ...
Hi. I need to pass 2 strings from VB.NET to an OCX written for VB6. VS2008 put a wrapper on the OCX, but while the routine is called, the string parameters are not correctly received. I do not know why but I am guessing that it is because, as I understand it, in VB6 parameters are passed By Ref as a default while in VB.NET, parameters ...
Hi, How can I include a batch file or an .exe file in my setup, that runs after setup is complete? Thanks Furqan ...
hello, how do i convert the string 30.10.2009 in date? (dd.mm.yyyy) thanks :> ...
I would like to count the frequency of words (excluding some keywords) in a string and sort them DESC. So, how can i do it? In the following string... This is stackoverflow. I repeat stackoverflow. Where the excluding keywords are ExKeywords() ={"i","is"} the output should be like stackoverflow repeat this ...
Hi! I'm very new to Regular Expressions, but I thought it'd be the best way to validate email addresses entered on my form. My Regex works, except if the email address entered has an underscore character (_) in it. Because of my lack of experience with regular expressions, I'm not sure where in my pattern I'm supposed to add the offen...
Currently, when I want to use Microsoft Chart Controls on a website, I need to add the following onto every aspx page where I want to use it: <%@ Register Assembly="System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %> ...
I have added a settings file to a project but whenever I reference one of the setting variables I get the following error: Error 2 Reference to a non-shared member requires an object reference. C:\Development\PhoenixApp\Process\CreditCardProcessing.vb 67 77 Process I had to manually add this in a merge conflict and the settin...
I want to create personal folders during installation. I did the following steps: Right click on your setup project -> View -> File System Right click on node “File system on target machine” -> Add special folder -> User’s personal data folder Right click on node “User’s personal data folder” -> Add -> Folder -> typ...
Using Microsoft Visual Studio 2008: ' Create an instance of the open file dialog box. Dim openFileDialog1 As OpenFileDialog = New OpenFileDialog ' Set filter options and filter index. openFileDialog1.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*" openFileDialog1.FilterIndex = 1 openFileDialog1.Multiselect = True ' Call the S...
I am trying to view Crystal Reports(.rpt) on a Visual Studion 2008 VB.Net web page and am having some problems. I tried using the CrystalReportViewer control but this is very slow for me. Just to view a 768 KB rpt file in took over 20 seconds and another 15 seconds to load a page when I clicked the next page button. Am I doing somethi...
I have a DataGridView that is bound to a DataSet and I allow someone to remove a row from the table and I remove the row from the set. My code looks like this: ds.Tables(0).Rows(dgCourseList.SelectedRows(0).Index).Delete() My problem I found is if the grid gets sorted the index of the rows no longer corresponds to the indexes in the D...
how i can deal directly with html page contents like counts the attribute in each tag and sort these attribute ...
I am developing a COM dll library, and I have a little vb.net (vs 2005) application just to test it. I had my object declared in the application as Private m_VarName As MyLib.CMyComClass So far, so good. But now, I need an event to inform the application of some things, so I implemented such event in the COM dll, and changed the...
I have a 500K+ lines vb.net app, written by 10+ different devs over the past 5 years. Many times it gets the system time and/or date and relies on it. Now I have to re-run real cases thru the program for regression testing purposes, and it screws up cases where the date/time matter. My fix is easy, just replace all the areas in the pro...