Ramy Mahrous 401 Postaholic Featured Poster

It's not about Microsoft or others, it's about opening a new forum, increase our community size, make it richer and richer, collect all people intersets, and be up-to-date.

Ramy Mahrous 401 Postaholic Featured Poster

Who said learn C++ in 2hrs???!!
I said learn Windows PowerShell in 2Hrs!!

Ramy Mahrous 401 Postaholic Featured Poster

Windows PowerShell is a very productive tool Microsoft has integrated it with Windows Server 2008 since beta versions to automate some taskes, make it easier and fun for developers, be integrated with .net libraries and so on.. developers and administrators who haven't experience in VB script and programming languages like C# and C++ syntax can learn its syntax in 2Hrs, what a power it is!
Shall we have a forum for it, learn it together and help who faces any problem regarding using it. I hope you agree opening a forum concerns in Windows PowerShell.

Thanks and regards,
Ramy Mahrous

Ramy Mahrous 401 Postaholic Featured Poster

Please, send me your project on RamyMahrous@gmail.com I'll debug it and tell you the problem en shaa ALLAH

Ramy Mahrous 401 Postaholic Featured Poster

From VS main menu Project->Add new item select .settings file, once you've added it a designer (tabular) form allows you to add variables add ServerName and assign it a default value.
In coding let's the connection string static except the server name dynamic from the settings file.

Ramy Mahrous 401 Postaholic Featured Poster

No sorry my friend, I just need your interest I want you get fast and correct answer, and I am sorry I couldn't help :)

Ramy Mahrous 401 Postaholic Featured Poster

Your question should be forwarded to http://www.daniweb.com/forums/forum126.html because we're in MS SQL Server forum not MySQL forum

Ramy Mahrous 401 Postaholic Featured Poster

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

peter_budo commented: Thank you for help +7
Ramy Mahrous 401 Postaholic Featured Poster

select sum(column1)\5, column2, column3, column4,.... from table1 where some conditions

but

I am using that query for Crystal report.
I tried to get this by using Formula field. But that formula field returning me the result of all rows not for a single row.

because you put it in a row so, for each row Crystal report repeats it.. try to define it by some way to avoid that...

Ramy Mahrous 401 Postaholic Featured Poster

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

Ramy Mahrous 401 Postaholic Featured Poster

After taking the value from the textbox, clear it
textbox.Text = null;

Ramy Mahrous 401 Postaholic Featured Poster

C# on MSDN: http://msdn2.microsoft.com/en-us/vcsharp/default.aspx

pictureBox1.Image = Properties.Resources.[image name];
Ramy Mahrous 401 Postaholic Featured Poster

About ComboBox you can control the data it bound to be unique i.e if you return data from database let it distinct

About tooltip, its show method take the control it shows if the cursor came on and the string it displayes i.e ToolTip1.Show(textbox1, "this is textbox")

About a textbox(input only alphabets) in text changed handler for the textbx\richtextbox it receives the key (last one) written on the textbox\richtextbox using some Char\char class method you can check if the key written was alphabet or digits and take the decision

Ramy Mahrous 401 Postaholic Featured Poster

it is limited to layout options

Ramy Mahrous 401 Postaholic Featured Poster

However, the <Extra Data> needs to be ignored and the cells "blacked out" if the ForeignKey occurs more than once in TableB

It should be occur more than once in table b as the relationship is 1-to-many!!
I think you must support me with inputs and output..

Ramy Mahrous 401 Postaholic Featured Poster

I'll read your question again but can you please provide us with sample input and the output, it'd help me

Ramy Mahrous 401 Postaholic Featured Poster

Read more on SQLTransaction class, if you search on this problem you may find something called COM+ don't go through it your problem can be solved using SQLTransaction class, don't overhead yourself by reading in COM+

Ramy Mahrous 401 Postaholic Featured Poster

That's your task not mine, but I'll give you a hint, declare two float objects op1 and op2, when user begins enter some numbers in the textbox (the only one) once s\he presses +, -, *, \ take the textbox.text value and assign it to the op1 then clear the textbox let him\her insert number in the textbox again until s\he presses = assign textbox.text to op2, according to the operation user entered evaluate op1 and op2...

Ramy Mahrous 401 Postaholic Featured Poster

Take a look at this article it'd help you http://fci-h.blogspot.com/2007/03/turn-off-your-monitor-via-code-c.html
Any questions is welcome...

Ramy Mahrous 401 Postaholic Featured Poster

Please, tell me what exactly what do you want to do ??

Ramy Mahrous 401 Postaholic Featured Poster

Sure, you've ml file and you also have System.Xml namespace which contains a lot of classes to add\remove and edit some nodes in xml files...

Ramy Mahrous 401 Postaholic Featured Poster

Try that, right click on your program then run as administrator.. reply if the problem still exists..

Ramy Mahrous 401 Postaholic Featured Poster

Uncompatiblity in running applications with the OS, sure you'll find the version of access should be run on OS above XP and so on... Contact Microsoft technical support for more information.

Ramy Mahrous 401 Postaholic Featured Poster

Usually VS saves connectionstrings in .config file or .settings file which is xml formatted. to do it yourself vs main menu Project->Add new item->.settings file
Add your items in this settings file, you're now can modify your settings without modifying your code.
Avoid using ini files, xml is better.

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

