20,284 Topics

Member Avatar for
Member Avatar for Ehtesham Siddiq

hi, I have a form and a button on that form.When the user clicks on the button an MS-Excel sheet is generated from MS-Sql Server 2005 and saved in a particular location.As this generation of excel tkes sometime to complete,what i want to do is i want to show a …

Member Avatar for Mitja Bonca
0
826
Member Avatar for imslala

Hello, i need help to do the insert inside repeater, but when i debug the stock_code inside sql command is not declared. what should i do? [CODE] Protected Sub repeaterAlert_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs) Handles repeaterAlert.ItemDataBound Try stockCodeheader.Text = " Stock Code " plcNameheader.Text = " PLC …

Member Avatar for Pgmer
0
176
Member Avatar for sackymatt

Hi all I have a situation, i have a form that has a datagridview, on form load, it selects the data from sql db, now what i want is when i right click on one row, i should be able to delete that row and it should also get deleted …

Member Avatar for Pgmer
0
2K
Member Avatar for flywheeljack

Hi, I am trying to get the value from a field in my Access DB.Once the value is retrieved I need to be able to compare it to a condition I set. I still haven't figured out the right code to make this happen....i don't know if I should convert …

Member Avatar for dew97
0
141
Member Avatar for dew97

Private Sub ComboBox6_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox6.SelectedIndexChanged con = New SqlConnection("Data Source=DEW-D63D9D2D032\SQLEXPRESS;Initial Catalog=system1;Integrated Security=True") con.Open() sql = "Select Faculty_Id From Faculty where Faculty_Name='" + ComboBox6.SelectedItem.ToString() + "'" cmd = New SqlCommand(sql, con) rdr = cmd.ExecuteReader() While (rdr.Read()) fid = rdr.GetInt32(0) End While con.Close() MsgBox(fid) con1 …

Member Avatar for dew97
0
148
Member Avatar for darahz

Hello, i have just a simple question. Is there a way to select the next item in a listview by pressing a button? I have been using listbox for along time now and its pretty easy to do there [CODE]ListBox1.SelectedIndex = ListBox1.SelectedIndex + 1[/CODE], any idea how to do it …

Member Avatar for Oxiegen
0
53
Member Avatar for aFg3

I want to calculate the average of a column or rows of project #1, project #2, etc.... and Adding a new column with the grade of the students ....like the picture.. Im new using visual basic. Thanks in advance. =D [img]http://i41.tinypic.com/5z1xi.png[/img]

Member Avatar for Oxiegen
0
145
Member Avatar for mihirpatel12

Hi, I want to Display My Table Data In Textbox I Have around 20 columns in my Table and I want to display each of that on particular TextBox. How Can I Do this ? I am using SQL Server as Database. Please Give me code for this Thank You

Member Avatar for Reverend Jim
0
84
Member Avatar for Ehtesham Siddiq

Hi, I have my application in VS2008 and coded Vb.net. My query is i want to save record from an excel sheet to my Database Table. But i dont want to insert the Excel sheet as a whole rather i want to insert the record in my database table Row …

Member Avatar for adam_k
0
279
Member Avatar for don420

i want to dynamically add the values in the column of a datagridview the row of which is also being created dynamically... [CODE]Form1.TextBox10.Text = total con.Open() cmd = New SqlClient.SqlCommand("select product,Quantity,MRP,Sale_Rate,Disc_Amt,Amt from sale_table ", con) adapter.SelectCommand = cmd adapter.Fill(ds) Dim r As Integer = ds.Tables(0).Rows.Count Dim counter As New Integer …

Member Avatar for adam_k
0
6K
Member Avatar for abc_123abc

hh.. how can i get the value accumulated from the date i select from datetimepicker1 to datetimepicker2 in vb.net and mysql? the value here refers to the daily sales and i need to find the total sales between the range dates that i choose.. please help me..as im beginner and …

Member Avatar for gd740
0
3K
Member Avatar for AT--O

[CODE] Public Class aaMyForm Inherits Windows.Forms.Form [/CODE] Added some controls. Build it, add the .DLL as reference to my other project. In my other project: [CODE] Imports MyLib Public Class XForm Inherits aaMyForm [/CODE] The events from aaMyForm execute correctly but the controls added to it are not shown on …

Member Avatar for AT--O
0
118
Member Avatar for aishapot

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click strsql = "delete from student_info where Student_No = " & ctrl & "" Dim sqlcmd As New SqlClient.SqlCommand sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqlcmd.ExecuteNonQuery() MsgBox("Student Deleted") Me.fillclasslist() When I try to delete a student in the list …

Member Avatar for aishapot
0
209
Member Avatar for mihirpatel12

Hey Guys, I Want to Display Content of Database Into TextBox, i.e. i have column named "Ename" in "EMP" table of database1 , now i want to display "Ename" in TextBox of my form , so, how can i do this ? Thanks In Advance

