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
naga jyothi
NA
62
111k
Not updating the data so please rectify this error
Aug 9 2012 1:14 AM
Not updating the data so please rectify this error.I am using 3 tier archeiture the error occurs in dates format so please rectify how to passing parameters in C# using MS_Access Database.In MS_Access Database
//Code for Presentation Layer
BOL.bolIncomeType obj = new PayRoll.BOL.bolIncomeType();
obj.IncomeTypes = txtIncomeType.Text;
obj.Amount = Convert.ToDecimal(txtAmount.Text);
obj.INotes = txtrnote.Text;
obj.IncomeDate = Convert.ToDateTime(dtp1.Value.ToShortDateString());
obj.IncomeId = Convert.ToInt16(txtincomeid.Text);
obj.update();
txtincomeid.Text = dbConnection.GetNextNumber("IncomeType", "IncomeId").ToString();
MessageBox.Show("Record Updated sucessfully", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information );
// Code for Business layer
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace PayRoll.BOL
{
class bolIncomeType
{
DAL.dalIncomeType dalObj= new PayRoll.DAL.dalIncomeType();
private Int32 m_Srlno;
private Int32 m_Id;
private string m_Incometype;
private Decimal m_Amount;
private DateTime m_IncomeDate;
private string m_note;
/// <constructor>
/// Constructor bolIncomeType
/// </constructor>
public bolIncomeType()
{
//Initialize the variable here
}
/// <summary>
/// ColumnName:Srlno
/// Data Type:int
/// Length:0
/// </summary>
public Int32 SrlNo
{
get
{
return m_Srlno;
}
set
{
m_Srlno = value;
}
}
public Int32 IncomeId
{
get
{
return m_Id;
}
set
{
m_Id = value;
}
}
/// <summary>
/// ColumnName:Incometype
/// Data Type:VarChar
/// Length:50
/// </summary>
public string IncomeTypes
{
get
{
return m_Incometype;
}
set
{
if (value == "")
{
throw new InvalidData("Please enter IncomeType", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
if (value.Length > 50)
{
throw new InvalidData("The Incometype is more length", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
m_Incometype = value;
}
}
/// <summary>
/// ColumnName:Amount
/// Data Type:decimal
/// Length:0
/// </summary>
public Decimal Amount
{
get
{
return m_Amount;
}
set
{
if (value == 0)
{
throw new InvalidData("Please enter the amount", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
m_Amount = value;
}
}
public DateTime IncomeDate
{
get
{
return m_IncomeDate;
}
set
{
m_IncomeDate = value;
}
}
public string INotes
{
get
{
return m_note;
}
set
{
if (value == "")
{
throw new InvalidData("Please enter Note", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
if (value.Length > 50)
{
throw new InvalidData("The Incometype is more length", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
m_note= value;
}
}
public bool Insert ()
{
dalObj.Insert(this);
return true;
}
public bool update()
{
dalObj.Update(this);
return true;
}
}
}
// Code for Data Access layer
dbConnection conn =new dbConnection();
string sql = "update IncomeType set IncomeTypes=@IncomeType,Amount=@Amount,IncomeDate=@IncomeDate,INotes=@Note where IncomeId=@IncomeId";
OleDbParameter[] oleDbParameters = new OleDbParameter[5];
oleDbParameters[0] = new OleDbParameter("@IncomeId", OleDbType.Decimal);
oleDbParameters[0].Value = obj.IncomeId;
oleDbParameters[1] = new OleDbParameter("@IncomeType", OleDbType.VarChar);
oleDbParameters[1].Value = obj.IncomeTypes;
oleDbParameters[2] = new OleDbParameter("@Amount", OleDbType.Decimal);
oleDbParameters[2].Value = obj.Amount;
oleDbParameters[3] = new OleDbParameter("#@IncomeDate#", OleDbType.Date);
oleDbParameters[3].Value = obj.IncomeDate;
oleDbParameters[4] = new OleDbParameter("@Note", OleDbType.VarChar);
oleDbParameters[4].Value = obj.INotes;
return conn.executeUpdateQuery(sql, oleDbParameters);
// Code for dbconnection
OleDbCommand myCommand = new OleDbCommand();
try
{
//OleDbCommand myCommand = new OleDbCommand(_query,conn);
//myCommand.Parameters.AddRange(sqlParameter);
//conn.Open();
//myCommand.ExecuteNonQuery();
myCommand.Connection = openConnection();
myCommand.CommandText = _query;
myCommand.Parameters.AddRange(sqlParameters);
//myAdapter.UpdateCommand = myCommand;
myCommand.ExecuteNonQuery();
}
catch (OleDbException e)
{
Console.Write("Error - Connection.executeUpdateQuery - Query: " + _query + " \nException: " + e.StackTrace.ToString());
MessageBox.Show("Error while updating... " + e.Message);
return false;
}
finally
{
}
return true;
Reply
Answers (
0
)
Problem with search
Data was not updating the first time second time it is updating please rectify that problem