20,278 Topics
 | |
 | Hi, Function GetReaderYear() As IDataReader Dim command As New MySqlCommand("SELECT aa.alert_id as alert_name,(SELECT alert_value a FROM company_alert a WHERE a.alert_id=aa.alert_id AND a.stock_code='" & bplc1 & "' AND year_id= '" & byear1 & "' AND a.period_id= 5 ) AS b1 ,(SELECT alert_value b FROM company_alert b WHERE b.alert_id=aa.alert_id AND b.stock_code='" & … |
| | Hey. I am fairly new to VB.NET so I research alot when I run into bugs. Problem is I cannot find a solution to this, or anything remotely dealing with it. I am developing software to connect to a remote mysql server, run a query, and come back with a … |
| | Hello !! I have a windows form having combobox and textbox controls.. I have to generate a part number, consisting of combobox and textbox values included.. I can explain in detail.. This is the code i have used to define a variable "type".. [CODE] If ComboBox1.SelectedIndex = 0 Then type … |
| | here in the below coding i cant able to view the (.rtf) and (.doc) files so kindly guide me with below coding [CODE] Imports System.IO Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Using fold As New OpenFileDialog fold.Filter = "document files (*.doc)|*.doc … |
| | here is the coding for creating a table with book name, author name, isbn , tile etc,........ in the below coding i need the insert , retrieve, and update coding as vb.net coding [CODE] DataGridView1.ColumnCount = 4 DataGridView1.ColumnHeadersVisible = True Dim colhdrstyle As New DataGridViewCellStyle DataGridView1.ColumnHeadersDefaultCellStyle = colhdrstyle DataGridView1.Columns(0).Name = … |
 | Hello everyone! I need to make a simple yet cool program for my professor. The program is this: To get the program to work, the user first presses a button on the form. Then, when the user presses an up arrow on the keyboard, the cursor will change to a …  |
| | Hi all. i have a problem on my coding here. it should insert the new triggered alert into database but it does not work. please have a look and tell me which part i've done wrong. thank you :) [CODE]Protected Sub repeaterAlert_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs) Handles …  |
| | [CODE]Protected Sub updatedata() Dim strSQL As String strSQL = "UPDATE company_alert, company_financial" strSQL = strSQL & " company_alert.alert_value = (company_financial.receivable * 360 / company_financial.revenue)" strSQL = strSQL & "WHERE company_alert.alert_id='DSO' AND company_alert.stock_code = company_financial.stock_code AND company_alert.year_id = company_financial.year_id AND company_alert.period_id = company_financial.period_id" cmd = New MySqlCommand(strSQL, conn) cmd.ExecuteNonQuery() End Sub … |
| | [CODE] Protected Sub updatedata() Dim command As New MySqlCommand("UPDATE company_alert, company_financial SET company_alert.alert_value = (company_financial.receivable * 360 / company_financial.revenue)WHERE company_alert.alert_id='DSO' AND company_alert.stock_code = company_financial.stock_code AND company_alert.year_id = company_financial.year_id AND company_alert.period_id = company_financial.period_id", conn) command.ExecuteNonQuery() End Sub Protected Sub insertdata() Dim strSQL As String strSQL = "INSERT INTO company_alert (stock_code, year_id, … |
| | have been trying to display on my data grip view but is not. i want a situation where by it will display on the datagrip view base on the invoice number, below are the code Private Sub getLastID() Dim oleDBDR As SqlDataReader Dim oleDBCommand As New SqlCommand With oleDBCommand .Connection … |
| | I have a scenario with a VB ASP.NET application where the calling application must send a session identifier in as a Parameter within the URL. I do not have control of the calling legacy applications (which are not web pages but automated server applications). So for example, it must be … |
| | I made a downloader.i need it can run multiple time a moment.i mean to say when we click on vb.net application icon it runs only one time.if we again click on vb.net application it cant run second time. We need to stop the first application and then run again . … |
| | I'm going to do my graduate dissertation this year .My title is develop a forensic tools which is able to detect and analyse the file signature then compare it with the extension.If the extension is wrong match with the file signature then there is a feature in the tools that …  |
| | Hey everyone, I'm fairly new to .Net and I am just starting to write some queries to begin using my database files, and I keep running into these errors. I have stepped through numerous tutorials and reference guides and still cannot seem to get things working properly. Basically I have … |
| | I actually posted this concern at another thread but I was accused of making double posts so I decided to make a new one. Anyway, I have been using VB.net for quite sometime now but I still don't know how to create a program that captures an image and even … |
| | I have this control named axWindowsMediaPlayer. Everything is going smooth. Just have one concern - I have been really figuring out how to get the file information of the media files that I am playing. I mean, what I want is that, I can display the length of the music … |
| | Guys, I have been using VB.net for quite sometime now but I still don't know how to create a program that captures an image and even record a video file. Can Anyone please tell me what controls will I be needing and how do i code one? Let's just make … |
| | I created one download accelerator using vb.net. now I integrate that application in IE(i.e when user click on any download link it should open my application instead of normal download window. for example the system having Internet download manager(IDM) ,when we click on any download link in Internet explore it … |
| | Hi Everyone. I am totally new here and this is my first post.. I have tried many place, since i could get any solution. I have no choice then posting here. basically, i have one delete form, where i will load the firstname from a table in access(hardcode) to listbox. … |
| | how to run a vb.net application after menu item of internet explorer clicked |
| | Good day. hi, i would just like to know if datagrid has a default number of columns in C#? If yes, how many columns? How can I set my datagrid to a certain number of columns only?. Thanks alot for your help.  |
| | when i right click on web browser is it possible to get my application on right click option?  |
| | I write a program but now got a problem. Everyone can help me. And this problem: + I have 2 form. - Form 1 have 3 combobox with some item load from database Access. - Form 2 load data when change item at combobox form 1. I close form 1 … |
| | I have a repeater table, could anyone help me on how to hide 1 whole repeater column without affecting other repeater column? Been trying before but it seems the column affect the column after the hiding column. I currently hide the header and the content but it seems the empty … |
| | these person is hired by her employee which it agree that the salary would be one penny the first day, two pennies the second day and four pennies the third day and continuing to double each day. i have to use a combo box to select the days that the … |
| | Hello, I'm a bit stuck here... Background: a program that (eventually) will save data synchronised from a MTC. (ive worked out all the mtc stuff) The code I am using uses winmm.dll to receive midi messages. This works fine, I can process incoming packets etc. using vb2010 What I'm stuck … |
| | Hi All, I have a text file which has a content like this: [TEX]network: Connecting http://webcodingtpp.nl.post.tnt:80/ with proxy=DIRECT [09 Nov 2011 06:10:57.994] New imageNo= 0 mailPieceId= null imageLen= 0 [09 Nov 2011 06:10:57.994] imageInfo=null [09 Nov 2011 06:10:58.510] requestGET = http://webcodingtpp.nl.post.tnt:80/servlet/TPP-BestemmingscoderenServlet?letterId=0&result=0 [09 Nov 2011 06:10:58.510] connecting to the servlet... network: … |
| | I have to create a form that accepts three test grades for three students and then writes them to a file and displays them to a list box and then it opens the file and displays it into a different list box. I have the following code but cannot get … |
| | [CODE]If minutes > 1 Then ProcessTerminate (FindWindow(vbNullString, "King Kong V-1.4")) Shell "I:\DISTRIBU\Quality\RIMData\Monkey\KingKong.mdb" End If[/CODE] this will restart the application.. i'm terminating the app but i can't get it to start again.. any suggestions? thanks |
| | Hello all. I'm trying to keep table structures in sync across 2 seperate databases on the same SQL server instance using a DDL trigger on ALTER_TABLE, CREATE_TABLE, DROP_TABLE. Using EVENTDATA() as shown below, I can catch the TSQL that fired the trigger, but I cannot figure out how to execute … |
The End.