Comments by Avinash_Pathak

Avinash_Pathak 28-Mar-13 7:42am View

its still giving null value...

Avinash_Pathak 11-Jan-13 23:37pm View

it was by mistake...here is the correct table....

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.61-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

--
-- Create schema hms
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ hms;
USE hms;

--
-- Table structure for table `hms`.`patient_progress_tracking_details`
--

DROP TABLE IF EXISTS `patient_progress_tracking_details`;
CREATE TABLE `patient_progress_tracking_details` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`ParameterId` int(11) DEFAULT NULL,
`DiseaseId` int(11) DEFAULT NULL,
`Patient_Id` int(11) DEFAULT NULL,
`Branch_Id` int(11) DEFAULT NULL,
`Tenant_Id` int(11) DEFAULT NULL,
`Last_Date` datetime DEFAULT NULL,
`Result` varchar(20) DEFAULT NULL,
`Next_Due_Date` datetime DEFAULT NULL,
`Remarks` varchar(20) DEFAULT NULL,
`Parameter_Code` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hms`.`patient_progress_tracking_details`
--

/*!40000 ALTER TABLE `patient_progress_tracking_details` DISABLE KEYS */;
INSERT INTO `patient_progress_tracking_details` (`Id`,`ParameterId`,`DiseaseId`,`Patient_Id`,`Branch_Id`,`Tenant_Id`,`Last_Date`,`Result`,`Next_Due_Date`,`Remarks`,`Parameter_Code`) VALUES
(1,3,1,132,1,1,'2012-11-17 00:00:00','65','2012-03-04 00:00:00','good',4),
(2,3,1,132,1,1,'2012-11-16 17:40:58','68','2012-11-28 17:41:16',NULL,5),
(3,3,1,132,1,1,'2013-11-15 17:41:32','70','2012-11-29 17:41:54',NULL,6),
(4,4,1,132,1,1,'2012-11-17 10:30:02','120',NULL,NULL,6),
(5,4,1,132,1,1,'2012-11-16 10:30:57','122',NULL,NULL,6),
(6,4,1,132,1,1,'2013-11-15 10:31:22','118',NULL,NULL,NULL);
/*!40000 ALTER TABLE `patient_progress_tracking_details` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Avinash_Pathak 11-Jan-13 5:19am View

Deleted

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.61-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

--
-- Create schema hms
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ hms;
USE hms;

--
-- Table structure for table `hms`.`progress_tacking_other_details`
--

DROP TABLE IF EXISTS `progress_tacking_other_details`;
CREATE TABLE `progress_tacking_other_details` (
`Id` int(11) NOT NULL,
`Left` varchar(50) DEFAULT NULL,
`Right` varchar(50) DEFAULT NULL,
`Remarks` varchar(200) DEFAULT NULL,
`SubType` varchar(50) DEFAULT NULL,
`Disease_Id` int(11) DEFAULT NULL,
`Parameter_Id` int(11) DEFAULT NULL,
`Branch_Id` int(11) DEFAULT NULL,
`Tenant_Id` int(11) DEFAULT NULL,
`f1` int(11) DEFAULT NULL,
`f2` int(11) DEFAULT NULL,
`f3` int(11) DEFAULT NULL,
`f4` int(11) DEFAULT NULL,
`f5` int(11) DEFAULT NULL,
KEY `Id` (`Id`),
CONSTRAINT `progress_tacking_other_details_ibfk_1` FOREIGN KEY (`Id`) REFERENCES `progress_tracking_other_header` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hms`.`progress_tacking_other_details`
--

