.NET (Core and Framework)

mohammad_b wrote:

thanks again.first i apologize for my dirty and ugly coding.

I are Troll

[DllImport("kernel32.dll", CharSet = CharSet.Auto)]
public static extern int GetShortPathName(
[MarshalAs(UnmanagedType.LPTStr)]
string path,
[MarshalAs(UnmanagedType.LPTStr)]
StringBuilder shortPath,
int shortPathLength
);
       
public static void Main()
{
    StringBuilder shortPath = new StringBuilder(255);
    GetShortPathName(@"D:\My Temp\ResourseProvider\sql.txt", shortPath, shortPath.Capacity);
    Console.WriteLine(shortPath.ToString());
}

    Private Declare Auto Function GetShortPathName Lib "kernel32" ( _
    ByVal lpszLongPath As String, _
    ByVal lpszShortPath As StringBuilder, _
    ByVal cchBuffer As Integer) As Integer


    Public Function GetShortPath(ByVal longPath As String) As String
    Dim requiredSize As Integer = GetShortPathName(longPath, Nothing, 0)
    Dim buffer As New StringBuilder(requiredSize)
    GetShortPathName(longPath, buffer, buffer.Capacity)
    Return buffer.ToString()
End Function

Dim myStyle As New DataGridTextBoxColumn

myStyle.MappingName = "Emp_name"
myStyle.HeaderText = "Employee Name"

void dataGrid _EditingControlShowing(object  sender, DataGridViewEditingControlShowingEventArgs  e)
{
    DataGridView dgr = (DataGridView)sender;
    if (dgr.CurrentCell.ColumnIndex == 2)
    {
        if (e.Control is TextBox)
        { 
            TextBox tb = e.Control as TextBox;
            tb.KeyPress += new KeyPressEventHandler(tb_KeyPress);
        }
    }
} 

void tb_KeyPress(object sender, KeyPressEventArgs e)
{
    if (!(char.IsDigit(e.KeyChar)))
    {
        if (e.KeyChar == Keys.Enter) //allow the backspace key and decimal point
        {
            //Write you code here to retrieve values of other three columns of datagrid.
            e.Handled = true;
        }
    }
}

string cmd = string.Format(@"-u{0} -p{1} -h{2} {3} <(4)", "dfs", "sf#", "localhost", '"' + temple1 + '"', "E:\\BackupMysql1\\temple.sql");

ProcessStartInfo proc = new ProcessStartInfo(@"[FullPath]\mysql.exe");

string cmd = string.Format(@"C:\wamp\bin\mysql\mysql5.1.36\bin\mysql.exe -u {0} -p -h {1} {2} < {3}", "root", "localhost", "test123", @"C:\wamp\bin\mysql\mysql5.1.36\bin\wp.sql");

ProcessStartInfo proc = new ProcessStartInfo("cmd", @"/C " + cmd);

//Avoid defining following two arguments
//proc.RedirectStandardInput = true;
//proc.RedirectStandardOutput = true;

proc.UseShellExecute = false;

Process p = new Process();
p.StartInfo = proc;
p.Start();
p.WaitForExit();