Ramy Mahrous 401 Postaholic Featured Poster

Kischi, it seems you in hurry!!! please be patient and think in codes before writing it. dateTimeColumn isn't column in your table program, rather I mean the column holds the date data.
Tell me your table columns if you faced another problem.

Ramy Mahrous 401 Postaholic Featured Poster

He should know your IP through configuration settings, and ports he could random port number and try to connect if failed generate another one.

Ramy Mahrous 401 Postaholic Featured Poster

Not Logical!!!

Ramy Mahrous 401 Postaholic Featured Poster

first text should contain 6 digit..

What do you mean by text??! plain text or textbox, please clarify..

Ramy Mahrous 401 Postaholic Featured Poster

Yes, you can, if you running on Windows Vista be sure to run this on administrative mode. Please include any error message appears.

Ramy Mahrous 401 Postaholic Featured Poster

Because your SQL Syntax is wrong
the right one is

SELECT CONVERT(VARCHAR(5), [dateTimeColumn], 14) , txt FROM PROGRAM WHERE DATE >= convert(varchar, GETDATE()) AND DATE <= DATEADD(Month, 2, GETDATE())";
Ramy Mahrous 401 Postaholic Featured Poster

In your Select statement add this

select CONVERT(VARCHAR(5), [dateTimeColumn], 14), ..... from [table name];
Ramy Mahrous 401 Postaholic Featured Poster

Look, send me the Excel file and the table scheme you need to insert into on ramyamahrous@hotmail.com I'll debug your code.

Ramy Mahrous 401 Postaholic Featured Poster

Because you've Express Edition!!

open SQL Server Business Intelligence Development Studio (Shipped with SQL Server all editions expect Express one

Ramy Mahrous 401 Postaholic Featured Poster

Again, open SQL Server Business Intelligence Development Studio (Shipped with SQL Server all editions expect Express one), create project from type SQL Server Integration Services Project, select Data Flow tab and do it, if you face any problem tell me.

Ramy Mahrous 401 Postaholic Featured Poster

No, don't use this code at all, and turn into using SSIS.

Ramy Mahrous 401 Postaholic Featured Poster

I can't debug your code right now, but I recommend to transfer data from different data repositories to SQL Server is to use SQL Server Integration Service which in SQL Server Business Intelligence Studio. through it your can transfer\cleans\custom your data.

Ramy Mahrous 401 Postaholic Featured Poster

For sure publisher won't save unless last changes, so use the Transactional mode. please read the last link I've sent you, to be sure you're using the best suitable for you.

Ramy Mahrous 401 Postaholic Featured Poster

Front end: ASP.NET, JSP, Servlets, etc...
Back end: SQL Server, Oracle, MySQL, etc...

I don't know what do you need please, specify your questions.

Ramy Mahrous 401 Postaholic Featured Poster

You must specify the database and the table to search in.

Ramy Mahrous 401 Postaholic Featured Poster

First SQL Query
UNION
Second SQL Query

Ramy Mahrous 401 Postaholic Featured Poster

You can filter ongoing IPs to the ones you trust... and also you can discuss that with someone aware of networks he may help you in such stuff.

Ramy Mahrous 401 Postaholic Featured Poster

My answer is: "Merge replication" http://msdn.microsoft.com/en-us/library/ms152746(SQL.90).aspx
To check if mine fits you take a look on http://msdn.microsoft.com/en-us/library/ms152531(SQL.90).aspx

Ramy Mahrous 401 Postaholic Featured Poster

If your machine which hosts SQL Server has static IP, you can connect it without need to VPN, using normal connection string, and instead of machine name you can write the IP.
Another way is to ask in Network forums http://www.daniweb.com/forums/forum13.html they may have a solution around VPN

Ramy Mahrous 401 Postaholic Featured Poster

Try first to write your solution in a draft, think how to code it, all of us know how to convert it theoretically, which means you won't pay a lot to think, and to code; it's for your interest to do it yourself, some lines of codes won't help you as they are not written by you!!

Ramy Mahrous 401 Postaholic Featured Poster

Microsoft DDK helps...

Ramy Mahrous 401 Postaholic Featured Poster

To explain DDanbe answer, DateTime is value type which means can't be null to make it accepts null you should add nullable flavor "DateTime?"

Ramy Mahrous 401 Postaholic Featured Poster

Just tell me to where you reached and what's the problem facing you?

Ramy Mahrous 401 Postaholic Featured Poster

Use Visual Studio Click Once Installer.
New project->Other Project Types->Setup and Depolyment->Setup Wizard

Ramy Mahrous 401 Postaholic Featured Poster

Check with (Map Quest) technical support, they may have solution regarding this, or (Map Quest) has minimal prerequisites, your web server must meet.

Ramy Mahrous 401 Postaholic Featured Poster

I went back, I was busy last days with my conscription.. thanks for asking :)

