20,284 Topics
 | |
| | [CODE]cmd.ActiveConnection = cn cmd.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc cmd.CommandText = "sp_login" cmd.Parameters.Append( _ cmd.CreateParameter("result", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamOutput)) cmd.Parameters.Append( _ cmd.CreateParameter("user", ADODB.DataTypeEnum.adVarChar, ADODB.ParameterDirectionEnum.adParamInput, 15, TextBox1.Text)) cmd.Parameters.Append( _ cmd.CreateParameter("passuser", ADODB.DataTypeEnum.adVarChar, ADODB.ParameterDirectionEnum.adParamInput, 15, TextBox2.Text)) rs.Open(cmd, , ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic) If rs.Fields!result.Value = 1 Then AddProduct.Show() Else MsgBox("Your Username or Password is Incorrect", MsgBoxStyle.Information, "AEB Gasul System") Exit … |
| | when connecting to sql server i get getting this error . please help how to resolve this problem TITLE: Connect to Server ------------------------------ Cannot connect to SOFTCITY\EIMPRESSION. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may … |
| | Hello everyone. I feel quite silly posting this as I know my way around C++ decently and am writing an application in VB however I am getting quite frustrated with this problem. [CODE] Dim FileNo As Integer FileNo = FreeFile() Dim FILE_NAME As String = "C:\test.txt" FileOpen(FileNo, FILE_NAME, OpenMode.Input) FileClose(FileNo) … |
| | Hello, I would like to disable a specific items from DropDownList. I have below code but it does not working. So, need someone to told me what I'm doing wrong. DropDownList have 5 items. And, I'm getting error: Index was out of range. Must be non-negative and less than the …  |
| | i have problem about if else code in my program. i also have made many changing in this code but still i didn't get the result that i want. my program is about vending machine. here is the code: [CODE] Private Sub btnpepsi_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) … |
| | I need to make a project about the game of goose.. Can someone explain me how i get started, Dont know how i should move the goose in the game? |
 | I have a grid of RadioButtons, and need some help in Check / Uncheck acording to data collected from a .txt file. The .txt file contains a list like this: A01,a B01,b C01,c A02,a B02,b C02,c I have set up in a grid formation RadioButtons, and named them A01,B01,C01,A02,B02,C02. I … |
