Comments by EM_Y - CodeProject

EM_Y 20-Sep-19 5:09am View

Hi Richard I'm using here the entity framework query not oledb connection . I don't need the parameterized query .

EM_Y 20-Sep-19 4:58am View

Thank you Richard

this code added make the difference . ^^

 if (!string.IsNullOrEmpty(path) && File.Exists(path))
    { }

EM_Y 19-Sep-19 4:08am View

Sorry but I didn't mention that my code debug perfectly even with this error , the objective of the code I set in my constructor is to fill my combobox with my file text lines , and it works ! that means that my path config is correct .

the problem is may be the data context needs specific format to define my view model when I use the app config reader in my constructor !!

EM_Y 13-Sep-19 6:14am View

I did succeed converting my MySQL table to excel using MySQL connection /command !
My question is to do the same operation using entity framework model query .


table_Entity result = new table_Entity();
var  EntityQuery=from t in DB.Table1 where t.date >= d1 && t.date <=  d2  select t;

EM_Y 12-Sep-19 9:17am View

YEs its related with the app.config ,cause when I replace the configAPPsetting with a simple string path , the error disappear .

foreach (string line in File.ReadAllLines("D:\\All Documents\\Famille.txt"))
            {
             }

Thank you Jim I'll try to figure out and poste the solution .

EM_Y 12-Sep-19 4:00am View

I found the problem but not the solution actually ^^ , I need to keep my public Model view code , what path needs the data context related to my wanted code ! thank you for your attention .

EM_Y 11-Sep-19 11:58am View

Hi Jim I found where the problem was : I have this public view model , when I have masked the code content the error has disappear , I wish you find the cause related between my public viewmodel and the data context .

   public ViewModel()
        {   
            
         string[] lineOfContents = File.ReadAllLines(ConfigurationManager.AppSettings["FiletextPath"]);

            MyList= new ObservableCollection<search>();           
           foreach (var line in lineOfContents)
           {
       string myline = line ;
                SearchCritaire = new search() { banc = line};
               

                MyList.Add(SearchCritaire);

            }

          }

EM_Y 11-Sep-19 11:42am View

Deleted

Well I have this command in my model view binded to button if it can make any difference !

 private RelayCommand Cmd;

        public RelayCommand cmd
        {
            get { return Cmd?? (extraction = new RelayCommand(param => Execute())); }
        }

private void Execute ()
{
MessageBox.Show("ok") ;

}

EM_Y 11-Sep-19 10:15am View

hello Jim ,
I updated my modelView UP ! please check it

EM_Y 10-Sep-19 10:40am View

Hi Gerry
I almost losing hope posting my problem . I'm trying my best to figure out ,Thank you for your reply !

EM_Y 11-Apr-19 4:27am View

very thankful :)

EM_Y 10-Apr-19 11:54am View

I tried to follow the link solution but i got any result ! my mistake !

i worked with condtructor methode , it works but I would be happy if you helped me with my first try (property methode ):

public frmChild (string data)
{
InitializeComponent();
tbData.Text = data;
}
Parent Form
Hide Copy Code
frmChild child = new frmChild("Hello child!");
child.Show();

Thank you for your help and attention :)

EM_Y 10-Apr-19 5:44am View

I ve update my code ; please check it !
i tried the property methode , but my value is not changing ! Boolquery is always false !

EM_Y 23-Oct-18 10:14am View

I'll try to check and learn the match I can ^^ .
Thank you.

EM_Y 23-Oct-18 9:02am View

You don't stop helping me ^^ ,
I appreciate your help and time , I'm a beginner in xml , I'm trying to get and do better .
Thank you for your attention .

EM_Y 23-Oct-18 6:55am View

Thank you for your help and time ^^ this is work catching first node with value I want .
I want to uncomment every node with this value ,
exemple :

  <Inputs>

<!--<Input>readOF</Input> -->
<!--<Input>readOF</Input> -->
    <Input>readReference</Input>
   
  </Inputs>

Desired output:

<Input>readOF</Input>
<Input>readOF</Input>

Can you help me plz with that ^^

EM_Y 18-Oct-18 10:17am View

