|
Good suggestion - the simple solutions always tend to be the ones that work best
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
Every now and then I'm executing a macro in Excel/VBA, and I get an error message box with nothing but three digits, "400". No link to help, no source, no description, nothing but "400". What is this error?
|
|
|
|
|
Found this[^]
thatrajaNobody remains a virgin, Life screws everyone
|
|
|
|
|
Experts,
Kind of a simple/oddball question...
I'm using VS2012, but making entities, and need to represent the IP Address and Netmask, among other things, for a router. Just a simple class that has all the basic router info, is all.
System.Net.IPAddress is great for the IP Address (really?), and I already have access to all kinds of netmask/CIDR conversion, etc., but the real issue is how to use, represent/convert/display a netmask.
So you typically talk about an ip in a line of *-config on a Cisco router like this:
ip address 75.150.122.161 255.255.255.240
But how would I store this in a class with properties, etc.?
One thought was to store BOTH the IP Address and netmask as IP Addresses...
What are your thoughts?
TIA!
pat
|
|
|
|
|
You could just store it as an integer (Int32), an IP address and netmask are nothing more than 4 bytes printed out in a formatted manner. Its easier for people to view them as dotted notation, but in a computer they are just a 32 bit int. If you want to add properties, you could create your own structure and add the methods you want.
|
|
|
|
|
Hello, I am doing this project where I need to perform Image Shading Correction in Visual Basic ? I am thinking of using a very strong Low Pass Filter for this purpose , can anyone tell me how can I design the filter using Visual Basic because I have never worked on it before.
Thanks
Arsalan
|
|
|
|
|
Hi,
I have 2 tables and from those two I created two different XML files and merge them into one.
My code is...
Try
OpenConnection()
Dim sb As New StringBuilder
With sb
.Append("SELECT * FROM salesdetails WHERE InvoiceId='" & TbInvNo.Text & "'")
End With
Dim dbcommand As New MySqlCommand
Dim dbadapter As New MySqlDataAdapter
Dim stdata As New DataSet()
dbcommand.Connection = conn
dbcommand.CommandText = sb.ToString
dbadapter.SelectCommand = dbcommand
dbadapter.Fill(stdata, "salesdetails")
stdata.WriteXml(Application.StartupPath & "\ReportXml\SaleXml.xml", XmlWriteMode.WriteSchema)
Dim dbread As MySqlDataReader = dbcommand.ExecuteReader
While dbread.Read
IID = dbread("InvoiceId")
End While
dbread.Close()
Dim sb2 As New StringBuilder
With sb2
.Append("SELECT * FROM salesitems WHERE InvoiceId='" & TbInvNo.Text & "'")
End With
Dim dcmd As New MySqlCommand
Dim sadapter As New MySqlDataAdapter
Dim sd As New DataSet()
dcmd.Connection = conn
dcmd.CommandText = sb2.ToString
sadapter.SelectCommand = dcmd
sadapter.Fill(sd, "salesitems")
sd.WriteXml(Application.StartupPath & "\ReportXml\SalesItems.xml", XmlWriteMode.WriteSchema)
Dim Table1 As New XmlTextReader(Application.StartupPath & "\ReportXml\SaleXml.xml")
Dim Table2 As New XmlTextReader(Application.StartupPath & "\ReportXml\SalesItems.xml")
Dim XmlDataSet1 As New DataSet
Try
XmlDataSet1.ReadXml(Table1)
Dim XmlDataSet2 As New DataSet
XmlDataSet2.ReadXml(Table2)
XmlDataSet1.Merge(XmlDataSet2)
XmlDataSet1.WriteXml(Application.StartupPath & "\ReportXml\CompleteSales.xml", XmlWriteMode.WriteSchema)
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "Error!!!")
End Try
Dim objRpt As New SaleBill
objRpt.SetDataSource(XmlDataSet1.Tables())
FormReport.RptViewer.ReportSource = objRpt
FormReport.ShowDialog()
FormReport.RptViewer.RefreshReport()
Catch ex As Exception
MsgBox(ex.Message)
Finally
CloseConnection()
End Try
I created the Datasource of the crystalreport file from the XML file and designed it.
But the problem is when I tried to generate the report, It shows only the SalesItems table data whereas the other table data are also present in the XML file BUT NOT SHOWING .
What should I do ?
I am using CrystalReport 13 with VB.NET 2010.
modified 3-Oct-13 16:37pm.
|
|
|
|
|
I think the problem is in ....
objRpt.SetDataSource(XmlDataSet1.Tables()) No index or tablename has been given here, but how to write multiple table index or multiple table name here ?
|
|
|
|
|
Try
objRpt.SetDataSource(XmlDataSet1)
instead of
objRpt.SetDataSource(XmlDataSet1.Tables())
FYI ReportDocument.SetDataSource Method[^]
thatrajaNobody remains a virgin, Life screws everyone
|
|
|
|
|
Thanks for your idea, I am going to try this.
By the way, I made this with SQL JOIN method and successful in my objective though JOIN method is a bit complex to me.
I will definitely try yours and let you know.
Thanks again.
Biplob
|
|
|
|
|
Sorry for asking this.. I have a key logger but I cannot try this cause
I don't know how to setup remote desktop
Is the key logger will work even the user is on remote desktop?
I program my key logger in VB.NET
What???
|
|
|
|
|
Is this also you[^]? The question posted is exactly the same; please do not do this.
Veni, vidi, abiit domum
|
|
|
|
|
sorry no.. i have only 1 account
What???
|
|
|
|
|
Strange that two people from Philippines ask exactly the same question on the same day.
Veni, vidi, abiit domum
|
|
|
|
|
What???
|
|
|
|
|
|
that is sure strange
What???
|
|
|
|
|
Hmmm...Key Logger is equivalent to Bank Robber in my jargon - probably better to describe what you are trying to do so that we can be sure you are not up to anything nefarious
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
I just want to detect foul words is any application, especially Entry Applications, What I think is the Key Logger is the solution. This is just a security in Remote Desktop
What???
modified 4-Oct-13 6:35am.
|
|
|
|
|
hansoctantan wrote: I just want to detect foul words is any application, especially Entry Applications, That's a pretty lame excuse.
Detect isn't the same as preventing, and I often use foul words in my passwords for webapps. Logging everything from a keyboard is simple, but not detecting "sh1t" where you only expect "sh*t" isn't going to be very helpfull.
..it'd be way easier to "ask" people not to curse, and to trust that their supervisors take some time to supervise. That means that you'd have to trust your supervisors.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Currently the manual process exists where users access SAP and select query FS10N to produce a report. This report is then exported from SAP to .XLS format and saved to user's hard drive.
I would like to automate this process with an Excel macro. So far I have implemented VBA code to connect to SAP. So now how do I implement extraction of FS10N report?
Thank you, David
|
|
|
|
|
Hi,
One of the users of my application is complaining that he can't open the application.
He gave me the debug output of the crashed application...unfortunately I'm not an expert and have difficulties to manage it...would you please give me some help and help me understand why the application is crashing on his system?
Thanks!!!
------------------------------
Callstack:
WindowsBase.dll!System.Windows.Threading.DispatcherOperation.InvokeImpl() + 0xac bytes
WindowsBase.dll!System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(object state) + 0x38 bytes
mscorlib.dll!System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state, bool preserveSyncCtx) + 0xa7 bytes
mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state, bool preserveSyncCtx) + 0x16 bytes
mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) + 0x41 bytes
WindowsBase.dll!System.Windows.Threading.DispatcherOperation.Invoke() + 0x5b bytes
WindowsBase.dll!System.Windows.Threading.Dispatcher.ProcessQueue() + 0x16b bytes
WindowsBase.dll!System.Windows.Threading.Dispatcher.WndProcHook(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) + 0x5a bytes
WindowsBase.dll!MS.Win32.HwndWrapper.WndProc(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) + 0x9b bytes
WindowsBase.dll!MS.Win32.HwndSubclass.DispatcherCallbackOperation(object o) + 0x6b bytes
WindowsBase.dll!System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate callback, object args, int numArgs) + 0x56 bytes
WindowsBase.dll!MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(object source, System.Delegate method, object args, int numArgs, System.Delegate catchHandler) + 0x3a bytes
WindowsBase.dll!System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority priority, System.TimeSpan timeout, System.Delegate method, object args, int numArgs) + 0x10e bytes
WindowsBase.dll!MS.Win32.HwndSubclass.SubclassWndProc(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam) + 0xf1 bytes
[Native to Managed Transition]
[Managed to Native Transition]
WindowsBase.dll!System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame frame) + 0xae bytes
WindowsBase.dll!System.Windows.Threading.Dispatcher.PushFrame(System.Windows.Threading.DispatcherFrame frame) + 0x49 bytes
WindowsBase.dll!System.Windows.Threading.Dispatcher.Run() + 0x4b bytes
PresentationFramework.dll!System.Windows.Application.RunDispatcher(object ignore) + 0x17 bytes
PresentationFramework.dll!System.Windows.Application.RunInternal(System.Windows.Window window) + 0x6f bytes
PresentationFramework.dll!System.Windows.Application.Run(System.Windows.Window window) + 0x26 bytes
PresentationFramework.dll!System.Windows.Application.Run() + 0x1b bytes
myapplication.exe!myapplication.Application.Main() + 0x54 bytes
Debug Output:
'myapplication.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'myapplication.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.Aero\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.Aero.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'myapplication.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\myapplication\Interop.WMPLib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'myapplication.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio.Debugger.Runtime\11.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Debugger.Runtime.dll'
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.dll: Cannot find or open the PDB file.
C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.dll: Cannot find or open the PDB file.
|
|
|
|
|
Jayme65 wrote: Cannot find or open the PDB file.
The most important part - as far as I am concerned.
Always deploy the PDB file with the application - this way you will get a decent stacktrace where it should tell you the exact line number on which the exception occured.
If you can do it re-deploy the application with the PDB file and get the user to do whatever they were doing previously to crash the application then post the results here and we may be able to help direct you to where to look.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
You seem to be missing the most important part - the actual error message.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I have a Application In Vb.Net .I am Developing This Application on Microsoft Visual Studio 2008 , VB.NET, Sql Server 2005 , Crystal Report.
And That Application Have Registration Form . Now My Question Is
This Application is Installed On 5 different Computer In a Network . At the Mean time all 5 users
are Open Registration form Then They click on Save button on same time . I Have a table registration , and that has a column (code) that is primary key. whenever they want to save the record only one user can get save the record . all 4 users are rollback the transaction because of primary key violation error. Therefor i want to generate code on a queue basis .. where user can wait to get a Unique Code of that Record and i dont want to users request to rollback ...
|
|
|
|