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

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) My Code is Private Function GetXlUsedRange(ByVal filePath As String) As Object(,) Dim xlApp As Excel.Application Dim xlWorkbooks As Excel.Workbooks Dim xlWorkbook As Excel.Workbook Dim xlSheets As Excel.Sheets Dim xlWorkSheet As Excel.Worksheet Dim xlRange As Excel.Range xlApp = New Excel.Application xlWorkbooks …

Member Avatar for tinstaafl
0
35
Member Avatar for JModak

how can i configure ip address, submask, getway, DNS1 and also DNS2 please help me i use this code but DNS not added what is the actual code for add all with DNS1 &2 Please help me Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Button2_Click(sender, …

Member Avatar for markanderson_1
0
206
Member Avatar for JModak

How can I check special characters are there (String) or Display on label? I Use this but it is only count Dim input As String = "Hi! Hello, How are you?" Dim pattern As String = "[!""#$%&'()*+,\-./:;<=>?@[\\\]^_`{|}~\s]" Dim matches As MatchCollection = Regex.Matches(input, pattern) MessageBox.Show(String.Format("There are {0} special characters in …

Member Avatar for Minimalist
0
520
Member Avatar for JModak

Debug time Application run good all private sub and Function work properly, but with out debug not run properly please help me

Member Avatar for Bert Pitt
0
638
Member Avatar for JModak

All Time Show Null value Please help me what is the wrong in my code declare @mxdbvlu int declare @dbvlunm int set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1) if @mxdbvlu = null set @dbvlunm=1000 else set @dbvlunm=sum(@mxdbvlu+1) select @dbvlunm,@mxdbvlu

Member Avatar for john_111
0
4K
Member Avatar for JModak

How can I get internal HDD_DETLAIS = SerialNumber, Model, Manufacturer,TotalHeads ...... etc. Please help me.. Now my problem is my code run ok, but when I insert external HDD or pen drive then showing the last counting device Details please help .... i want to show only internal HHD device …

Member Avatar for JamesCherrill
0
885
Member Avatar for JModak

Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name SELECT @@servername AS 'ServerName' using this line the show new change server name. Then I closed the window of …

Member Avatar for sanjay.vaniya
0
5K
Member Avatar for JModak

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

0
2K
Member Avatar for JModak

hello sir getting error when run the loop and going to last value of row count please help and i can not use the 2nd loop in the place of cells(?????) number how can i use this **Index was out of range. Must be non-negative and less than the size …

Member Avatar for Reverend Jim
0
3K
Member Avatar for JModak

Getting error when showing data in list view, please help me..... Error :* Cannot add or insert the item '10-07-2018' in more than one place. You must first remove it from its current location or clone it. Parameter name: item* I use Vb.net 2010 visual basic sql server 2008 r2 …

Member Avatar for JModak
0
615
Member Avatar for JModak

I create a project on vb.net 2010 and SQL server 2008r2 I showing a report in listview report am show fine and error free. But now I want to add a sub total column every end of the category. How it is possible please help me sir Please see the …

Member Avatar for Santanu.Das
0
449
Member Avatar for JModak

I create a project encrypt and decrypt data in vb.net how to use this code as a function please help it is work only on a textbox i want to send a string value then return encrypt value and when i send encrypt value then send me decrypt value. [Click …

Member Avatar for rproffitt
0
554
Member Avatar for JModak

How to copy a store procedure one to another database in same server I work on a project. I want copy all or single store procedure from old financial year **db_17_18** to new financial year **db_18_19** I want to do it using sql server command. i try it but showing …

Member Avatar for pty
0
492
Member Avatar for JModak

showing Error "Failure sending mail." please help me i used port 587 because maximum example 587 used this port how i can know the my mail port or it is right error in this line SMTP.Send(Mail) massage is:- Just "Failure sending mail." ------------------ Imports System.Net.Mail Public Class Form1 Private Sub …

Member Avatar for rproffitt
0
706
Member Avatar for JModak

How to change the color of a cell(back or fore color) of listview item according to item value with if condition. I do it but it is not work and show no error Please help me...... For k = 0 To ListView1.Items.Count - 1 If ListView1.Items(k).SubItems(6).Text > 100 Then ListView1.Items(k).SubItems(6).ForeColor …

Member Avatar for Reverend Jim
0
343
Member Avatar for JModak

automatically duplicate rows in sql server 2008 r2 select query i have two table name 1) tbl_Stock_Journal 2) tbl_Stock_Journal_Details i run a select query with where condition i have 5 data in table1 and in table 2 have 3 data when i run the query result is showing 15 row …

Member Avatar for pty
0
644
Member Avatar for JModak

Sir. I create a project in vb.net 2010 sql server 2008r2 and crystal report 13. i use this code for showing the report. Public Sub PrintSaleRInvoice() Dim PrintSale As New DataSet objsale.saleinvid = txtSaleInvid.Text PrintSale = objsale.PrintSaleInvoice() ' Procedure name PrintSale.Tables(0).TableName = "DataTable1" Dim rpt As New SaleInv rpt.PrintOptions.PaperOrientation = …

Member Avatar for rproffitt
0
577
Member Avatar for JModak

Vshost.exe has stopped working... Posted A minute ago vshost.exe has stopped working this error showing after using the Crystal Report. The error show when I closed the application. If I not use the crystal report then the error not showing. I am creating a program in vb with visual studio …

Member Avatar for rproffitt
0
667
Member Avatar for JModak

hello sir how can I get my system short date format in a label in vb. net. I try this code : Label1.Text = System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat.ShortDatePattern() but show wrong data. all time show "M/d/yyyy" format. I change it(to "dd/MM/yyyy") manually and by coding result is same("M/d/yyyy") please help me..... For Change …

Member Avatar for xrjf
1
8K
Member Avatar for JModak

How can I show the database in a single mode (windows or SQL authentications mode) please help me..... How can I Show the database in a single mode (windows or SQL authentications mode) please help me. I create a project VB.NET 2010 and SQL server 2008r2 , When I login …

Member Avatar for overwraith
0
347
Member Avatar for JModak

i have 3 table i inner join with 3 table and add function but now getting error please help me how to solve the the problem please help me ERROR :Msg 8120, Level 16, State 1, Line 1 Column 'TBL_pur_inv.invno' is invalid in the select list because it is not …

Member Avatar for Santanu.Das
0
393
Member Avatar for JModak

How to the excel data please help me In the original excel sheet data show column wise. But now I want to same change to data showing structure and re arrange the data structure. I can't upload the excel sheet that for i attached the IMG please help me https://ibb.co/jdzC4m …

Member Avatar for rproffitt
0
372
Member Avatar for JModak

Visual Studio suddenly close when i open crystal report right click on page and design>page setup i try many time result is same please help me please.... please help me https://ibb.co/iBfiaG I used --- vb.net-2010 sql server 2008 r2 crystal report 13 OS windows 8.1

Member Avatar for rproffitt
0
206
Member Avatar for JModak

Sir Please help me about MenuStrip Control used. I create a project there one parents form and two child form MenuStripControl-1 is on parents form (main_form) Menu Item name a) Trans. b)Report c) Setting and MenuStripControl-2 is on child form (purchase_Entry_Form) Menu Item name a) File. b)Close I want to …

