|
Hi All
I have one application in vb.I have problem with crystal report.
I have one annual report in crystal report.
Problem is: annual report means apr 2000 to march 2001
I have database in access.simaple annual report is ok but i have no idea how to
fire query on two year in crystal report means how to get all records from two table with two parameters?
I hope u r getting my point.
if possible pls reply as early as possible
Thanks
monika
|
|
|
|
|
Hi
Please explain more and are u using web or windos application and what kind of DB u r using
Mohammad Al Hoss
|
|
|
|
|
hi
Thanks for yr reply.
But i think u r not getting my point.
I have access database and windows application with vb.
My problem is when i take report as quaterly it's working fine
but when i take report as annualy,it creates problem
how i explain u.
i have student database.Two tables student and presence
annual report means suppose april 2006 to may 2007.
My problem is how to pass two parameters from vb to crystal report and how to access all records based on 2006 and 2007
means if have one record as name "monika" i want to fetch record from apr to dec 2006 and jan to may 2007 for monika.
I have two entry in database for monika.
This is tha mymajor problem
Pls help me and try out solve this problem.
Thanks
monika
|
|
|
|
|
Hi,
as i understond u need to get info from date to date this can be done by write the query u need in VB then use :
Dim oledt As New OleDbDataAdapter
Dim dt As DataTable
oledt.Fill(dt)
Crystalreport1.SetDataSource(dt)
sure when u design the report u design to the table or query then write the query u need and execute it.
also if it is ok mail me back
Mohammad Al Hoss
|
|
|
|
|
Hiiiiii
I m developing outlook-2003 Add ins using vb.net 2005. and i want to add the custom task pane in outlook reply window. means when user open a mail and click on Reply button the new mail to windows is displayed. and i want to add custom task pane in this window. Please suggest how i do this.
Thanx
Mitesh Khatri
Khatrimitesh@hotmail.com
|
|
|
|
|
Hello,
I got stuck to one problem and need your help.
In my asp.net application i am using RegEx (regular expresiion) to get all the emailids enclosed in a
particular html tag.
For ex : see the code below line1
<to> test@test.com, user1@user.com </to> -----line1
This statement could repeat in my textbox multiple times with same or different mailids enclosed.
So finally regex should return two emailids w.r.t. to above example line1.
now line1 generates different html with different mail providers like yahoo, rediffmail gmail.
for ex for outlook generated html, i have written
Dim S As New Regex("<to>(.*)</to>", RegexOptions.Multiline Or RegexOptions.IgnoreCase Or RegexOptions.Compiled)
this returns the expected result but if i press enter before closing to tag then ids get converted to hyperlink and href get inserted into html code.
then i pass this statement to regex i dont get expected result.
Let me tell you that i pass html code generated as a string to regex and expecting that it should return all emailids
enclosed in the code removing duplications and irrespective of other symbols or tags.
so my query is how i could retrieve the emailid s from any generated htmls.
Please anyone who knows provide me the code.
thanks in advance.
|
|
|
|
|
I am working at VS2008 and SQL Server2005.I want to put login restriction that after 100 logins is done by the same user after that he will not able to log thruogh the user name.
|
|
|
|
|
On the database side you can use SQL Server's logon trigger to count the user's logins. On the app side you are on your own.
|
|
|
|
|
Thanks for your reply.Can you give the query for SQLServer2005.Pls help me.
|
|
|
|
|
No, because there is no query. I suggested either a trigger or counting it in your app. Neither requires a query.
|
|
|
|
|
Hi all,
I have tried posting the dedicates subjects, but it seems that knowone has the knowledge or just so obnoxious they dont care for any other language and as soon as you mention VB or .net well thats it....see u later
Out of all the .net languages i prefer VB.net, its just easier to work with.
So does anyone in here know anything about MFC apps, first i would like to convert an MFC windows app to a MFC console app and then wrap it in MC++ with the #pragma umanaged and #prama managed blocks.
Once i have this working i can create a .net DLL, instead of the console app, this DLL with import straight into a VB.net application and allow me to leverage the COM method within the API and also have the .net functionality.
I explain this because, i would not expect every VB coder to understand this but someone with C++/MC++ should understand without thinking.......NOT! http://www.codeproject.com/script/Forums/View.aspx?fid=3785&msg=2565053[^]
All i'm asking here is what i need to do you make the existing MFC app, that has windows etc.., into a console app - like a DOS prompt.
Thanks
|
|
|
|
|
you're talking about a significant amount of effort - it doesnt even translate 1 for 1 - it depends on lots of things eg how much input is coming from the dialog etc if the MFC app is using a dialog for input .. while I dont agree of the way you've treated 'led mike' or your 'just so obnoxious' comment, Id start like this ...
1) Ascertain all the dialog inputs from the MFC program - maybe design an XML file or such that will be read by the console program, and feed it as an argument on the command line
2) Look at all the calculation logic in the MFC program - it could be spread across all sorts of classes/locations. If you have discrete classes, single them out for inclusion into the console program, else bundle all the code etc, think about where in the console prog it will sit/be accessed - under main() for instance
3) any output from the MFC that went to a listbox for example, and the results of your calculations can be output to cout, cerr etc using iostreams
but I suspect you'll already have thought of all that
'g'
|
|
|
|
|
The application uses an API to access the currency exchange, the application was design by the company that allows this access - and by modern stardards is not very good.
this app is pretty simple, by this i mean its just got one menu and about 6 items in the menu, when selected by the user the API writes the info to a log window, and like you say my plan was to capture this in a console window with cout etc...
yes your right about the classes being spread about, this is the MFC stuff which is why i've included the the MFC classes in the console application.
my question here would be this, is there any difference in solution settings from an MFC app to a console app. By this a mean what tells the compiler to run if you comment all the code in the MFC app and paste the code from a console app it will not run!
andy
|
|
|
|
|
Fu Manchu wrote: is there any difference in solution settings from an MFC app to a console app
I would have thought, heaps, plus the non-inclusion of the MFC code libs/dlls etc - you could check by generating two projects, one MFC, one console, and comparing their make files. "In general" I have added MFC support to a console app - for CString etc, but the dialog stuff (for example) yeesh, not game to try it, although I have seen others do it with a wrapper or two (add a dialog or such)
thats why I think you'll only be porting the calc/logic to your console program, the rest - toast !! (once you have all the logic/calcs isolated, you could almost go to a dll anyway couldnt you ?)
'g'
|
|
|
|
|
sorry, that exactly what i'm doing i dont care for the windows stuff and dialogs - i'm just trying to get the business logic end that connects to the API - the rest can be done in .net
so you reckon its possible, basically i just want to have a class C++ that i can wrap in MC++. i would call the method etc from .net and get the returned data.
|
|
|
|
|
yeah - if you factor the class so that it has a setup/init stage where you feed it paras etc then a do_it() method that returns the result or a seperate get_result() method, then you're in good stead
'g'
|
|
|
|
|
hi all,
i want to get the list of all Application , that are currently running on my computer and which is listed in Application tab of Windows Task manager.
anybody have idea that how can i perform this task ?
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
the anwser is .....Imports System.Diagnostics.Process with is not that obvious
Imports System.Diagnostics.Process
Module Module1
Sub Main()
Dim myProcess() As Process = Process.GetProcesses()
For Each proc As Process In myProcess
Console.WriteLine("Process: {0} ID: {1}", proc.ProcessName, proc.Id)
Next
End Sub
End Module
Andy
|
|
|
|
|
imports system.diagnostics
Public Sub showProcesses()
Dim W As Object
Dim sQuery As String
Dim processes As Object
Dim process As Object
W = GetObject("winmgmts:")
sQuery = "SELECT * FROM win32_process"
processes = W.execquery(sQuery)
For Each process In processes
MsgBox(process.Name) 'you can also get the process.Handle
Next
W = Nothing
processes = Nothing
process = Nothing
End Sub
This function get the name of all running process Names.
Thanx
Mitesh Khatri
khatrimitesh@hotmail.com
|
|
|
|
|
|
Dear All,
I have a problem
If I insert values from text boxes as 3, +, 2 and I catch it for string variables.
a = textbox1.text
b = textboxt2.text
c = textbox3.text
Then I want to calculate those values
ex: total = 3+2
virtually,
total = a b c (because b="+")
How can I do this,
please help
Thanks
|
|
|
|
|
want you have here is a casting problem. i guess that you want have the option to have different operators in the in 'b' so you could do basic maths operation....+ \ - *
if this is so...what i would so is have b a dropdownlist or combobox with the selection fixed and maybe have it defaulted to '+'
the next thing to do if make textbox 'a' and 'c' only except numbers, you can find many example of this on the web
and once you have done this because you know that only number are going be entered you can cast the strings to ints
i.e.
Dim int1 As Integer = CType(textbox1, Integer)
Dim int2 As Integer = CType(textbox3, Integer)
then based on the selection do a case select to do the calculation
hope this is what you wanted....
|
|
|
|
|
Thank you very much Fu Manchu,
Yes, it is ok for a and c. But how can I include b ("+" or may be "-", "*", "/" something like that). Becuase the operator is as in the textbox text, therefore I want to it convert to operator and also, include into equation. Is it possible??
If I describe further, there are three texboxes in the application. So user can type values in 1st and 3rd textboxes and operator (may be one of these +, -, *, /) in 2nd text box. Then application should give the results.
help me,
Thanks
|
|
|
|
|
Hi All,
how to get Numeric values from a String Variable through Regular Expressions in VB.Net.
i have a string variable and it contains string Data and Numeric values,
i need to extract the Numeric value.
Example :
strData="FM*kl-Class Oyr 563"
strData="FM*kl-Class Oyr 563.21"
Out put= 563
Out put= 563.21
i expect your valuable help.
By
George Garvasis
|
|
|
|
|
George, thats pretty much info google can show you. Why dont you try to put a regex together for it and then come back when that doesnt give you quite what you expect - honestly, a regex to do what you've asked is quite easy
georgegarvasis wrote: i expect your valuable help.
I'd suggest you try to be a bit more polite - you're likely to be shredded by the regulars if they see that !!! (if not, completely ignored)
'g'
|
|
|
|