PM312

I have chart showing daily closing price of share for last 20 days. There is no closing price for Saturday and Sunday . However chart is showing blank space for these days i.e. total 29 days interval i do not want blank spaces but only 20 columns. Not getting how …

hi I have datagridview which i want to add on several forms. Number of columons and all ather functionality remains the same. to avoid creating size, columns, column names each time, i am trying to create class control for datagridview which will give me by default number of columns and …

Hi, I Have below table I want all rows with all coloumn from below table where ActCode is 1162828 and sum of DocAmount for DocNo. i.e where the docNo is repeated i want only one row with sum of amount of all repeated rows. ** "Select *, Sum (DocAmount) from …

I am traying to filter Datagrid view based on user type in TbxGlCode (TextBox) Initialy Datatable is populated from SQL table to TempTable (DataTable) getting error at **runtime** at below line Dim Rows As DataRow() = TempTable.[Select]("Code like '%" & VerCode & "%'") Exception Unhandled **System.Data.EvaluateException: 'Cannot perform 'Like' operation …

I have Lenovo Ideapad 320 i7 8550u 8th Gen laptop it has below display adapotrs AMD readon TM 530 Intel(R) UHD graphics 620 I want to add two or three external monitors but it has only one HDMI port, Two USB 3.00 and one Type-C 3.1 port how can i …

i am trying to add two external monitors to extend screen on my toshiba laptop through vga and hdmi port . But only one is working. i cannot detect second monitor. if i plugout one other is working then. how to add two monitors? display card is :intel(r) hd graphics …

I Am uploading excel data into DataGrid cell . Once uploaded date changes from uk to US date format in datagrid. What could be the reason.

Hi I have below code to save pdf file in sql. but getting error **"Cannot Bulk Load. The File "D:\xyz.pdf" does not exist."** Private Sub ButBouncePdfAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButBouncePdfAdd.Click Try If TxtRefNo.Text <> "" Then OpenFileDialog1.InitialDirectory = "d:\" OpenFileDialog1.Title = "Select PDF File" OpenFileDialog1.Filter …

I am trying to update Varbinary(Max) column data with Null value. But unable to do so. Error "**Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.**" my code Private Sub ButRemove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButRemove.Click …

I am trying to update pdf file to sql but getting error (line 17) as **operator '&' is not defined for types 'string' and '1-dimensional array of byte'** on beow line cmd.CommandText = "UPDATE PDC_CHQ_IN_HAND set PDC_CHQ_IN_HAND.PDF='" & data & "'WHERE PDC_CHQ_IN_HAND.RefNo='" & TxtRefNo.Text & "'" * my code is* …

i have app.config file in my application for storing/updating connecting strinng to my database.But when i installed my application on user machine i cannot locate the file to update new database link. How can i find the file on user machine .i.e where the file is installed on hard drive.

i have below code to send email in outlook 2013 Try Dim SmtpServer As New SmtpClient() Dim mail As New MailMessage() SmtpServer.Credentials = New Net.NetworkCredential(OutlookID, OutlookPassword) SmtpServer.Port = *** SmtpServer.Host = "smtp.office365.com" SmtpServer.EnableSsl = True mail = New MailMessage() mail.From = New MailAddress(OutlookID) mail.To.Add(TbxTo.Text) mail.Subject = TbxSubject.Text mail.Body = TbxBody.Text …

I have below code to print richtextbox text. My textbox contains Regular and bold text but below code print either bold or reguler text. How can i print text as it is in the text box. Private Sub PrintToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PrintToolStripMenuItem.Click If PrintDialog1.ShowDialog() …

hi, i am trying to print report by ceating excel file and print. but getting below error when creating sheet2. osheet = obook.Worksheets("Sheet2") Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) worksheet1 works fine. I have Excel 2013 installed on my system. what could be the problem. Thanks

Hi i want to display version information on my MDI form text Below code displays "1.0.0.0" it doesnot display rivision no `Me.Text = System.Windows.Forms.Application.ProductVersion` how can i display version revision ? thanks

