C#

Quote:Solved!

1. In DCOMCNFG, right click on the My Computer and select properties. 
2. Choose the COM Securities tab
3. In Access Permissions, click "Edit Defaults" and add Network Service to it and give it "Allow local access" permission. Do the same for \Users.
4. In launch and Activation Permissions, click "Edit Defaults" and add Network Service to it and give it "Local launch" and "Local Activation" permission. Do the same for \Users

createXLS error 1: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
   at Microsoft.Office.Interop.Excel.Workbooks.Add(Object Template)
   at UPNP_WS_Weekly.UpnpWeeklyMailService.createXLS(String dir) in c:\Users\Documents\Visual Studio 2013\Projects\UPNP_WS_Weekly\UPNP_WS_Weekly\Service1.cs:line 218

xlWorkBook = xlApp.Workbooks.Add(misValue);

Arjun Mourya wrote:

I have written the below code to connect to the server.

Arjun Mourya wrote:

Also I should login to the server to fetch data from it

Arjun Mourya wrote:

<layer>How to supply credentials via socket so that the server allows the client to fetch the data from server.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

UPDATE [tablename]
  SET col1 = value1,
      col2 = value2

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

string query = "SELECT tag_id,category_id,product_id,product_name,gate_id,remarks FROM inventory where tag_id Like '" + sEPC + "'";
                      MySqlCommand cmd;
                      MySqlDataReader rdr;
                      MySqlConnection connection = new MySqlConnection(MyConnectionString);
                      connection.Open();

                     // DataTable dt = new DataTable();
                      cmd = new MySqlCommand(query, connection);
                      rdr = cmd.ExecuteReader();
                      /*Received Epc matched in the Inventory Table */
                      if (rdr != null)
                      {
                          String s2 = DateTime.Now.ToString("yyyy-MM-dd HH:MM:ss").Trim();
                          //      ListView1_EPC.Items[j].Remove();
                          if (rdr.Read())
                          {


                              cnt = ListView1_EPC.Items.Count;
                              ListViewItem item = new ListViewItem(rdr.GetString(0));
                              cnt = ListView1_EPC.Items.Count;

                              item.SubItems.Add(rdr.GetString(1));
                              item.SubItems.Add(rdr.GetString(2));
                              item.SubItems.Add(rdr.GetString(3));
                              item.SubItems.Add(rdr.GetString(4));
                             // item.SubItems.Add(s2);
                             // item.SubItems.Add(s2);
                              //item.SubItems[OUTTime.Index].Text = rdr.GetString(5);
                              item.SubItems.Add(rdr.GetString(5));
                              ListView1_EPC.Items.Add(item);
                              cnt = ListView1_EPC.Items.Count;
                              rdr.Close();
                              string query1 = "SELECT tag_id,category_id,product_id,product_name,gate_id,remarks FROM transaction where tag_id Like '" + sEPC + "' AND out_time=NULL";
                              MySqlCommand cmd1= new MySqlCommand(query1,connection);
                              MySqlDataReader rdr1 = cmd1.ExecuteReader();
                              if (rdr1 != null)
                              {
                                  item.SubItems[INTime.Index].Text = s2;
                                  ListView1_EPC.Items.Add(item);

                                  String s1 = "update transaction set out_time='" + s2 + "'  where tag_id='" + ListView1_EPC.Items[i].Text + "' ";
                                  MySqlCommand cmd2 = new MySqlCommand(s1, connection);
                                  cmd2.ExecuteNonQuery();

                              }
                              else
                              {
                                  item.SubItems[Remarks.Index].Text = s2;
                                  ListView1_EPC.Items.Add(item);

                                  String str = "insert into transaction(tag_id,category_id,product_id,product_name,gate_id,in_time,remarks)values('" + ListView1_EPC.Items[i].Text.Trim() + "','" + item.SubItems[CategoryID.Index].Text.Trim() + "','" + item.SubItems[ProductID.Index].Text.Trim() + "','" + item.SubItems[ProductName.Index].Text.Trim() + "','" + item.SubItems[GateID.Index].Text.Trim() + "','" + item.SubItems[Remarks.Index].Text.Trim() + "','" + item.SubItems[OUTTime.Index].Text.Trim() + "')";
                                  MySqlCommand cmd2 = new MySqlCommand(str, connection);
                                  cmd2.ExecuteNonQuery();
                              }



                          }//if

Member 10263519 wrote:

But am getting error as ArgumentOutORange exception at
item.SubItems[INTime.Index].Text = s2;

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

AshwiniSH wrote:

Can i relate these two nodes?

private static int calcPrice(int drawerA, char getWoodA)

int drawerA = getDrawer();
string getWoodA = getWood();
int getPrice = calcPrice(drawerA, getWoodA);

using System;
public class ComputePriceDesk
{
	public static void Main()
	{
	double calc = usersDrawers();	
	Console.WriteLine ("The total of your desk is $ {0}", calc);
	}
	 
	public static double usersDrawers()
	{
	int New;
	string HowManyDrawers = "";
	 
	Console.Write("How many drawers will you like in your desk?: ");
	HowManyDrawers = Console.ReadLine();
	New = Convert.ToInt32(HowManyDrawers);
	return New;
	}
 
//User Enters Wood Type
	public static int woodType()
	{
	string woodType;
	char charWoodType;
	 
	Console.WriteLine ("What type of Wood will your desk be? ");
	 
	Console.WriteLine ("m for mahogony");
	 
	Console.WriteLine ("o for oak");
	 
	Console.WriteLine ("p for pine");
	 
	woodType = Console.ReadLine();
	charWoodType = Convert.ToChar(woodType);
	return 0;
	}
	
 	public static int usersWood()
 	{
 	    const int moh = 180;
 	    const int oak = 140;
 	    const int pine = 100;
 	    int wood;
 
 	    if (woodType.Equals('m') || woodType.Equals('M'))
 	        wood = moh;
 	    else if (woodType.Equals('o') || woodType.Equals('O'))
 	        wood = oak;
 	    else
 	        wood = pine;
 
 	    return wood;
 	}
 	public static void calculations(int totalDrawers, char wood)
 	{
 	    int totalDrawers;
 	    char wood;
 	    int calc;
 	    calc = totalDrawers * wood;
	}
}

double calc = usersDrawers();

public static double usersDrawers()
{
int New;
...
return New;
}