Re: Mutliple ResultSet from Stored Procedure using EF 5.0 - C# Discussion Boards

Richard MacCutchan12-Jul-14 21:33

12-Jul-14 21:33

This will depend on how the printer is connected, and to what, and the actual commands required by the device. You need to check the documentation for the printer as a first step.

Re: Send command To Printe

Zeyad Jalil12-Jul-14 22:09

Zeyad Jalil

12-Jul-14 22:09

Hi,

I Use wintec printer which connected to the PC Using USB Port, and the cash drawer connected to the printer directly.

Re: Send command To Printe

Richard MacCutchan12-Jul-14 22:20

Richard MacCutchan

12-Jul-14 22:20

As I said before, you need to check the documentation for the printer to see what commands it needs.

Re: Send command To Printe

Dave Kreskowiak13-Jul-14 4:40

Dave Kreskowiak

13-Jul-14 4:40

Soooooo you want other people to do your research for you? That's what I'm hearing from you.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Add other component in c# 2008

KaKoten12-Jul-14 15:30

KaKoten

12-Jul-14 15:30

I want to adding another component including timer.tick, progressbar and backroundworker, how do i adding the component to process mailsend and this is the code, thanks:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Net.Mail;
using System.Net;


namespace Mail_Send
{
    public partial class Form4 : Form
    {
        SmtpClient obj_SMTPClient;
        MailMessage Obj_MailMsg;
        Attachment obj_Attachment;
        //string pBar;
       
        
        public Form4()

        {
            InitializeComponent();            
        }
        
        private void Form4_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog open = new OpenFileDialog();
            if (open.ShowDialog() == DialogResult.OK)
            {
                label3.Text = open.FileName;
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void SendMail_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
            {
                MessageBox.Show("please fill, don't let a column blank!!!");
            }
            else
                try
                {
                    obj_SMTPClient = new SmtpClient("smtp.gmail.com");
                    Obj_MailMsg = new MailMessage();
                    obj_Attachment = new System.Net.Mail.Attachment(label3.Text);
                    Obj_MailMsg.From = new MailAddress(textBox1.Text);
                    Obj_MailMsg.To.Add(textBox3.Text);
                    Obj_MailMsg.Body = textBox5.Text;
                    Obj_MailMsg.Attachments.Add(obj_Attachment);
                    Obj_MailMsg.Subject = textBox4.Text;
                    SmtpClient smtps = new SmtpClient("smtp.gmail.com", 587);
                    obj_SMTPClient.Credentials = new NetworkCredential();
                    obj_SMTPClient.Port = 587;
                    obj_SMTPClient.Credentials = new System.Net.NetworkCredential(textBox1.Text, textBox2.Text);
                    obj_SMTPClient.EnableSsl = true;
                    obj_SMTPClient.Send(Obj_MailMsg);

                    obj_SMTPClient.EnableSsl = true;
                    obj_SMTPClient.Send(Obj_MailMsg);
                    MessageBox.Show("Message Successful sent!!!");
                }
                catch
                {
                    MessageBox.Show("Sorry, Request TimeOut!!!");
                }
        } 

        private void button4_Click(object sender, EventArgs e)
        {
                
        }     
     
         
    

        private void button8_Click(object sender, EventArgs e)
        {
            foreach (Control sayre in this.Controls)
            {
                if (sayre is TextBox)
                {
                    (sayre as TextBox).Clear();
                }
            } 
        }

        private void button6_Click(object sender, EventArgs e)
        {
           
        }

        private void button5_Click(object sender, EventArgs e)
        {
           
        }

        private void button4_Click_1(object sender, EventArgs e)
        {
            foreach (Control sayre in this.Controls)
            {
                if (sayre is TextBox)
                {
                    (sayre as TextBox).Clear();
                }
            }  
        }       
        
        
        }
    }

modified 12-Jul-14 21:38pm.

Re: Add other component in c# 2008

Richard MacCutchan12-Jul-14 21:28

Richard MacCutchan

