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 = …