Member Avatar for Pgmer
0
142
Member Avatar for juniorsilver

I was wondering if there is a code i could add to my applicatio that will delete a data entry from a database. I'm designing a voting application as my project and i want a situation where an access code is good for only one entry. i put my code …

Member Avatar for adam_k
0
141
Member Avatar for CrankyMero

Hello By accident I named a report like a form that i already had example: Form Name: CheckIn Report Name: CheckIn And know I cant use the form, anyone know how to get back the code from that form Thanks In Advance!

Member Avatar for CrankyMero
0
67
Member Avatar for bilal_fazlani

i know crystal reports can access data stored database.. what I want is actually to create a report on the basis of a listview values..no database at all. how do I pass these listview items and subitems to crystal reports... please help guys..

Member Avatar for bilal_fazlani
0
124
Member Avatar for ninjatalon

How can I add the prerequisite for Crystal Reports Redistributable . I only see Crystal Report Runtime on there. I used to have VS2008 and it was available as a prerequisite. BTW I have already installed CRfoVS_13 to the IDE.

0
160
Member Avatar for dgzo_08

Hi all, I have a datagridview in which I add programatically a combobox column with its datasource set to a datatable I fill from a query, then I populate manually (for good reasons) the DGV, but just when I try to add the first row, this error shows up: Fielld …

Member Avatar for Phixius
0
664
Member Avatar for markdean.expres

I'm just wondering guys if it is possible for me to go to the specified listbox item via searching. Example; Listbox1 items are Apple Banana Guava Pineapple Peach When I key in the word Apple in a textbox, the SelectedItem would go to Apple, is this possible?

Member Avatar for markdean.expres
0
6K
Member Avatar for markdean.expres

Guys is it possible that I create a program whose functionality would be selecting a file, then gets the contents of that file (Word or text files). The program, of course, has a Richtextbox on it where the file content will be filled to. If it is, could anyone please …

Member Avatar for markdean.expres
0
130
Member Avatar for projecttoday

I'm trying to make a form in VB.Net that takes speech input (not text-to-speech) on my Windows XP Pro computer. I've tried to install Microsoft Speech SDK 5.1 according to [URL="http://support.microsoft.com/kb/306537"]http://support.microsoft.com/kb/306537[/URL]. The problem is my Office 2007 does not have an Alternative User Input feature, as it says in the …

Member Avatar for Micro_2001
0
408
Member Avatar for Ehtesham Siddiq

Hi, I have my application in VS2008 and coded Vb.net. My query is i want to save record from an excel sheet to my Database Table. But i dont want to insert the Excel sheet as a whole rather i want to insert the record in my database table Row …

Member Avatar for lolafuertes
0
289
Member Avatar for Ruchi224

A new issue !! I have a checkbox column in the datagridview and also a column named "partqty" which displays the quantity of materails available.. I would want that when the user checks on the checkbox, the quantities of checked rows should be added and displayed in the textbox.. I …

Member Avatar for Ruchi224
0
273
Member Avatar for Ruchi224

Hello !! I am stuck with an issue and need some guidance.. I am using visual studio 2008, vb.net Windows app and ms access 2003. I just wanted to know that there is a form in which i select an option from the list of options in combobox.. While the …

Member Avatar for Ruchi224
0
131
Member Avatar for Ruchi224

Hi again !! I am making a widows application wherein i have a form containing two datagridviews.. The first one( named dgv1) consists of all the data from the database and a checkbox column.. While the user selects the rows using checkbox, the data are displayed in adjoining datagridview(named dgv3).. …

Member Avatar for Ruchi224
0
2K
Member Avatar for imslala

Hi there, I need help regards to my sql statement. I am developing a system using vb.net but now i'm having trouble to insert all the data (where i bind using repeater control) into the sql statement. I didn't know how to declare the stockcode.Text, year.Text, quarter.Text and total1.text as …

0
60
Member Avatar for lbgladson

I have to create a form that I enter the price of gas each month over a year. I enter the price in a text box and click the enter button to send the price to a list box immediatley and use an array. I have the following code but …

Member Avatar for lolafuertes
0
145
Member Avatar for markdean.expres

guys, it's been a long while since the last I asked about this and so far, no one yet has ever given me the right and helpful answer. My problem is, I have a program, I have published it, and I have been actually using it in my PC. Whenever …

Member Avatar for lolafuertes
0
152
Member Avatar for AT--O

Using VB Express 2010 in windows XP Pro 64. A ListBox shows the project forms names. On ListBox_DoubleClick [CODE] For Each F As Form In xFormCollection If F.Name = ListBox.SelectedItem.ToString Then Try F.Show() Catch ex As Exception MsgBox(ex.Message) End Try End If Next [/CODE] Works fine the first time but …

Member Avatar for AT--O
0
1K

The End.