/*!40000 ALTER TABLE `progress_tacking_other_details` DISABLE KEYS */;
INSERT INTO `progress_tacking_other_details` (`Id`,`Left`,`Right`,`Remarks`,`SubType`,`Disease_Id`,`Parameter_Id`,`Branch_Id`,`Tenant_Id`,`f1`,`f2`,`f3`,`f4`,`f5`) VALUES
(15,NULL,NULL,NULL,'FEET',1,3,1,1,NULL,NULL,NULL,NULL,NULL),
(15,NULL,NULL,NULL,'FEET',1,7,1,1,NULL,NULL,NULL,NULL,NULL),
(15,NULL,NULL,NULL,'FEET',1,8,1,1,NULL,NULL,NULL,NULL,NULL),
(15,NULL,NULL,NULL,'FEET',1,9,1,1,NULL,NULL,NULL,NULL,NULL),
(15,NULL,NULL,NULL,'FEET',1,10,1,1,NULL,NULL,NULL,NULL,NULL),
(15,NULL,NULL,NULL,'FEET',1,12,1,1,NULL,NULL,NULL,NULL,NULL),
(15,NULL,NULL,NULL,'FEET',1,13,1,1,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `progress_tacking_other_details` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Avinash_Pathak 11-Jan-13 4:29am View

I want output like
Last_Date BPLow BPHigh
11/16/2012 65 120

instead of in two columns want in a single column

Avinash_Pathak 11-Jan-13 4:28am View

it is giving me only the first column result not the 2nd...I have already tried this...

Avinash_Pathak 10-Jan-13 7:28am View

can u explain little more please...

Avinash_Pathak 29-Dec-12 5:36am View

add textbox in templatefield...in that itemtemplate and take textbox

Avinash_Pathak 22-Dec-12 6:10am View

have you remove (!IsPostBack)??

Avinash_Pathak 22-Dec-12 6:07am View

I think you should remove if (!IsPostBack)...because whatever you put inside this...will execute on first time only when page is loaded...and set autopostback true to checkbox

Avinash_Pathak 22-Dec-12 2:11am View

question is not clear...

Avinash_Pathak 22-Dec-12 1:59am View

try to add the refference of this dll to your project...

Avinash_Pathak 20-Dec-12 23:30pm View

this is correct but if i dont want to use union...because it is performance effective...is that ant alternative...??

Avinash_Pathak 20-Dec-12 23:29pm View

your idea is working but if i dont want to use union because its performance effective...is that any alternative??

Avinash_Pathak 18-Dec-12 6:36am View

do something like this...make 2 css class...I did same as you want by using the above code...

Avinash_Pathak 18-Dec-12 6:27am View

take two div in your td and pass different color to them...

Avinash_Pathak 18-Dec-12 6:26am View

what you want exactly???

Avinash_Pathak 18-Dec-12 6:24am View

hi...u can use javascript to check whether anything is changed in your current tab or not. If yes so before leaving active tab call that java script alert indicating that"There is unsaved data on this tab, you want to still move?"
By doing this your problem must be solved...I did the same thing while moving one page to another...

Avinash_Pathak 18-Dec-12 6:14am View

that online sql server must have servername (ip address) and the database you want to connect must have username and password so take it from there and put it your web.config file in your connectionstring...and you done it...

Avinash_Pathak 18-Dec-12 5:39am View

you have to create 2 css class for that..on 1st button click just pass 1st class from code behind that will be your default class and in last line of that click event pass it 2nd css class that will be use for highlight your button. thats it...do it on every button

Avinash_Pathak 18-Dec-12 5:31am View

protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Gen_Lic_Grid.PageIndex = e.NewPageIndex;
Gen_Lic_Grid.DataSource = //<-- what should be written here?
Gen_Lic_Grid.DataBind();
}
before this code you must bind your gridview. and it must be in separate function and call that function in this code block.,

Avinash_Pathak 14-Dec-12 5:20am View

ok...but how to encode it??? can you guide me....

Avinash_Pathak 14-Dec-12 1:51am View

I have not found the proper solution yet....

Avinash_Pathak 13-Dec-12 23:48pm View

hello Muthukumar...this is working but in my application there is not any button or hidden field in aspx page....I want this value in string which is on .cs file....I am searching this since last 3 days but still not found proper solution...is it possible... ??? if yes then please help me... thanks in advance...

Avinash_Pathak 12-Dec-12 12:23pm View

i want to use this data variable value in code behind,,,

Avinash_Pathak 12-Dec-12 3:01am View

<form name="form" action="Default.aspx" method="post">
<td> Amount: </td>
<td><input type="text" name="mmount" /></td>
</tr>
<tr>
<td class="style34"> Name</td>
<td class="style1"><input type="text" id="name" name="txtname" size="45" /> </td>
</tr>
<tr>
<td> EmailID</td>
<td><input type="text" name="txtEmailID" size="35" /> </td>
</tr>
<tr>
<td><br/>
<input type="submit" value="SUBMIT" />
<br /> </td>
</tr>

this is my code...now I dont want any of textfield value can tamper on submit click..

Avinash_Pathak 12-Dec-12 2:04am View

ok sir...but how to validate them...?

Avinash_Pathak 20-Oct-12 5:25am View

i go through this but how to call this service on user define date and time? want to send sms/email on specific date and time...

Avinash_Pathak 20-Oct-12 2:59am View

i have never used windows service...can u show me how to use it?

Avinash_Pathak 24-Sep-12 7:08am View

yes there will be a gridview in a.aspx and want to bind it from b.aspx

Comments by Avinash_Pathak (Top 29 by date)