Hi, i am trying to extract values based on range of dates. Why i am getting this error Invalidcastexception was unhandeled **Conversion from string "SELECT * FROM TBLRequest where T" to type 'Long' is not valid.** for below string **FlexString = "SELECT * FROM TBLRequest where TBLRequest.PrDate >='" &** **Date.Parse(TxtDateFrom.Text) …

to create unique reference i had below code in **vb6** Dim UNKREFBATCH As String UNKREFBATCH = "B" & Format(Date, "MMDD") & Format(Time, "HHMMSS") but the same is not giving correct result in **vb.net** Dim UNKREFBATCH As String UNKREFBATCH = "B" & Format(Date.Now, "MMDD") & Format(DateTime.Now, "HHMMSS") MsgBox(UNKREFBATCH) instead of minutes …

i am trying to import data from excel to datagrid view. why instead of actuel data "System.__ComObject" is displayed in datagrid cell. Dim xl As New excel.Application Dim xlsheet As excel.Worksheet Dim xlwbook As excel.Workbook xlwbook = xl.Workbooks.Open("d:\PayableInput\InvoiceUpload.xlsx") xlsheet = xlwbook.Sheets.Item(1) Dim Rowst As Integer = 0 Dim RN As …

Is there a way to get all contacts id's from outlook 2013 or 2007 to datagridview or combobox.collection list. Thanks

I have datagridview with one CheckBox column I have CellClick event for this datagrid even if user click **outside** the checkbox but **within column cell**, cellclick event get trigerred but checked value dosen get changed. How to know if user have clicked inside the checkbox to control cellclick event Thanks

There is no **"Microsoft Outlook 14.0 Object Library"** in my **visual studio 2008 reference COM** List how can i update it. Thanks

hi I wnat to make **only third line** i.e "Wenisday" bold in richtextbox. how can i do this Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click RichTextBox1.Text = RichTextBox1.Text & vbCrLf & "Monday" RichTextBox1.Text = RichTextBox1.Text & vbCrLf & "Tuesday" RichTextBox1.Text = RichTextBox1.Text & vbCrLf & …

for last one month my laptop(fujitsu) heats up and shuts down when i watch videos on youth tube or when on skype video call. before it was working fine. what could be the probleme.

i have below code for my custom textbox to allow numeric chatecters for entering amount. Protected Overrides Sub OnKeyPress(ByVal e As System.Windows.Forms.KeyPressEventArgs) MyBase.OnKeyPress(e) If Asc(e.KeyChar) >= 48 And Asc(e.KeyChar) <= 57 Or _ Asc(e.KeyChar) = 46 Or _ Asc(e.KeyChar) = 13 Or _ Asc(e.KeyChar) = 8 Then If Asc(e.KeyChar) = …

for my combobox i want to prevent user from typing **further text** if the typed text **do not match part** of combobox items i.e from starting Autocomplete mode set to SuggestAppend Autocompletesource set ot Listitems Private Sub ComboBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles ComboBox1.KeyPress Dim i As …

I have a combobox with 5 coloums of which coloumn 1 is DataGridViewComboBoxColumn I want to populate / add items to DataGridViewComboBoxColumn with data from access database using datatable. i am not getting how to add items to DataGridViewComboBoxColumn. How can i do it. Thanks

I have created custom text box for specific purpose i.e to accept alphanumeric values only and the length of text should be 6. If the user put less than six characters the code in below block converts it to 6 characters by filling in zeros . ‘Custom Clss block Protected …

When the readonly property of textbox is set to true then back colour turns to grey. i use below code to change the back colour to white Private Sub TextBox1_ReadOnlyChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.ReadOnlyChanged If TextBox1.ReadOnly = True Then TextBox1.BackColor = Color.White End If End …

I am trying to populate combobox from access database but not geting populated only message 1 is displayed message 2 ,3 & 4 are not displayed, nither any eror is shown ------------------------------------ Imports System.Data.OleDb Public Class FrmPlPostCodeNl Public acsconn As New OleDb.OleDbConnection Public acsdr As OleDbDataReader Public strSql As String …

I am getting below Error “Update requires a valid InsertCommand when passed DataRow collection with new rows.” **Below is the code in Module** Module ModDBConnection Public CnCommon As New SqlConnection Public DTCodeMaster As New DataTable Public DACodeMaster As New SqlDataAdapter Public CBCodeMaster As New SqlCommandBuilder Public Sub CommonCn() CnCommon = …

