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?

Member Avatar
+0 forum 0

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.

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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

Member Avatar
+0 forum 0

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

Member Avatar
+0 forum 0

** 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, …

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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") …

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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 ???

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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....**

Member Avatar
+0 forum 0

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")

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

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 …

Member Avatar
+0 forum 0

Hello everyone, I've looked in several forums but can't find an answer. In excel I want to place a picture in a cell, that's no problem. Then, I want to display that picture in the header with VBA code. I know vba can link to a directory to display a picture, but I don't want that. The link must me to the cell which contains the picture. Thanx in advance. Sneaky Peter

Member Avatar
+0 forum 0

How to make picturebox from form to picturebox rdlc reportviewer vb.net Imports Microsoft.Reporting.WinForms Public Class BCPrint Private Sub BCPrint_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'PNJKDCDataSet.tbl_Pat_Image' table. You can move, or remove it, as needed. Me.tbl_Pat_ImageTableAdapter.Fill(Me.PNJKDCDataSet.tbl_Pat_Image) 'TODO: This line of code loads data into the 'PNJKDCDataSet1.BCPrint' table. You can move, or remove it, as needed. Me.BCPrintTableAdapter.Fill(Me.PNJKDCDataSet1.BCPrint) 'Try ' Dim Image As New ReportParameter("Image", BC.ImagePictureBox.Image) ' ReportViewer1.LocalReport.SetParameters(Image) 'Catch ex As Exception ' MessageBox.Show(ex.Message) ' End Try 'Try 'Dim saveImage As IO.MemoryStream 'Dim imgByte As Byte() 'If PNJKDCDataSet.Tables.Count > 0 Then 'imgByte …

Member Avatar
+0 forum 0

Hi friends, Please I am writing an app that is meant to work like WhatsApp. When a user type some text, he clicks a send button. The clicking sends the text to a central database. There is a timer that is checking for unread messages and display them in a richtextbox. My problem is: when the timer retrieves an text (that is pointing to an attachment), I like to turn the text to an hyperlink so that I can write a procedure for linkClick event (that will download the attachment). Can anyone help me, PLEASE, on how to turn a …

Member Avatar
+0 forum 0

Dear everyone, I have got a excelsheet with some vba code. The sheet contains a row with columns with specific information. When the user clicks a button, the code will look for the last row which contains data, copy the whole row, paste it beneath the row and the number in column B gets a + 1 value. So far so good. Beneath every last row, I would like to have a specific text. So when the user clicks the button, the program should do the same as above, but, also copy the specific text and copy that one row …

Member Avatar
+0 forum 0

<option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option value="05">05</option> <option value="06">06</option> <option value="07">07</option> <option value="08">08</option> <option value="09">09</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> My Command : WebBrowser1.Document.All("Value").SetAttribute("02", "02") Dont Works!! Plz Help Me Vb.net

Member Avatar
+0 forum 0

I generate income statement of the business using windows form on vb.net. And Now I want to print it. I want print it this way, *.I prepared some income statement on word document. * I want to put my text boxes values to word document right places.

Member Avatar
+0 forum 0

My Visual Studin 2010 suddenly showing nbsp symbol for the html designer. how do i disable it.

Member Avatar
+0 forum 0

I do see AutoClose as a property for primary ContextMenu items, but I observe the secondary menu items do not stay open. Does anyone have a solution for this? I did opt with Secondary menu item click handler to set AutoClose to False, and create a single handler to process and handle a click event for any items on the form OTHER than my context menu, which works, it is 3 lines, but seems a kludgy approach. Perhaps there is a better way?

Member Avatar
+0 forum 0

How to block or prevent print dialog using a webcontrol from a win form in vb.net ---------------------------------------------------------------------------------------------------------------------------- In vb.net How to block or prevent print dialog show while printing a pdf using a web browser control (webcontrol) from a Windows Form

Member Avatar
+0 forum 0

I had 3 datagridview in visual basic, and each of them is linked to each other. 1 Main component can have many Failure Mode and 1 Failure Mode can have many Critical. [Click Here](http://i1333.photobucket.com/albums/w631/lloyd1006/1_zpsapbu0wla.png) [Click Here](http://i1333.photobucket.com/albums/w631/lloyd1006/2_zpsbe2c2u3n.png) [Click Here](http://i1333.photobucket.com/albums/w631/lloyd1006/3_zpsw2s2weo6.png) I want to duplicate selected row or record including their children details, I manage to duplicate all the details for first main component but unable to duplicate the second. Below are by coding cmd.CommandText = "INSERT INTO tbl_MainComp (EquipTag, MC_Name, MC_Function) " & " SELECT '" & TextBox1.Text & "', MC_Name, MC_Function FROM tbl_MainComp WHERE EquipTag ='" & Tbl_SystemDataGridView.CurrentRow.Cells(0).Value & "'" cmd.ExecuteNonQuery() …

Member Avatar
+0 forum 0

I have 3 table which are ![zz.PNG](/attachments/large/3/f81c645612d06529dba9af30a4a314ac.PNG "align-center") I want to duplicate a record from the master table in the same time it will duplicate all children table. I will assign new primary key to the new duplicate record. For the tbl_System and tbl_MainComp work fine. But when i have 2 record in tbl_MainComp and each of them contain 1 record in tbl_SubComp, it just copy all the record in tbl_SubComp to each tbl_MainComp record. cmd.CommandText = "INSERT INTO tbl_System (EquipTag, S_Name, S_Function, S_Failure) " & " SELECT '" & TextBox1.Text & "', S_Name, S_Function, S_Failure FROM tbl_System WHERE EquipTag …

Member Avatar
+0 forum 0

The End.