Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: How to make your controls moveable?

First solution came is to group them inside UserControl, and play with them like above.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: How to insert\retrieve image in SQL Server database?

1- The work and the privilage you need to operate on file system is much harder with lots of exceptions.
2- In many cases there no images on HDD, all manipulated from database directly.

Conclusion... both solutions right and correct.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: How to insert\retrieve image in SQL Server database?

In many many many cases you have to save it as image not only the path.. In case users may change\delete images and you depend on them.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: SQL table relationships, primary keys, and restoring backup data

You're not replicate to take care about auto increment indexes... did you try backup and restore then faced any problem?!
If you ask about how to backup it... you can build SSIS package to backup the database with any logic and create job to execute this package.

Databases mssql
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: how to make this code run faster

new it like counts = new int[100000]; time to initialize it by for loop 430024
time to initialize it by new 10001

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Lock or protect a folder.

Look you can't do that... unless you may run a service to open all files so user can't open\copy or do any operations on those files (I don't recommend it)
You may save images as binary so user can't access it, but still any operations applicable on them.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: how to make this code run faster

Why counts[i] = 0; it's initialized by default.
and this too c1[i, j] = 0;

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Started writing a scripting type class. Would like your input.

Again can't get exactly what you meant! do you mean log actions done by or on objects?

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Started writing a scripting type class. Would like your input.

I don't get what you need us to help in?

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: How to add new column to SQL from inside the code

You don't need C# right now, just concerntate on datbase design and concepts read more about database normalization and how to make your desing more efficient. I don't have specific resources use Google\Bing you'll read posts about each topic.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: How to add new column to SQL from inside the code

Using SMO library you can modify your database objects, here's a sample http://www.codeproject.com/Tips/43900/Creating-SQL-Server-Login-programmatically.aspx but to do something a bit different but I'm sure you'll get it.

I believe there's something in your design to avoid redesign everytime, be sure your system is scalable enough and try another database design.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: multiple checkboxes validation

I believe ASP.NET forum is better for such questions http://www.daniweb.com/forums/forum18.html

Web Development asp.net
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Converters to visual basic to c#
Software Development c# visual-basic
ddanbe commented: Good tip Ramy :) +7
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Background image c# email

Change email.Body to email.Body = "<body background=\"@@IMAGE@@\"> </body>"

Software Development c#
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: crystal report with two tables

Does this T-SQL script work? inner joins\nestes queries make you get fields from multiple tables, did you try it?
Please tell me what you want to get from the tables? I think it AdventureWorks database, isn't it?

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: How to import Redemption.DLL

You can use "using" or fullnaming methodology Namespace.NestedNamespace.ClassName

using Microsoft.Office.Interop.Outlook;

Sample http://www.codeguru.com/csharp/csharp/cs_syntax/operators/article.php/c14293/Microsoft-Outlook-Integration-with-CNET.htm

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: storing temporary and large amount of data

First I recommend to ask this question in ASP.NET forum http://www.daniweb.com/forums/forum18.html
Second Why to retrive the 7000 records? those records a result for something? search result of example? if yes you should get them 10 by 10 or X by X where X < 100
Session in your case is pure abuse for what it should be used in :)

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Files in a drive
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: MSSQL datetime format

We don't hear anything from them.

Databases mssql
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: detect and close explorer

If it helps, please share your code with us as answer here or as code snippet and remark this thread as solved.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Help with HttpWebRequest

So?!

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: detect and close explorer
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Help with HttpWebRequest

Sorry, but what's the expected response? give me input\output to figure it out. or read http://fci-h.blogspot.com/2010/05/how-to-consum-rest-based-services.html and configure it to work on simple web request.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: C# and Acces database

Move your mouse on ExecuteScalar and see what the tooltip shows.

Software Development c#
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: C# and Acces database

OK! As you like...
This code untested please adjust your variables to fit your case.

private const string CONNECTION_STRING =
            @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=[access database file path];Persist Security Info=False;";

        public bool CheckValidUser(string username, string password)
        {
            OleDbConnection dbConnection = new OleDbConnection(CONNECTION_STRING);
            
            string commandString = 
            "select count(*) from users where username = @username and password = @password";
            
            OleDbCommand commandStatement = new OleDbCommand(commandString, dbConnection);
            
            commandStatement.Parameters.Add("@username", OleDbType.VarWChar).Value = username;
            commandStatement.Parameters.Add("@password", OleDbType.VarWChar).Value = password;
            
            dbConnection.Open();
            int x = (int)commandStatement.ExecuteScalar();
return true ? x > 0 : false;
        }
Software Development c#
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: C# and Acces database

Buddy! If I showed you some codes you'd drop million of questions! here we don't say how to develop an application, here we help if you face some problem, as because you're not familiar with ADO.NET anything answered here is valueless!!

Software Development c#
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Date Time Picker

Does reader.HasRows = false ?

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: index out of range

I don't know :) but do you see there's row selected to be edited? or when you leave the grid it unselect all selected rows to be changed?! I really don't know your scenario, but the debugger very helpful guy in such situations.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

What :)

Text_Property_Dani.png 11.27 KB
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: index out of range

While debugging check the count of form.dataGridView2.SelectedRows I'm sure it equals -1

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

replace if (LinkLabel.Equals("linkLabel1")) with

if (LinkLabel.Text("linkLabel1"))
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: index out of range

Because there is not selected rows! is it?

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Date Time Picker

