I have a windows form that imports data from an xls file to sql2005. I have a browser button, a dropdown list for the sheet names in excel and a process button. Now the excel file has 3 sheets (sheet1, sheet2, sheet3) the columns and data type are not the same so I need 3 different queries to access this file,
I think about CASE, but not very sure,
So if dropdown list.selectedvalue=sheet1 then
run code
What i am tring to do is execute certain code based on a variable held in a module someting like compiler directives, here's an example for lack of an explanation.[code]...
View 2 RepliesWe have a Try/Catch block of code in our web application to trap a certain exception. What we want to do with this exception depends on the current time. If it is between 4:30PM and 3:00AM we will want to send an email, otherwise we will throw the exception.
Try
'Yada
Catch ex as WebException
Dim Time As DateTime = DateTime.Now
[code].....
I have a multiline (> 50 lines) textbox containing plain text. I want to add either a session variable to the text in this box. In asp I would have done it by putting in <% %> code blocks but in .net I am getting the following error: "Code blocks are not supported in this context". I assume therefore that this would need doing in code behind.Is there a quicker way than putting all the text from the textbox in a string in code-behind and then adding the variable on like this? I would like to keep the text in my aspx page if possible.
View 2 Repliesi am making a Reflector,I want Some help with generating Blocks of Code(Loops,Branching,using Blocks,Switch Case Blocks etc).Until now i am able to convert IL to expressions and identifying startoffset and endoffset of a Code Block for Generating Code Blocks..The Trouble i am facing is Identifying the Initializer, Incrementer and Condition in a For Next Loop. which are contained between the StartOffset and EndOffset as Expressions. [code]
View 1 RepliesIs there a way to pass code blocks to a method or class?
I'm trying to write a number of exception handling methods.[cod]e...
I have a form with a "Send" button to test a code to send SMTP emails.It fires the click event when I hit the "Send" button, but the email is never sent if I leave the form running. When I close it, the email is sent.This is not the needed behavior because the User may never close the Application (this is a Client/Server application, not Web).Below is the code behind the "Send" button's click event[code]...
View 1 RepliesI have some code to execute code at runtime...
Here is the main
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
If TextBox1.Text.Trim <> "" Then
If TextBox2.Text.Trim <> "" Then
[code]....
When the button is pressed, it all works and the following files are created: yahoo.dll and yahoo.pdb My question is this: What is the code to load the already compiled yahoo files to execute the code again, without having to recompile the code?
I'm not sure the best way to accomplish this, what i have is 10 checkboxes on a form named chkbox1 to chkbox10, say ther user selects 4 then clicks a button, i was wanting to execute code one after each other like[code]...
View 3 RepliesI am getting this error by simply trying to insert some VB.NET code in ASP.NET markup. See the code:
<%@ Control Inherits="PerformanceWeb.Framework.SiteSettings" CodeBehind="sitesettings.ascx.vb" language="vb" AutoEventWireup="false" %>
<table id="TABLE1" cellSpacing="0" cellPadding="2" border="0" runat="server">
[code]....
I want to execute a code after every 5 min.I am trying to develop the application in .net and using the C# as a backend language.My basic requirement is a C# code which executes after every 5min which i click a start button on my .net form.
View 6 Repliesfor example there is a file named abc.exe in c:
what would be the code for executing this file?
I have a data table that looks like this:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
LAGX03 1698 1112 05-07-2012
LAGX04 4598 1555 05-07-2012
LAGX05 2589 3245 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX07 3698 3458 05-07-2012
LAGX08 2589 4587 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX10 3156 1987 05-07-2012
LAGX11 5547 2011 05-07-2012
LAGX12 9456 3459 05-07-2012
Now, I want to execute a sql query that will display the top 5 based on average, so i did this:
SELECT DISTINCT USERNAME,IAVERAGE FROM myTable WHERE IAVERAGE > 0 AND DATE_LOGGED='05-07-2012' ORDER BY IAVERAGE LIMIT 0,5 and the result is:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX03 1698 1112 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
Now, I want to numberize my query result, so it will look like this:
RANK USERNAME ICOUNT IAVERAGE DATE_LOGGED
1 LAGX03 1698 1112 05-07-2012
2 LAGX09 1598 1142 05-07-2012
3 LAGX06 3321 1155 05-07-2012
4 LAGX01 1245 1245 05-07-2012
5 LAGX02 2211 1422 05-07-2012
Lets say i have a text box and i type picturebox.visible = false; then i press a button to execute it. and My Picturebox is not visible now.so How do i run that command since it was in a text box???
View 7 RepliesI know this requirement may seem weired to many of you but it is one of my project requirement.Is it possible to add code in Sp and execute in .Net exe. Like on button click i call one SP that SP returns few line of code and then program execute the code.
View 4 RepliesBeen spending some time on Codility.com recently and it crossed my mind; how do they execute the code you have created (Specifically pertaining to C# and VB.NET) ?
What I am basically wondering is how would I take a textbox on a form type some code in it and then run that code? Is this possible without 3rd party tools?
I need to to make a timer that will execute my code every 30 minutes
View 8 RepliesCan anyone think of a clever way to execute a piece of code every time a form opens, application wide? I have an app with about 45 screens, and I don't want to drop code in each form load event.
View 7 RepliesCan anyone think of a clever way to execute a piece of code every time a form opens, application wide? I have an app with about 45 screens, and I don't want to drop code in each form load event.
View 12 Replieshow to run code "in the background".As a form is loaded into memory I have the following code filling a listbox from a database table with this sub.I read in one of the documents about making code efficient that I could make this execute in the background.The list box is not needed immediately.
Private Sub getReleaseChoices()
Dim da As New OleDb.OleDbDataAdapter()
Dim cn As New OleDb.OleDbConnection(gCnRefString)
Dim ds As New DataSet()
[code]....
I have an app that allows a user to type in code that can be executed much like vba code in the office world.I currently execute this code with the Proprietary Dexterity code used with MS Dynamics - GP.However, my users need to be able to run outside the Dexterity world.The easy answer is to allow them to type in vb scripting or vb code instead of dex code.However, I can't find an easy way to dynamically execute their code within my methods.CodeCom looked like it could be the answer, but If i'm reading it right, I would have to know what libraries the user is using in their code for vb.Thus, I thought to simply limit them to vb scripting.Unfortunately, I can't find a way to execute vb scripting from within vb, (all the articles are ancient and most links fail - thus I gotta believe there is an easier way).I'm at a deadline where I developed the prototype but trying to use sql statements failed miserably when trying to execute.
View 3 RepliesI am totally new to VB2008, so please bear with this likely dumb question.
I have seen numerous "my first program" tutorial that show you how to create your form, put controls on it, etc. I can get through those just fine.
However, I am wondering: If I compile a set of subroutines into a .exe, how do I indicate which code/sub to execute initially? I am an old school programmer (remember COBOL?), and we always had a starting point; a set of code execute, that initiated execution of other subroutines, functions, etc.
I have dabbled in VBA for Excel, and MS Access, and even those, you indicate in the interface, and menus you create, that first bit of code that brings up the menu, or perhaps the program's main interface.
When ever i execute this code it hangs ..how to troubleshoot
Imports System.Net
Imports System.IO
Partial Class vbIPNexample
[CODE]...
I'm trying to accomplish something fairly simple in VB that I do everyday in JavaScript.I need to parse text between two strings (HTML tags mainly) that have multiple occurrences.
Sample Data:
<tag>test</tag>
<tag>test2</tag>
<tag>test3</tag>
If I wanted to grab the data in the 2nd <tag> in JavaScript I would simply do this:
var result = string.split('<tag>')[2].split('</tag>')[0];
And the only way I seem to get that to work in VB looks like this...
Dim from = string.IndexOf("<tag>")
Dim [to] = string.IndexOf("</tag>", from)
Dim result = string.Substring(from + "<tag>".Length, [to] - from - "<tag>".Length)
I have some code that access an API out on the web. One of the API's parameters allows me to let them know that I am testing.I would like to only set this parameter in my code when I am testing. Currently, I just comment the code out when I do a release build. Is there an automatic way of doing this based on the build configuration?
View 6 RepliesI have a VB.NET application with Enable application framework checked, and Splash screen set. At the same time, I need to run some code before the splash screen is loadedMyApplication_Startup seems to go later, so it's not suitable. I understand it's possible with custom splash screen, but would prefer any other way to make it without more complex customization.
View 15 RepliesSuppose I have two buttons btnCheck and btnOK. I want to execute few lines code of btnCheck from btnOK. So that When I click on btnOK, btnOK's code as well as BtnCheck's Code should be executed one after the other. How can I do this in vb.net
[Code]...
ASPX [code]...
When i click on the div it does not execute the ServerSide Code ...why?
I want a RichText box that will allow me to type basic vb code and then have this code executed. Similar to what could be done with SQL statements and ExecuteNonQuery, is there something similar to this for VB?
View 2 Repliesim having a speed issue with a puzzle solution generator i am developing. its currently running fine.. but i would love to have it tick faster then 1 millisecond.is there any way i could get my code to execute up to uS(microsecond) speed? or even faster heh. i just need a continuous loop faster then a timer that can update the UI, or form?
View 7 Replies