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
mohammed shamsheer
NA
394
143.8k
Duplicate datagridview columns creating
Dec 23 2014 6:32 AM
DATABOUND COLUMN CREATED AUTOMATICALLY CREATING FOR DATAGRIDVIEW
I HAVE A GRID VIEW AND SOME COLUMNS EG : ROOMNO,rOOMCAPACITY,rOOrent etc
i am inserting the textbox and combobox items to datagridview
it inserted nicely to day suddenly some databound columns is created automatically so duplicate columns in datagridveiw occured.
this is my code :
string roomID = Convert.ToString(cmbroomno.SelectedValue);
object[,] ParamArray = new object[,] { { "@RoomID", roomID } };
DataSet ds = new DataSet();
ds = DB.ExecuteQuery_SP("SelectRoomDetailsForGridByID", ParamArray);
if (ds.Tables.Count > 0)
{
int row = 0;
dgvcheckin.Rows.Add();
row = dgvcheckin.Rows.Count - 1;
dgvcheckin["RoomNo", row].Value = ds.Tables[0].Rows[0]["RoomNo"].ToString();
dgvcheckin["RoomCategoryName", row].Value = ds.Tables[0].Rows[0]["RoomCategoryName"].ToString();
dgvcheckin["RoomCapacity", row].Value = ds.Tables[0].Rows[0]["RoomCapacity"].ToString();
dgvcheckin["NoofPerson", row].Value = txtTotalHours.Text;
dgvcheckin["Hours", row].Value = txtTotalHours.Text;
dgvcheckin["InTime", row].Value = dtpchkintime.Text;
dgvcheckin["CheckInDate", row].Value = dtpcheckin.Text;
dgvcheckin["Rents", row].Value = ds.Tables[0].Rows[0]["PerdayRent"].ToString();
dgvcheckin["TaxAmount", row].Value = ds.Tables[0].Rows[0]["TaxAmount"].ToString();
dgvcheckin["CheckOutday", row].Value = dtpcheckOutdate.Text;
dgvcheckin["CheckOutTime", row].Value = dtpouttime.Text;
dgvcheckin["Roomid", row].Value = cmbroomno.SelectedValue;
if (Convert.ToInt32(txtTotalHours.Text) > 1)
{
double NetTotal = ((Convert.ToDouble(ds.Tables[0].Rows[0]["PerdayRent"]) + Convert.ToDouble(ds.Tables[0].Rows[0]["TaxAmount"])) + ((PolosysHMS.General.Classes.Settings.InventorySettings.ExtraHoursCost) * (Convert.ToDouble(txtTotalHours.Text) - 1)));
dgvcheckin.Rows[row].Cells["NetTotal"].Value = NetTotal.ToString();
}
any body have any idea about it
Reply
Answers (
2
)
delete last row have exception
tabcycling is not working after datagridinsertin