12-Jul-14 21:28

BackGroundWorker[^], ProgressBar[^], Timer[^]. You should also give your controls meaningful names, rather than button1, button2 etc.

Mutliple ResultSet from Stored Procedure using EF 5.0

meeram3912-Jul-14 12:57

meeram39

12-Jul-14 12:57

I have a stored procedure that returns two resultset. I am calling this stored procedure in C# using EF 5.0. I have gone through the examples on this site as well as on thissite.

I can understand that it is comparatively easy to call multiple result set with EF 5.0. But I am confused on adding ReturnType on FunctionImport tag which is as below:

XML

<FunctionImport Name="GetAllBlogsAndPosts"> 
  <ReturnType EntitySet="Blogs" Type="Collection(BlogModel.Blog)" /> 
  <ReturnType EntitySet="Posts" Type="Collection(BlogModel.Post)" /> 
</FunctionImport>

In the above example, Blog and Post are two different entities so can easily be referred. However, in my case, the two resultset is the result of joining of multiple tables. SO how will I specify a specific table name here? (On EntitySet as well as Type). I am not able to understand clearly what value should go into these tags? Please provide any help.

Re: Mutliple ResultSet from Stored Procedure using EF 5.0

Dave Kreskowiak13-Jul-14 4:42

Dave Kreskowiak

13-Jul-14 4:42

Wow. This[^] took me 5 seconds to find with a simple Google search for "entity framework map to stored procedure returning multiple result sets[^]".

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: Mutliple ResultSet from Stored Procedure using EF 5.0

meeram3913-Jul-14 8:39

meeram39

13-Jul-14 8:39

Thank you.

I have already referred this and I mentioned this in my question also. I asked the question because I am not able to understand how to refer multiple tables on FunctionImport and Return Types.

Anyway, I found out already. Thanks for your help.

Translate method in Entity framework not found

meeram3912-Jul-14 7:53

meeram39

12-Jul-14 7:53

I have a stored procedure that returns multiple result set. I tried to use Translate method to handle this, however, I am not able to call this method, as it is giving error such a method doesn't exist. I am using .Net Framework 4.5 and Entity Framework 5.0. Following is what I have tried.

using (var db = new MyEntities())
            {
                using (IDbConnection oaConnection = db.Database.Connection)
                {
                    // 3. Create a new instance of the OACommand class.
                    using (IDbCommand oaCommand = oaConnection.CreateCommand())
                    {
                        // 4. Set the CommandType property.
                        oaCommand.CommandType = CommandType.StoredProcedure;

                        // 5. Set the CommandText property.
                        oaCommand.CommandText = "gsp_get_emp_details";
                        oaCommand.Parameters.Add(empInput.EmployeeId);
                        oaCommand.Parameters.Add(empInput.UserId);
                        oaCommand.Parameters.Add(empInput.RoleList);

                        // 6. Execute the command and materialize the car entities
                        using (IDataReader dataReader = oaCommand.ExecuteReader())
                        {
                            EmployeeData empData = db.Translate<EmployeeData>(dataReader as DbDataReader);
}
}
}
}

I tried using by calling

using System.Data.Objects;

, however it is giving compile error on db.Translate. It is giving the message that "project does not contain a definition for Translate...". May I know what's wrong with the above code? Thanks in advance for any help.

Re: Translate method in Entity framework not found

Pete O'Hanlon12-Jul-14 8:54

Pete O'Hanlon

12-Jul-14 8:54

I'm pretty sure that you should be using Translate on an ObjectContext.

Re: Translate method in Entity framework not found

meeram3912-Jul-14 9:52

meeram39

12-Jul-14 9:52

Thanks a lot!!!. I was using DBContext. I was little aware of ObjectContext. I done some examples now. This link is useful, hope it will be useful for someone.

This link also much useful how to get objectcontext references.

Thanks again.. Smile | :)

modified 12-Jul-14 16:14pm.

Self Hosted WCF + REST + CORS

evolcoder11-Jul-14 22:10

evolcoder

