which row i click that row name go to top of second asp:textbox
using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Telerik.Web.UI;
using System.Data.SqlClient;
using System.Configuration;
using TBSDataLayer;
namespace TBS_HelpDesk.Views.Assets
{
public partial class NewModels : System.Web.UI.Page
{
public static string Manuf_ID;
private SqlDataAdapter sqladp;
private SqlCommand sqlcmd;
private DataTable dtTable;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Manuf_ID = "0";
}
}
protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
AssetModel oAssetModel = new AssetModel();
RadGrid1.DataSource = oAssetModel.fetchAssetManufacturer();
}
protected void RadGrid2_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
AssetModel oAssetModel = new AssetModel();
RadGrid2.DataSource = oAssetModel.fetchAssetModel(Manuf_ID);
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
dtTable = new DataTable();
sqladp = new SqlDataAdapter();
sqlcmd = new SqlCommand();
Manufacturers oManufacturers = new Manufacturers();
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
if (e.Item is GridEditFormItem)
{
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
TextBox Manuf_Name = (e.Item as GridEditFormInsertItem)["Manuf_Name"].Controls[0] as TextBox;
TextBox Manuf_Description = (e.Item as GridEditFormInsertItem)["Manuf_Description"].Controls[0] as TextBox;
CheckBox Manuf_Inactive = (e.Item as GridEditFormInsertItem)["Manuf_Inactive"].Controls[0] as CheckBox;
//GridEditFormItem item = (GridEditFormItem)e.Item;
//TextBox Manuf_Name = (TextBox)item.FindControl("Manuf_Name");
//TextBox Manuf_Description = (TextBox)item.FindControl("Manuf_Description");
//CheckBox Manuf_Inactive = (CheckBox)item.FindControl("Manuf_Inactive");
// newly changed
oManufacturers.Manuf_Name = Manuf_Name.Text;
oManufacturers.Manuf_Description = Manuf_Description.Text;
oManufacturers.Manuf_Inactive = Manuf_Inactive.Checked;
try
{
RadGrid1.DataSource = oManufacturers.AddManufacturers(oManufacturers.Manuf_Name, oManufacturers.Manuf_Description, oManufacturers.Manuf_Inactive);
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
}
RadGrid1.MasterTableView.IsItemInserted = false;
RadGrid1.DataBind();
e.Canceled = true;
}
//GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
//TextBox Manuf_Name = (e.Item as GridEditFormInsertItem)["Manuf_Name"].Controls[0] as TextBox;
//TextBox Manuf_Description = (e.Item as GridEditFormInsertItem)["Manuf_Description"].Controls[0] as TextBox;
//CheckBox Manuf_Inactive = (e.Item as GridEditFormInsertItem)["Manuf_Inactive"].Controls[0] as CheckBox;
}
else if (e.CommandName == RadGrid.UpdateCommandName)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
if (e.Item is GridEditFormItem)
{
GridEditFormItem item = (GridEditFormItem)e.Item;
TextBox Manuf_ID = (e.Item as GridEditableItem)["Manuf_ID"].Controls[0] as TextBox;
TextBox Manuf_Name = (e.Item as GridEditableItem)["Manuf_Name"].Controls[0] as TextBox;
TextBox Manuf_Description = (e.Item as GridEditableItem)["Manuf_Description"].Controls[0] as TextBox;
CheckBox Manuf_Inactive = (e.Item as GridEditableItem)["Manuf_Inactive"].Controls[0] as CheckBox;
//GridEditFormItem item = (GridEditFormItem)e.Item;
//TextBox Manuf_ID = (TextBox)item.FindControl("Manuf_ID");
//TextBox Manuf_Name = (TextBox)item.FindControl("Manuf_Name");
//TextBox Manuf_Description = (TextBox)item.FindControl("Manuf_Description");
//CheckBox Manuf_Inactive = (CheckBox)item.FindControl("Manuf_Inactive");
oManufacturers.Manuf_ID = Convert.ToInt32(Manuf_ID.Text);
oManufacturers.Manuf_Name = Manuf_Name.Text;
oManufacturers.Manuf_Description = Manuf_Description.Text;
oManufacturers.Manuf_Inactive = Manuf_Inactive.Checked;
try
{
RadGrid1.DataSource = oManufacturers.ModManufacturers(oManufacturers.Manuf_ID, oManufacturers.Manuf_Name, oManufacturers.Manuf_Description, oManufacturers.Manuf_Inactive);
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));
}
RadGrid1.EditIndexes.Clear();
RadGrid1.DataBind();
e.Canceled = true;
}
//RadNumericTextBox Manuf_ID = (e.Item as GridEditableItem)["Manuf_ID"].Controls[0] as RadNumericTextBox;
//TextBox Manuf_Name = (e.Item as GridEditableItem)["Manuf_Name"].Controls[0] as TextBox;
//TextBox Manuf_Description = (e.Item as GridEditableItem)["Manuf_Description"].Controls[0] as TextBox;
//CheckBox Manuf_Inactive = (e.Item as GridEditableItem)["Manuf_Inactive"].Controls[0] as CheckBox;
}
else if (e.CommandName == RadGrid.DeleteCommandName)
{
GridDataItem item = (GridDataItem)e.Item;
Int32 Manuf_ID = Convert.ToInt32(item["Manuf_ID"].Text);
try
{
RadGrid1.DataSource = oManufacturers.DelManufacturers(Manuf_ID);
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
e.Canceled = true;
}
}
else if (e.CommandName == "RowClick")
{
GridDataItem item = (GridDataItem)e.Item;
Manuf_ID = item["Manuf_ID"].Text;
string Manuf_Name = item["Manuf_Name"].Text;
ModelText.Text = "Model For " + item["Manuf_Name"].Text;
RadGrid2.DataSource = null;
RadGrid2.Rebind();
ModelText.Text = "Model For " + Manuf_Name;
//e.Row.Cells[1].ForeColor = System.Drawing.Color.Red;
}
}
protected void RadGrid2_ItemCommand(object sender, GridCommandEventArgs e)
{
dtTable = new DataTable();
sqladp = new SqlDataAdapter();
sqlcmd = new SqlCommand();
AssetModel oAssetModel = new AssetModel();
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
RadNumericTextBox Model_ID = (e.Item as GridEditFormInsertItem)["Model_ID"].Controls[0] as RadNumericTextBox;
TextBox Model_Name = (e.Item as GridEditFormInsertItem)["Model_Name"].Controls[0] as TextBox;
TextBox Model_Description = (e.Item as GridEditFormInsertItem)["Model_Description"].Controls[0] as TextBox;
oAssetModel.Model_Manuf_ID = Convert.ToInt16(Manuf_ID);
oAssetModel.Model_Name = Model_Name.Text;
oAssetModel.Model_Description = Model_Description.Text;
try
{
RadGrid2.DataSource = oAssetModel.AddAssetModel(oAssetModel.Model_Manuf_ID, oAssetModel.Model_Name, oAssetModel.Model_Description);
}
catch (Exception ex)
{
RadGrid2.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
}
RadGrid2.MasterTableView.IsItemInserted = false;
RadGrid2.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.UpdateCommandName)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
RadNumericTextBox Model_ID = (e.Item as GridEditableItem)["Model_ID"].Controls[0] as RadNumericTextBox;
TextBox Model_Name = (e.Item as GridEditableItem)["Model_Name"].Controls[0] as TextBox;
TextBox Model_Description = (e.Item as GridEditableItem)["Model_Description"].Controls[0] as TextBox;
oAssetModel.Model_Manuf_ID = Convert.ToInt16(Manuf_ID);
oAssetModel.Model_ID = Convert.ToInt16(Model_ID.Text);
oAssetModel.Model_Name = Model_Name.Text;
oAssetModel.Model_Description = Model_Description.Text;
try
{
RadGrid2.DataSource = oAssetModel.ModAssetModel(oAssetModel.Model_Manuf_ID, oAssetModel.Model_ID, oAssetModel.Model_Name, oAssetModel.Model_Description);
}
catch (Exception ex)
{
RadGrid2.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));
}
RadGrid2.EditIndexes.Clear();
RadGrid2.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.DeleteCommandName)
{
GridDataItem item = (GridDataItem)e.Item;
oAssetModel.Model_Manuf_ID = Convert.ToInt16(Manuf_ID);
Int32 Model_ID = Convert.ToInt16(item["Model_ID"].Text);
try
{
RadGrid2.DataSource = oAssetModel.DelAssetModel(oAssetModel.Model_Manuf_ID, Model_ID);
}
catch (Exception ex)
{
RadGrid2.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
e.Canceled = true;
}
}
}
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
{
}
protected void RadToolBar2_ButtonClick(object sender, RadToolBarEventArgs e)
{
}
}
}
Thanks
Mohamed
using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Telerik.Web.UI;
using System.Data.SqlClient;
using System.Configuration;
using TBSDataLayer;
namespace TBS_HelpDesk.Views.Assets
{
public partial class NewModels : System.Web.UI.Page
{
public static string Manuf_ID;
private SqlDataAdapter sqladp;
private SqlCommand sqlcmd;
private DataTable dtTable;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Manuf_ID = "0";
}
}
protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
AssetModel oAssetModel = new AssetModel();
RadGrid1.DataSource = oAssetModel.fetchAssetManufacturer();
}
protected void RadGrid2_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
AssetModel oAssetModel = new AssetModel();
RadGrid2.DataSource = oAssetModel.fetchAssetModel(Manuf_ID);
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
dtTable = new DataTable();
sqladp = new SqlDataAdapter();
sqlcmd = new SqlCommand();
Manufacturers oManufacturers = new Manufacturers();
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
if (e.Item is GridEditFormItem)
{
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
TextBox Manuf_Name = (e.Item as GridEditFormInsertItem)["Manuf_Name"].Controls[0] as TextBox;
TextBox Manuf_Description = (e.Item as GridEditFormInsertItem)["Manuf_Description"].Controls[0] as TextBox;
CheckBox Manuf_Inactive = (e.Item as GridEditFormInsertItem)["Manuf_Inactive"].Controls[0] as CheckBox;
//GridEditFormItem item = (GridEditFormItem)e.Item;
//TextBox Manuf_Name = (TextBox)item.FindControl("Manuf_Name");
//TextBox Manuf_Description = (TextBox)item.FindControl("Manuf_Description");
//CheckBox Manuf_Inactive = (CheckBox)item.FindControl("Manuf_Inactive");
// newly changed
oManufacturers.Manuf_Name = Manuf_Name.Text;
oManufacturers.Manuf_Description = Manuf_Description.Text;
oManufacturers.Manuf_Inactive = Manuf_Inactive.Checked;
try
{
RadGrid1.DataSource = oManufacturers.AddManufacturers(oManufacturers.Manuf_Name, oManufacturers.Manuf_Description, oManufacturers.Manuf_Inactive);
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
}
RadGrid1.MasterTableView.IsItemInserted = false;
RadGrid1.DataBind();
e.Canceled = true;
}
//GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
//TextBox Manuf_Name = (e.Item as GridEditFormInsertItem)["Manuf_Name"].Controls[0] as TextBox;
//TextBox Manuf_Description = (e.Item as GridEditFormInsertItem)["Manuf_Description"].Controls[0] as TextBox;
//CheckBox Manuf_Inactive = (e.Item as GridEditFormInsertItem)["Manuf_Inactive"].Controls[0] as CheckBox;
}
else if (e.CommandName == RadGrid.UpdateCommandName)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
if (e.Item is GridEditFormItem)
{
GridEditFormItem item = (GridEditFormItem)e.Item;
TextBox Manuf_ID = (e.Item as GridEditableItem)["Manuf_ID"].Controls[0] as TextBox;
TextBox Manuf_Name = (e.Item as GridEditableItem)["Manuf_Name"].Controls[0] as TextBox;
TextBox Manuf_Description = (e.Item as GridEditableItem)["Manuf_Description"].Controls[0] as TextBox;
CheckBox Manuf_Inactive = (e.Item as GridEditableItem)["Manuf_Inactive"].Controls[0] as CheckBox;
//GridEditFormItem item = (GridEditFormItem)e.Item;
//TextBox Manuf_ID = (TextBox)item.FindControl("Manuf_ID");
//TextBox Manuf_Name = (TextBox)item.FindControl("Manuf_Name");
//TextBox Manuf_Description = (TextBox)item.FindControl("Manuf_Description");
//CheckBox Manuf_Inactive = (CheckBox)item.FindControl("Manuf_Inactive");
oManufacturers.Manuf_ID = Convert.ToInt32(Manuf_ID.Text);
oManufacturers.Manuf_Name = Manuf_Name.Text;
oManufacturers.Manuf_Description = Manuf_Description.Text;
oManufacturers.Manuf_Inactive = Manuf_Inactive.Checked;
try
{
RadGrid1.DataSource = oManufacturers.ModManufacturers(oManufacturers.Manuf_ID, oManufacturers.Manuf_Name, oManufacturers.Manuf_Description, oManufacturers.Manuf_Inactive);
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));
}
RadGrid1.EditIndexes.Clear();
RadGrid1.DataBind();
e.Canceled = true;
}
//RadNumericTextBox Manuf_ID = (e.Item as GridEditableItem)["Manuf_ID"].Controls[0] as RadNumericTextBox;
//TextBox Manuf_Name = (e.Item as GridEditableItem)["Manuf_Name"].Controls[0] as TextBox;
//TextBox Manuf_Description = (e.Item as GridEditableItem)["Manuf_Description"].Controls[0] as TextBox;
//CheckBox Manuf_Inactive = (e.Item as GridEditableItem)["Manuf_Inactive"].Controls[0] as CheckBox;
}
else if (e.CommandName == RadGrid.DeleteCommandName)
{
GridDataItem item = (GridDataItem)e.Item;
Int32 Manuf_ID = Convert.ToInt32(item["Manuf_ID"].Text);
try
{
RadGrid1.DataSource = oManufacturers.DelManufacturers(Manuf_ID);
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
e.Canceled = true;
}
}
else if (e.CommandName == "RowClick")
{
GridDataItem item = (GridDataItem)e.Item;
Manuf_ID = item["Manuf_ID"].Text;
string Manuf_Name = item["Manuf_Name"].Text;
ModelText.Text = "Model For " + item["Manuf_Name"].Text;
RadGrid2.DataSource = null;
RadGrid2.Rebind();
ModelText.Text = "Model For " + Manuf_Name;
//e.Row.Cells[1].ForeColor = System.Drawing.Color.Red;
}
}
protected void RadGrid2_ItemCommand(object sender, GridCommandEventArgs e)
{
dtTable = new DataTable();
sqladp = new SqlDataAdapter();
sqlcmd = new SqlCommand();
AssetModel oAssetModel = new AssetModel();
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
RadNumericTextBox Model_ID = (e.Item as GridEditFormInsertItem)["Model_ID"].Controls[0] as RadNumericTextBox;
TextBox Model_Name = (e.Item as GridEditFormInsertItem)["Model_Name"].Controls[0] as TextBox;
TextBox Model_Description = (e.Item as GridEditFormInsertItem)["Model_Description"].Controls[0] as TextBox;
oAssetModel.Model_Manuf_ID = Convert.ToInt16(Manuf_ID);
oAssetModel.Model_Name = Model_Name.Text;
oAssetModel.Model_Description = Model_Description.Text;
try
{
RadGrid2.DataSource = oAssetModel.AddAssetModel(oAssetModel.Model_Manuf_ID, oAssetModel.Model_Name, oAssetModel.Model_Description);
}
catch (Exception ex)
{
RadGrid2.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
}
RadGrid2.MasterTableView.IsItemInserted = false;
RadGrid2.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.UpdateCommandName)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
RadNumericTextBox Model_ID = (e.Item as GridEditableItem)["Model_ID"].Controls[0] as RadNumericTextBox;
TextBox Model_Name = (e.Item as GridEditableItem)["Model_Name"].Controls[0] as TextBox;
TextBox Model_Description = (e.Item as GridEditableItem)["Model_Description"].Controls[0] as TextBox;
oAssetModel.Model_Manuf_ID = Convert.ToInt16(Manuf_ID);
oAssetModel.Model_ID = Convert.ToInt16(Model_ID.Text);
oAssetModel.Model_Name = Model_Name.Text;
oAssetModel.Model_Description = Model_Description.Text;
try
{
RadGrid2.DataSource = oAssetModel.ModAssetModel(oAssetModel.Model_Manuf_ID, oAssetModel.Model_ID, oAssetModel.Model_Name, oAssetModel.Model_Description);
}
catch (Exception ex)
{
RadGrid2.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));
}
RadGrid2.EditIndexes.Clear();
RadGrid2.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.DeleteCommandName)
{
GridDataItem item = (GridDataItem)e.Item;
oAssetModel.Model_Manuf_ID = Convert.ToInt16(Manuf_ID);
Int32 Model_ID = Convert.ToInt16(item["Model_ID"].Text);
try
{
RadGrid2.DataSource = oAssetModel.DelAssetModel(oAssetModel.Model_Manuf_ID, Model_ID);
}
catch (Exception ex)
{
RadGrid2.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
e.Canceled = true;
}
}
}
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
{
}
protected void RadToolBar2_ButtonClick(object sender, RadToolBarEventArgs e)
{
}
}
}
Thanks
Mohamed