20,899 Topics
![]() | |
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 … | |
HELP! I am a medium duty VB.Net developer and want to start developing web applications and converting some of my VB apps to web apps. I know the basics and have put together a working ASP.Net application with no problem. I have the mechanics working fine. I just can't seem … | |
Hi, i'm just wondering if there's any differnece between visual basic 6.0 and visual basic 2008?? Is visual basic 2008 compatible with the older versions of visual basic??? Please help.. Thank you in advance! :) | |
HELLO. i want to put logo in my crystal report, i couldn't find image property in crystal report plz help. Thanks in advance. | |
Hello, I have access database which have hyperlink column, and values as "/yes.bmp", "/no.bmp". Then in asp.net have a GridView with ImageField which in browser will show Yes image, or No image. ImageField Properties >> DataImageUrlFormatString: ~/images/{0}.jpg. My goal is to get in vb.net code a value from GridView's imagefield. … | |
I am working on developing p2p chat system and also file share system.... But only thing is that ...i can't find out the way to find how to implement it...i have worked on client server programs but i m not able to get p2p... The concepts of P2P are:- 1. … | |
Hello, I am interested in learning Visual Basic 2010 from scratch. I have no programming experience at all and I am looking for a good book that helps me grasp the concepts of programming as well as learn Visual Basic 2010 and the .NET framework. I would like a book … | |
hi am having problem in saving datagridview data to excel file.. i have import excel namespace into my project but it shows [COLOR="red"] error : Namespace or type specified in the Imports 'class2' doesn't contain any public member or cannot be found. Make sure the namespace or the type is … | |
Basically im having problems programming an array as double. I have it as ' public arrytotal() as double ', however i keep getting the error messages 1. Error 5 Operator '+' is not defined for types '2-dimensional array of Double' and '2-dimensional array of Double'. C:\Users\Alex\Documents\Cafe Assignment\Cafe Assignmentconverthome\Backup\WindowsApplication2\Form2.vb 115 22 … | |
Hello, Could any one plz tell, where am i going wrong. I am unable to popup msgbox if count=0. It will work only if i use MsgBox(""). I am unable to understand how it has anything to do with msgbox("") Private Sub txtstaffID_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) … | |
Hi, i want to accept data from user in messagebox using a variable. and later i want to use that variable. please help me. | |
hi, I am new to these online threads .. i had a question: i am migrating vb6 to vb.net. the ini.file of vb6 has to be converted to app.config file, and we has to use this app.config in our code by removing ini file. how to create app.config for this … | |
how to find the internet explorer go evenmt in vb.net plz reply as early as possible thanks in advance | |
i am able to add items in listview at runtime ,but not able to add this items and subitems in database pls help me in code | |
Hello, I am trying this.. [code] Imports System.Data.OleDb Public Class Form1 Dim conn As OleDbConnection Dim cmd As OleDbCommand Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click conn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source=c:\nikhil.mdb") conn.Open() Dim row As DataRowView=ComboBox1.SelectedValue Dim row1 As DataRowView = ComboBox2.SelectedValue Dim row2 … | |
Hello all, I am trying to make this login page for users, but when I go to login it gives me an Error or just does not work. Here is what I am using. [CODE]Imports MySql.Data.MySqlClient Public Class Form1 Public conn As MySqlConnection Private Sub Button1_Click(ByVal sender As System.Object, ByVal … | |
I already understand how to do the quadratic equation when the it is in the format of ax^2 + bx + c and the a variable is 1. The only problem I am having to make it a fully functional quadratic equation solver, it needs to work with a being … | |
Hi guys, basically im writing a program where the user inputs the number of coffees they require from a number of drop down boxes, one for cappucino, espresso, iced coffee and latte. after this, there is a 'calculate' button which totals these up and displays them in a textbox. my … | |
I have already asked about the problem in java forum... Now i think the solution is only possible through microsoft products... Problem is i want to get the handle of a application and send commands to that application... Is it possible,, commands are send to combo box , text area, … | |
how to check if the user input has a match in my given string [CODE] Dim a as string a = "abc" [/CODE] if the user input in the textbox "erty" the message box will be shown string not found. if the user input 123abc the message box will be … | |
Hello anybody I 'm a beginner programmer and now I have one problems that is errors " could not find store procedure" in myform here is my code [code] Public Sub GRID_STAFF_INFO() CONTOSQL()'that is a function for connection to sql server' Dim table As New DataTable CMD.CommandType = CommandType.StoredProcedure CMD.CommandText … | |
hi, please help me to do this. i have problem in vb.net window base application. i want to block TAB key from the keyboard. please give me API code or any useful hint to do that. thanks in advance. jack parsana. | |
Hi. I just want to ask if it is possible to create a function that accepts an expression into its arguments. Just like what IIF do. Ex: [CODE]Dim strResponse as String = IIF(Msgbox("Select Yes or No", vbYesNo) = vbYes, "Yes", "No")[/CODE] I forgot the code, but its the thought that … | |
Hello everybody, hope you're all good. I'm making a quiz and I've got a set of questions and answers being loading into two different arrays, the idea is to answer a question with a choice of 4 buttons, so on a button click the answers checks to see if it … | |
HI Guys, I have completed my VB project using vb 2008 express edition.. I am not able to create a set up file for my project and I think it is because of the file path i have provided in my program dbSource = "Data Source = C:\Documents and Settings\cfadmin\Desktop\Lead_management\Lead_Management_Project\Lead_Management_Project\London.mdb" … | |
give me an example pleas. | |
Hey it's me again. i know u guys might be sick of me asking q's but i really need ur help. i'm trying to make a game now for my brother for his birthday. and i have the boundary code i need thanks to u guys but i decided to … | |
hello to all of you i am using crystal report wizard and i want to put a search box in my crystal rpt but i don't know what i'm going to do view my attached thumbnails anybody can help me please? thanks... | |
hi all, I am used in me.showintaskbar property to remove application from taskmanager.but it removes the form(application)it still refreshes.How to stop the form refresh.to avoid that issue please help me. Thanks, | |
Hello guys. I'm using a Microsoft Word form template to create objects in a form programatically, so depending on the information read by the program from the template. So, I've got some fields where I store formula data for the form, in which I specify that the value for that … | |
hi i manage to export a data coming from listview to excel here is my code [CODE] Try ' Open output file Dim os As New StreamWriter(filename) ' Write Headers For i As Integer = 0 To ListView1.Columns.Count - 1 ' replace quotes with double quotes if necessary os.Write("""" & … | |
Hi alls, since 2 week i'm stuck to do this thing. Actually i need to display image from oracle database into the picturebox. My oracle database got table name "STAFF_PHOTO" and the column of photo is "PICTURE". The image already converted into ByteArray. I'm already make a connection and success … |
The End.