Posts by Ramy Mahrous

Don't guess please; try it in Access, and tell me the result!

Can you create table in access by SQL script??

Windows service run an executable with an silly interface which doesn't allow a user to max, mini, or close it.
Executable will do its job for authentication.

If you need to use wildcard with date you need to cast it first to string, and then play with it.

I am not aware of crystal reports issues but take a look at this site http://www.thescarms.com/dotnet/CrystalRptViewer.aspx

Where you write this code?? I think you don't write them within method!! PLEASE SEND ME SNAP SHOT OF VS SCREEN SHOWS THE ERROR. It'd help me to help you!

ooooh, Macros, I think you need to ask this question in Visual Basic 4 / 5 / 6 forum

OK, show me to where you reached, post some code to know how can I do the next step.

You can work with crystal reports using Reporting tools in VS toolbox it'd help you a lot, try it!

Are you developing in VB.NET project?? or C# project? please send us screenshot your code should work right!

This ComboBox in VB.NET form or in Excel sheet?

Look my friend I don't know how you don't know the size of array and you said you will generate some number, so tell me when you'll stop generating numbers? Any way I know you question is away from this.
Your question answer is

For index As Integer = 1 To YourArray.Length
'Your search algorithm resides here
Next

It'd work whatever you know the size or not and if you changed its size at runtime.
Hope I got more from you :) best of luck

You mean to not let the user to select it by himself? if so check this http://www.daniweb.com/forums/thread168467.html

If you col1 not primary key you can use trigger to check on the columns in inserted table(read about it in triggers) if col1 data already exists don't insert it in the destination table.

Here is the sample data:

???!

Give me sample data and what you need to get, then I can understand you well

Catch the transaction code, and show me the error raised!

I am so sorry RonnySaid, if I annoyed you; please accept my apologies.

Running on Vista?

I really don't care about the dates they worked together, I just want to know how many times they worked together. So I really don't need the Date column and I could run the same query.

You really really really need it, tell me why because if you don't attach it and make the three columns primary key you enforced just 2 employees can work 2 or 4 times with each other? how come and watch out
Emp1# Emp2# Date
1 2 1/1/08 (√)
1 2 1/8/08 (X)
2 1 1/5/08 (√)
2 1 1/5/08 (X)

But if you do it like that Emp1#, Emp2# and Date#
Emp1# Emp2# Date#
1 2 1/1/08 (√)
1 2 1/8/08 (√)
2 1 1/5/08 (√)
2 3 1/5/08 (√)

DATABASE DESIGN PRINCIPLE DON'T STORE ANY CALCULATED VALUE, Use SP to calculate it, faster, more performance, etc....

You should have table called tbl_work (ID_EMP1 #, ID_EMP2 #) that's if you need to restrict 2 employees work together more than 4 times. Actually I don't understand you well but I'll give solution to what I got.
If you need system tracks whom\when employees work together and remove redundancy you can use this table tbl_work(ID_EMP1 #, ID_EMP2 #, WorkDate #).
Let's discuss that to understand you well

So, show us your ERD I am bit lost in the description.

If it's not confidential, you can show us the SP to see if we can optimize it. I think in connection string you can specify the time out value play with it, it may solve the problem on the first machine.

Yes :) you're right

I am trying not to run multiple queries.. and was wondering if there is a efficient and condensed way of doing this?

Stored Procedure.

If you need help in designing database please send us a description to these tables.

I don't know what you need from this query?? do you use Microsoft SQL Server?

What's the error?
You can use Import\Export data. (right click on the database->All tasks-> Import\Export data)

I guess the error because there's violation in primary key... you've to provide us with the error.

If the two tables (has difference in structure columns number, different datatypes) I recommend you to use SQL Server Integration Services.

If you have string like that in table "lmlmlaa,lmlmlaa, lmlmlaa, lmlmlaa" and need to return it as table
ID text
1 lmlmlaa
2 lmlmlaa
3 lmlmlaa
4 lmlmlaa
and you may also do some operation on this table, what do you see is to handle this in C# or UDF?

1- Depends on your version but it doesn't make any difference.
2- Yes calling UDF like SP, search how to use it in .net
3- Pre-compiled queries, you can use some logic (splitting strings, some calculations, etc..)
4- In some situations you'd better to write UDF than programming code.
haa, discuss me if you're convinced.

I didn't do any progress because of a lot of load, please try to search and tell me your progress, keep in touch.

404 File Not Found

In asp.net forum they answer such questions relevant to web development

Clarify please!

Here you're http://www.connectionstrings.com/oracle

http://www.google.com.eg/search?hl=en&q=work+with+excel+by+C%23&meta=&aq=f&oq=

No, because Joins are standards. But did you use query visualizer to make sure you're doing correct relationship?

Originally Posted by RamyMahrous
You may ask in ASP.NET forum, it'd be better.

This is the ASP.net forum?

It was in vb.net forum and it's just moved!!

http://msdn.com enjoy a lot of examples and explanation...

I can't but moderators may do :) I don't know :$

I recommend you to ask this question in Visual Basic 4 / 5 / 6 forum http://www.daniweb.com/forums/forum4.html

Exactly and in .net 2.0 and later you can write

'try block
catch..
catch..
catch..

without need to use nested try catch

If you didn't find what you need from this post, search on "convert case when to access" you find a lot, wish for you the best of luck

You've to. and don't write catch code in Finally (because finally code executed in all cases)

Look there's no Case...Where syntax in Access, and that's way I asked your "Where you run this query" but I found an article shows how to convert T-SQL query to Access query; here you're http://ewbi.blogs.com/develops/2006/02/adding_case_to_.html please keep me up-to-date with your problem

Your query is very complicated but where do you run this query? and what I can help you is to give you this link may the error in Case....When syntax http://msdn.microsoft.com/en-us/library/ms181765.aspx

and what about http://sourceforge.net/ ?

My friend I don't mean it's weak, I just concentrate on syntax similarities:)
And thanks for your great answer :)

Sure there's way :)

SQL Script is declarative which means you just need something without any knowledge how the engine will get it for you.
Title, description, etc are strings so, you need to know how to get search in string and get string which starts with\ends with\contains character(s) ..

NullReferenceException

I think you used an button without new it. and you have to because it's reference type.
[out of topic]
someone professional in Java, the next step should be C# not VB.NET:)

forum application in asp.net with c#.

and it's VB.NET forum anyway, you mean to provide the user with bold, underline, colors, to enrich his message, that's is normal buttons add some html tags on the message, I'm sure if you ask this question in asp.net forum you'll find some experts provide you with controls and tutorial to do that. Best of luck