Unable To Make SQL QUERIES?
Aug 26, 2009I am newbee to VB Express and having many problems for displaying different reports from Tables in MsAccess to Listview in Vb Express.
View 4 Replies
ADVERTISEMENT
IDE :: Unable To Use TextBox With Wildcard LIKE Parameter Queries?
Jul 3, 2011I have a form which takes input from the user in a TextBox to display ("contains") record/data on a grid. However, I am unable to achieve the input data thing. I have been trying to solve this for a while now. Dtatbase is MS Access.
Here is my code: I don't get any values in the form grid whatsoever for this query.
Imports
System.Data.OleDb
Public
[code]....
LINQ Queries - Combine The First 3 Queries Into A Single Query And Place In A List?
Jan 6, 2010I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
Make A .net Program Which Will Perform WMI Queries To Check For Remote Computer's Name And OS?
Jan 18, 2012I am trying to make a vb.net program which will perform WMI queries to check for remote computer's name and OS. I manage to do the first query of name using the code below..
[Code]...
I am getting error "Local variable 'query' is already declared in the current block. (BC30288)".I understand that I am using same name for the object variable for performing subsequent query. Is there a way in which I can dispose the variable completely and reuse it again for querying the new required WMI detail? My search in the net couldn't give me any clue as of how to clear the variable and use it again. The issue is with two variables "query" and "searcher". Is it only possible that I should give unique names to each query object variable as I might add more queries later on?
Unable To Make An Installer For Project?
Aug 17, 2009I use VB 2008 express edition. I want to be able to make an installer for my project. If I run the executable file from the development computer, it works fine. When I try to install the program in other computer, it tries to download .net framework. Is there anyway to prevent this to happen? I have the .net framework installer in a CD.
View 2 RepliesUnable To Make Combobox ListIndex?
Jan 20, 2010I am trying to have the index value of a selected item in a combobox returned to a variableThen, if the variable = 1 (which would be the index of th second item in the combobox), I want a groupbox to be hidden (be invisible) on the form. Here is my code...Getting an error that says:
'ListIndex' is not a member of 'System.Windows.Forms.ComboBox'
Private Sub cbxAccounts_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]....
Unable To Make Keyboard Functions?
Aug 29, 2011I wanted to make a calculator. Its fully made and everything but I recently wanted to add more to it. Only thing I can't figure out to do is to make keyboard functions. Like, if I want to type in the numbers instead of clicking the buttons on the calculator to input it into the calc. [code]....
It works to a certain point but i found out that the timer input multiple integers when pressing a key so I thought of about turning off the timer and then having the timer turn back on somehow but that is as close as i can get.
VS 2008 Unable To Make Settings?
Apr 5, 2010I'm having trouble understanding how this works.Under my Project properties I select Settings and define the ones I need.Things like:
DefaultSaveToLocation (As String)
DefaultFileName (As String)
NoOfTimesAppStarted (As Integer)
[code]...
Unable To Make Conditional Date Formatting?
Sep 25, 2010I am frustrated that I cannot solve this seemingly easy problem:
Here's the code:
If Date.Now.Day = vbSaturday Then
Label6.Visible = False
[code]....
Unable To Make An Attendance Monitoring System?
Dec 15, 2009im trying to make an attendance monitoring system using vb.net 2005. i have a little experienced programming, i used vb6. But vb.net is much more different in vb6 because of its codes. my problem is that in dtpicker, it do not accept any value that came from a textbox.
my code is like this
dtpicker1.value = textbox1.text
but an error existed..then i coded like this hoping that it will work
dtpicker1.value.hour = textbox1.text
Unable To Make Own Buttons Drop Down Boxes?
Oct 13, 2011I bet you all know DotNetFrameWork 4 needed for VB 2010 applications to work...
Any idea how i make my own framework?
I want to be able to make my own buttons drop down boxes...
And after i make it how to i put it into a dll so i can reload it in another app and use it...
Unable To Make The Button In Working Order
Feb 9, 2012Public Class Form5 Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
txtfinaltot.Text = Format((pizza + extratotal), "currency")
VS 2010 Unable To Make Login System?
Oct 27, 2009Im creating (trying) a login system for my application , but im having problems with the directory. The following code will create the folder but it wont create the username.txt & password.txt file within the folder , any ideas whats up ?
Textbox3 = Username
Textbox4 = Password
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
Unable To Make Some Settings And Load The Result Of The Settings Via LinQ Into The Grid Of The UscStat?
Jan 3, 2012I have the following structure:OLD: frmMain (WinForm)uscStat (UserControl with Grid) In frmMain I'm able to make some settings and load the result of the settings via LinQ into the Grid of the uscStat.
[Code]...
.Net Cannot See JET Queries?
Dec 5, 2010I have a Access 2003 backend db and I'm using vb 2005 to connect to the db via conntection string. It works ok! I can see all the tables but only some of the queries. Why should some queries be absent? In 1 query I have a user define function which cuts up a string. I've created a new VB project with a new connection but the same result. I've compacted the database with not change.
View 2 RepliesAny Way To Combine Two Queries?
Jun 8, 2011I am trying to UNION the two queries below without success.
Dim
ds1
As
New
DataSet
Dim
MyConnection1 As
New
OleDb.OleDbConnection(GetPOWERConnectionString())
[Code] .....
Asp.net - Search Queries In .net?
Aug 3, 2011I am trying to perform a search query using drop down boxes with a button named search. I want it to bring up the data that is searched for. I dont know where to start from, i have looked around for some coding and different ways to do it but they seem complicated, this is the bit of ASP that is my weakness, need some assistance and guidance. below is the code for the page;
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="ForSale.aspx.vb" Inherits="Users_ForSale" title="Properties For Sale" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
[code]......
Asp.net - SQL Queries Through .NET And JSON?
Feb 19, 2010I'm trying to figure out how to do SQL queries towards an SQL 2005 Express server and format the return value to JSON. I got the queries working using this (perhaps very newbie-like) code;
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI
[code]....
Available WMI Queries For ManagementObject
Aug 6, 2009Where can I find informations on which WMI queries are in fact available for .NET interface through ManagementObjectSearcher. The command below returns exception for "Win32_LogicalDisk", but works for "Win32_Environment". Every reference in msdn directs to msdn library, which contains all Win32 and COM development classes (that seems not to be available from vb .net code):
[Code]...
Multiple Sql Queries?
Nov 5, 2010I have a form that will have at least 3 seperate sql queries that I want to have submitted with an onclick event.
View 4 RepliesParametrized Queries With ADO.NET
May 18, 2012I've been going through a lot of forums and see a lot of mention of ADO.NET and how it's better to use. I guess because it's newer and being maintained with current times?I've done google searches for this, but every time I see different programming languages other than VB.NET implementing param queries with ADO.net, or it brings me to results that have oledb commands again.Is there a good ADO.NET for VB.NET tutorial with parametrized queries?
View 3 RepliesQueries - Loop Through Dgv
Dec 14, 2011finish my querie, it works for the first 2 rows, I need ti to loop through my dgv:
[Code]...
Run .sql Files Queries In .net?
Sep 22, 2010I want to send the a vb.net application which will run some updates on the database. I have built the sql script files which i would normally run thru query analyser but that is not available thru MSDE.I know i can use OSQL or ISQL to run these scripts but i really want to run them thru a VB.Net application.here is the code i'm using which is generating an error beacuse i'm trying to execute more than one statement?
Dim connectionString As String = ' CONNECTION STRING IS HERE
Dim conn As New SqlClient.SqlConnection(connectionString)
Dim cmd As New SqlClient.SqlCommand
[code]....
Update Queries In VB?
Nov 23, 2009i have a form which once the user has entered their correct Account No they will access the jobs relating to their number. I now need to use and update query so that once I select yes in the Query handled box, after clicking the update button, this row will then be deleted from the table. Here is the code that I have so far:
Public Class Form1
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
End Sub
[code]....
Using Variables In SQL Queries
May 18, 2009I am a beginner when it comes to VB express. I went to the FAQ and found what looked like the answer to my question in "Database - How can I put the value of a variable/control into my SQL statement?" which said I should use thecode ...... where Field = ' " & variablename & " ' at the end of the SQL statement
I am using a field defined as a nchar with 10 charecters and my variable is defined as a string. my field has been given the value "abcdefghij" so it is full to avoid confusion with spaces and even though the variable is identical and I have used the len command to check there are no hidden spaces etc. When I run the query I get no records selected. What am I doing wrong?. If I use Where Field = 'abcdefghij', ie specify the value in the SQL I get the correct records selected but this does not give me the flexibility I need
.net - Know To Refresh Linq Queries?
Aug 24, 2011I have a basic grid of Linq2Sql entities (frmList). I have a separate form for editing (frmEdit). frmEdit has its own DataContext (as that appears to be the recommended way). How can I tell when my detail form has saved changes?
I don't see a built-in method. I am considering raising an event on the detail form when I save the datacontex, but not sure how I consume this event on frmList, and I have a feeling these events are already created for me somewhere?
.NET Reporting System: IMP Queries?
Aug 2, 2011We have a reporting system where in we are getting unexpected results:
1) The size of reports at different time of interval is different?
2) The reports are writen as pdf to a directory. When we have thousand of older unused pdf(which will not get merged) in the directory the Adobe Life Cycle(to murge the PDF) throws error.But when we clear the directory by deleting the old unused pdf, it works fine?
3) Some of the pdf that are rejected by Adobe life cycle may or may not be corrupted. Meaning they may or may not open up with Adobe Reader, manually.
App Makes Use Of Many Queries And Commands?
May 6, 2010I have a data driven application in <acronym title="Visual Basic">VB</acronym> which works with an SQL Server 05 Database.Since this app makes use of many queries and commands, occasionally i'me getting a timeout error as the connection pool is full. So i figured that at a specifc point in time within the app,i'll clear the connection pools using the ClearAllPools method rather than increase max pool size.
I'm using the performance monitor on my XP development machine (NumberOfPooledConnections) however not once do i see the number of Pooled Connections reset to 0 even when that method is called.How can I determine that my solution is working (if it is) before I deploy the update?
Fundamental Vb And Csv Reader Queries?
Apr 15, 2012always had a problem getting my head around it. I don't have a very strong mental model of how the code flows. My main problem is i think i understand the syntax, but not really its application. Any links people found useful would be great.
Couple of questions. The code below doesn't make sense to me (written by someone else) the application is basically a csv reader, but manipulates the data.
Public Sub entryType()
[code].....
Get Multiple Insert Queries From C#?
Apr 23, 2009I am using C# and MSAccess as my database.
Code:private void ExecuteQuery(string strempname,string strQuestion,string IndividualRating,string OverallRating, string Comment1, string Comment2,string Comment3, string SessionName) { string strQuery= string.Empty; try { strQuery = "insert into FeedbackDetails(EmpName,Question,IndividualRating,OverallRating,Comment1,Comment2,Comment3,SessionName)"
[code]....
so this actually opens and close connection for every method. but i need to open and close the connection only one time. so how to customize this code to achieve my need. now i am hitting database for 14 times in a button click as of now. instead i need to hit only once but all the rows has to be inserted in my database.i am using MSAccess as Database.