I am trying to create a session after the else statement. How do you create a session and for it to be read by another file ?
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
[code]....
some variables in my class:
[Code]...
i wana create session content all of these fields to use some of them in ctrls.
I am trying to find the way to create RDP session on remote computer using VB and net framework.
Because my company is using RDP(not a console session), some processes that have window that is to show logs and event must be executed on the screen.
However there is a lot of computers, I have to find some solution that is to execute remotely.
The problems that I encounter are as below.
1. if there is no session(in case of restarted) - I have to create session.
2. if there is session - I have to get appropriate sessionID
3. Remote execution - to execute remotely on the session.
I'm looking for a little assistance in creating a network printer. I will have all the information required to create it, but I'm not sure where to start looking. I just need to create a printer in the current session of the user running my program.
View 2 RepliesTo create a program that asks for input then uses an else statement to create a handling fee balance.
Input: sales record - first name, last name, purchase amount, balance before purchase
Output: report - full name, old balance, purchase amount, handling fee, new balance
Definitions: handling fee is 5% of the old balance if the old balance is less than $1000.00 else it is 2% new balance = old balance + purchase + handling fee
Processing:
Ask for and receive sales information
Calculate new balance
Print output report
End the program when a purchase amount of 9999.99 is entered
I am storing a session variable that a user types into a textbox. With their valid input, their session gets created and they get a little more functionality than the regular end users of the site.I was wondering if it is possible to find a way to add someone's session variable to the end of a URL. This way we can email a link to one of our clients, they click it, and their session has automatically begun. They already have the textbox to enter their code into, but I was told that it would be much easier for the users to just click a link that will start their session.
View 1 RepliesOn startup of my software which i developed in vb.net, it connects to mssql server. I want to have session id or session number of the connection with mssql. I'm sure it is unique number and i want to use this session in my software for different purposes. My question is
1. is there anything like session id or session unique number when you connection mssql server
2. if yes to 1 then how i can get it in vb
I have had several occasions recently to access a specific class several times over a relatively small time frame.So I've been storing the value of the class in Session and trying to access it on page load, if it's not available creating a new instance and storing that in session.
So instead of constantly replicating the same code for different classes on different pages I'm trying to create an extension method to do this for me.
[Code]...
I'm stuck on what to do when I make my new instance of my class (it would have to have a New() sub)
I'm not sure where to go from here... or even if this is the best way to do it.
I created a sql query to check if the mobile number is registered or not. If its registered, it will send the new pin code to the customer and if its not, the customer will get a message that "This number is not registered or you are not authorized to this"... something like that... Sending of new code is already working. I just dont know how to make it as conditional statement like PHP. After you query on PHP, you can just set a variable and make a conditional statement..Here is my script in vb.net:
Private Sub CheSMS()
Dim SQLServer As String = My.Settings.SQLServer
Dim conn As SqlConnection[code]......
how to create a conditional statement if the value of rows is zero or not.I want my output to something like... IF the value is zero, an sms message will be sent to the client that he is not registered ELSE an sms message will be sent containing his new autogeneration code. Been working on this for a month but i have no luck.
Here's my code:
Private Sub CheSMS()
Dim SQLServer As String = My.Settings.SQLServer
Dim conn As SqlConnection
Dim cmd As SqlCommand
[code]....
Option Explicit On
Option Strict On
Option Infer Off
[Code].....
For example, 10 people cost 800, 11 people the cost goes down to 770.
well i am not that good at the programming i was about to make a small program that allow me to change a character to another , like if the whole text contains the litter "a" in some places i would like to change it to other character in the same places they are, but instead of having it in the same text box , the program transfer it to a label with the changes i maid
View 23 RepliesIn my first application I need to create a multi-level "IF" statement and I am a little lost on how to proceed. The idea is to do figure out an estimate on costs based on the quantity of products being sold. I can do this in Excel, but the VB code escapes me.
So I'll show you in psuedo code what I want to do.
IF comboBoxA = 1 and comboBoxB = 1 then
value X
IF comboBoxA = 2 and comboBoxB = 1 then
value X
If comboBoxA > 3 and comboBoxB > 1 then
(comboxBoxA * costA) + (comboBoxB * costB) = Value X
I have another IF statement that will work off the calculations here. Haven't figured this one out yet, but I haven't gotten there yet in my form.
If Value X > Y Amount then
Offer product Z as a better idea
i need to create a xml file to be used for translate from english to spanish, i have create the file using sql server since i have data on my server this is how it looks
<row ENGLISH="" SPANISH="" />
<row ENGLISH="Align" SPANISH="Alineacion" />
<row ENGLISH="Body Motion" SPANISH="Movimiento del cuerpo" />
<row ENGLISH="Cut" SPANISH="Cortar" />
<row ENGLISH="Distance" SPANISH="Distancia" />
I'm trying to create a quiz system and I have 200 question stored in question table.I have two quizID which is 1 and 2. Each quizID have about 100 questions. I trying to randomly select 50 question from the 100 question.
SELECT [QuestionID], [Title], [Answer1], [Answer2], [Answer3], [Answer4], [CorrectAnswer]
FROM [Question]
WHERE ([QuizID] = @QuizID)
ORDER BY NEWID()
I'm trying to create a parameter insert statement for an SQL server Db. when i've used similar code for an access db, it works fine. can anyone tell me what i'm doing wrong? Public Sub SubmitMyData(ByRef getArray)
Dim MySQL As String = "INSERT INTO WebSurveyResults(Q1,Q2,Q3,Q4,Q5,Q6) VALUES
Dim myConnString As String = "Data Source=jasonwucinski1.db.1111111.hostedresource.com; " _
& "Initial Catalog=jasonwucinski1; User ID=jasonwucinski1; Password='myPW';"
Dim thisConnection As New System.Data.SqlClient.SqlConnection(myConnString)
[Code]...
I want to extract
[code]...
using a regular expression. I have a regex like this:
FROM.*order
which extracts FROM codes WHERE FieldName='ContactMethod' and IsNull(Deactived,'') != 'T' order Also, how can I get rid of the capitalization?
In my programming task I've gone down a dark alley and wished I hadn't, but there is no turning back now.
I'm building up a SQL statement where the table name, column name and id value are retrieved from query string parameters i.e. ("SELECT [{0}] FROM [{1}] WHERE [Id] = {2};", c, t, id)
But it isn't as bad as it looks, I'm protected: Only authenticated users (i.e. signed in users) can execute the Page_Load I'm checking that both the table and the column exists beforehand (using GetSchema etc.)I'm checking that the Id is an integer beforehand All my tables have Id columns The database connection is reasonably secure
[Code]...
I am tring to bind a data to listbox with where combobox.selectedvalue. My code is below; I am using data entity in wpf project;
Class Window1
Dim db As New AdvanceEntities
Private Sub Window1_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded[code].....
Also I need to create a query with Join In statement. I need to get two table in one query, they have same values in USERID collumn.
I need to create a Select Case statement to assign the per check processing fee:user inputs number of cks into textbox that i need to validate the input if user puts in a negative amount.
10 cents for <=20 cks written ea month
8 cents <= 20 to 39 cks written ea mo
6 cents <= 40 to 59 cks written ea mo
4 cents for 60 or more cks written ea mo.
Also, I have a label programmed to display the $10 monthly fee thats has to be included into the: Total monthly fees.
Here's the coding I have so far:
Const decSERVICE_FEE As Decimal = 10D
Const decTWENTY_OR_LESS_CHECKS As Decimal = 0.1D
Const decTWENTY_THRU_THIRTYNINE_CHECKS As Decimal = 0.08D
[code].....
I want to enforce validation rule in create table statement for a coloumn. im using vb.net as front end and access as back end.
View 2 RepliesI am trying to create a LINQ query statement that retrieve intersecting data from 3 datatables (dt, dt1, dt2). My first attempt to do so with the following LINQ query statement was successful: [code] However in my design, I would need the LINQ query statement to be dynamically generated, because I want a user to be able to retrieve intersecting data entries from VARIABLE number of datatables. In this case, the first option is not as good as the "INTERSECT" query operator, with which I can just easily connect each SQL query statement with a "INTERSECT" operator. The problem is that my second attempt using the "intersect" operator fails, and after many trials and errors I still can't get it to work. [code]
View 5 RepliesI have an SQL statement which i need to code in vb:
CODE:
Notice the fields prodno1 and prodno2 in the table structure.. this is part of a number of sql statements i need to run and put inside a loop. my problem is i want to automatically use this same code such that on the next loop, this sql statement is going to be:
CODE:
Note that in this "2nd loop"
- the table name is now r3 from r2 in the first SQL statement
- there are now prodno1, prodno2 and prodno3 instead of just prodno1 and prodno2
- in the WHERE clause, the p.prodNo becomes p.prodNo2
And so on and so forth.. so for the 3rd loop
- there's going to be r4
- there's going to be prodno4
- in the WHERE clause i will use p.prodNo3
I would like to get some input as to how I would create the same code without a dreaded "goTo" statement. This is something i've wanted to get an answer to for a while and just thought about it again.
[Code]...
See
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
I was convinced that If <expression> Then <statement [:statement]> Else [statements] in concrete form of If a = b Then SayHello() Else SayBye() End has sense. I read article on msdn on If-then-else, but I forgot why I was reading, so I concluded, that snippet above means this
If a = b Then HelloIsSaid : IsNotEnded Else ByeIsSaid : IsEnded But I have tested it now, and I see, that Else without statement is nothing more than decoration. It would be pretty good if it had function I described. Do you think its good request? Or do you know any circumstance where this Else has some function?
y friend and I are re-learning Visual Basic, and we are stumped on this bit of code.
For intAsterisks As Integer = 0 To intLine - 1
lblAsterisks.Text = lblAsterisks.Text + "*"
Next
I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
[Code]...
A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
