Posts
 
Reputation
Joined
Last Seen
Ranked #829
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
4
Posts with Upvotes
4
Upvoting Members
3
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
2 Commented Posts
2 Endorsements
Ranked #620
Member Avatar for PM312

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 …

Member Avatar for xrjf
0
4K
Member Avatar for PM312

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 …

Member Avatar for SeanDevoy
0
2K
Member Avatar for PM312

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 …

Member Avatar for tinstaafl
0
16K
Member Avatar for PM312

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 …

Member Avatar for rproffitt
0
611
Member Avatar for PM312

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 …

Member Avatar for rproffitt
0
1K
Member Avatar for PM312

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.

Member Avatar for rproffitt
0
137
Member Avatar for PM312

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 …

Member Avatar for Reverend Jim
0
561
Member Avatar for PM312

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 …

Member Avatar for PM312
0
2K
Member Avatar for PM312

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

Member Avatar for PM312
0
3K
Member Avatar for PM312

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.

Member Avatar for AleMonteiro
0
234
Member Avatar for PM312

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 …

Member Avatar for PM312
0
458
Member Avatar for PM312

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

Member Avatar for PM312
0
1K
Member Avatar for PM312

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

Member Avatar for Minimalist
0
356
Member Avatar for PM312

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

Member Avatar for Deep Modi
1
3K
Member Avatar for PM312

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

Member Avatar for danielgr
0
269
Member Avatar for PM312

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 …

Member Avatar for Reverend Jim
0
206
Member Avatar for PM312

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 …

Member Avatar for PM312
0
283
Member Avatar for PM312

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

Member Avatar for PM312
0
2K
Member Avatar for PM312

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

Member Avatar for deceptikon
0
117
Member Avatar for PM312

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

Member Avatar for PM312
0
1K
Member Avatar for PM312

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

Member Avatar for deceptikon
0
121
Member Avatar for PM312

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.

Member Avatar for ss125
0
150
Member Avatar for PM312

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

Member Avatar for PM312
0
180
Member Avatar for PM312

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 …

Member Avatar for Reverend Jim
0
2K
Member Avatar for PM312

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

Member Avatar for tinstaafl
0
498
Member Avatar for PM312

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 …

Member Avatar for PM312
0
173
Member Avatar for PM312

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 …

Member Avatar for PM312
0
1K
Member Avatar for PM312

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 …

Member Avatar for PM312
0
214
Member Avatar for PM312

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

Member Avatar for PM312
0
185
Member Avatar for sharmi cse

hi all, i am creating a form in which when a particular command button is clicked, it will open another form with a flex grid. Based on the row selection the user makes on the flex the first form will be filled with datas retrieved from sql database. i can …

Member Avatar for PM312
0
53