TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
MANEESH AN
NA
110
46.9k
HOW TO GET DATE
Jul 20 2013 6:28 AM
Declaration
DateTime DTFROM;
DateTime DTTO;
string vSeries;
button view
frmView view = new frmView();
view.vSeries = txtSeries.Text;
view.Show();
view.Location = new Point(0, 50);
DataTable dt = new DataTable();
dt = objPaymentBL.fnGetPayReg(DTFROM, DTTO);
view.DTFROM.Text = DtpDateFrom.Value.Date.ToString() + "TO" + DtpDateTo.Value.Date.ToString();
BL
DateTime dRPDate;
DateTime FROM;
DateTime TO;
public DateTime DTFROM
{
get { return FROM; }
set { FROM = value; }
}
public DateTime DTTO
{
get { return TO; }
set { TO = value; }
}
public DataTable fnGetPayReg(string vSeries,DateTime FROM, DateTime TO)
{
DataTable dt = new DataTable();
dt = objPaymentMasterDL.fnGetPayReg(vSeries,DTFROM, DTTO);
return dt;
}
DL
public DataTable fnGetPayReg(string vSeries,DateTime FROM, DateTime TO)
{
DataTable dt = new DataTable();
dt = objPaymentMasterDL.fnGetPayReg(vSeries,DTFROM, DTTO);
return dt;
}
GRID
DECLARATION
DateTime DATEFROM;
DateTime DTTO;
public DateTime FROM
{
get { return DATEFROM; }
set { DATEFROM = value; }
}
public DateTime TO
{
get { return DTTO; }
set { DTTO = value; }
}
GRID LOAD
DateTime @dRPDate;
DataTable DT = new DataTable();
DT = objViewBL.fnGetPayReg(FROM, TO);
ONLY ON FIELD 'drpdate' is inserted in one table,series is inserted in another table,when form come up,we will select series,date from.datet to and click view button,that time grid will come up within the region of date and time...how can i go?Error found:SQL DATETIME OVERFLOW.....I DONT KNOW THE FORMAT OF DATE HOW TO GIVE?I HAD SENT ALREADY OUTPUT OF SP(THERE YOU CAN SEE DATE VALUE OF DATETIME)...
Reply
Answers (
1
)
how sticky note creating or example
how to extract json data in c#.net windows form application?