|
No,it willnot work,
Ur query will work,when that two tables have same id...,
If table1 have particular date on some other ids,
then those records willn't display...,
Similarly table2 also have paricular date some other ids those records will not display...,
ex:
table1:
Id cardDate Intime1 Outtime1
1 12/22/2006 09:00 20:00
2 12/22/2007 09:00 20:00
3 12/22/2006 09:00 13:00
7 12/22/2006 09:00 20:00
and table 2:
Id leaveDate Intime2 Outtime2
3 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00
5 11/11/2006 09:00 20:00
8 12/22/2006 09:00 20:00
see ur query willn't show id=7 & 8,
and ur query will display table2 all records it willn't check the date condition
and it willn't show at one row when the date will be there in two tables
see my first ques i told output style also..........
Magi
|
|
|
|
|
after connecting vb6 with sql+, i can create normal data reports but how should i create dynamic data reports........
or
i use only one data environment and one form and one data report then how should i create such a report that the value entered in the text box of the form(for example a class in a school like 10th or 12th) then how should it be possible that i can create a report that whatever class is entered in the text box i get the fields of that class from the table of the students in the same data report........
deepak jain
|
|
|
|
|
Hi can you plz advice me how to filter file while upload image through webapplication for example when open dialogue box has open you want to show the file type with *.jpg and *.gif the file dialogue box should not show any other file type.
Magi
|
|
|
|
|
simply set your OpenFileDialog box property like.....
OpenFileDialog.Filter = "JPG Files(*.jpg)|*.jpg|GIF Files(*.gif)|*.gif"
thus Your OpenFileDialog box will not show any other file type.....
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
Hey one doubt..........,this command will be use in web application?
it will work in web application?
Magi
|
|
|
|
|
then you can use the Accept method of HTML FileField control for your work.....
MyFileField.Accept="jpeg,gif"
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
Hello,
[VS 2005]
Is there a way to manually order the columns in a DataGridView.
My grid is bound to the datasource at run-time. So I can't change the order in the designer.
Is there a method to do that in code?
Many thanks,
Steve
|
|
|
|
|
what do u mean by Ordering of column?? Construct your SQL Query as you like....
are you using SELECT * FROM TableName WHERE.....???
instead use....
SELECT Column1,Column2,...... FROM TableName WHERE ....."
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
I have a vb.net application that has a third party ActiveX/ocx control on the form .. The control can display data in a so called data-grid like format ... and one can add/remove/re-position/set width of the specific columns of data you want to display
Having set up the right columns I want ...
e.g | Column A | Column B | Column C | etc ... All works fine ..
If I then exit the application ... and re-run the application .. I have to again "set" all the columns as I want them on the control ...
Is there a way to "save" the column layout of the control?
I am not able to see any "methods" associated with the control to do this ...
Is there anything within the overall vb.net form to do this ..?
I hope I have explained myself clearly enough ...
Regards,
GaryAW
|
|
|
|
|
hi friends,
i want learn to make crystal report step by step...plz help
Imagine the I.T
|
|
|
|
|
|
i just complate my b.e i.t .
i want to do MCPD or MCSD
i want information abt MCPD or MCSD.
how can get material or book for exam?
Imagine the I.T
|
|
|
|
|
You have completed an IT qualification, but you don't know about google ? http://www.amazon.com[^] is the place for books.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I have my MCSD .net. It was hard, but if you study you can pass the tests.
MCSD .net is .net 1.1.
MCPD is .net 2.0. I am having more trouble with these tests. They seem harder then the MCSD ones.
Ben
|
|
|
|
|
hi..
thks 4 reply
.........
tell me abt books, & all related info....
Imagine the I.T
|
|
|
|
|
I got my books on amazon at a discount for the mcsd tests. They are pretty cheap for used copies this the certification is for .net 1.1. I have really found any good books yet for MCPD.
Ben
|
|
|
|
|
i want to make a component that contains a datagrid. when i press f1 i want to display another form with so many textboxes and when i click ok in that form i want to add all the details in textbox to the datagrid which i called that form .can anyone help me.......
|
|
|
|
|
If we can use static variables inside instance constructor then why static method or constructor is required? When this will be used? Any practical usage of static or shared method.
|
|
|
|
|
A static method is a C# term. The vb.net equivalent is shared. A shared method can be called without creating an instance of your class. There are plenty of examples. For instance the 'string' class has a number of shared methods. There all over. A shared variable can also be accessed without creating an instance. A static variable is only good for a single instance of the class and can only be accessed if you have an instance. A shared variable on the other hand spans classes if you will.
|
|
|
|
|
TwoFaced wrote: A static variable is only good for a single instance of the class and can only be accessed if you have an instance
You mean a member variable, right ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
No, I meant static. My wording however was chosen poorly (and yes defines a member variable). I shouldn't write stuff when I'm tired. What I tried to say was the static variable requires an instance (Of course it has local scope and can't be seen outside the method it exists in). This is wrong, however, becuase you could use a static variable inside a shared method. Being awake certainly helps clarify things. Thanks for catching my mistake.
|
|
|
|
|
Shraddha Bhatt wrote: If we can use static variables inside instance constructor then why static method or constructor is required?
Because, you can access static variables and methods without ever calling an instance constructor. For example, the MessageBox class is static, you call MessageBox.Show(), without ever creating an instance constructor. If it needs to initialise anything, a static constructor is the only place to do it.
Shraddha Bhatt wrote: Any practical usage of static or shared method.
Usually, it comes down to offering stateless functionality ( i.e. methods that don't ever change any properties on a class instance ), so that you can call it without having to create an instance. An obvious example, is factory pattern methods. So, instead of saying
Dim f as Foo = new Foo()
you would say
Dim f as Foo = Foo.MakeOne();
There are benefits to this design, and obviously, I cannot call MakeOne to create a Foo, if it's not a static method, because, if the constructor is private, I could never have an instance of Foo on which to call the method.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi all,
I have created a small project in Vb.net 2005. When I try to debug the project with break point,the debuuger skips some breakpoints.
Can anybody help me regarding this?
Thanx in advance.
Max
|
|
|
|
|
Where are the break points located? If the code doesn't execute then the breakpoint won't stop the program. For instance if I have a breakpoint on the second line below it won't stop anything because that line will never execute.
If 1=2
msgbox("I won't be displayed")
end if
|
|
|
|
|
No man the code is being executed,but Debugger doesn´t stop on breakpoint.
When I try to do it on my machine it works,but on some other machine it falis to stop at the breakpoint.
Thankx for your quick response
Max
|
|
|
|