I'm trying to retrieve values using vb.net from a sql database. How do I use "SqlDataSource.Select()"? Is there a way to move the value to a variable that I can use for other things? I know its kind of scattered and vague but that is the best I can do. I basically need to set a labels text to a value in a table.
View 2 RepliesSo making a .Net site w/ VB + running off a MySQL server.
Trying to use a variable within the connectionstring to only retrieve certain data.[code]...
I am trying to pass a variable to a SelectCommand in SqlDataSource. I have this MyIdVal that need to be passed.
Here is the code :
<form id="form1" runat="server">
<div>
<%=MyIdVal%>
</div>
[Code]....
What does this error mean? I havent modified anything in the designer code, but its giving me an error? WithEvents variable 'Move' conflicts with event 'Move' in the base class 'Control' and should be declared 'Shadows'. The error relates to Friend WithEvents Move As System.Windows.Forms.DataGridViewCheckBoxColumn
View 1 RepliesI am trying to move a row in a datagridview and then select that row in case they want to move it up or down again. I have the code to move the row and then select the row here:
[Code]...
I'm making a game and I want to select a picturebox while the program is running. Then I want to make it move with I think the mouse click event. How do I go about doing this?
View 2 RepliesI'm using the following sub routines to allow the user to move treeview nodes up/down:
Public Sub MoveNodeUp(ByVal Nod As TreeNode)
Try
If Not (Nod.PrevNode Is Nothing) Then
Nod.Parent.Nodes.Insert(Nod.Index - 1, CType(Nod.Clone, TreeNode))
Nod.Remove()
[Code]...
Is there a simple way to keep the moved node selected after the move?
As you can see from the code below there is a lot of repeated code. I want to move that code outside the if statement as it's performed for each if, but the Dim employees variable I'm declaring is causing my issues. I don't know how to declare the variable outside the if statement as it's a linq-to-sql query, so I can later define it within the if statement. I can't access employees outside the if statement, so I can't just put the repeating code outside the if statement.
Private Sub btnFindEmployee_Click(sender As System.Object, e As System.EventArgs) Handles btnFindEmployee.Click
If chkSrcEmpID.Checked = True Then
[CODE]...
working with: ASP.net using VB.net connecting to MS SQL Server
What I'm trying to do is take the result of a SQL select query and place that in a string variable so it can be used in things like a textbox or label. code so far that doesn't work...
Imports System.Data.SqlClient
Partial Class dev_Default
Inherits System.Web.UI.Page
Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs)
[Code].....
I have a case where my enumeration is like this:
Public Const PREVIEWCREATE As Integer = -3
Public Const SETUP As Integer = -2
Public Const PREVIEW As Integer = -1
I then have a form post where i recover a string like:
Dim mode_custom_mode = request.Form("custom_mode")
I can do
Select Case UCase(mode_custom_mode)
Case "PREVIEWCREATE"
[Code].....
is there a more direct way in VB to do something like:
t.StartupModeId = StartupMode.(mode_custom_mode) ?????
I am having an issue with the following code. It works when the data is all numeric such as 9200000 but not when the data is alpah numeric such as b101462 I am collecting data from a textbox into a string variable findacct and then using the variable in the sql statement. The data in the access database is char type.
The following select statement works when all the data is numeric for the find acct varialbe but if start with a alpha char like B101462 it gives me a missing parameter error."Select * From purchase where issuedate >= " & "#" & finddate & "#" & "and account like " & findacct)The following statement works when I actually put the account info in the select statement and do not use a variable."Select * From purchase where issuedate >= " & "#" & finddate & "#" & "and account like 'b101462'")
I want to select a table on my database but I have the name of the table on a variable.Because I will create tables periodically I have don't know the name of the future tables so I will stored on a variable. The problem is how I call the variable on SQL statment. I made a code using the addwithvalue to use the variable on the SQL but didn't work. Here is my code
Dim tablename As String
tablename = InputBox("Enter the table name")
Dim myconecction As String
[code].....
I have a simple vb script which extracts some data from our accounting software to a text file. It works fine when I do not use a variable in my select statment as follows:
xselect = "SELECT SourceJournal,JournalRegisterNo, PostingDate, PostingComment,UserCreatedKey
FROM GL_DetailPosting
[Code].....
I'm working on a function that handles events from a number of buttons and trying to define a Select...Case based on the clicked button. Something like this...
Private Sub btnClick(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles btnThis.Click, _
btnThat.Click, _
[Code]....
which don't work either. Is there any way I can define a Select...Case in this manner or is it always destined to fail due to the attempt at comparison of reference types?
How do I fill the variable in my SELECT statement?
Private Sub TabPage2_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles TabPage2.Enter
strTenantPin = tbxTenInfo_Pin.Text
[Code].....
I have several instances of one form loaded. They all have an instantiated variable "Name." How do I select one of these forms based on the name variable?
Code:
Public Sub MakeForms()
Dim x as New frmBlack(me)
x.show
End Sub
I am using VS 2010, SQL 2008 express and doing windows applicaion programming in vb.net.I want to write a select query(or Stored Procedure) such that the conditions mentioned under WHERE clause can be variable .like :Select * from TABLE where F1 = var1 and F2 = var2 and F3 = var3.Now on the basis of some conditons the equations in where clause should beused.Say condition is variable value >6.Now in this case ,if
var1 =7 var2 =3 var3 = 8 then the query shud behave like
:
select * from TABLE where F1 = var1 and F3 = var3
[code].....
I've been working on a Stored Procedure that checks the time, then retrieves records going back over the last full 24 hour period between 8am and the previous 8am. So, for instance, assume that it's currently 10am. The stored procedure looks at the current time, notes that it is past 8am, and sets the query to run backwards 24 hours, from 8am today to 8a yesterday. If it were, say, 7am, the query would be set to check from 8am yesterday to 8am the day before. This was actually relatively simple to do. The SP is meant to be used to retrieve records for a report tracking jobs completed in the given time span.
However, they've come back at me and asked me to change the stored procedure such that the hour the report ends at, and the span of time checked, is configurable from the front-end of the site. I have this working for TimeSpans greater or equal to 24 hours, but am having trouble with spans under that. Here's what I have so far for my logic in the Stored Procedure -
-- Retrieves data on jobs that completed/completed with errors during a given time span.
DECLARE @Hour NVARCHAR(2)
DECLARE @TimeFrame NVARCHAR(2)
[Code].....
I have 10 checkboxes on my screen. I have a variable setup called "case" as a string. I want to know how I can say:
If checkbox1 is checked then case would be equal to "this".
If checkbox2 is checked then case would = "that"
Example of something I tried to cook up but didn't work because it tells me that I can't only use this in a "select case".
Dim Case as string
If checkbox1.checked = true
case = test1
end if
If checkbox2.checked = true
[Code] ......
I am using VS2010 windows application , SQL server 2008 express at backend.I am designing a windows form with fields to search records in database.Say there are 3 fields in the form :
1) material no 2) material group 3)creation date the corressponding table in database with above fields is " Material_master" User can search materials in the database by entering any of the above fields.No I want to write a query where if user doesn't enter anything then my query should work like
"select * from materialmaster "
if only material no is enterd at screen then
"select * from materialmaster where MatNo = materialno "
if both date of creation and material no enterd then
" select * from materialmaster where MatNo = materialno and Date = creationdate "
In other words , field with no values in it should not be accounted in the where clause. Only one query I want to write.How we can achieve this in VB.net windows application?
I am trying to retrieve a password from an SQLite database. The id of the row the password is in is 1. I want to assignt his password to a variable called actualpass.[code]
View 1 RepliesI'm relatively new to VB. I want to perform a SELECT statement that uses a variable to return a value, example;
mysql> SELECT room_description FROM room_descriptions WHERE current_room = 'someVariable';
And display the result in a TextBox i.e. TextBox.text = someVariable.
So how do I perform a query from VB that passes a variable? How do I assign the result to a variable?
I have a listview box. I load the listview up from a text file and everything is divided into three groups. I need to be able to select multiple lines then push that out to a single variable, separated by commas. Two things are happening that are problematic:
1) If I just have it set to smallicons and no checkboxes, anything I select is highlighted right up until the control loses focus at which point everything un-selects.
2) If I turn on checkboxes, I can click boxes and they stay selected when I lose focus BUT the checkboxes are cut off on the left side of the control. (The checkbox appears to go off the edge of the control.) There's plenty of space in the control for the checkbox and the listed items.
I'm using some VB.Net code to manipulate files on my system - the idea is that the code checks if a file exists, and based on a value read from a text file elsewhere the system decides what to do... For this I'm using a 'select... case' statement to decide on the action to take. However, when assigning a value to the variable, the code doesn't even find the option to go for... Here's the VB code:
[Code]...
I am trying to write a module that will select cells from multiple, non-contiguous columns within a row that is defined by a variable. The column numbers are known and are unchanging. For example, my worksheet might look like this:
A B C D
Row 1 X X X X
I want to select cells A1, B1, and D1; however, I don't want to use the row number (1 in this case) in my code. Rather, I want the row number to be specified as a variable. The code I am writing is inside a For/Next loop, so I would like to use the iterative variable (i in this case) to define the row number. That way, every iteration of the For loop will select cells from a different row.
I am using OleDb, trying to do this:
Dim d as Date = DateSerial(Year(rptDate), Month(rptDate), 1 - 1)
Dim conn as OleDbConnection = new OleDbConnection(connStr)
Dim cm as OleDbCommand = new OleDbCommand()
[code]....
I know that d is the same date as the one in SQL server, specifically 3/31/2011 12:00:00 AM.
How to retrieve Dataset if there is sqldatasource control in the aspx page?
View 2 RepliesIn my window application, Form1 variable eg. Public str as string. value blank/null when move to Form2 and Back to Form1. How to maintain Form1 varable's value when back to Form1 In vb.net if any one know, reply me soon
View 2 RepliesI am retrieving the scope_identity of a db entry, and I want to use that variable in a different SqlDataSource, primarily as an but I am unable to access the variable.I have the variable being displayed in a msgbox, and it is displaying properly, I am just unsure how to access it in the SqlDataSource. Here is my code;This is the datasource that inserts the first information and received the scope_identity, as well as the _inserted event;
Code:
<asp:SqlDataSource ID="InsertPatientInfo" runat="server" ConnectionString="<%$ ConnectionStrings:DataConnectionString %>"
providername="<%$ ConnectionStrings:DataConnectionString.ProviderName %>"[code]....
After the SQLDataSource gets the values from the database, I want to be able to use these values in the code behind. Kindly spare 5 minutes and give me some suggestions.
[Code]...