| | hi and hellow i have very starange problem iam just trying to get the data which i just inserted into the database but datagrid is no loading very faster my below code there two methods AddDetailItems which will insert record into table and there is an other method GetBillItemDetail wich … |
| | hello i need some help regarding my coding. i want to change the number to be like this = 1.00 . here is my coding: [CODE] Private iTotal As Decimal Private Sub btnseringgit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnseringgit.Click displayText.Text = "RM 1.00" displayText.Text = iTotal iTotal … |
| | i want that by using on changevent a calculation can be done in vb.net windosapplication suppose i had got some textbox like totalamount(t) , amountpaid(ap), balancerefund(bf), amount due(ad), [CODE] If t > ap Then bf textbox shows the amount Else ad textbox shows the amount End If [/CODE] how to … |
| | hi. here a simple class to change the wallpaper in winxp and win7. i think it will work on every windows version. [CODE] public sealed class clsWallpaper { const int SPI_SETDESKWALLPAPER = 20; const int SPIF_UPDATEINIFILE = 0x01; const int SPIF_SENDWININICHANGE = 0x02; [DllImport("user32.dll", CharSet = CharSet.Auto)] static extern int … |
| | Hi All, [CODE] SELECT 'Name A ' as Column0, Some column as Column2, FROM MyTable WHERE my condition UNION SELECT 'Name B' as Column0, Some other column as Column2, FROM MyTable WHERE my condition [/CODE] I want to concatenate the rowNumber with column0 any idea how to do that? Thanks … |
| | Anyone Can Help Me?.. I really don't know how to save all values of grid view in database that are checked in grid view, i hope anyone can help me?.. this is really help to finish my project in school. Thanks.! |
| | I have loaded a .TXT file into an array, and want to display each of the posts in the array in a grid. Any pointers how to start attacking this beast? Have tried using Datagrid, and failed :( I have a "Learn by doing" approach to VB.NET, so I need … |
| | HI,anyone know how to check every single record that we have been inserted in sql server?either exist or not..please help. |
| | Im using eneity framework and I would like to create a partail class which i have done. Namespace CulminITIMSModel Partial Public Class Role Private _roleID As Integer = 0 Private _role As String = "" <StringLengthValidator(1, 50, Ruleset:="RuleSetA", _ MessageTemplate:="First Name must be between 1 and 50 characters")> _ Public … |
| | i have a code in stored procedure like this [CODE]if exists (select code from dbo.tbl_product where code = @prodcode) Begin select 'Product Code Already Exist' as msg return End[/CODE] my problem is how can i show this msg in visual basic? |
| | Hi I am hoping someone might be able to shed some light on my issue. I have some BLOB images within a small, 9 row, database and I simply want to run through the database and sequentially place each separate image into 9 picture boxes. I have tried with a … |
| | After downloading crystal reports for VS 2010, the code i used in VS 2008 generates a database login error[CODE]Imports CrystalDecisions.CrystalReports.Engine Imports System.Data.SqlClient Imports System.Data.OleDb Public Class RrportForm Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim RrportForm As New ReportDocument RrportForm.Load("D:\PROJECT\Vehicle Management and Maintenance\Vehicle Management and …  |
| | [LEFT]Hey guys. i am trying to insert data from a form to a sql database, but this error keeps coming up. [code]Incorrect syntax near ',' [/code] Here is the code. [code] Dim AddSwimmer_comm As New SqlCommand( _ "INSERT INTO [MasterRecords] ([APASCID], [FullName], [Gender], [DOB], [21m], [25m], [50m], [100m], [4x21m], [4x50m]) … |
| | Hi, Thanks for any help in advance. I am using vb.net in visual studio 2008. here is my delima. From my program I would like to call a function that grabs all file names in a certain folder and I would like to pass them to a text file. I … |
 | Hy guys Can anyone help me on the below? I created a small application that I'm able to add items from an access DB to a DataGridView. Now, My questions is: suppose that I have a list of item in this DGV, containing name and Quantity. Now I would like … |
| | Hi, i have a card number and i convert it into hexadecimal. After that i wan to set the format to 6 digit if the hexa card number has a length =5. so how i'm going to set the format? [ICODE] Dim value As Long value = Convert.ToInt64(CardNo) dim CNo … |
| | Hi this is my first week in vb.net I m using visual studio 2010, I am trying to show the week days in Combo box but its not showing when i run it. plz help! Class MainWindow Private Sub ComboBox1_SelectionChanged(sender As System.Object, e As System.Windows.Controls.SelectionChangedEventArgs) Handles ComboBox1.SelectionChanged Dim listofdays As … |
| | Hi all, how to get values from checkbox in datagridview and transfer into arraylist? i'm using datagridviewcheckbox column..new checkbox will be added into datagridview when it populate from sql query. the example table is shown as below. CardNo|Name|Door Access|checkbox1|Lift Access|checkbox2 02233 |Lyn |Testing | checked | - |unchecked 01999 |Matt| … |
 | Hello to all, How to print the contents of textboxes in proper formate like Student Name ABC Father Name BDC DOB 14/02/2011 Please help if any body know Thanks in advance. |
| | Hello, I am working on my new project and I need to create a table for each user dynamically. In which the user will provide the Table name in the textbox and on pressing Create button a new table gets created in the same MS access database file with the … |
 | Hello everyone, So im been looking around and i havent been able to find info of this problem that i have, so this is the main thing I have this datagridview of an inventory, and i added an extra column(unbound) to the dgv, so what i want to be able … |
| | Hello All, I am newbie and looking for a script to search for the following: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Windows XP\SP4\KBXXXXXX\Description HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\xxxxxxx\xxxxxxxxx I want to loop as I am trying to search for KB#'s under these folders Please advise as how i can go for writing this script. The script will eliminate the manual … |
 | Hey all. I am trying to make a program that consists of two list boxes. The first list box contains the names of several employees of a given company, and the second is to display the name, department, ID number, and phone number of the person when the name is … |
The End.