Comments by Member 10370658 (Top 22 by date)

Ya ...Sure...
Acceppted
:)

i got it i used second method .now its working fine.
:)

Okay .I understood.
hello can u say how to write the code for eg:
pd.DOB = Convert.ToDateTime(dtpdob.Text);

pd.DOB = Convert.ToDateTime(dtpdob.Tostring());

here which code is correct

Can u please explain ?i didnt get u

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BAL
{
public class PersonelData
{
public int SID { get; set; }
public string FName { get;set;}
public string MName{get;set;}
public string LName{get;set;}
public DateTime DOB{get;set;}
public string Sex{get;set;}
public int Age{get;set;}
public string Address { get; set; }



public string SPCNum1 { get; set; }
public string SPCNum2 { get; set; }
public string SPAddress { get; set; }
public string SPName { get; set; }


public string FathName { get; set; }
public string MothName { get; set; }
public string Fam1 { get; set; }
public string Fam2 { get; set; }
public string Fam3 { get; set; }
public string Fam4 { get; set; }
public string Fam5 { get; set; }
public string Fam6 { get; set; }
public string Fam7 { get; set; }
public string Fam8 { get; set; }

public string FamCond { get; set; }
public string FamNotes { get; set; }
public string Status { get; set; }

public DateTime EntryDate { get; set; }
public DateTime DOA { get; set; }

public string FathOccu { get; set; }
public string MothOccu { get; set; }





}
}

:) My question says varchar means,i posted my entire code can u able to findout where i defined varchar instead of Datetime?.Its a conversion problem.

Here is my Stored procedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <nidheesh>
-- Create date: <05-11-2013>
-- Description: <insert personel="" data="">
-- =============================================
ALTER PROCEDURE [dbo].[UPDATE_BULK_INFO]

@sid int,
@FName varchar(50),
@MName varchar(50),
@LName varchar (50),
@DOB datetime,
@sex varchar(50),
@age int,
@address varchar(50),
@SponserName varchar(50),

@FathName varchar(50),
@FathOccu varchar(50),
@MothName varchar(50),
@MothOccu varchar(50),
@Fam1 varchar(150),
@Fam2 varchar(150),
@Fam3 varchar(150),
@Fam4 varchar(150),
@Fam5 varchar(150),
@Fam6 varchar(150),
@Fam7 varchar(150),
@Fam8 varchar(150),

@FamCond varchar(150),
@FamNotes varchar(150),
@Status varchar(150),
@DOA datetime


AS
BEGIN
UPDATE tbl_Personel set FName=@FName,
MName=@MName,
LName=@LName,
DOB=@DOB,
Sex=@sex,
Age=@age,
Address=@address,
SponserName=@SponserName,
DOA=@DOA where SID=@sid

UPDATE tbl_Family set FathName=@FathName,
MothName=@MothName,
FathOccu=@FathOccu,
MothOccu=@MothOccu,
Fam1=@Fam1,
Fam2=@Fam2,
Fam3=@Fam3,
Fam4=@Fam4,
Fam5=@Fam5,
Fam6=@Fam6,
Fam7=@Fam7,
Fam8=@Fam8 where SID=@SID

UPDATE tbl_others set FamCond=@FamCond,
FamNotes=@FamNotes,
Status=@Status where SID=@SID
END

And also when am executing the storedprocedure it doesnt shows any error..it simply inserts the date.

i didnt use varchar anywhere...in my table it is datetime not varchar

Here in my table ,i have declared the field as datetime.

i will show my table details ;there three tables they are

USE [IMS]
GO
/****** Object: Table [dbo].[tbl_Family] Script Date: 11/15/2013 13:19:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_Family](
[FID] [int] IDENTITY(1,1) NOT NULL,
[FathName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MothName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam1] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam2] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam3] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam4] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam5] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam6] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam7] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fam8] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SID] [int] NOT NULL,
[FathOccu] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MothOccu] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_tbl_Family] PRIMARY KEY CLUSTERED
(
[FID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[tbl_Family] WITH CHECK ADD CONSTRAINT [FK_tbl_Family_tbl_Personel] FOREIGN KEY([SID])
REFERENCES [dbo].[tbl_Personel] ([SID])
GO
ALTER TABLE [dbo].[tbl_Family] CHECK CONSTRAINT [FK_tbl_Family_tbl_Personel]


USE [IMS]
GO
/****** Object: Table [dbo].[tbl_Personel] Script Date: 11/15/2013 13:19:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_Personel](
[PID] [int] IDENTITY(1,1) NOT NULL,
[SID] [int] NOT NULL,
[FName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DOB] [datetime] NULL,
[Sex] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Age] [int] NULL,
[Address] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SponserName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EntryDate] [datetime] NULL,
[DOA] [datetime] NULL,
CONSTRAINT [PK_tbl_Personel] PRIMARY KEY CLUSTERED
(
[SID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


USE [IMS]
GO
/****** Object: Table [dbo].[tbl_others] Script Date: 11/15/2013 13:19:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_others](
[SID] [int] NOT NULL,
[OID] [int] IDENTITY(1,1) NOT NULL,
[FamCond] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FamNotes] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_tbl_others] PRIMARY KEY CLUSTERED
(
[OID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[tbl_others] WITH CHECK ADD CONSTRAINT [FK_tbl_others_tbl_Personel] FOREIGN KEY([SID])
REFERENCES [dbo].[tbl_Personel] ([SID])
GO
ALTER TABLE [dbo].[tbl_others] CHECK CONSTRAINT [FK_tbl_others_tbl_Personel]

hello i have changed my code
string SID = txtsid.Text;
this.Image_sqlcmd.Parameters.Add("@SID",SID);
this.Image_sqlcmd.Parameters.Add("@Picture", System.Data.SqlDbType.Image);

now its working fine....Noconversion problem..:)

Hello i have tried comboBox.ResetText().It works fine.

yes.Application is working fine ,but only one set of data will display at a time

ohhh Thank You :)

Hello
When we click a menu Say "Dashboard" it will show the dashboard page.For that we can use href="dashboard.aspx" .like this how we use it in mvc?How the controller will handle the request

Wow!!!!! Its works Now!!!