User Profile

Collapse

Profile Sidebar

Collapse
rajeswari02
rajeswari02
Last Activity: Apr 11 '14, 09:43 AM
Joined: Nov 23 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rajeswari02
    replied to get day records based on id
    in MySQL
    above out put is after the querying database.
    i want output as

    V0001 Petrol - - -
    Diesel - - -
    Total - - -
    V0002 Petrol - - -
    Diesel - - -
    total - - -
    See more | Go to post

      Leave a comment:

    • rajeswari02
      replied to get day records based on id
      in MySQL
      Based on item_name also actually
      i am having records with name"petrol" more than 1 per day , so i need to sum() based on item_name,machi ne_id
      See more | Go to post

        Leave a comment:

      • rajeswari02
        started a topic get day records based on id
        in MySQL

        get day records based on id

        hi,

        am using query as
        Code:
        Select machine_id as MachineID,item_name as Name,SUM(item_quantity) as Quantity,SUM(billed_amount) as BilledAmount,SUM(received_amount) as ReceivedAmount from transaction where DATE(paid_date)='" + rdate + "'Group by machine_id,item_name
        here rdate , am collecting from UI,

        Code:
        string rdate = dateTimePicker1.Value.ToString("yyyy-MM-dd");
        Code:
        MachineID
        ...
        See more | Go to post
        Last edited by Rabbit; Mar 14 '14, 03:36 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
        • rajeswari02
          started a topic find the index of row in datatable,mysql
          in MySQL

          find the index of row in datatable,mysql

          hi,

          i want to know the index of row( i know the primary key column value, based on that i want to know the index of that row in data table)

          here is my code i tried:
          but it's giving error as:table doesn't have a primary key. c#

          But my datatable in Mysql database is having primary key column.
          Code:
          using (MySqlConnection con = new MySqlConnection(ConnectionString))
                {
          ...
          See more | Go to post
          • rajeswari02
            started a topic Datetime problem in Mysql Database
            in MySQL

            Datetime problem in Mysql Database

            Hi,

            am developing application in .net,c#.

            am saving datetime value as: yyyy-MM-ss HH:mm:ss (24 hour format)
            after saving in database i observed in database , it's stored in specified format .

            and here the problem is:

            when i retrieve data , datetime is coming as 12 hour format.
            what to do........
            See more | Go to post
            • rajeswari02
              started a topic accessing selecteditem of comboBox of form into another form
              in C Sharp

              accessing selecteditem of comboBox of form into another form

              hi,

              How to get the selected item of combox in form to another form.(connect and Form1 )

              in connect form :

              Collapse | Copy Code
              Code:
              <pre lang="c#"><pre lang="sql">public string machineId
        {
            get
            {
                return comboBox1.SelectedItem.ToString();
            }
            set
              ...
              See more | Go to post
              Last edited by Rabbit; Feb 20 '14, 06:02 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
              • rajeswari02
                started a topic appending row in excel2007,c#
                in C Sharp

                appending row in excel2007,c#

                hi,
                i need to open already existing excel file(.xlsx format),and add a row by collecting data from textboxes . am using code following. but am getting error at opening file:
                Code:
                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.IO;
using
                ...
                See more | Go to post
                • rajeswari02
                  started a topic get data through serialport and place in excel sheet c#,windows application
                  in .NET

                  get data through serialport and place in excel sheet c#,windows application

                  hi

                  am developing application on c#,

                  in this am getting data from handheld system through serialport.

                  data is like this:
                  $machine id,responce code,no of rows,current row,customer name,name,total balance,paid,pa id date,remaining, checksum#

                  data like this getting from serialport ,and i need to split that and store in excel sheet,only machine id,customerid,n ame,total balance,paid,pa id...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...