try puting the first form1 name

Component comdlg32.ocx or one of its dependencies not correctly registered: a file is missing or invalid I am getting this error when I tried to run my application on my friends pc . I copied this file COMDLG32.OCX’ from my laptop and tried to paste on that pc in System32 …

When working with loop some time the loop goes into infinity while testing and I have terminate with “Ctrl+Alt+Del" and lose all unsaved work. How to get out of infinity loop without losing unsaved work. thanks

I have 3 tables in which one column name is common for all i.e PRNO .I want to write SQL query to select everything from Table1 where PRNO is 500, Table2 where PRNO is 500 , Table3 where PRNO is 500 . “Select * from Tab1,Tab2,Tab3 WHERE PRNO=500” Getting Error …

I have a data grid view and trying to compare data in coloumn 4 with coloumn 6 when data is entered in coloumn 6. but comparision is not happening . How to achive this. my code Private Sub DgvAllocate_CellLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DgvAllocate.CellLeave Crno = …

i am trying to add values in two coloums of data grid view. Howeaver the result is values are concatenated instead of adding. i.e 10+25 result is 1025 and not 35. DgvLedger.Rows.Item(GRNO).Cells(6).Value = DgvLedger.Rows.Item(PRNO).Cells(6).Value + DgvLedger.Rows.Item(GRNO).Cells(3).Value howeaver multiplaying two coloums value result is correct.

I have combobox on child form. combobox get populated when form is loaded. Now the problem is when child form is closed and reloaded combobox get populed twice with same items. it appears that combobox dosen get cleared when for is closed. Below code dosen work CboScrip.Items.Clear() Below code is …

i added some text boxes and button in group box and entered its code . Later i added tab control and i cut the group box and pasted on tab control. now the codes are not working. when i double click it dosen goes to old code i type but …

I Have laptop with windows 7 .Recently my laptop gets shutdown automatically below is the error shown Problem signature: Problem Event Name: BlueScreen OS Version: 6.1.7600.2.0.0.768.3 Locale ID: 2057 Additional information about the problem: BCCode: d1 BCP1: 0000008000000000 BCP2: 0000000000000002 BCP3: 0000000000000000 BCP4: FFFFF88002E65610OS Version: 6_1_7600 Service Pack: 0_0 Product: …

i have programe where i use serial number for each document number. now i want to start serial number with one againe in new financial year, but restarting number with one result in duplication of reference number in database. how to get this.

i was using ms access as my database where my default value for coloum was "" empty string . now i have shifted to sql 2008 where i cannot put empty sting as default value in the same manner as in access i.e "" . here i have to put …

hi I used to write below code for do Loop in vb6 [CODE]Do While Recordset.EOF <> True[/CODE] How to get this or replaced for ado.net vb.net Thanks

hi i am trying to accepte text in text box only numbers and capital alphabets in keypress event below code is not converting lower case to upper case [CODE]Private Sub Tbx_AcctCode_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Tbx_AcctCode.KeyPress Dim KeyAscii As Short KeyAscii = Asc(e.KeyChar) If KeyAscii >= …

i used to create sub procedures in vb6 under tools/ add procedure. Same is not available in vb2008. how can i create sub procedure in form. for eg. Private Sub CmdDisabl() Cmd_New.Enabled = False Cmd_Amend.Enabled = False End sub if i type above code in form i get error statement …

Hi, How can i disable left and right arrow key only on msflexgrid control Thanks

Can the value of vertical scrollbar attached to Msflexgrid be made to maximum through vb code. thanks & regards

00

I have made a programme to print chaques through excel report. i have network printer “Xerox Phaser 3435 PCL 6” (inkjet) which is my default printer I have local printer is “Epson LQ-300 ESC/P 2” (dot-matrix) and used only to print chaques. every time when i want to print chq. …

i am traying to put date from access table in text box with 2 coloumn (Invoice No &Invoice Amount) below code gives me right allignment for both coloumns . i want field 1 i.e invoice no to be left allign and field 3 i.e invoice amt. to be right allign. …

How can i deletete excel file saved as "D:\PRLIST.xls" through VB Code.