I have some code that will give me a week number, But How can I add to my code for checking if a particular year has 52, or 53, weeks. there is also a leap year to consider, I would like my week number to reset when the new year starts to week Number 01,so here is my code can anyone add to this code for checking the above..[code]
View 16 RepliesProtected Sub updatedata()
Dim command As New MySqlCommand("UPDATE company_alert, company_financial SET company_alert.alert_value = (company_financial.receivable * 360 / company_financial.revenue)WHERE company_alert.alert_id='DSO' AND company_alert.stock_code = company_financial.stock_code AND company_alert.year_id = company_financial.year_id AND company_alert.period_id = company_financial.period_id", conn)
[code]....
How am i to do the checking in db that if stock_code already have in the company_alert it will go to insert..
I am using the given code to copy my database files...it works like a charm in debug mode but as soon as I create a setup, it stops working. The error is
"Database Detach Failed"
I tried checking the code line by line and found that the code does not enter the IF block.I have no idea why.
Public Sub bk()
Try
Dim strDatabasePath As String = My.Computer.FileSystem.CombinePath(My.Application.Info.DirectoryPath, "LIC.mdf")[code].....
code for checking out using an online shopper i have the products what i need is help on getting the checkout to work.I want it so that when i lclick checkout i get the total amount, and when i enter the amound tendered i would like the change to come up with however mcuh change is left?
View 21 RepliesI have conditional code checking in a card game Im working on and it just feels wrong.I m looking for a better way.Right now, all my functions return a card. If I get a card Im usually done and can fall out of my nested structure.If I dont get a card I have to test a condition If card is nothing.And this condition gets repeated ad-nauseum.Here is a small sample of the code.
card = FindMaxTrump(playableCards)
If Not card Is Nothing Then
'If we found a trump at all[code]....
This might be a fine way to do it, but the constant check for a null card is what has me wondering if there is a better approach I'm missing.
I have been using the code below to tell if the computer has an internet connection. It works fine on my home computer but when I run it at work on our network which has internet, it fails. I can go to the sites I use below in my browser but when this is run in my app, it returns false. Any ideas why? Is there a better way i should be checking?
[Code]...
I am trying to implement a function for my SSRS report which will return a color value depending on the values of three dates.
[Code]...
I am using following code in rowdatabound fn.
Protected Sub gvwMileStone_RowDataBound(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
[code]...
ddlEProjectLevels is dropdownlist in edititemtemplate.Whwn i click edit in 1st row ddlEProjectLevels gets loaded with data from database.But in 2nd row dropdownlist does not contain values.Again in 3rd it gets loaded from db.Means in alternate rows,when i click edit dropdownlist(ddlEProjectLevels) doesnot load values.Can anybody help?
A long time ago, on a PC far, far away from Windows, one MS-DOS program (the father) could run / execute / spawn another MS-DOS program (the son). When the son terminated, it could set a return code which could certainly be interrogated by an MS-DOS batch program or, I think, by any father program that invoked it (depending on the language in which that program was written). I have a small utilility which I want to invoke from my application, and, since that utility sets a return code, I would like to interrogate it in my application when the utility terminates. I've looked through the MSDN Library but could not find anything that seemed to cover this situation. Is there a way to do this in Visual Basic 2008 Express
View 2 RepliesI have below code in vb.net.
[Code]...
I want to check at client end whether the entered date in text box is future date. I mean this textbox should allow future date only. code the above problem using jquery or vb.net
I am a new member that has just start coding. Im currently working on a small application for a desktop that will give me information from my system. I have code that works but might not be great. I have code that checks that the network is connected but need it to keep checking and updating. I Have tryed loops, goto and timers but not having any luck. Can anyone help point me in right direction. Here is my code so far.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text = TimeOfDay
Label8.Text = "Time :"
[CODE].........................
Is there any better performance by checking for a true value like this:
[CODE]..............
Than like this:
[CODE]..............
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
View 2 RepliesCheck Score: The winner is the one with the highest score less than or equal to 21If both scores(player total and computer total) are over 21, or if both are equal but under 21, the game is declared a draw.
There is something wrong with this line:
If intPlayerCardTotal < intScore And intComputerTotal < intScore Then
MsgBox "Draw"
[code]......
With this code i check the serial serialnumber of a usb stick.
[code]...
It is not perfect because the programma crash when there is no usb in de PC.But how do i search fot the sctick if it has a name , for example PPH ? And not G: , because it is everytime a different station.
I 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 am writing a vb.net program which gets a c program as an input and checks it for errors,now i want my program to skip the comments in the c program,i have written some code but its not working
For Each line In TextBox1.Lines
sample = TextBox1.Lines(k)
Dim len As String
len = sample.Length
[code]....
Basically, I have a list of dates in a SQL table with some statistics next to each of them. I want to compare the dates in the table with a certain date I choose. However, my dates in my table are stored as Varchar(50) (and have to be). Apparently I can convert the date in the table into date type but I don't know. Does anyone know how? My current code can be seen below.
[Code]...
I have a form which contains a checkbox field. On page load I want to create a separate checkbox for each customer in my Database. The code I have to create the checkboxes for each customer works fine. However, I also want to check in the database if the customer is set to unauthorized if they are then I want to check there box. I also have code for the case where the user checks a box. If a box is checked I update the database setting the unauthorized attribute to true. My problem is when I check a box it works fine and the box is checked, however if I reload the page all the boxes are unchecked. So either my database update is not updating the database or the way I check on page load for checked boxes is incorrect. Any ideas?
The code for the asp checkbox field:
<asp:CheckBoxList id="check1" AutoPostBack="True" TextAlign="Right" OnSelectedIndexChanged="Check" runat="server">
</asp:CheckBoxList>
The Code for the page load:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sql As String = "SELECT Name, unauthorized, ID FROM Customer ORDER BY Name"
Dim dt As DataTable = db.execDataTableQuery(sql, "Customer")
[code]....
I am trying to check whether a row is getting inserted into my database. It is throwing an error even when it does insert (it's a database issue that will get resolved later when I get a newer version of Microsoft Access), so I can't check whether the insert is successful based on whether there's an error or not. I think I need to check the AffectedRows of something, but I'm not sure what. I've been looking for info on how to do this but I can't figure out how to make it work for my exact situation. Here's a general idea of what my code looks like:
Protected Sub Wizard1_FinishButtonClick(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.WizardNavigationEventArgs) Handles Wizard1.FinishButtonClick
[Code]...
But the numInserted is coming out as 0 every time even though the insert is successful. It may have to do with the fact that myIns1.ExecuteNonQuery() throws an error even though the insert is successful.
-EDIT- I discovered that the "duplicate values" error is because it is somehow attempting to insert the record twice. I have no idea why it's doing that though.
The following line of code gives a warning with Resharper: 'Comparison of floating point numbers with equality operator. Possible loss of precision while rounding values.'
Dim samples() As Single
If samples(i) = Nothing Then
samples(i) = _mPreviousSamples(i)
End If
What is the best way of checking if a value is present?
I am trying to figure out how to check a string can contain a certain value.In the begining I had a checkbox and wanted to hide a ceratin field depending upon which checkboxes were selected.The problem with this is that the value is always = to the first value.
I got around this by writing these values into a hidden textBox and using a loop.So now I have a textbox and if the user selected the 1st and 3rd choice the textBox would = "AC" If they selected all choices it would = ABCD etc...How can I determine if the values in my textBox contains just letter 'B' ?
I tried this:
--------------------------
Dim values As String = [String].Empty
For Each item As ListItem In section2List.Items
If item.Selected Then
[code]....
but this doesn't work.
I need to check if my SQL statement returned any results from the Access db I'm using to store my data.
I have this code atm:
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:Computing Projectdatabase.mdb;")
cn.Open()
[Code]....
I would like to be able to check (maybe via a boolean value or something) that this result returned a query. I'm using VB.net.
I've been wondering how to do that for a while. (I never really needed it so far ). I wanna make e.g. a simple alarm script (waits for 6.30 am and makes a beep). The only way I could think of it is make a loop in the main function which loops until 8 hours later. Is there any other, more civilized way (probably event?)
View 6 RepliesHow do I check which functions are in a dll I don't who's contents are unknown to me? I am looking to use a certain function and I have a couple of dlls and I don't know in which one it is are its name. So i need to be able to show all function available in a dll and their parameters.
View 6 RepliesIn my application i have set a reference to an activeX component that has been written in vb6(that's not important) What i have done is Here (woo my first hyperlink i hope it works lol) But this is neither here nor there, what i would like to do is put a check to see if the object that has been assigned the activeX component has been assigned it. What i can think of is:If myObject Is Not Nothing Then'set some other stuff End If
The only trouble is, obviously i have an error. Over the Not Nothing I have the following error: 'Is' requires operands that have reference types, but this operand has the value type 'Integer'.Is the type 'Integer' at the end there refering to the Nothing being an integer -1 or 0 and i'm not sure how i would reference the type active x.my question: How can i check if the activeX component is an activeX component and not a whisp of thin air/nothing.
I am trying to make a form that is connected to all my systems at work, this form will not be doing much, it will have an image representing each system, all I want the application to do is if one system is down, the image will turn into red, and if its up, it should be green, to be more clearly and make it simpler, I want it to be linked to more than one destination, each time one link goes down, its image changes to red, and that it. But the problem here is i dont know where to start from, specially that I don't know how to link and get a true or false for the connection!
View 3 RepliesThe following piece of code executes a SELECT query and places the result into a textbox, but if the query returns nothing an error appears saying that there is no value and it won't continue the lines of code after it. (I modified code I found on a website after a Google search, I'm not sure if this is the best way to do it but it seems to do what I want.. so far)
[code]...
How would I change the code so that it checks the query to see if it returns a result? I'm still not too sure what the SqlDataReader can do fully, so I'm not sure if it can check for a result.
what the following code is ment to do is generate a bunch of numbers between 1 and 49 using the while loop to check if two of these numbers are the same. Problem is two numbers are still being generated the same and I know that the numbers generated again will not match them originals so it stops the loop.
[Code]...
i hope to create an application to check vb.net syntaxes (for simple function or methoe). Application will be given richtext box to add function or method and when submit, need to check that vb.net syntax and it will be execute by powershell.
View 1 Replies