Comments by Murugan.NM

Murugan.NM 15-Nov-14 0:43am View

Solved Myself

Murugan.NM 4-Jul-14 3:21am View

I need to use formula with this field. if i declare nullable CertificateNo, then how to make formulas.

Murugan.NM 4-Jul-14 1:00am View

Date

Murugan.NM 29-Jun-14 2:43am View

Hi Sir,

I tried but not it passed null value
What is wrong with i tried the following
DateTime defaultdate = DateTime.Parse("1753-01-01");

DateTime ContractDatetime = new DateTime();
if (invoice.ContractDatetime.Date == defaultdate.Date)
{
Console.WriteLine("null");
}
else
{
Console.WriteLine(invoice.ContractDatetime.ToString());
}

Murugan.NM 29-Jun-14 2:01am View

Hi Sir,
if (invoice.ContractDatetime = "01/01/1753")
{
invoice.ContractDatetime = "";
}
I tried the above. it throws the following errors
Error 1 Cannot implicitly convert type 'string' to 'System.DateTime'
Error 2 Cannot implicitly convert type 'System.DateTime' to 'bool'
Error 3 Cannot convert null to 'System.DateTime' because it is a value type

Murugan.NM 20-Mar-14 14:41pm View

Deleted

Can you share the solution with me by mail nallas.murugan at gmail.com

Murugan.NM 10-Mar-14 5:52am View

Hi Mr.Raja. I would like to do it through programmatically (by using join and group) in Store Procedure and by passing Parameters. Please help me in this as it is urgent to complete.

Murugan.NM 9-Mar-14 21:17pm View

i have tried the following for your reference,

tableONE(BILLNO,FINYEAR,CUSTNAME,ADDRESS,CITY)
TABLEtwo(BILLNO,FINYEAR,VEHICLEDETAILS)
TABLEthree(BILLNO,FINYEAR,PROD_SLNO,PRODUCTDETAILS)
TABLEfour(BILLNO,FINYEAR,PROD_SLNO,PRODUCTDETAILS,ACCESS_SLNO,PRODACCESS,ACCESS_QTY)
TABLEfive(BILLNO,FINYEAR,PROD_SLNO,PRODUCTDETAILS,ACCESS_SLNO,PRODACCESS,DELIVERYFEEDBACK)

MYSQL STORED PROCEDURE

<pre lang="sql">DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_BILLDetails`(IN billNo DECIMAL,IN finYr INT)
BEGIN
SELECT DISTINCT * FROM tableone
left join tabletwo ttwo on tableone.BillNO = ttwo.BillNO
left join tablethree tthree on tableone.BillNO= tthree.BillNO
left join tablefour tfour on tableone.BillNO= tfour.BillNO
left join tablefive tfive on tableone.BillNO= tfive.BillNO
where tableone.BillNO = billNumber and BillNO .FINYEAR = finYr;
END $$

DELIMITER ;

Here i need the output is table-wise against BILLNO = FINYEAR

Murugan.NM 29-Aug-13 13:20pm View

Still no comments and reply for my Q

Murugan.NM 22-Aug-13 17:01pm View

Deleted

Dear Thatraja,
Pls understand my requirement-

Table Name: BILLS / FIELDS: BILL_NO, AC_YEAR, BL_DT, SOME ADDL FIELDS; / BILL_NO = AC_YEAR <single data="" record="">

Table Name: BILL_DATA / FIELDS: BILL_NO, AC_YEAR, BL_DT, PROCESS_SLNO, PROCESS_STAGE, SOME ADDL FIELDS; <bill_no =="" ac_year="PROCESS_SLNO" <-=""> MULTIBLE DATA RECORD>

Table Name: BILL_EXP / FIELDS: BILL_NO, AC_YEAR, BL_DT, PROCESS_SLNO, PROCESS_EXP_SLNO, PROCESS_EXP_AMT, SOME ADDL FIELDS; <bill_no =="" ac_year="PROCESS_SLNO" process_exp_slno="" <-=""> MULTIBLE DATA RECORD>

Table Name: BILL_OUT / FIELDS: BILL_NO, AC_YEAR, BL_DT, PROCESS_SLNO, PROCESS_EXP_SLNO, BL_OUT_DT, PROCESS_STATUS, SOME ADDL FIELDS; <bill_no =="" ac_year="PROCESS_SLNO" process_exp_slno="" <-=""> MULTIBLE DATA RECORD>

Murugan.NM 27-Apr-13 11:19am View

Deleted

Thanks for your comments and it will save my time

Murugan.NM 11-Jan-13 16:29pm View

Deleted

Shall i use the MySqlDatareader (above mentioned)

Murugan.NM 11-Jan-13 16:19pm View

Ya Sure...

Murugan.NM 11-Jan-13 16:16pm View

one small request, first i used database MsSql now changed to MySql. Can you suggest which method is good...

Murugan.NM 11-Jan-13 16:15pm View

Deleted

one small request, first i used database MsSql now changed to MySql. Can you suggest which method is good...

Murugan.NM 11-Jan-13 15:46pm View

i am using MySqlDataReader

Murugan.NM 11-Jan-13 15:35pm View

can u share your method with me

Murugan.NM 11-Jan-13 15:06pm View

Deleted

public List<studentdetails> GetStudentCodeInGrid(string StudCode)
{
List<studdetails> studDetailsList = new List<studdetails>();
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();

MySqlCommand command = new MySqlCommand();
command.CommandText = "select COALESCE(SL_NO) SL_NO, COALESCE(STUD_CODE,'')STUD_CODE, COALESCE(STUD_NAME,'') STUD_NAME from STUD_CODE WHERE STUDENTREGISTER LIKE '" + studCode + "%' ORDER BY STUD_CODE";
command.Connection = connection;

MySqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
StudDetails studDetails = new StudDetails();

studDetails.SNO = Convert.ToInt32(reader["SL_NO"]);
studDetails.PortCode = reader["STUD_CODE"].ToString();
studDetails.PortName = reader["STUD_NAME"].ToString();

studDetailsList.Add(studDetails);
}

return studDetailsList;
}

Murugan.NM 11-Jan-13 14:42pm View

Again I gor the same error Message: FUNCTION <database>.COALESCE does not exist

Murugan.NM 5-Jul-12 6:31am View

Deleted

Lot of Thanks for your advice.

Comments by Murugan.NM (Top 20 by date)