I'm doing this right now - .Add'ing parameters and then at the bottom I'm looping through them and setting the Source column by just removing the "@" character from the parameter name.
[Code]...
I'm loading the results of different stored procedures into a DGV.If the second time I load I have less columns - the DGV does not clear the extra ones.Seems if I do dgv.columns.clear I mess up the DGV in general
I've got this so far
'reportDGV.Columns.Clear()
'reportDGV.Rows.Clear()
reportDGV.DataSource = Nothing
reportDGV.DataSource = caseBAL_C.runReport(reportDrop.Text)
I am try to modify this code
_adapter.UpdateCommand = New SqlCommand
With _adapter.UpdateCommand
.Connection = _connection
.CommandType = CommandType.StoredProcedure
.CommandText = "CaseInfo_Update"
[Code]...
VS 2008 Creating a Password Application with Do Loop
View 4 RepliesI have the seperate sql commands that will use the same parameters from a database. I can add the parameters to 1 of the commands, but when I add them to the others I get an error.
dim updateCmd as new sqlcommand("USP_TableUpdate", myConn) with {.commandtype = commandtype.storedprocedure}
dim insertCmd as new sqlcommand("USP_TableInsert", myConn) with {.commandtype = commandtype.storedprocedure}
dim deleteCmd as new sqlcomman("USP_TableDelete", myConn) with {.commandtype = commandtype.storedprocedure}
[Code]...
I was looking at a tutorial for SQLParameters and apparently I need to Import something for my code to work.I downloaded Microsoft Patterns and Practices a couple of weeks ago, and have been using that but I can't figure out what I need to Import for the VB.NET code on this website to work:[URL] Of course, I'll me modifying that to what I need it to do but at present I'm just after an understanding of how it works, but I've got no clue what to do about Microsoft.ApplicationBlocks.Data.SQLHelper, where do I find it?
View 5 RepliesI have a table, I add a dataadapter to it and it has all the commands. There are lists of paramters for update,insert and delete. I wonder where does the Visual Studio find the related informatio on the size of the parameter? Since I believe it is reading from a wrong place or I did not set someting correctly. While the corresponding NvarChar column in dataset and database table is having the size of 20, in dataadapter it is all 0!
View 3 Replieswhy the size of all SqlParameters generated by VS2010 are set to 0, while when I look in the dataset all the columns are set to different sizes but when I read it from sqldataadapter they are all set to 0. Isn't it going to make some other issues in future? I mean, I have many sqlparameter with NVarChar types that they are generated by VS2010 and the size is 0!
View 1 Repliesway to create and initialize SqlParameters in VB.NET? Using 3 lines per variable seems quite excessive. Unfortunately the constructors for this class are rather ridiculous, so I'm thinking of just writing my own sub for initializing each parameter. This is how I've been doing it.
Dim ID As New SqlParameter("@ID", SqlDbType.Int)
ID.Value = val
query.Parameters.Add(ID)
[Code]....
I have this code
Code:
Public Function ExecuteDataReaderSP( _
ByVal storedProcedureName As String, _
ByVal ParamArray arrParam() As SqlParameter) As SqlDataReader[code]....
I try various ways to pass the parameters, every time it return a different error.How is the correct way to pass those parameters?
I'm creating 50 picbox in code. they are named Area1_1 to Area 1_50.
They all have different XY position and different size, setup in % of the form width.
Like this:
Code:
Dim Area1_1 As New PictureBox
' Dim 48 other box...
Dim Area1_50 As New PictureBox
[Code]....
But it don't work. Probably because the controls is not added to the form yet...
i have to create for loop that create each time a new GroupBox with new name and location this is not a homework.it is a personal Application to manage my information [code]i have to change the name of the first Dim in the loop each time , but i couldn't.
View 2 RepliesI need to create a variable number of Group Boxes, at runtime, inside an existing Layout panel. The name of the Group Box also needs to contain the integer, from the loop, as part of its name. i.e x = 1 to 3 > GroupBox1, GroupBox2, GroupBox3
View 5 RepliesI have some variables that are distinct by numbers, like in1, in2...If I have for loop, how would I access those variables, using the counter, and attaching it to the variable?I believe in JAVA, you could just use in+ct... where ct is the counter to access the variable.also how could you make a new variable in the for loop?Initially I had variables declare outside of the for loop. The problem was how to access those variables using the for loop.
var_nm1 = in1.Text
var_nm2 = in2.Text
var_nm3 = in3.Text
Dim nmList(2) As Integer
[code]....
This is object oriented programming, and I made the textboxes in1, in2, and in3 using the GUI editor. that was so easy.
i have a web browser control, that refreshes pages on a loop after calling a few subs, i need to create a delay in the loop so that the page has a chance to refresh and redisplay before it loops again. i tried the code below, but it seemed to freeze the entire form, elements including, so the web browser didnt refresh before the loop, so how could i create a non form-freezing delay for a loop?
For count = 1 To 20
WebBrowser1.Navigate("URL")
simcheckcheck()
[code].....
I have ran into a situation where it would be a lot faster to create a thread by the users demand. Basically, what I have is some kind of downloading program which grabs URLs from the clipboard into a DataGridView. Now when multiple URL's have been added, it becomes really inefficient since only one URL is being processed at a time.Now what I wanted to do is, create a thread for each URL. The parameter for each thread are the URLs which are stored as strings inside the DataGridView rows.[code]
View 3 RepliesI wanted to draw a chart on a picture box. So I create a form, put a picture box on it, and then in the code of Form_load, I put a handler to the paint event of the picture box. This seems to create an infinite loop, judging from the behavior of the form.
View 19 RepliesI am trying to populate a dictionary with objects created from data in a recordset, but am having difficulty with VB's object referencing. I am very new to VB. Pseudo code of what I am trying to do:
dim dict as Dictionary
rs = getRecordSet
while rs.moveNext
set myObj = new MyClass
myObj.properties = rs.relevantFields
dict.add myObj.getUniqueKey, myObj
wend
However, all 'objects' in the dictionary are actually references to the most recently created (and thus last) object in the dictionary. I know why what I am doing above is not working, but I don't know the correct way to do it so that each element in the dictionary is it's own object.
im doing this:
[code]...
but im wondering is there anyway i could say add to the "first-parameter" instead of specifying a name like @CategoryName?
I would be grateful with some help with reading a text file into a Richtext box. The code I have at present appends the first line of text as I want it but the rest of the lines of text do not alter. I need a loop to read to the end of file and display in Richtext box. the code i have at present is this:-
[Code]...
I assigned an integer as 1, and looped my program using:[code]I can recieve the packets without looping, but once i loop, i receive nothing.
View 29 RepliesMakes the following statement about the code below:
**"The computer evaluates the loop condition in the Do...Loop statment to determine whether the loop instructions should be processed. In this case, the inputsales <> String.Empty condition compares the contenst of the input sales variable to the String.Empty value. As you know the String.Empty value represents a zero length, or empty, string if the inputsales variable is empty, the loop condition evaluates to True and the computer process the loop instructions. *If on the other hand the inputsales variable is not empty, the loop condition evaluates to false and the computer skips over the loop instructions.
Based on the code I think it is the opposite: ...that while the inputsales value is not empty it should evaluate to true and process the loop and if it is empty it should evaluate to false and skip the loop?
See below.
Option Explicit On
Option Strict On
Imports System.Globalization
[CODE]...
I am trying to create a simple program that will receive input from 6 buttons entered 6 times (That is, from a row of 6 buttons, pressing 6 of them in order) will produce some mathematical results. Depsite being new to the world of programming, I managed to write some code in VB 2010 Express that gets me to getting the 6 buttons of the first set using a for loop. However, I've been unable to make a difference between the buttons That is, each button will do that same thing each time it is pressed. This is the code I have so far:
Public Class Form1
Dim StartButton As New Button
Dim QuestionSet1() As String = New String() {"Ardor", "Passion", "Vigor", "Talent",
[code].....
Dim xml As New XmlDocument
Dim rd As XmlTextReader
Dim wrq As System.Net.HttpWebRequest
[code].....
Is there any way to design and print reports using VB.Net Express 2008 If there is no solution, my backend is Access 2000 - so can I open & print a stored A2000 report from within VB.Net 2008 Express ? How
View 5 RepliesI keep getting a notification that the application is already open. I have multiple users in different sessions on the box, and I thought I coded it right, but for some reason it loops still, but only with this one app??
vb.net
Private Sub clinicalLaunchorSwitch()
Dim CurrentSessionID As Integer = Process.GetCurrentProcess.SessionId
Dim hwnd As IntPtr
Dim prc() As Process = Process.GetProcessesByName("open")
[Code] .....
Maybe I just don't understand Exit For yet? I want to do something like:
For each instance of x.exe then t = t + 1
then
exit for t# of times. Is this possible??
I am very close to finishing this function, what I am trying to do is a for loop which:
1) Grabs the value
2) saves the value in an .xml file for later use
Currently when I use a for loop to feed in my function I overwrite the hiddenFields.xml on every pass, instead of adding to it.
Calling function:
vb.net
For X As Integer = 0 To postingHiddenFields
Dim hiddenFieldsReturned As String = functionDealWithHiddenFields(HTMLResponse, postingHiddenFields, X)
Next
[Code] .....
So basically on every pass of the function I'm overwriting the values instead of adding to them.
The following code is executed at an interval of 60000 milliseconds.
[Code]...
I tried doing a step through starting at a break point i put at the For Each line. It will go inside the For Each loop but when it reaches the first if statement and it finds that if statement false it will not go to 'Next' and continue to execute the loop instead it goes to End Sub. I want to be able to view what is going on inside the loop, i think the final upload process works so it does do the loop, though i can't step through to view it.
I know it can be written better but the problem is: FOR loop is performed only first time BtnAdd1 is clicked. Why???? Private Sub BtnAdd1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnAdd1.Click
[Code]....
I can't think of a better way to do this, what i have is this function:
vb.net
Function functionDealWithHiddenFields(ByVal HTML As String, ByVal numHiddenFields As Integer)
[Code].....
which usually contains: 4 so when i loop out the names, it loops the 4 results, 4 times, instead of just showing me the names 4 times so i can then store them