Start over! did you try my piece of code? if you yes then tell me what's wrong else kindly check it.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

Simply... implement the event handler for the LinkButton, Double click on your LinkButton. VS will switch you to code view inside this method

private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
//here to write your code 
LinkLabel link = (LinkLabel)sender;
            if (LinkLabel.Equals("linkLabel1"))
            {
                SqlDataAdapter dtadp = new SqlDataAdapter();
                DataTable dtbl = new DataTable();

                SqlConnection cn = new SqlConnection(@"Server=208.124.179.197;Database=RTLUser;UID=sa;");
                cn.Open();
                DataSet data = new DataSet();
                string myString = "";
                myString = @"Select distinct word from wordTbl where word like 'a%'";
                SqlCommand cmd = new SqlCommand(myString, cn);

                SqlDataReader rdr = cmd.ExecuteReader();
                cn.Close();
                dtadp.SelectCommand = cmd;
                dtadp.Fill(dtbl);
                dataGridView2.DataSource = dtbl;
            }
            else
            {


               dateTimePicker1.Visible = true;
               SqlDataAdapter dtadp = new SqlDataAdapter();
               DataTable dtbl = new DataTable();

               SqlConnection cn = new SqlConnection(@"Server=208.124.179.197;Database=RTLUser;UID=sa;");
               cn.Open();
               DataSet data = new DataSet();
               string myString = "";
               myString = @"Select distinct word from wordTbl";
               SqlCommand cmd = new SqlCommand(myString, cn);

               SqlDataReader rdr = cmd.ExecuteReader();
               cn.Close();
               dtadp.SelectCommand = cmd;
               dtadp.Fill(dtbl);
               dataGridView2.DataSource = dtbl;
           }
        }
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: C# and Acces database

Then you've to read in Introduction to OLE DB http://www.functionx.com/vbnet/oledb/Lesson01.htm

Software Development c#
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Date Time Picker

You use Insert command and need to Pull data?! How come?!
Can you please tell me after changing SqlDbType what errors raised.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

Reasonable! You handle the Click event of Button then cast it as LinkLabel! Use another event handler for the Click of LinkLabel.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Restrict user to type 'Arabic' Text in TextBox

Danny, you don't imagine how much I miss you... Welcome back...
I love Arabic, that's why I did this as code snippet to help who want to deal with it, and for sure I'll be happy to find lots of questions about it.
"salaam" or "salam" == greeting words == "Hey, Hello, or bye bye" the origin "Al Salam" == some name of Allah -our God in Islam-
"Salaam" said instead of "Al Salam Alikom" == Peace be upon you.

What I wrote in the TextBox == I love Arabic language :)

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

Give me your code :) with just exceptions I can't assume what did you write.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Date Time Picker

It's another question, isn't it? please if thread question answered mark it as solved and open another thread.
Consistency Required :)

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Restrict user to type 'Arabic' Text in TextBox

1- Handler TextBox Key pressed event handler.

Arabic_codesnippet_on_Dani.png 37.07 KB
Software Development
ddanbe commented: Hi Ramy! Nice snippet :) +6
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

That's the code when you click on the button -when you assign button_Click method to its Click event handler-

void button_Click(object sender, EventArgs e)
{
//here change the properties of the LinkedButton...
}
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

Buddy, It's a business scenario! what the technical problem you face?!

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Date Time Picker

SqlDbType :)

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Access one method from another

I didn't get it! can you please clarify!
If you want to handle two buttons click in one handler you set the event handler for each of which by its properties window to button_Click method.

void button_Click(object sender, EventArgs e)
{
Button clickedButton = (Button)sender;
if(clickedButton.Name == "Button1")
{
MessageBox.Show("Button 1 Clicked");
/// some operations 
}
else if(clickedButton.Name == "Button2")
{
MessageBox.Show("Button 2 Clicked");
/// some operations 
}
}
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Date Time Picker 
SELECT words FROM TableWords WHERE date = @date
SqlConnection dbConnection = new SqlConnection(CONNECTION_STRING);
string commandString = 
            "SELECT words FROM TableWords WHERE date = @date";
             SqlCommand commandStatement = new SqlCommand(commandString, dbConnection);
            commandStatement.Parameters.Add("@date", SqlType.SmallDatetime).Value = DateTimePicker1.Value;
DataReader results = commandStatement.ExecuteReader();
....
Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: C# - Enable/ Disable Button 
//Global Variables
Form frmChild;

private void button1_Click(....)
{
//show child form
frmChild=new Form();
frmChild.MDIParent=this;
frmChild.Show();
frmChild.FormClosed+=new FormClosedEventHandler(frmChild_FormClosed);
//disable your button
button1.Enabled = false;
}

void frmChild_FormClosed(object sender, EventArgs e)
{
button1.Enabled = true;
}
Software Development c#
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: Using Text from dynamically created link label..

Look... You should write the query to have the question answer.
SELECT Question, ...., Answer, then you set the navigation property of the Dynamic Link created to the [Answer] column returned -Here I suppose you're using DataGridView- if you tell me how the database looks like, definitely I'll help you better.

Software Development
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: C# - Enable/ Disable Button

Please clarify, where the button is? Parent Form or the Child one? and tell me the exact scenario.

Software Development c#
Member Avatar for Ramy Mahrous
Ramy Mahrous 401 Postaholic
Re: what is the event to triggerwhen beginediting the datagrid view combo box

CellBeginEdit

private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
MessageBox.Show("User began editing the cell");
}
Software Development vb.net