11-Jul-14 22:10

Can someone tell me how to do that? There is tons of examples in the internet, but they don't cover self hosted WCF libraries. Please if anyone, share some code, bwt i need app.config configuration, and feature to enable CORS and REST

Re: Self Hosted WCF + REST + CORS

OriginalGriff11-Jul-14 22:37

OriginalGriff

11-Jul-14 22:37

You might be best asking the specific WCF forum[^]

Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

Re: Self Hosted WCF + REST + CORS

Rob Philpott11-Jul-14 22:39

Rob Philpott

11-Jul-14 22:39

You can't have a self-hosted library. A library is something that is used by something else.

You need some sort of host - a process. Simplest thing to do is a simple console app.

Regards,
Rob Philpott.

Re: Self Hosted WCF + REST + CORS

evolcoder14-Jul-14 17:16

evolcoder

14-Jul-14 17:16

no i can, start new wcf library template from visual studio, and you will have self hosted wcf, which plugs into windows wcf-hoster.

exe of C# file.

Mehmood Ali Biswas11-Jul-14 21:36

Mehmood Ali Biswas

11-Jul-14 21:36

i create a s/w , by C# (visual studio) , at backend mySql. i create exe file which i create in visual studio.
so my Question is-

a)if i install the exe file in other computer then i have to install Mysql workbrench on that computer ?

b)if yes then how can i install it?

Re: exe of C# file.

OriginalGriff11-Jul-14 22:36

OriginalGriff

11-Jul-14 22:36

Don't post this in multiple places - it wastes time and annoys people.
You have it posted in QA, leave it there.

Re: exe of C# file.

Rob Philpott11-Jul-14 22:37

Rob Philpott

11-Jul-14 22:37

No, you shouldn't have to. Presumably your exe is using MySQL 'driver' assemblies, so as long as they are distributed with your .exe you should be fine.

Regards,
Rob Philpott.

Import XML file without stylesheet

Richard.Berry10011-Jul-14 19:01

Richard.Berry100

11-Jul-14 19:01

Hi
I need to populate a datatable with two fields from an xml file.<partnum> and <actualqtynum>

The file was obtained from a report that opens in a web browser, and the file saved from there.

DataTabel.ReadXml(XMLFilename)

fails (complains about the ':' character in Line 2 of the xml file.)

I thought about using something like below, since I do have a complete list of the <partnum> in another table, but the <actualqtynum> is not a child node of <partnum> , and this also fails (complains about the ':' character in Line 2 of the xml file.)

public string GetKeyValue(string key)
       {
           System.Xml.XmlDocument xd = new System.Xml.XmlDocument();
           xd.Load(_XMLFileName);
           System.Xml.XmlNode Node = xd.DocumentElement.SelectSingleNode("/REPORTTABLE/REPORTTABLEDETAILS/PARTNUM add[@key=\"" + key + "\"]");

           if ((Node != null))
           {
               return Node.Attributes.GetNamedItem("value").Value;
           }
           else
           {
               return null;
           }
       }

Any idea how I can get a list of PARTNUM with the corresponding ACTUALQTYNUM?

XML

