3
Answers

Get value of cell in select row in nested gridview

Boguda Boguda

Boguda Boguda

9y
556
1

HI here is my problem

in my gridview1 I have template field with another gridview(gridview2).

in gridview2 I insert commandfield with delete button and I don't now how to write code for delete row.
My gridview1 I populate by objectdatasource and I write my DataAccessLayer in separate class. I also have  DeleteScanLogRow function but  need value from gridview2 cell . I try something like:

GridView grv2 = (GridView)GridView1.FindControl("GridView2");

string id =grv2.SelectedRow.Cells[0].Text;

            but this dosent work!!!

Here is my code from  DataAccessLayer class 

public class ScanLog

{

public int ScLogID { get; set; }

public int NalogID { get; set; }

public string tip{get;set;}

public string KatBR{get;set;}

public string FormatFrm{get;set;}

public string NazivFilma{get;set;}

public string Napomene{get;set;}

public string Bckp{get;set;}

//public string FilmID{get;set;}

public string ScanFor{get;set;}

public bool SkenTon{get;set;}

public List<ScanLogRow>ScanLogRow

{

get { return ScanLogDataAccessLayerRow.GetAllScanLogRow(this.ScLogID); }

}

}

public class ScanLogRow

{

public int ScLogRowID { get; set; }

public int ScLogID { get; set; }

public string datum { get; set; }

public int metraza { get; set; }

public int sfrm { get; set; }

public int efrm { get; set; }

public int cfrm { get; set; }

public decimal size { get; set; }

public string brrol { get; set; }

public string path { get; set; }

}

public class ScanLogDataAccessLayer

{

public static List<ScanLog> GetAllScanLog()

{

List<ScanLog> ListaScLog = new List<ScanLog>();

string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection con = new SqlConnection(CS))

{

SqlCommand com = new SqlCommand("SELECT DISTINCT * from tblScLog order by NalogID DESC",con);

con.Open();

SqlDataReader dr = com.ExecuteReader();

while (dr.Read())

{

ScanLog sc = new ScanLog();

sc.ScLogID = Convert.ToInt32(dr["ScLogID"]);

sc.NalogID = Convert.ToInt32(dr["NalogID"]);

sc.tip = dr["tip"].ToString();

sc.KatBR= dr["KatBr"].ToString();

sc.FormatFrm= dr["FormatFrm"].ToString();

sc.NazivFilma = dr["NazivFilma"].ToString();

sc.Napomene = dr["Napomene"].ToString();

sc.Bckp = dr["Bckp"].ToString();

// sc.FilmID = dr["FilmID"].ToString();

sc.ScanFor = dr["ScanFor"].ToString();

if (dr["SkenTon"] != null) { sc.SkenTon = (bool)dr["SkenTon"]; }

else { sc.SkenTon = false; }

ListaScLog.Add(sc);

}

}

return ListaScLog;

public class ScanLogDataAccessLayerRow

{

public static List<ScanLogRow> GetAllScanLogRow(int SLID)

{

List<ScanLogRow> ListaScLogRow = new List<ScanLogRow>();

string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection con = new SqlConnection(CS))

{

SqlCommand com = new SqlCommand("Select * from tblScLogRow where ScLogID=@ScLogID", con);

SqlParameter par = new SqlParameter();

par.ParameterName = "@ScLogID";

par.Value = SLID;

com.Parameters.Add(par);

con.Open();

SqlDataReader dr = com.ExecuteReader();

while (dr.Read())

{

ScanLogRow sc = new ScanLogRow();

sc.ScLogRowID = Convert.ToInt32(dr["ScLogRowID"]);

sc.ScLogID = Convert.ToInt32(dr["ScLogID"]);

sc.datum = dr["datum"].ToString();

sc.metraza = Convert.ToInt32( dr["metraza"]);

sc.sfrm = Convert.ToInt32(dr["sfrm"]);

sc.efrm = Convert.ToInt32(dr["efrm"]);

sc.cfrm = Convert.ToInt32(dr["cfrm"]);

sc.brrol = dr["brrol"].ToString();

sc.size =Convert.ToDecimal( dr["size"]);

sc.path = dr["path"].ToString();

ListaScLogRow.Add(sc);

}

}

return ListaScLogRow;

}

public static int UpdateScanLogRow(int ScLogRowID,int ScLogID, DateTime datum, int metraza, int sfrm, int efrm, int cfrm, float size, string brrol, string path)

{

string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection con = new SqlConnection(CS))

{

SqlCommand com = new SqlCommand(@"UPDATE tblScLogRow SET ScLogID=@ScLogID, datum=@datum, metraza=@metraza,

sfrm=@sfrm, efrm=@efrm, cfrm=@cfrm, size=@size, brrol=@brrol, path=@path WHERE ScLogRowID=@ScLogRowID", con);

com.Parameters.AddWithValue(@"ScLogRowID",ScLogRowID);

com.Parameters.AddWithValue(@"ScLogID", ScLogID);

com.Parameters.AddWithValue(@"datum", datum);

com.Parameters.AddWithValue(@"metraza", metraza);

com.Parameters.AddWithValue(@"sfrm",sfrm );

com.Parameters.AddWithValue(@"efrm",efrm );

com.Parameters.AddWithValue(@"cfrm",cfrm );

com.Parameters.AddWithValue(@"size",size );

com.Parameters.AddWithValue(@"brrol",brrol );

com.Parameters.AddWithValue(@"path", path);

con.Open();

return com.ExecuteNonQuery();

}

}

public static void DeleteScanLogRow(int ScLogRowID)

{

string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection con = new SqlConnection(CS))

{

SqlCommand com = new SqlCommand("DELETE FROM tblScLogRow where ScLogRowID=@ScLogRowID", con);

com.Parameters.AddWithValue(@"ScLogRowID", ScLogRowID);

con.Open();

com.ExecuteNonQuery();

}

}

}

}

 
 
Answers (3)
0
Satyapriya Nayak

Satyapriya Nayak

NA 53k 8m 11y
OLE DB is a set of COM-based interfaces that expose data from a variety of sources. OLE DB interfaces provide applications with uniform access to data stored in diverse information sources, or data stores. These interfaces support the amount of DBMS functionality appropriate to the data store, enabling the data store to share its data.

http://msdn.microsoft.com/en-us/library/windows/desktop/ms722784%28v=vs.85%29.aspx

Language-Integrated Query (LINQ) is a set of features introduced in Visual Studio 2008 that extends powerful query capabilities to the language syntax of C# and Visual Basic. LINQ introduces standard, easily-learned patterns for querying and updating data, and the technology can be extended to support potentially any kind of data store. Visual Studio includes LINQ provider assemblies that enable the use of LINQ with .NET Framework collections, SQL Server databases, ADO.NET Datasets, and XML documents.

http://msdn.microsoft.com/en-us/library/vstudio/bb397926.aspx
Accepted