Ramy Mahrous 401 Postaholic Featured Poster

Project properties!

Ramy Mahrous 401 Postaholic Featured Poster

I didn't fully understand you, however have you .config file has some resources used by your code, like connection string, etc...

try to deploy your project on XP machine and see if error raises or not.

Keep me updated with your problem.

Ramy Mahrous 401 Postaholic Featured Poster

That's surely because you select to output for example 2 or more .exe, which each of which depends on same dll, so windows installed get the 2 .exe + the depended dll, so it warns you about that, don't worry at all, your work is good

Ramy Mahrous 401 Postaholic Featured Poster

Has permission to write on this directory?!

Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster

OK, just give me time to do it I am kinda busy right now..

Ramy Mahrous 401 Postaholic Featured Poster

working on Windows Vista? maybe you need to run this application as administrator.. really I don't know but I give some assumptions.. it's really strange!

Ramy Mahrous 401 Postaholic Featured Poster

DirectX has facilities to develop networking games..

Ramy Mahrous 401 Postaholic Featured Poster

Start->Run->regedit and based on the location you register the dlls go, and edit them..

Ramy Mahrous 401 Postaholic Featured Poster

Ok, I'll help you regards this, but first tell me it's Windows application or web-based application?!

Ramy Mahrous 401 Postaholic Featured Poster

Are you sure that the connection string is correct?

Ramy Mahrous 401 Postaholic Featured Poster

Can't!!
Your question has words "OR" this means you've to use a branched code...

Ramy Mahrous 401 Postaholic Featured Poster

Very easy, I'll write code, when user presses on the button, it creates object fron ListBox type and create an event for it also...

private void Grow(object sender, EventArgs e)
{
ListBox lstBoxForItems = new ListBox();
lstBoxForItems.Items.Add("1");
lstBoxForItems.Items.Add("2");
lstBoxForItems.Items.Add("3");
lstBoxForItems.Show();
this.Controls.Add(lstBoxForItems);
lstBoxForItems.SelectedIndexChanged += new EventHandler(lstBoxForItems_SelectedIndexChanged);
        }

        void lstBoxForItems_SelectedIndexChanged(object sender, EventArgs e)
        {
            MessageBox.Show(lstBoxForItems.SelectedItem.ToString());
        }
Ramy Mahrous 401 Postaholic Featured Poster

Please clarify!

Ramy Mahrous 401 Postaholic Featured Poster

Better to ask @ ASP.NET forum http://www.daniweb.com/forums/forum18.html

Ramy Mahrous 401 Postaholic Featured Poster

Target client has Excel installed??!

Ramy Mahrous 401 Postaholic Featured Poster

http://www.microsoft.com/com/default.mspx
If you don't get anything, send your questions..

Ramy Mahrous 401 Postaholic Featured Poster

First create shared folder on HCTADMINS and set read\write permission.
Let's say we called the shared folder Database Folder
So, connection string be

string strconnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\HCTADMINS\Database Folder\c#.accdb";
Ramy Mahrous 401 Postaholic Featured Poster

Menu items from another form?!?!
So, please clarify your question, to let us give solution...

Ramy Mahrous 401 Postaholic Featured Poster

Yes, according to your .net security, you don't give the user permissions to access protected resources, configure it from Control panel->Administrative tools->Microsoft .NET Framework 2.0 Configuration.
You may need to configure the zone of the application, work around this you'll solve this problem :)

Ramy Mahrous 401 Postaholic Featured Poster

The .exe and .dll should be beside each other, you may don't have the permission to run the application.

Ramy Mahrous 401 Postaholic Featured Poster

Sure, cast it to ShapeControl because Control class doesn't contain Growing property.

private void Grow(object sender, EventArgs e)
{
Shape controlAll = (Shape)sender; 
controlAll.Growing = 50;
}