Member Avatar

Hi, I'm new to vb When i try to retrieve edit time i get error using ( Data Grid View Cell Click) i do not have problem when i retrieve date.

+0 forum 0
Member Avatar

Hello i am new with this programming vb.net. i have simple problem loading the data. i have 1 datagridview and contains also a comboboxcolumn in that datagridview my problem is how do i populate the data in my first table and the second table would be populate in my combobox inside the datagridview

+0 forum 0
Member Avatar

I have 2 form there are form 1 and form 2 my program current situation is when user click delete it will pop up a login form. When user click cancel button from login form the data on the database will be delete ![login_form.PNG](/attachments/large/4/44621e202c33a0c03d1931bb384694fa.PNG) when user click cancel it will restart program and delete my data the program i would like to write on cancel button is when user click the cancel, form 2 will refresh and the data on the database will not be delete this is the my program running current situation ![A.PNG](/attachments/large/4/a86e1db60cebb2450ef5c573ef63e1db.PNG) ![InkedB_LI.jpg](/attachments/large/4/c5fa7a80e2be0600dfbd31349a6b18df.jpg) ![C.PNG](/attachments/large/4/c34e142048b1cb6a507db992fd043875.PNG) i am using …

+0 forum 0
Member Avatar

hi everyone can someone help me on vb.net code on how to load selected row from datagridview and transfer in to combobox or radio button.. i will appreciate your help so much

+0 forum 0
Member Avatar

