protected void FillGrid()
{
GV_ServerTable.DataSource = null;
GV_ServerTable.DataBind();
string str = "";
if (chk_active.Checked == true)
{
str = " and ClientProductTableMaster.Id In (Select ServerTableID as Id From SatelliteSyncronisationrequiringTablesMaster where DatabaseID='" + ddlcodetype.SelectedValue + "') ";
}
string strcln1 = " select distinct ClientProductTableMaster.TableName, ClientProductTableMaster.Id,ClientProductTableMaster.VersionInfoId , dbo.ProductCodeDetailTbl.CodeTypeName from dbo.ClientProductTableMaster INNER JOIN dbo.ProductCodeDetailTbl ON dbo.ClientProductTableMaster.Databaseid = dbo.ProductCodeDetailTbl.Id where ClientProductTableMaster.active=1 and ClientProductTableMaster.Databaseid='" + ddlcodetype.SelectedValue + "' " + str + " order by ClientProductTableMaster.TableName ";
SqlCommand cmdcln = new SqlCommand(strcln1, con);
DataTable dtcln = new DataTable();
SqlDataAdapter adpcln = new SqlDataAdapter(cmdcln);
adpcln.Fill(dtcln);
GV_ServerTable.DataSource = dtcln;
DataView myDataView = new DataView();
myDataView = dtcln.DefaultView;
if (hdnsortExp.Value != string.Empty)
{
myDataView.Sort = string.Format("{0} {1}", hdnsortExp.Value, hdnsortDir.Value);
}
GV_ServerTable.DataBind();
}
protected void FillGrid()
{
GV_ServerTable.DataSource = null;
GV_ServerTable.DataBind();
string str = "";
if (chk_active.Checked == true)
{
str = " and ClientProductTableMaster.Id In (Select ServerTableID as Id From SatelliteSyncronisationrequiringTablesMaster where DatabaseID='" + ddlcodetype.SelectedValue + "') ";
}
string strcln1 = " select distinct ClientProductTableMaster.TableName, ClientProductTableMaster.Id,ClientProductTableMaster.VersionInfoId , dbo.ProductCodeDetailTbl.CodeTypeName from dbo.ClientProductTableMaster INNER JOIN dbo.ProductCodeDetailTbl ON dbo.ClientProductTableMaster.Databaseid = dbo.ProductCodeDetailTbl.Id where ClientProductTableMaster.active=1 and ClientProductTableMaster.Databaseid='" + ddlcodetype.SelectedValue + "' " + str + " order by ClientProductTableMaster.TableName ";
SqlCommand cmdcln = new SqlCommand(strcln1, con);
DataTable dtcln = new DataTable();
SqlDataAdapter adpcln = new SqlDataAdapter(cmdcln);
adpcln.Fill(dtcln);
GV_ServerTable.DataSource = dtcln;
DataView myDataView = new DataView();
myDataView = dtcln.DefaultView;
if (hdnsortExp.Value != string.Empty)
{
myDataView.Sort = string.Format("{0} {1}", hdnsortExp.Value, hdnsortDir.Value);
}
GV_ServerTable.DataBind();
//foreach (GridViewRow gr5 in GV_ServerTable.Rows)
//{
// DropDownList DDLLiceTableName = ((DropDownList)gr5.FindControl("DDLLiceTableName"));
// CheckBox nul = ((CheckBox)gr5.FindControl("CheckBox6"));
// if (ViewState["sp"] == "1")
// {
// nul.Checked = true;
// }
// DataTable dtcln = MyCommonfile.selectBZ(" SELECT DISTINCT TOP (100) PERCENT dbo.ProductCodeDetailTbl.Id, dbo.ProductCodeDetailTbl.ProductId, dbo.ProductCodeDetailTbl.CodeTypeName,dbo.CodeTypeTbl.CodeTypeCategoryId FROM dbo.CodeTypeTbl INNER JOIN dbo.CodeTypeCategory ON dbo.CodeTypeCategory.CodeMasterNo = dbo.CodeTypeTbl.CodeTypeCategoryId INNER JOIN dbo.ProductCodeDetailTbl ON dbo.CodeTypeTbl.ProductCodeDetailId = dbo.ProductCodeDetailTbl.Id where ProductCodeDetailTbl.Active='1' and CodeTypeTbl.ProductVersionId='" + ddlProductname.SelectedValue + "' and CodeTypeCategory.Id='2' order by dbo.ProductCodeDetailTbl.CodeTypeName ");
// if (dtcln.Rows.Count > 0)
// {
// DDLLiceTableName.DataSource = dtcln;
// DDLLiceTableName.DataValueField = "tableid";
// DDLLiceTableName.DataTextField = "TableName";
// DDLLiceTableName.DataBind();
// DDLLiceTableName.Items.Insert(0, "--Select--");
// DDLLiceTableName.Items[0].Value = "0";
// }
//}
}
