How to edit Datagrid

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
i will when I pres F2 focused cells Sasia and to set some valuebut I cant
Can you hellp me?
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; using System;
<span style="color:Blue; using System.Collections.Generic;
<span style="color:Blue; using System.ComponentModel;
<span style="color:Blue; using System.Data;
<span style="color:Blue; using System.Drawing;
<span style="color:Blue; using System.Linq;
<span style="color:Blue; using System.Text;
<span style="color:Blue; using System.Windows.Forms;
<span style="color:Blue; using System.Data.SqlClient;

<span style="color:Blue; namespace Restoranti
{
<span style="color:Blue; public <span style="color:Blue; partial <span style="color:Blue; class frmFatura : Form
{
<span style="color:Blue; private <span style="color:Blue; string connstr = Constants.GetConnectionString();
<span style="color:Blue; protected <span style="color:Blue; int mFaturaID = 0;

<span style="color:Blue; protected SqlDataAdapter mdaArtikujt = <span style="color:Blue; null;
<span style="color:Blue; protected SqlDataAdapter mdaFatura = <span style="color:Blue; null;
<span style="color:Blue; protected SqlDataAdapter mdaDetaletFatura = <span style="color:Blue; null;
<span style="color:Blue; protected DataTable dtArtikujt = <span style="color:Blue; null;
<span style="color:Blue; protected DataView dvartikujt = <span style="color:Blue; null;

<span style="color:Blue; protected DataTable dtFatura = <span style="color:Blue; null;
<span style="color:Blue; protected DataTable dtDetaletFatura = <span style="color:Blue; null;

<span style="color:Gray; ///



<span style="color:Green; //class properties
<span style="color:Blue; public <span style="color:Blue; int IDFatura
{
<span style="color:Blue; get { <span style="color:Blue; return mFaturaID; }
<span style="color:Blue; set { mFaturaID = value; }
}

<span style="color:Gray; /// <span style="color:Gray; <summary>
<span style="color:Gray; ///<span style="color:Green; Metoda per leximini e artikujve nga databaza ne gridview
<span style="color:Gray; /// <span style="color:Gray; </summary>
<span style="color:Blue; protected <span style="color:Blue; void LexoArtikujt()
{
<span style="color:Green; //Mbushja e datagridit me sqldataadapter

<span style="color:Blue; using (<span style="color:Blue; var db = <span style="color:Blue; new RestDBDataContext())
{
<span style="color:Green; //dgArtikujt.DataSource = dvartikujt;
dgArtikujt.DataSource = db.Artikujts.ToList();
}
}

<span style="color:Gray; /// <span style="color:Gray; <summary>
<span style="color:Gray; ///<span style="color:Green; Metoda per leximini e detaleve te fatures nga databaza ne gridview
<span style="color:Gray; /// <span style="color:Gray; </summary>
<span style="color:Blue; protected <span style="color:Blue; void LexoFaturen()
{


}

<span style="color:Gray; /// <span style="color:Gray; <summary>
<span style="color:Gray; ///<span style="color:Green; Metoda per leximini e detaleve te fatures nga databaza ne gridview
<span style="color:Gray; /// <span style="color:Gray; </summary>
<span style="color:Blue; protected <span style="color:Blue; void LexoDetaletFatura()
{

<span style="color:Blue; string strselect = <span style="color:#A31515; "SELECT FD.ID, FaturaID,A.ID as ArtikulliID ,A.Emri,A.Njesia, Sasia,FD.Cmimi, Sasia * FD.Cmimi as Totali" +
<span style="color:#A31515; " FROM FaturatDetalet FD INNER JOIN Artikujt A ON A.ID = FD.ArtikulliID WHERE FaturaID = @FaturaID";

<span style="color:Green; //Mbushja e datagridit me sqldataadapter
SqlConnection cnn = <span style="color:Blue; new SqlConnection(connstr);
mdaDetaletFatura = <span style="color:Blue; new SqlDataAdapter(strselect, connstr);

mdaDetaletFatura.SelectCommand.Parameters.Add(<span style="color:#A31515; "@FaturaID", SqlDbType.Int, 4, <span style="color:#A31515; "FaturaID").Value = mFaturaID;


dtDetaletFatura = <span style="color:Blue; new DataTable();
mdaDetaletFatura.Fill(dtDetaletFatura);
<span style="color:Blue; foreach (DataRow row <span style="color:Blue; in dtDetaletFatura.Rows)
{
DataGridViewRow gridrow = <span style="color:Blue; new DataGridViewRow();
gridrow.CreateCells(dgDetaletFat);

gridrow.Cells[0].Value = 0;
gridrow.Cells[1].Value = row[<span style="color:#A31515; "FaturaID"];
gridrow.Cells[2].Value = row[<span style="color:#A31515; "ArtikulliID"];
gridrow.Cells[3].Value = row[<span style="color:#A31515; "Emri"];
gridrow.Cells[4].Value = row[<span style="color:#A31515; "Sasia"];
gridrow.Cells[5].Value = row[<span style="color:#A31515; "Cmimi"];
gridrow.Cells[6].Value = row[<span style="color:#A31515; "Totali"];

dtDetaletFatura.Rows.Add(gridrow);
}
dgDetaletFat.DataSource = dtDetaletFatura;

}

<span style="color:Blue; public frmFatura()
{
InitializeComponent();
dgDetaletFat.EditMode = DataGridViewEditMode.EditProgrammatically;
}

<span style="color:Blue; private <span style="color:Blue; void Fatura_Load(<span style="color:Blue; object sender, EventArgs e)
{
txtSearch.Focus();
<span style="color:Blue; this.WindowState = FormWindowState.Maximized;


<span style="color:Green; //dgDetaletFat.AutoGenerateColumns = true;

LexoArtikujt();
LexoFaturen();
LexoDetaletFatura();



<span style="color:Blue; foreach (DataGridViewColumn c <span style="color:Blue; in dgDetaletFat.Columns)
{
c.DefaultCellStyle.Font = <span style="color:Blue; new Font(<span style="color:#A31515; "Arial", 18.5F, GraphicsUnit.Pixel);
}



}
<span style="color:Blue; private <span style="color:Blue; void ShtoArtikullin()
{
<span style="color:Green; //FaturatDetalet fd = new FaturatDetalet();
DataRow newrow = dtDetaletFatura.NewRow();
<span style="color:Green; //fd.FaturaID = -1;

newrow[<span style="color:#A31515; "FaturaID"] = -1;
newrow[<span style="color:#A31515; "ArtikulliID"] = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "ID"].Value;
newrow[<span style="color:#A31515; "Emri"] = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "Emri"].Value;
newrow[<span style="color:#A31515; "Njesia"] = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "Njesia"].Value;
newrow[<span style="color:#A31515; "Sasia"] = 1;
newrow[<span style="color:#A31515; "Cmimi"] = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "Cmimi"].Value;
newrow[<span style="color:#A31515; "Totali"] = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "Cmimi"].Value;

dtDetaletFatura.Rows.Add(newrow);
<span style="color:Gray; ///<span style="color:Green; /selektimi e percjell artikullin e fundit
dgDetaletFat.Rows[dgDetaletFat.Rows.Count - 1].Selected = <span style="color:Blue; true;
<span style="color:Green; //dgDetaletFat.ClearSelection();
}

<span style="color:Blue; private <span style="color:Blue; void dgArtikujt_DoubleClick(<span style="color:Blue; object sender, EventArgs e)
{
ShtoArtikullin();

}

<span style="color:Blue; private <span style="color:Blue; void btnRuaj_Click(<span style="color:Blue; object sender, EventArgs e)
{
<span style="color:Blue; int fatID = -1;
<span style="color:Blue; using(<span style="color:Blue; var db = <span style="color:Blue; new RestDBDataContext())
{
<span style="color:Blue; var fat = <span style="color:Blue; new Faturat() {PuntoriID = 1, Data = dtData.Value, Klienti = cbKlienti.Text};
db.Faturats.InsertOnSubmit(fat);
db.SubmitChanges();
fatID = fat.ID;
<span style="color:Blue; decimal total = 0;
<span style="color:Blue; foreach (DataRow row <span style="color:Blue; in dtDetaletFatura.Rows)
{
<span style="color:Blue; var fd = <span style="color:Blue; new FaturatDetalet();
fd.ArtikulliID = (<span style="color:Blue; int)row[<span style="color:#A31515; "ArtikulliID"];
fd.Cmimi = (<span style="color:Blue; decimal?)row[<span style="color:#A31515; "Cmimi"];
fd.Sasia = (<span style="color:Blue; decimal?) row[<span style="color:#A31515; "Sasia"];
fd.Njesia = row[<span style="color:#A31515; "Njesia"].ToString();
fd.FaturaID = fatID;
total += fd.Cmimi.GetValueOrDefault(0) * fd.Sasia.GetValueOrDefault(0);
db.FaturatDetalets.InsertOnSubmit(fd);

}
fat.Shuma = Convert.ToDecimal(txtTotali.Text);
db.SubmitChanges();
dtDetaletFatura.Rows.Clear();

}

<span style="color:Blue; return;
}

<span style="color:Blue; private <span style="color:Blue; void dgDetaletFat_RowsAdded(<span style="color:Blue; object sender, DataGridViewRowsAddedEventArgs e)
{
<span style="color:Blue; if (dgDetaletFat.Rows.Count < 1)
<span style="color:Blue; return;
<span style="color:Blue; decimal shuma = 0.0M;
<span style="color:Blue; foreach (DataGridViewRow row <span style="color:Blue; in dgDetaletFat.Rows)
{
<span style="color:Blue; decimal cmimi = (<span style="color:Blue; decimal)row.Cells[<span style="color:#A31515; "cmimi"].Value;
<span style="color:Blue; decimal sasia = (<span style="color:Blue; decimal)row.Cells[<span style="color:#A31515; "sasia"].Value;
<span style="color:Blue; decimal totali = cmimi * sasia;
row.Cells[<span style="color:#A31515; "Totali"].Value = totali;
<span style="color:Green; //string strtotali =
shuma += <span style="color:Blue; decimal.Parse(row.Cells[<span style="color:#A31515; "Totali"].Value.ToString());
}

txtTotali.Text = shuma.ToString();
}

<span style="color:Blue; private <span style="color:Blue; void dgDetaletFat_CellValueChanged_1(<span style="color:Blue; object sender, DataGridViewCellEventArgs e)
{
<span style="color:Blue; if (dgDetaletFat.Rows.Count < 1)
<span style="color:Blue; return;
<span style="color:Blue; decimal shuma = 0.0M;
<span style="color:Blue; foreach (DataGridViewRow row <span style="color:Blue; in dgDetaletFat.Rows)
{
<span style="color:Blue; decimal cmimi = (<span style="color:Blue; decimal)row.Cells[<span style="color:#A31515; "cmimi"].Value;
<span style="color:Blue; decimal sasia = (<span style="color:Blue; decimal)row.Cells[<span style="color:#A31515; "sasia"].Value;
<span style="color:Blue; decimal totali = cmimi * sasia;
row.Cells[<span style="color:#A31515; "Totali"].Value = totali;
<span style="color:Green; //string strtotali =
shuma += <span style="color:Blue; decimal.Parse(row.Cells[<span style="color:#A31515; "Totali"].Value.ToString());

}

txtTotali.Text = shuma.ToString();
}

<span style="color:Blue; private <span style="color:Blue; void txtSearch_TextChanged(<span style="color:Blue; object sender, EventArgs e)
{
<span style="color:Green; //dvartikujt.RowFilter = "emri like *" + txtSearch.Text + "*";
<span style="color:Blue; foreach (DataGridViewRow row <span style="color:Blue; in dgArtikujt.Rows)
{
<span style="color:Blue; string name = (<span style="color:Blue; string)row.Cells[<span style="color:#A31515; "Barkodi"].Value ;
<span style="color:Green; //string name = row.Cells["Barkodi"].Value.ToString();


<span style="color:Blue; if (<span style="color:Blue; string.IsNullOrEmpty(name))
<span style="color:Blue; return;
<span style="color:Blue; if (name.Length >= txtSearch.Text.Length)
{
<span style="color:Blue; string substr = name.Substring(0, txtSearch.Text.Length);
<span style="color:Blue; if (substr.ToUpper() == txtSearch.Text.ToUpper())
{
dgArtikujt.FirstDisplayedScrollingRowIndex = row.Index;
row.Selected = <span style="color:Blue; true;
<span style="color:Blue; break;
}
}
}
}

<span style="color:Blue; private <span style="color:Blue; void txtSearch_KeyDown(<span style="color:Blue; object sender, KeyEventArgs e)
{
<span style="color:Blue; if (dgArtikujt.SelectedRows.Count < 1)
<span style="color:Blue; return;


<span style="color:Blue; switch(e.KeyCode)
{
<span style="color:Blue; case Keys.Enter:
{
<span style="color:Blue; string barkodi = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "Barkodi"].Value.ToString();
<span style="color:Blue; if (txtSearch.Text.ToLower() == barkodi.ToLower())
{
ShtoArtikullin();
txtSearch.BackColor = Color.White;
txtSearch.Clear();
}
<span style="color:Blue; else
{
txtSearch.SelectAll();
<span style="color:Green; //btnFaturo.Focus();
txtSearch.BackColor = Color.Yellow;
}

} <span style="color:Blue; break;
<span style="color:Blue; case Keys.Up :
{
<span style="color:Blue; int index = dgArtikujt.SelectedRows[0].Index;
dgArtikujt.Rows[index - 1].Selected = <span style="color:Blue; true;
dgArtikujt.FirstDisplayedScrollingRowIndex = index - 1;
txtSearch.Text = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "Barkodi"].Value.ToString();
}; <span style="color:Blue; break;
<span style="color:Blue; case Keys.Down:
{
<span style="color:Blue; int index = dgArtikujt.SelectedRows[0].Index;
dgArtikujt.Rows[index + 1].Selected = <span style="color:Blue; true;
dgArtikujt.FirstDisplayedScrollingRowIndex = index + 1;
txtSearch.Text = dgArtikujt.SelectedRows[0].Cells[<span style="color:#A31515; "Barkodi"].Value.ToString();

} <span style="color:Blue; break;
<span style="color:Blue; default : <span style="color:Blue; break;

}
}
<span style="color:Blue; private <span style="color:Blue; void dgArtikujt_Enter(<span style="color:Blue; object sender, EventArgs e)
{
txtSearch.Focus();
}

<span style="color:Blue; private <span style="color:Blue; void dgDetaletFat_CellEnter(<span style="color:Blue; object sender, DataGridViewCellEventArgs e)
{
<span style="color:Blue; if (dgDetaletFat.Rows.Count < 1)
<span style="color:Blue; return;
<span style="color:Blue; decimal shuma = 0.0M;
<span style="color:Blue; foreach (DataGridViewRow row <span style="color:Blue; in dgDetaletFat.Rows)
{
<span style="color:Blue; decimal cmimi = (<span style="color:Blue; decimal)row.Cells[<span style="color:#A31515; "cmimi"].Value;
<span style="color:Blue; decimal sasia = (<span style="color:Blue; decimal)row.Cells[<span style="color:#A31515; "sasia"].Value;
<span style="color:Blue; decimal totali = cmimi * sasia;
row.Cells[<span style="color:#A31515; "Totali"].Value = totali;
<span style="color:Green; //string strtotali =
shuma += <span style="color:Blue; decimal.Parse(row.Cells[<span style="color:#A31515; "Totali"].Value.ToString());

}

txtTotali.Text = shuma.ToString();
txtSearch.Focus();
}

<span style="color:Blue; private <span style="color:Blue; void btnMbylle_Click(<span style="color:Blue; object sender, EventArgs e)
{
<span style="color:Blue; this.Close();
}

<span style="color:Blue; private <span style="color:Blue; void btnFaturo_Click(<span style="color:Blue; object sender, EventArgs e)
{
<span style="color:Green; //frmkalkulo frm = new frmkalkulo();
<span style="color:Green; //frm.Show ();
}

<span style="color:Blue; private <span style="color:Blue; void btnFaturo_KeyDown(<span style="color:Blue; object sender, KeyEventArgs e)
{
<span style="color:Blue; switch (e.KeyCode)
{
<span style="color:Blue; case Keys.F12:
{

frmkalkulo frm = <span style="color:Blue; new frmkalkulo();
frm.Totali = <span style="color:Blue; decimal.Parse(txtTotali.Text);
frm.Show();

} <span style="color:Blue; break;
<span style="color:Blue; default: <span style="color:Blue; break;
}
}

<span style="color:Blue; private <span style="color:Blue; void btnFaturo_Click_1(<span style="color:Blue; object sender, EventArgs e)
{

frmFatura frm = <span style="color:Blue; new frmFatura(); frm.Show();

<span style="color:Blue; this.Close();

}

<span style="color:Blue; private <span style="color:Blue; void dgDetaletFat_RowEnter(<span style="color:Blue; object sender, DataGridViewCellEventArgs e)
{
<span style="color:Green; //this.Select();
}

<span style="color:Blue; private <span style="color:Blue; void frmFatura_KeyDown(<span style="color:Blue; object sender, KeyEventArgs e)
{
<span style="color:Blue; if (e.KeyCode == Keys.F12)
{
<span style="color:Blue; int fatID = -1;
<span style="color:Blue; using (<span style="color:Blue; var db = <span style="color:Blue; new RestDBDataContext())
{
<span style="color:Blue; var fat = <span style="color:Blue; new Faturat() { PuntoriID = 1, Data = dtData.Value, Klienti = cbKlienti.Text };
db.Faturats.InsertOnSubmit(fat);
db.SubmitChanges();
fatID = fat.ID;
<span style="color:Blue; decimal total = 0;
<span style="color:Blue; foreach (DataRow row <span style="color:Blue; in dtDetaletFatura.Rows)
{
<span style="color:Blue; var fd = <span style="color:Blue; new FaturatDetalet();
fd.ArtikulliID = (<span style="color:Blue; int)row[<span style="color:#A31515; "ArtikulliID"];
fd.Cmimi = (<span style="color:Blue; decimal?)row[<span style="color:#A31515; "Cmimi"];
fd.Sasia = (<span style="color:Blue; decimal?)row[<span style="color:#A31515; "Sasia"];
fd.Njesia = row[<span style="color:#A31515; "Njesia"].ToString();
fd.FaturaID = fatID;
total += fd.Cmimi.GetValueOrDefault(0) * fd.Sasia.GetValueOrDefault(0);
db.FaturatDetalets.InsertOnSubmit(fd);

}
fat.Shuma = Convert.ToDecimal(txtTotali.Text);
db.SubmitChanges();
dtDetaletFatura.Rows.Clear();

}

frmkalkulo frm = <span style="color:Blue; new frmkalkulo();
frm.Totali = <span style="color:Blue; decimal.Parse(txtTotali.Text);
frm.Show();
<span style="color:Blue; this.Close();
}
<span style="color:Blue; else <span style="color:Blue; if (e.KeyCode == Keys.F8)
{
frmFatura frm = <span style="color:Blue; new frmFatura(); frm.Show();
<span style="color:Blue; this.Close();

}
<span style="color:Blue; else <span style="color:Blue; if (e.KeyCode == Keys.F3)
{

Here I must <span style="color:Blue; set CODe
}
<span style="color:Blue; else <span style="color:Blue; if (e.KeyCode == Keys.F2)
{
txtBack.Focus();

}
}

<span style="color:Blue; private <span style="color:Blue; void SetupDataGridView()
{

}

<span style="color:Blue; private <span style="color:Blue; void txtSearch_Enter(<span style="color:Blue; object sender, EventArgs e)
{
<span style="color:Green; //Agroni
}

<span style="color:Blue; private <span style="color:Blue; void txtBack_KeyDown(<span style="color:Blue; object sender, KeyEventArgs e)
{
<span style="color:Blue; if (e.KeyCode == Keys.Enter)
{
<span style="color:Blue; int artikulliID = -1;
<span style="color:Blue; foreach (DataGridViewRow row <span style="color:Blue; in dgArtikujt.Rows)
{
<span style="color:Blue; string barkodi = (<span style="color:Blue; string)row.Cells[<span style="color:#A31515; "Barkodi"].Value ;
<span style="color:Blue; if(barkodi == txtBack.Text)
{
artikulliID = (<span style="color:Blue; int)row.Cells[<span style="color:#A31515; "ID"].Value;
<span style="color:Blue; break;
}
}
<span style="color:Blue; for (<span style="color:Blue; int i = 0; i < dgDetaletFat.Rows.Count; i++)
{
<span style="color:Blue; if (((<span style="color:Blue; int)dgDetaletFat.Rows.Cells[<span style="color:#A31515; "ArtikulliID"].Value) == artikulliID)
{
<span style="color:Blue; var row = dgDetaletFat.Rows;
dgDetaletFat.Rows.Remove(row);
txtBack.Clear();


<span style="color:Blue; return;
}
}

}
}


}
}

[/code]
<hr class="sig Agron Sverkaj

View the full article
 

Similar threads

H
How to insert data direct from datagridview to database using LINQ
Replies
0
Views
102
How to create this functions
H
B
using datagridview_cellformatting in C# with data that is databound to change background color
Replies
0
Views
97
bosco dog
B
J
WPF: how to enable DataGrid ID cells in first column editable when highlight it from code?
Replies
0
Views
177
Jane Jie Chen
J
B
C# winform textbox, I have a textbox and want to enter decimals
Replies
0
Views
151
Booney440
B
B
C# Winform export to PDF
Replies
0
Views
116
Booney440
B
Back
Top