Through Web Search I found [this link](https://www.daniweb.com/posts/jump/1740388) but I want to know is there a way to do it so the sub items in the dropdown would be colored?

+0 forum 0
Member Avatar

The panel has controls like labels, text boxes, list view and pictures boxes. which is probably more than four pages. I have tried all my best still i cant print all the pages. i surf online for help and found this code. the code works perfect by printing all the pages but leaves the list view and picture boxes. how do i fix this please Static page As Integer = 1 Dim startPosition As Integer = (page - 1) * PrintDocument1.DefaultPageSettings.Bounds.Height Static maxPages As Integer = 0 If page = 1 Then For Each ctrl As Control In Me.Panel1.Controls If …

+0 forum 0
Member Avatar

I am trying to apply an automatic scrolling down and up in Datagridview Scrollbar. I've seen a related topic (using scrollbar panel) but I dont know how to convert for datagridview auto scrolling up and down. I'll be using Timer for autoscrolling. Here is the code from another topics forum. Please help. Private scrollUp As Boolean = False Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick If scrollUp Then Dim scrollY As Integer = -Panel1.AutoScrollPosition.Y - 1 If scrollY < 0 Then scrollUp = False Else Panel1.AutoScrollPosition = New Point(Panel1.AutoScrollPosition.X, scrollY) End If Else Dim scrollY As Integer …

+0 forum 0
Member Avatar

I have to Create an application that enables the user to create a file named grades.txt in which to store grades. The app should allow the user to write to grades.txt file: student number, student name, surname, subject, individual assignment grade, group assignment grade, test grade. When you click Create button grades.txt should be created in your app Debug folder. When you click display button the file contents should display on datagridview. Display at least 10 records. Use LINQ to read and display file contents to datagridview. I'm not sure where to start.

+0 forum 0
Member Avatar

Hello. So I had to make this program that: 1. User enters a value (say, ID number) in a textbox, presses search, then the program searches for that particular item on a table and then copies all the row data where that ID number is. 2. Then pastes those copied data on another table in Access, then displays it on a datagrid Thanks. Im new so I haven't made up code yet :(

+0 forum 0
Member Avatar

please i want to be able to move down and up my textboxes in vb.net with the arrow keys and i want to also use the enter key to move to the next textbox and with that i did and it has been working but i recently place a group box unto that form and suddenly it stops working

+0 forum 0
Member Avatar

I need to check the validity of the URL to different files without opening the link document/image. I used the below code in ASP.net 4.7.2 in validation attribute. The current code is as follows : (working fine with jpg) public override bool IsValid(object DocumentURL) { try { string urlLink = (string)DocumentURL; WebRequest request = WebRequest.Create(urlLink); request.GetResponse(); return true; } catch { return false; } } This works for images but failed when I sent a link to xls file. The error message is : "The request entity's media type 'text/plain' is not supported for this resource" No mediaTypeFormatter is available …

+0 forum 0
Member Avatar

Hi guys , I have a tables called “scores” With the following Fields AdmNo,Name, Maths,English,Biology ,Avg Am loading this data to my datagridview using select “Select * from scores order by Avg Desc” Which works fine my question is how do i get the rank of every student from the datagridview in the form of Adm Name Maths Eng Biology Avg. rank 1. Peter. 80. 60. 70. 75. 1 2. Alex. 20. 20. 20. 20. 2 Etc How do I rank?

+0 forum 0
Member Avatar

Magento : Using app/design/frontend/default/theme/template/catalog/product/view.phtml how to display my text message on my selected products, workout : <?php $productId = '42150'; $product = Mage::getModel('catalog/product')->load($productId); if( $productId == '42150' ) { echo "Test"; } ?> if i wrong pls correct me.

+0 forum 0
Member Avatar

Hi All, I have 7 tables in my access database. i wrote a code to select the data table using the combobox and to display the selected table in the datagridview. Now i need to add,edit or update, delete the data into the selected tables. In which the text boxes are common to the all the tables, for ex: if i select the table "Capacitor" in the combobox, whatever the data i entered into the textboxes will go to the "capacitor" tables, likewise other tables. Please anyone help me to resolve this code, i am struck in it for long …

+0 forum 0
Member Avatar

I'm creating a program that maintains student scores. I've created a class called students that stores the data and displays it in a list box. Once the user clicks btnAdd a new form (frmAddStudent) loads that allows them to add the user by name and their scores and display it in the listbox in the main form. It also allows the update/delete functions. I can succesfully add students to the list and edit them, but when I press the ok button in the update students form I get the error, "System.ArgumentOutOfRangeException: 'Index was out of range. Must be non-negative and …

+0 forum 0
Member Avatar

Hello, I have question guys. basically, i have 2 forms which is login form and main form. On login form i have database consist of username,password,fullname, and contact. I have toolstripstatuslabel on my main form. the question is, how can i view the fullname on toolstripstatuslabel from the information i use to log on from login form after logging successfully. thanks in advance

+0 forum 0
Member Avatar

hi members i am new in vb.net so i faced some problem resolving problems with datagridview i managed to resolve a lot in this days i have faced a problem with no solution if anyone can help me my problem is to add a new columns in datatgridview with data from database the datagridview if filled from text with 4 columns (command,article,Qte,PU) i want to add a new columns (designation) will be (command,article,Qte,PU,"designation") how i can do that please

+0 forum 0
Member Avatar

** Cannot open MSSQLSSQLEXPRESS service on computer'.'. ** **What I have tried:** Dim myController As New System.ServiceProcess.ServiceController("SQL Server (SQLEXPRESS)") ------------------------------------------------------------------------------------------------------------ Private Sub Service_status() If myController.Status = ServiceProcess.ServiceControllerStatus.Running Then TextBox1.Text = "Started" ElseIf myController.Status = ServiceProcess.ServiceControllerStatus.Stopped Then TextBox1.Text = "Stopped" End If End Sub ------------------------------------------------------------------------------------------------------------ Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Service_status() End Sub ------------------------------------------------------------------------------------------------------------ Private Sub BtnStop_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnStop.Click ProgressBar1.Value = 0 Try myController.Stop() Catch ex As Exception MsgBox(ex.Message) Finally ProgressBar1.Value = 100 myController.WaitForStatus(ServiceProcess.ServiceControllerStatus.Stopped) '//Add Service_status() End Try End Sub ------------------------------------------------------------------------------------------------------------ Private Sub BtnStart_Click(ByVal sender As System.Object, …

+0 forum 0
Member Avatar

Dear All i am developing .Net Application with MS Access and Crystal Report i am using DSN for crystal report to view the data from database. on each new client i have to go there to make DSN and then crystal reoport work, my application forms using database through physical connection string, i have managed query in my crystal report and then that command represent the data into crystal reports. everything working fine. my question is can i provide crystal report database source at runtime where is my database installed in application folder, so client just download my software and …

+0 forum 0
Member Avatar

Here I present a WebSite containing just Default.aspx. Current snippet code has to do with coloring text in an input field of a web page. The input field is an editable DIV HTML element. While the user writes, there is a partial post (an XMLHttpRequest) to the server. Then the code behind decides which parts of the input should be colored and which color should it be, and returns back to the client the input already formatted with color(s). The code behind must be as fast as possible to interfere as less as possible the user input. After the formatted …

+0 forum 0
Member Avatar

Error: The Remote Server Returned An Error 400 Bad Request I am using asp vb.net and instagram api also I am using Newtonsoft.Json -Version 10.0.3 I following below link as a tutorial but issue is I am converting code from c# to VB and I am getting an error: https://code.msdn.microsoft.com/Haroon-Said-e1d8d388 The insta api's documentation says I need to request it like this : curl \-F 'client_id=CLIENT-ID' \ -F 'client_secret=CLIENT-SECRET' \ -F 'grant_type=authorization_code' \ -F 'redirect_uri=YOUR-REDIRECT-URI' \ -F 'code=CODE' \https://api.instagram.com/oauth/access_token I am getting an error on line client.uploadvalues(...) Dim parameters As New NameValueCollection parameters.Add("client_id", "ssdfsdfsdfsdfsdf") parameters.Add("client_secret", "sdsdfdsfsdfsdfsdfsdfsdf") parameters.Add("grant_type", "authorization_code") parameters.Add("redirect_uri", "http://localhost:8979/UI/InstaHome.aspx") …

+0 forum 0
Member Avatar

Suppose we need to populate and filter a Datagrid with the data coming from an Access table. It could be of course a table from Sql Server also. Form dataGridSelect contains two buttons and a DataGridView. Clicking the first button will populate the DataGridView the data comming from a Sql Server database. The second button does the same comming the data from an Access database. Nothing new, but once the data is fetched a Linq filters through a Regex pattern. The pattern "[^d|D]ata" tells to select the rows where the field Title has the sequence 'ata', not those [^d|D] preceeded …

+0 forum 0
Member Avatar

Hello, I'm working on some helpdesk based application. I'm triying to select datagridview row and this dgv's selected row's id fetch on text box and updated record from dgv and i'm also succeed but my requirement is when i update this record, this record will automatically clear after updating and this updated record can display on another form's datagridview.. Can you help me for this ???

+0 forum 0
Member Avatar

hey, I need help :) Now I realized that this problem. In my software there are many reports. I used report viewer (defualt comes with visual studio) control for reporting. All the other forms loaded to MDI paren form. I run one of report. Then I run another report then the second report doesn't view. It shows only loading. I'll put my code which I used for generate reports. Private Sub report_of_all() Dim ds As New DataSet Dim dt As New DataTable Dim RpDs1 As New Microsoft.Reporting.WinForms.ReportDataSource Dim SQL As String = "select * from moneycs.collector" Dim da As New …

