Category: Visual Studio

21 Oct 2015 04:42

Joined:	21/10/2015
Level:	Bronze
Points:	6

Points:	5

Delete button code using checkbox

// Delete Button Details//
private void button3_Click(object sender, EventArgs e)
{
iselibraryEntities ise = new iselibraryEntities();
foreach(var item in dataGridView1.Rows)
{
DataGridViewRow row = item as DataGridViewRow;
if(row.Selected)
{
string usn = row.Cells["USN"].Value.ToString();
var issu = ise.T_BOOK_ISSUE_TABLE.FirstOrDefault(a => a.USN.Equals(usn));
if(issu!=null)
{
ise.T_BOOK_ISSUE_TABLE.remove
}
}
}
Thing is I don't get a dropdown for remove in if loop after ise.T_BOOK_ISSUE_TABLE.

Error says as 'Object Query<T_BOOK_ISSUE_TABLE>' does not contain a definition for 'remove' and no extension method 'remove' accepting a first argument of type'Object Query<T_BOOK_ISSUE_TABLE>'could be found(are you missing a directive or an assembly reference?)
How to get rid of this error?

#762925

21 Oct 2015 23:36

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	2

Hi bharthish,

Could you please check whether "error" method is available in "iselibraryEntities".

If it's available then I'm sure that is not latest dll your referring, I request you to please update the dll and add reference to that then rebuild the solution.

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#762930

22 Oct 2015 02:56

Joined:	21/10/2015
Level:	Bronze
Points:	6

Points:	1

How to check whether "error" method is available in "iselibraryEntities".?

#762934

22 Oct 2015 09:48

Joined:	21/10/2015
Level:	Bronze
Points:	6

Points:	1

GOT SOLUTION here it is....

private void button3_Click(object sender, EventArgs e)
{
var selectedidlist = new List<string>();
for (var rownum = 0; rownum < dataGridView1.Rows.Count; rownum++)
{
if (dataGridView1.Rows[rownum].Cells["Column1"].Value!=null && ((bool)(dataGridView1.Rows[rownum].Cells["Column1"]).Value))
{
selectedidlist.Add(dataGridView1.Rows[rownum].Cells["USN"].Value.ToString());

}
}

if (selectedidlist.Count > 0)
{

var selectedListString = selectedidlist.Aggregate((current, next) => current + ", " + next);

String str = "delete from T_BOOK_ISSUE_TABLE where USN in (@search)";
SqlCommand xp = new SqlCommand(str, vid);
xp.Parameters.Add("@search", SqlDbType.NVarChar).Value = selectedListString;

vid.Open();
xp.ExecuteNonQuery();
vid.Close();
Delete_Load(null, null);
}

#762994

27 Oct 2015 02:32

Joined:	23/10/2015
Level:	Bronze
Points:	34

Points:	4

Try this :-

private void button3_Click(object sender, EventArgs e)

{
var selectedidlist = new List<string>();
for (var rownum = 0; rownum < dataGridView1.Rows.Count; rownum++)
{
if (dataGridView1.Rows[rownum].Cells["Column1"].Value!=null && ((bool)(dataGridView1.Rows[rownum].Cells["Column1"]).Value))
{
selectedidlist.Add(dataGridView1.Rows[rownum].Cells["USN"].Value.ToString());

}
}

if (selectedidlist.Count > 0)
{

var selectedListString = selectedidlist.Aggregate((current, next) => current + ", " + next);

String str = "delete from T_BOOK_ISSUE_TABLE where USN in (@search)";
SqlCommand xp = new SqlCommand(str, vid);
xp.Parameters.Add("@search", SqlDbType.NVarChar).Value = selectedListString;

vid.Open();
xp.ExecuteNonQuery();
vid.Close();
Delete_Load(null, null);

HOPE THIS HELPS.

Delete button code using checkbox

About dotnetspider.com

Quick Links

General

Services