In my code solution ,I replaced this 2 lines
inputs.RemoveChild(child);
inputs.PrependChild(commentNode);

with
child.ParentNode.ReplaceChild(commentNode, child);
=>Order respected .

Thank you @Eric for your help :) I appreciate you attention .

EM_Y 18-Oct-18 9:46am View

Can you please explain to me the difference between your code and mine (My answer bellow) and why my code change the comment Order and remote It on the rest inputs ?

Thank you ^^

EM_Y 18-Oct-18 9:42am View

Your awesome , thank you ^^ , I found solution but the code I found is changing the comment order to up .
your code comment it and save to same order ,Thank you for help and attention :)

EM_Y 18-Oct-18 5:08am View

I want to comment this line readOF using wpf/c# programmatically
My code is working only when I have one only Input but when I have more than one nothing works ,
I tried to identify my element value readOF but I couldn't find the right code format .

I Wish this is clear for you , Thank you for your attention .

EM_Y 17-Oct-18 10:52am View

here I found some solution , I updated my Problem , please check it , I'll appreciate any help .

EM_Y 17-Oct-18 9:44am View

I want to comment and uncomment specific xml file code or line from wpf application using button action

EM_Y 9-Feb-18 6:47am View

Done.

EM_Y 8-Feb-18 2:28am View

You'r genius :p ^^ , it works perfectly .
I appreciate your help .

EM_Y 7-Feb-18 4:29am View

I found also how to delete all shapes (pictures/images ) from excel file but couldn't transform it to delete only one specific shape !

foreach (Excel.Shape sh in RapportXlSheet.Shapes)
            {
                sh.Delete();
            }

EM_Y 7-Feb-18 2:53am View

you are right ,
I'll try to explain better.

When I used

 RapportXlSheet.Shapes[imageName].Delete();

Error message shows : Cannot apply indexing with [] to an expression of type 'Microsoft.Office.Interop.Excel.Shapes' !

*I appreciate your attention :) .

EM_Y 6-Feb-18 3:19am View

Thank you for your help and time , but it doesn't work ! :) @Richard Deeming

EM_Y 6-Feb-18 3:09am View

Deleted

Thank you for your help and time , but it doesn't work ! :)

EM_Y 5-Dec-17 4:33am View

I've just update my code , I hope it's clear now ! very thankful for your attention and I wish your help !
I want to copy all rows result in one simple code !

EM_Y 4-Dec-17 6:22am View

okey I'm understanding this , Thank you for your time I'm trying my best .

EM_Y 4-Dec-17 5:16am View

it's not the same property code , there is differences between using : using spire.xls and using Excel = Microsoft.Office.Interop.Excel namespaces !
I'm still trying to find it .. very thankful .

EM_Y 4-Dec-17 4:46am View

I guess you didn't even get what I'm trying to explain !
I want to copy the line where my Key search exist in column [0]filesource +the 2 line next to my new file destination . I used to code with spire .xls and my code work very fine but I want to convert it to nrmal excel.App method .
It'll be sure simple to copy a specific cell data to another .
Thank you for your help.

EM_Y 28-Nov-17 8:16am View

Thank you for your precious help ,it works !

EM_Y 28-Nov-17 4:56am View

Deleted

Here I found the solution :

private void Print_Click(object sender, RoutedEventArgs e)
{

Excel.Application APP = new Microsoft.Office.Interop.Excel.Application();
          Microsoft.Office.Interop.Excel.Workbook wb = APP.Workbooks.Open(
     my File path",
     Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
     Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
     Type.Missing, Type.Missing, Type.Missing, Type.Missing);

          // Get the first worksheet.
          // (Excel uses base 1 indexing, not base 0.)
   Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];

    ws.PrintOut(
              Type.Missing, Type.Missing, Type.Missing, Type.Missing,
              Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}

EM_Y 27-Nov-17 4:39am View

this code is printing " the Evaluation warning sheet" witch is always activate when the excel file opened because I'm using spire.xls , I need to define in code the sheet number wich is zero here to print it .
Thank you for help !

EM_Y 24-Nov-17 3:20am View

thank you very much it works ,
but can you help me please to specify exactly the sheet that I want to print in this file !

EM_Y 10-Nov-17 4:15am View