Member Avatar for tinstaafl
0
557
Member Avatar for JModak

Procedure or function P_UpdatePurchaseInv_test has too many arguments specified. ALTER PROC [dbo].[P_DeleteForUpdatePurInvDet] --Purchase Invoice Details 12 pic(13pic active) --@purid int , --@purinvid varchar(255), @purinvdt date, @invno varchar(255), @invdt date, @nrr varchar(200), @partyIDpur int, @invtypidpur int, @tottaxblamt decimal(18, 2), @nettaxamt decimal(18, 2), @invamt decimal(18, 2), @totalcgst decimal(18, 2), @totalsgst decimal(18, 2), …

Member Avatar for hericles
0
366
Member Avatar for JModak

how to Generate Auto Alpha numeric Inv. number in SQL Store procedure i used Sql Server 2008 r2 and vb.net 2012 I got a error ---- *Msg 245, Level 16, State 1, Procedure P_GetAutoIDPurchaseInv, Line 13 Conversion failed when converting the varchar value '17-18/00002' to data type int. * When …

Member Avatar for hericles
0
288
Member Avatar for JModak

How to Update Sql database from vb.net 2010 i want to add a stored procedure in sql database from login time on button click.. **database name ** db17-18 **stored procedure** Create Proc P_SelectAllRole As Select StatusId,Status from tblStatusMaster

Member Avatar for mahe_1
0
6K
Member Avatar for JModak

I use the this code. showing "Update" msg but not update and if i add an item then show "Update" not "save" Please help me..... Private Sub Button14_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button14.Click Dim sql = "select Count(*) from pur_invdet where purinvid= txtpurinvid.text" Dim cmd = …

Member Avatar for dspnhn
0
2K
Member Avatar for JModak

Hello Teachers I create a project in vb.net 2010 with access database. I want to show data in listview. It Is show in listview but a problem I entry **Id wise**. So, when I click on the show data button I see the **Id** . How to show the id …

Member Avatar for xrjf
0
305
Member Avatar for JModak

how can I use Alt+Del to Delete listview item ... Now I just select the row and press del key delete the item, But I want to delete item by press alt+del key. How it is possible Please help me.... What I have tried: Private Sub ListView1_KeyDown(ByVal sender As Object, …

Member Avatar for xrjf
0
1K