+0 forum 0
Member Avatar

How to display picture stored in MS access to PictureBox in vb.net I make a login form that require your username and password and picture to login successfuly

+0 forum 0
Member Avatar

I find something related to this topic and found. But I can't satisfie with this. The code is below. Imports System.Runtime.InteropServices Public Class Form1 Private Const SB_BOTH As Integer = 3 Private Const WM_NCCALCSIZE As Integer = &H83 <DllImport("user32.dll")> _ Private Shared Function ShowScrollBar(ByVal hWnd As IntPtr, ByVal wBar As Integer, ByVal bShow As Integer) As Integer End Function Protected Overrides Sub WndProc(ByRef m As Message) If mdiClient IsNot Nothing Then 'Hide the ScrollBars ShowScrollBar(mdiClient.Handle, SB_BOTH, 0) End If MyBase.WndProc(m) End Sub Private mdiClient As MdiClient = Nothing Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load …

+0 forum 0
Member Avatar

Hi been trying to **click on a button.**. ![SnapCrab_NoName_2016-9-18_17-32-55_No-00.png](/attachments/small/4/0d67448b4c9a403d8045742796fd1a6e.png "align-left") heres the **code** from html** webDocument** ![SnapCrab_NoName_2016-9-21_20-35-31_No-00.png](/attachments/small/4/d21666d16295481ea3442c1cbeb44690.png "align-left") within **WebBrowser control**.. **Please Help**.. Thank You.. Heres my code so far.. Dim theElementCollection As Windows.Forms.HtmlElementCollection = Nothing theElementCollection = WebBrowser1.Document.GetElementsByTagName("a") For Each curElement As HtmlElement In theElementCollection If curElement.GetAttribute("id").Contains("remove-over") Then curElement.InvokeMember("click") End If Next **Please Help....**

+0 forum 0
Member Avatar

Hi im trying to **click** on a **button** within a **webbrowser control**.. to close a ad in a **iframe** wich i have no **access** to my code works on first page but not on second page heres my **Code** Dim theElementCollection12 As Windows.Forms.HtmlElementCollection theElementCollection12 = WebBrowser1.Document.GetElementsByTagName("a") For Each curElement As HtmlElement In theElementCollection12 curElement.InvokeMember("OnClick") Next Im trying to **simulate click** on the **X** to **close adbanner**.. Please Help.. Thank You.. ![SnapCrab_NoName_2016-9-18_17-32-55_No-00.png](/attachments/small/4/9f2d68be098feb3b44fb85f22ebcda45.png "align-left")

+0 forum 0
Member Avatar

Hello! I am working in VB.NET 2010 with SQL Server 2014. Using SAP Crystal Reports i want to make a report in Multiple Master Detail Format. Now I Explain in Detail. In Database i have two tables tbl_Voucher_M & tbl_Voucher_D as master & detail table respectively. Each voucher consists of one record in its master table (tbl_Voucher_M) and multiple rows in detail table (tbl_Voucher_M). Suppose there are 25 vouchers are stored in the month of June and i want to make a report that displays all vouchers having their master and detail data one by one vertically for the month …

+0 forum 0
Member Avatar

I'm newbie to vb.net. Now I'm on report viewer component. I'm just trying to generate reports. It's okay with select data from one data table of mysql. But now I trying it advanced. I try to generate report data from two data tables. This is query I tried. It show result on mysql query browser. select loan.loan_id,loan.customer_name,loan.total_amount,sum(settlement.amount) as 'Total Received',(loan.total_amount-sum(settlement.amount))as 'Total Due' from loan join settlement where loan.loan_id='" & ComboBox1.Text & "'; I made data table on dataset. which name 'due' and connected it to report viewer. I'm not sure about my dataset's data table. because I'm new. So help …

+0 forum 0

The End.