I resulted the problem ,I converted my data to integer while I have float numbers :thank you for your help

float TimeFab = float.Parse(item.ColumnSum);

EM_Y 27-Oct-17 7:06am View

thank you it works ^^

EM_Y 27-Oct-17 6:57am View

Thank you but it doesn't work .

EM_Y 20-Jun-17 8:02am View

@ppolymorphe

I exported MySQL table to excel using wpf ,
my excel sheet start from cell position A5,
Rows of first column can had same value .
I want to let the first value and delete the rest cell content that has the same value .

the code that I've tried ,compare row1col1 and row2Col1 and if it had the same value row2col2 will be deleted , and pass to row3col1 and compare it with row4 and etc...
Hide Copy Code

try { if (xlWorkSheetCarteProd.Cells[i,1].Value==xlWorkSheetCarteProd.Cells[i + 1, 1].Value) {         xlWorkSheetCarteProd.Cells[i +1, 1].Value = "";        }} catch{ }

I wish I explained it well ?

Thank you for your attention .

EM_Y 20-Jun-17 4:39am View

It works when and inside loop j=1 ,
it works but it compare only the 2 first rows .
My objective is to delete the repeated Texts cell in column A and let the first copy ,While my excel data sheet start from A5 .
I wish your help ! Thank you

EM_Y 20-Jun-17 4:25am View

You are right about j=1 ,
it works but it compare only the 2 first rows .
My objective is to delete the repeated Texts cell in column A and let the first copy ,While my excel data sheet start from A5 .
I wish your help ! Thank you

EM_Y 20-Jun-17 4:18am View

Deleted

You are right about j=1 ,
it works but it compare only the 2 first rows .
My objective is to delete the repeated Texts cell in column A and let the first copy ,While my excel data sheet start from A5 .
I wish your help ! Thank you

EM_Y 19-Jun-17 7:41am View

@F-ES
Thank you ,but It doesn't work for me I tried to play code refer to your suggestion but It doesn't work either ,
and error shows : Exception from HRESULT: 0x800A03EC
It means that excel didn't find any result !

EM_Y 19-Jun-17 5:30am View

I'll open a new question .

EM_Y 19-Jun-17 5:10am View

I want to compare 2 cells from the same column when exporting data to excel
I added this code in my loop but it doesn't work for me :
Thank you for you help :)

if (xlWorkSheetCarteProd.Cells[i + 5, j].Value  ==  xlWorkSheetCarteProd.Cells[i + 6, j].Value)                    {          xlWorkSheetCarteProd.Cells[i + 6, j].Value = "";    }

@ppolymorphe

EM_Y 19-Jun-17 3:29am View

It works ,Thank you for your help !

EM_Y 23-May-17 9:23am View

with this code I can display my datagrid to descending order by defining the column , I used this entity code , and it's work for me , but I want to convert it to a type of mySQL query !

EM_Y 15-May-17 3:32am View

your genius :p , thank you for help ^^

EM_Y 12-May-17 11:45am View

I've just updated my code , I wish it's more clear

EM_Y 12-May-17 11:45am View

I've just update my code , I wish it's more clear

EM_Y 12-May-17 11:41am View

t could be the string from any row in data grid ; I've just updated my code , I wish it's more clear

EM_Y 12-May-17 11:40am View

t could be the string from any row in data grid ; I've just updated my code , I wish it's more clear

EM_Y 12-May-17 10:38am View

It's a For loop to test datagrid rows cells ,
my code works in Windows forms App c# , But I'm beginner in wpf that's why I'm having some difficulties. Thank you .

EM_Y 12-May-17 9:45am View

Thank you It's tap mistake ,I fixed that ! :)

EM_Y 12-May-17 9:44am View

Deleted

I'm using wpf with c# and it's not the same code

EM_Y 28-Apr-17 3:40am View

Problem solved ,My mistake was that I created new APP.config while I already have one !
Thank you for your time and help , I will do my best to focus more :)

EM_Y 28-Apr-17 3:20am View

I got zero error , but the debugging stopped at the same line :
string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;

EM_Y 27-Apr-17 6:23am View

1. yes it's Xml in App.config
2. yes the error shows at this line :
string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;

