Posts by Ramy Mahrous

let your SQL holds the date in any format, we won't care!!! what I care about? is date when returns, I suggest you a SQL statement to solve all of your problems.

Remove the container control (DataList, Repeater, etc...) and insert someone again... or try asking asp.net forum http://www.daniweb.com/forums/forum18.html

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.

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

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())";

In your Select statement add this

select CONVERT(VARCHAR(5), [dateTimeColumn], 14), ..... from [table name];

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

Because you've Express Edition!!

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

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.

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

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.

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!!

Microsoft DDK helps...

Project properties!

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.

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

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

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

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

You can manage enabling and disabling items according to user cerdentials, when user logins into your system get its type (Admin, user,...) and then make switch case, in case of User's type is user so CreateUser.Enable = false....

Probably you've added just the .resx file!! and didn't form code file.

Just make your button control access modifier public, then handle second form closing event to enable the button by your code.

I wrote post regards this talks generally about how to make form's controls movable(you can drag and drop) just take a look http://fci-h.blogspot.com/2008/05/how-to-make-your-controls-moveable.html

Did you commit the changes done at the dataset?!

To convert string to float

string numberAsString = "50.5";
float floatingPointNumber = float.Parse(numberAsString);

To convert string to integer

string numberAsString = "50";
int number = int.Parse(numberAsString);

I can't debug your code or even read it, to make it easy, inform us with error raises when you run the code.

What's the error raises when you run this code?!

To know about connection strings http://connectionstrings.com to know how to play with database read in ADO.NET in http://msdn.com

I mean such questions that related to ASP.NET, preferebly to ask at ASP.NET forum to get accurate and fast help :)

ASP.NET forum http://www.daniweb.com/forums/forum18.html

Look, I tried it myself it works fine without replacing anything, Just I read text file using this

string str = File.ReadAllText(filePath);
textbox.Text = str;

No additional characters added!!
May be you should provide non-unicoding in ReadAllText method.

Just small question, you read text from file and then write it to textbox?? or what?

Your TextBox is multiline or isn't??

string str = char.ConvertFromUtf32(65)

You mean MDI? or just you need to open Form2 from Form1 and use some values in Form1 user entered in Form2??

For second case, just create another Form let say it called Form2, some public members (TextBox, ListBox, etc...)

Add this code in Form1 to open Form2

Form2 form2 = new Form2();
fom2.ShowDialog();//enforces user to not back to form1 unless finishing work on form2

Get the value of form2's textbox

string str = form2.textbox2.Text;

Say you've button, when user presses on it fills the grid with the data filtered with your critria, OK?

So, on you button click event handler write this code

this.table1TableAdapter.FillBy(this.myDataSet.myTable, new System.Nullable<int>(((int)(System.Convert.ChangeType(textbox1.Text, typeof(int))))));

N.P: My critria was integer value
sorry but I don't know VB.NET code :)

You can use regular expression to validate user input, in your case your regular expression'd be ^\d{3}-\d{4}$
So, on your btn validate click event handler you can check if user enters valid phoen number or not

if Regex.IsMatch(txtPhoneNumber.Text, textBox1.Text)
then
MessageBox.Show("Correct")
else
MessageBox.Show("Wrong")

comboBox1.Items.Clear()

Yes, there is

foreach (ToolStripMenuItem item in menuStrip1.Items)
{
                item.Checked = false;
}

May you make a timeout for transaction which is smaller than the time needed to send the binary data for the image and saving it in database I recommend you to open another thread in MySQL forum http://www.daniweb.com/forums/forum126.html you may find someone helps you...

In your dataset you can add some queries or paramatized queries and pass the value of its variable(s) at the runtime, on your DataTable right click then Add query and go through it....
Concerns Textbox you should do some process on the data return from database before showing them on the textbox, first to have multiple lines on textbox, set the from its properties or use RichTextBox..

Kindly move your thread to ASP.NET forum http://www.daniweb.com/forums/forum18.html to get help..

Sorry Jerry I was out Cairo last 4 days, I didn't read your question else now so binary columns by default in gridview read as image, in your scenario VS tries to convert your binary data (timestamp) to image so it fails so it throws exception!!! try to change the gridview control in you timestamp column to text data..

Sorry, explain more..

A great article which makes you understand when to use abstract classes and when you use interfaces
Interfaces: http://fci-h.blogspot.com/2008/03/oop-design-concepts-interfaces_05.html

Abstract classes: http://fci-h.blogspot.com/2008/03/oop-design-concepts-abstract-classes.html

Yeah i created a blog in daniweb but they ask me to carry all the entries to forums since they were going to delete my blog(it cant contain code snippets like mine). I am going to hire hosting for my next blog

WHYYYYYYYYYYYY!!! I've a blog on daniweb http://www.daniweb.com/blogs/blog100382.html and I wrote some article there!! they didn't delete it!!

Hello, Serkan that's good material for solution deployment but we usually use threads to ask and answer you can create a blog and put your valuable information in so we can make use of!!!

Million thanks for your contribution :)

I don't have something in which I can say that's the problem I am not sure but try to be sure from column names like 'name'.
Trace the parameters sent to this SP if it works!
Send me the error raised to help you.

In pictureBox event handler (MouseOver) assign the picturebox.image to the image which in resources. It works!

Manually you can stop the server copy the data files and then restart the server..