<?xml version="1.0" encoding="Shift_JIS" ?>
<?xml:stylesheet type="text/xsl" href="../Bin/KITSCHREPFLEXA.xsl" ?>
<DOCUMENT>
<REPORTHEADER>
<REPORTTIME>2014/07/11 13:36:44</REPORTTIME>
<CREATEBY>Fujiuser</CREATEBY>
<SCHEDULENAME>Week_23_2014</SCHEDULENAME>
</REPORTHEADER>
<REPORTTABLE>
<REPORTTABLEDETAILS>
<JOBNAMES><JOBNAME>260-C536000-PACE - Top_TLine 1 / Line 1 / Top / 1</JOBNAME></JOBNAMES>
<JOBNAMES><JOBNAME>260-C536000-PACE - Top_BLine 2 / VEK Line 2 / Bottom / 1</JOBNAME></JOBNAMES>
<DATANUM>38</DATANUM>
<PARTBARCODE>938-1030507</PARTBARCODE><ORIGINALPARTBARCODE>938-1030507</ORIGINALPARTBARCODE><PARTNUM>938-1030507</PARTNUM>
<SUPPLYNUM>2</SUPPLYNUM>
<ACTUALNUM>2</ACTUALNUM>
<REMAINSNUM>0</REMAINSNUM>
<QTYSUPPLYNUM>4</QTYSUPPLYNUM>
<QTYACTUALNUM>6249</QTYACTUALNUM>
<QTYREMAINSNUM>6245</QTYREMAINSNUM>
</REPORTTABLEDETAILS>
<REPORTTABLEDETAILS>
<DATANUM></DATANUM>
<PARTBARCODE>948-1025627</PARTBARCODE><ORIGINALPARTBARCODE>948-1025627</ORIGINALPARTBARCODE><PARTNUM>948-1025627</PARTNUM>
<SUPPLYNUM>2</SUPPLYNUM>
<ACTUALNUM>1</ACTUALNUM>
<REMAINSNUM>-1</REMAINSNUM>
<QTYSUPPLYNUM>40</QTYSUPPLYNUM>
<QTYACTUALNUM>6720</QTYACTUALNUM>
<QTYREMAINSNUM>6680</QTYREMAINSNUM>
</REPORTTABLEDETAILS>

Re: Import XML file without stylesheet

Richard MacCutchan11-Jul-14 21:35

Richard MacCutchan

11-Jul-14 21:35

See http://www.w3.org/TR/xml-stylesheet/[^].

Re: Import XML file without stylesheet

Richard.Berry10012-Jul-14 18:17

Richard.Berry100

12-Jul-14 18:17

Thanks for your reply Richard.

From W3.org it seems the file is possibly not 100% compliant

HTML

xml:stylesheet

should be

xml-stylesheet

But even so, I eventually got hold of the stylesheet which did not have any Schema info.

Also tried DataSet.ReadXml as many posts on the net suggested where a schema was not available with no luck.

Ended up reading the file with StreamReader.ReadLine and picking out the values I needed with SubString(...)

Re: Import XML file without stylesheet

Bernhard Hiller13-Jul-14 21:40

Bernhard Hiller

13-Jul-14 21:40

Having to deal with defective XML files is always fun... My 5 for seeing that little difference.
Alternatively to your solution, write the file back line by line, just omitting the "bad" line. With that file, some tools could generate classes for its content, and thus making the access to the properties easier.
The Japanese encoding could cause some more fun later on, be prepared for that.

Error : Method name expected // how do I fix this error. please

Member 1074342211-Jul-14 17:47

Member 10743422

11-Jul-14 17:47

C# Code
using System;
using System.Collections;

namespace Loop_Test
{
public class ForLoopTest
{
static void Main()
{
int Ticks = 0;
int Bit = 0;
int Ask = 0;
int Bar1 = 22;
for(int i = 0; i < 22 ( Bit + Ask) ; i++)

Console.WriteLine("Bar1");

}
}
}
This is one of bar from 22 Ticks ,Stock bar chart (Bid,Ask,Open,High,Low, Close).
When bar close must have Variable (Bit&Ask) Total= 22;

Can somebody help me with this loop.
David.

Re: Error : Method name expected // how do I fix this error. please

Richard.Berry10011-Jul-14 19:19

Richard.Berry100

11-Jul-14 19:19

A few things:

1) Do you want to loop until (Bit + Ask) = 22?
2) The value of Bit,Ask and Bar1 are not changing from 0
3) If you want to display the value of Bar1 then you should put Console.WriteLine(Bar1.ToString());

(Console.WriteLine("Bar1") will display 'Bar1' and not the value of the variable Bar1)

for (int i = 0; (Bit + Ask) < 22; i++)
            {
                //Do something here to change the value of Bit and Ask - else infinite loop!!!
                Console.WriteLine(Bar1.ToString());
            }

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.