Comments by Member 12363094 (Top 29 by date)

yeah really when i have run above query in ssms it is coming well
but when i am running application there i am calling this sp at that time i am getting other date date if data is not on that date.

when i use CONVERT(varchar,convert(date, [Date], 103),101) then it is taking next date data if on that date data is not there

thanks but when i applied order by at end of query like urs i was getting error

yes

no [Date] one that is type of varchar

date=convert(varchar,convert(date,[Date],103),101)
and time is seperate column in rawtable

i want to use order by in above query if i use this order by i am getting error.
where i have to use orderby column

convert(varchar,convert(date, [Date], 103),101) this date and time is different column in table

then i have to convert varchar to float?

ooh that is varchar type

Hi thanks it is working fine

getting exception like "object has not sent for instance"

sorry i have removed that line
this is orginalcode with classes.
This is Main Class

namespace ConsoleApplication1
{
public class Main
{

public static int BURD_RATE;
public static int DATABITS;
public static int STOPBITS;
public static String comPort = "";

public Main()
{
BURD_RATE = 9600;
DATABITS = 8;
STOPBITS = 1;
comPort = "COM3";
}

public void initializeModem()
{
Boolean modemStatus = false;
try
{
Port.open(BURD_RATE, DATABITS, STOPBITS, comPort);
do
{
if(modemStatus)
{
break;
}
modemStatus = SmsUtil.initializeModem();
if(!modemStatus)
{
Console.WriteLine("AT Command is not responding. So going to reconnect the port once again.\n");
if (Port.Serial1 != null)
{
Port.close();
}
Port.open(19200, 8, 1, "COM1");
}
} while(true);
Port.isReading = true;

// ReadSMS readSMS = new ReadSMS();
// readSMS.readSMS();
}
catch(Exception e)
{
try
{
if (Port.Serial1 != null)
{
Port.close();
}
}
catch(Exception ex)
{
Console.WriteLine("Exception:"+ex);
}
}
}

public static void main(String[] args)
{
Main main = new Main();
main.initializeModem();
}
}
2.This is Port Class

class Port
{

public static Boolean isReading = false;
public static Boolean isSending = false;
public static SerialPort Serial1;
public static string s;
public Port()
{

}



public static void open(int boardRates, int dataBits, int stopBits, String comPort)
{
try
{

Console.WriteLine("Trying to open port...");

SerialPort Serial1 = new System.IO.Ports.SerialPort(comPort, boardRates, Parity.None, dataBits);
Serial1 = new System.IO.Ports.SerialPort(comPort);
Serial1.Open();
Serial1.Encoding = Encoding.GetEncoding("iso-8859-1");


Console.WriteLine("Port is opened successfully..... \n");
// Thread.Sleep(10000);
}
catch (Exception e)
{
Console.WriteLine((new StringBuilder()).Append("could not open port:").Append(e).Append(" ").Append(comPort).ToString());
//System.Exit(0);
}
}

public static String sendAT(String atcommand)
{

try
{
Thread.Sleep(500);
writeln(atcommand);
Thread.Sleep(500);
s = read();
Thread.Sleep(500);
}
catch(Exception e)
{
}
return s;
}

public static void write(string s)

{
Serial1.Write(s);
// Serial1.Flush();
}

public static void write(char[] s)
{
Serial1.Write(s,0,13);
// Sout.Flush();
}

public static void writeln(string s)
{
Console.WriteLine(s);
Serial1.WriteLine(s);
// Serial1.Write(13);
// Sout.Flush();

}

public static string read()
{
// Requires that the data is en

that Port is a class not serialport
in that writeln is method.
i have only one port that is serial1

but in my solution i am getting "object reference has not set " runtime exception
when i was writing serialport.write(s);
public static Boolean atCommandCheck()
{
String s1 = " ";
try
{
Port.writeln("AT");
//Thread.Sleep(1000);
s1 = Port.read();
}
catch(Exception e)
{
Console.WriteLine((new StringBuilder()).Append("Exception in atCommandCheck(AT Command Checking)..........").Append(e.Message).ToString());
s1="OK";
}
Console.WriteLine((new StringBuilder()).Append("AT..................").Append(s1).ToString());
return s1.IndexOf("OK") >= 0;
}
above one is in sms class i am calling writeln method from another class
public static void writeln(String s)
{
Serial1.Write(s);

}
in this case i was not able to write command to serial port

then how to convert
out = new OutputStreamWriter(port.getOutputStream(), "ISO-8859-1");to dotnet

above code i have mention streamreader sout=null& streamwriter sin=null;
wen i was sending AT commands(modem) to port then i have to use like
sout.write(AT).
in this case i am getting null reference exception

Console.WriteLine("Trying to open port...");
Console.WriteLine(comPort);
port = new System.IO.Ports.SerialPort(comPort);
port.Open();
SerialPort Serial1 = new System.IO.Ports.SerialPort(comPort, boardRates, Parity.None, dataBits);
port.Encoding = Encoding.GetEncoding("iso-8859-1");
Console.WriteLine("Port is opened successfully..... \n");
Thread.Sleep(10000);

hi sorry in code u have given false instead of true.
now working fine .Thank u so much

i have tried with ur solution but still that button is enable once we clicked otherthan that every thing is working fine.

Hi i have tried with ur solution but i was not able to disable a button.still that is enable

i want to invoke some link(href functionality) when i clicked on button.
what u understood is correct.

after clicking on button i can able to open link on other window also.
i am having problem with when we clicked on button that should be disable

that is not adding same line in that input tag
Onclick="window.open('http://www.google.co.in/')"