Sorry I didn't get what you mean or where problem happens??!! please clarify.. thanks

Ramy Mahrous 401 Postaholic Featured Poster

Googlize it, friend! and if you faced in problem regarding code, send us! we're here to help!

Ramy Mahrous 401 Postaholic Featured Poster

mmmm, working in real life applications will lead you to use in common matlab librabries and may be in front end c# form, I don't know software vendor has written image processing libraries like matlab!! their lgorithms is fast may be you found some faster than them, try to comapre in that time but all in all don't re-write something aleardy made.

Ramy Mahrous 401 Postaholic Featured Poster

usually email service provider, provides some webservices via it you can do a lot of operations on its clients like retrieving their mails and also send mails......

Ramy Mahrous 401 Postaholic Featured Poster

Contact hardware manufacturer, s\he can help you more..

Ramy Mahrous 401 Postaholic Featured Poster

More clearification, please!!

Ramy Mahrous 401 Postaholic Featured Poster

Thanks for all your replies, but why they need engineers, doctors and computer scientists to serve as soldiers???
They can make useful of them in militral units without apply some restrictions!! like waking up at 5 am, no vacations, ......
I hate being in army!!
And the most stupid point in army they treat who has qualifications like who hasn't! in that moment you feel you waste your time learning and in that moment also you'll see someone who is ignorant controlling you!!!!!!!!!!!
I've learnt very very bad things from conscription. I need to back again as free man I am in need to all your prayers :(

Ramy Mahrous 401 Postaholic Featured Poster

Those question preferable to be asked in ASP.NET forums, move your thread there to find a lot of answers..
http://www.daniweb.com/forums/forum18.html

Ramy Mahrous 401 Postaholic Featured Poster

You're so helpful Jerrrrrrrry :)

Ramy Mahrous 401 Postaholic Featured Poster

Just one question flashed in my mind who spent Mandatory service (Military service)??? and what do you think about Army??

Ramy Mahrous 401 Postaholic Featured Poster

If you need a project to learn, search on projects developed by Visual Studio Database Edtion.
Develop phonebook application, go deeply db-design...

Ramy Mahrous 401 Postaholic Featured Poster

???!

Ramy Mahrous 401 Postaholic Featured Poster

Once you dragged and dropped the gridview on your form, it'd ask you about the datasource, just create datasource and let it the grid's datasource.
using some grid handlers you can handle on row selection something happen. first I'll let you create th grid and bind the data.
If you faced any problem reply to this thread..

Ramy Mahrous 401 Postaholic Featured Poster

did u insert the whole binary data for the image??!
how did u insert let me check your code??

Ramy Mahrous 401 Postaholic Featured Poster

usually strings like what you show paths, connection strings,... saved in .config files that's a solution... but I'll give you another solution is to use relative path without refering to long path as u did simply if you need to tell your application you'll find the audio file besides the .exe so the path is "\\1.mp3"

Ramy Mahrous 401 Postaholic Featured Poster

Please just copy the lines give errors not all your application!!! and provide us with exception\error raised!!

Ramy Mahrous 401 Postaholic Featured Poster

If you use Microsoft SQL Server 2008 there is FileStream datatype.
If you use Microsoft SQL Server 2000/2005 the optimal solution is to save file path rather file itself.

Ramy Mahrous 401 Postaholic Featured Poster

what??

Ramy Mahrous 401 Postaholic Featured Poster

You're welcome, friend ;)

Ramy Mahrous 401 Postaholic Featured Poster

To get object type

Program p = new Program();
Console.WriteLine(p.GetType().Name);//prints Program

To get object base type

Program p = new Program();
Console.WriteLine(p.GetType().BaseType.Name);//prints Object (the base class of Program class)

To compare between two objects you just need to use string.Compare....

Ramy Mahrous 401 Postaholic Featured Poster

You're welcome Emilio

Ramy Mahrous 401 Postaholic Featured Poster
public new void show()
{
....
}
Ramy Mahrous 401 Postaholic Featured Poster

I see your SP not written well what about that

alter PROCEDURE dbo.spGet_image  	
(	@Image_id int
) AS
SELECT [Image_MIME_type]
      ,[Image_image]
  FROM [MailSystem].[dbo].[image] WHERE Image.Image_id = @Image_id

Pass your image ID

SqlCommand cmd = new SqlCommand("spGet_image", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(
              new SqlParameter("@Image_id", SqlDbType.INT,4));
cmd.Parameters["@Image_id"].Value = pic_id;
adm = cmd.ExecuteReader();
            if (adm.HasRows)
            {
                while (adm.Read())
                {
                    //System.Windows.Forms.MessageBox.Show("We got data");
                    Response.Redirect("image.aspx");
                    Response.ContentType = adm["Type"].ToString();
                    Response.BinaryWrite((byte[])adm["Image"]);
                    Response.Write("hello!!!!");
                }

            }
            else
            {
                System.Windows.Forms.MessageBox.Show("We have no data");
            }

It works with me :)

Ramy Mahrous 401 Postaholic Featured Poster

what error you got?

Ramy Mahrous 401 Postaholic Featured Poster

What do you mean by writing controls at text file? give me example??