EM_Y 13-Apr-17 6:46am View

It's working I'm very thankful .

EM_Y 12-Apr-17 5:21am View

I tried it , and the message error change to " Column 'Date' not known " !

EM_Y 10-Apr-17 7:05am View

I'm sorry for my miss understand I used Datagridview Tasks to choose data Source !!and it populate its data automatically.

EM_Y 10-Apr-17 3:36am View

Thank you but I tried your code and it showed me this Error Message 'The expression contains unsupported operator 'Between'. !

EM_Y 7-Apr-17 7:40am View

I updated it you can see it now !
I hope it's more clear !
it's a button show

EM_Y 31-Mar-17 10:04am View

Your are brilliant ^^ thank you .

EM_Y 31-Mar-17 9:27am View

Should I do the same with 1,2 and 3 , Or it needs another Code structure !?

1. public static int supplierCode { get; private set; } = int.Parse(ConfigurationManager.AppSettings.Get("supplierCode"));

2. public List<string> alreadyScannedSubsets { get; set; } = new List<string>();

3. Dictionary<string, Delegate> SequencerInputs {get; set;} = null;

Thank you for your help ,Bless you :) .

EM_Y 31-Mar-17 7:40am View

Thank you I will try it and tell you the result !

EM_Y 21-Mar-17 9:36am View

thank you but Same message error shows :)

EM_Y 21-Mar-17 3:52am View

I got this error meaage :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Convert(researchkey,'System.String') like @filter) subq ORDER BY (id) ASC' at line 1

? any way I'll keep trying ,I'm so thankful for your help , Bless you .

EM_Y 17-Mar-17 10:49am View

Can you translate this to c# code plz ! thank you :)

EM_Y 17-Mar-17 10:31am View

can you help me , how can I populate it with pre-filtered data !
and get result in datagridview !?
I'm using c#

EM_Y 17-Mar-17 10:01am View

Thank you so much for your help , I will try this :)

EM_Y 17-Mar-17 10:01am View

Deleted

Thank you so much for your help , I'll try this

EM_Y 17-Mar-17 9:18am View

I'm thankful , I wish your help :)

EM_Y 17-Mar-17 4:45am View

Is it right to write like this :

  private void button1_Click(object sender, EventArgs e)
        {
            String constring = "";
            MySqlConnection connection = new MySqlConnection(constring);
            connection.Open();
            BindingSource bs = new BindingSource();

            bs.DataSource = dataGridView1.DataSource;
            bs.Filter = "SELECT * FROM (SELECT * FROM database.table ORDER BY (id) DESC LIMIT 5 WHERE Convert(researchKey,'System.String') like '" + textbox.Text + "') subq ORDER BY (id) ASC";

       
            dataGridView1.DataSource = bs;

        }

EM_Y 7-Mar-17 6:06am View

Done .
Thank you for your help :)

EM_Y 7-Mar-17 5:57am View

How can I do that ?

EM_Y 7-Mar-17 5:40am View

It was a problem in the model table , I added a wrong association .
Thank you @Karthic for you help :)

EM_Y 2-Mar-17 5:11am View

it's the idRow with type : integer auto increment

EM_Y 2-Mar-17 4:56am View

Error :
http://imgur.com/M4wj5gG

EM_Y 2-Mar-17 4:54am View

Error :
http://imgur.com/M4wj5gG

EM_Y 2-Mar-17 4:42am View

Sorry I'm new in this Forum , I've never post a screen shot!

EM_Y 2-Mar-17 4:36am View

Error Message Exception "Input string was not in a correct format".

EM_Y 2-Mar-17 4:19am View

Errror shows in this line code :

" var get = dc.table.Where(b => b.IdRow == id).SingleOrDefault();"

EM_Y 2-Mar-17 4:15am View

Thank you but I'm Still getting same error !
Any other suggestions ?

EM_Y 6-Feb-17 6:04am View

thank you I will try it !
but why it works for me in other tables !?

EM_Y 6-Feb-17 5:54am View

Thank you i will fixe that :)

EM_Y 2-Feb-17 4:54am View

It solved my problem
Thank you ^^

Comments by EM_Y (Top 88 by date)