| <asp:Panel runat="server" ID="DrugList" Height="370px" Width="550" ScrollBars="Auto"> |
| <telerik:RadGrid ID="rgDrugList" runat="server" AllowMultiRowSelection="True" |
| AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" GridLines="None" |
| Height="350px" OnItemCommand="rgDrugList_ItemCommand" |
| Skin="Vista" Width="545px" OnselectedIndexChanged="rgDrugList_SelectedIndexChanged"> |
| <MasterTableView> |
| <PagerStyle Mode="NextPrevAndNumeric" /> |
| <Columns> |
| <telerik:GridBoundColumn DataField="Name" HeaderText="Drug Name" SortExpression="Name" UniqueName="Name"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| <ClientSettings EnablePostBackOnRowClick="true"> |
| <Selecting AllowRowSelect="True" /> |
| </ClientSettings> |
| </telerik:RadGrid> |
| </asp:Panel> |
| Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles form1.Load |
| InitializeData() |
| End Sub |
| Protected Sub InitializeData() |
| Dim o As New localhost.Service1 |
| Dim ds As New DataSet |
| ds = o.GetNumbderDrugData |
| If ds Is Nothing Then |
| errorPanel.Visible = True |
| Exit Sub |
| End If |
| If ds.Tables(0).Rows.Count = 0 Then |
| errorPanel.Visible = True |
| Exit Sub |
| Else |
| errorPanel.Visible = False |
| rgDrugList.DataSource = ds |
| rgDrugList.DataBind() |
| End If |
| End Sub |
| Protected Sub rgDrugList_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles rgDrugList.SelectedIndexChanged |
| Dim item As GridDataItem = DirectCast(rgDrugList.SelectedItems(0), GridDataItem) |
| ' Get the first selected item |
| If True Then |
| MsgBox(item("Name").Text) |
| End If |
| End Sub |
private DataTable GetData(string text)
{
objUser = (
LoggedUser)Session["USER"];
string appendSql = string.Empty;
objUser = (
LoggedUser)Session["USER"];
string appendText = string.Empty;
string appText = string.Empty;
string fillMedication = string.Empty;
int catType = 0;
if (RbtnOral.Checked == true)
{
catType =
TypeID.ORAL_TYPE;
}
else
{
catType =
TypeID.TOPICAL_TYPE;
}
if (text != "")
{
appendText =
" AND LD.DRUG_NAME LIKE '" + text + '%' + "' ";
appText =
"AND LPM.DRUG_NAME LIKE '" + text + '%' + "' ";
}
if (chkStandard.Checked == true)
{
fillMedication =
"SELECT TOP 10 LD.DRUG_NAME AS MEDICATION, PK_DRUG_ID AS PKMEDICATION FROM L_DRUGNAME LD " +
"WHERE " +
" LD.DRUG_NAME IS NOT NULL " + appendText + " ";
}
else
{
fillMedication =
"SELECT LD.DRUG_NAME as MEDICATION,PK_ID as " +
"PKMEDICATION,case LPM.STRENGTH when ' ' then ' ' " +
"else isnull((select strength from l_strength where " +
"CONVERT(VARCHAR,pk_stren_id)=LPM.STRENGTH),' ') " +
"end as STRENGTH,PK_ID as PKSTRENGTH,case LPM.DIRECTIONS when ' ' then ' ' " +
"else isnull((select DIRECTIONS from L_DIRECTIONS where " +
"Convert(varchar,PK_DIR_ID)=LPM.DIRECTIONS),' ') " +
"end as DIRECTIONS,PK_ID as " +
"PKDIRECTIONS from L_PREFERED_MEDICATION LPM,L_DRUGNAME LD where " +
"CONVERT(VARCHAR,pk_drug_id)=LPM.DRUG_NAME " + appendText + " " +
"and LPM.DRUG_NAME IS NOT NULL " +
" AND LPM.FK_PRACTIONER_ID = " + objUser.PractitionerID + " AND LPM.STATUS = 1 AND IS_CUSTOM = 'FALSE' AND LPM.Category =" + catType + " " +
"UNION " +
"SELECT DRUG_NAME AS MEDICATION, LPM.PK_ID,LPM.STRENGTH AS STRENGTHSTR, " +
"LPM.PK_ID AS PKSTRENGTH,LPM.DIRECTIONS AS 'DIRECTIONSSTR',LPM.PK_ID AS 'PKDIRECTIONS' " +
"FROM L_PREFERED_MEDICATION LPM WHERE LPM.FK_PRACTIONER_ID = " + objUser.PractitionerID + " " +
"AND LPM.STATUS = 1 AND IS_CUSTOM = 'TRUE' " + appText + " and DRUG_NAME IS NOT NULL AND LPM.Category =" + catType +" ";
}
DataTable dtData = SqlHelper.ExecuteDataset(new Connection().GetCon, CommandType.Text, fillMedication).Tables[0];
return dtData;
}
protected
void RadComboBoxMedication_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
DataTable data = GetData(e.Text);
RadComboBoxMedication.Items.Clear();
string text = e.Text;
DataRow[] rows = data.Select();
int itemsPerRequest = 10;
int itemOffset = e.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > rows.Length)
{
endOffset = rows.Length;
}
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxMedication.Items.Add(
new RadComboBoxItem(data.Rows[i]["MEDICATION"].ToString(), data.Rows[i]["PKMEDICATION"].ToString()));
}
// e.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset, rows.Length);
e.Message = GetStatusMessage(endOffset, data.Rows.Count);
}
even after i uncheck chkStandard checkbox or rbtnOral radioButton but it shows it is checked.
Plz help me.
Name A B
Test1 valueA1 * valueB1 *
Test2 valueA2 * valueB2 *
Test3 valueA3 * valueB3 *
Bulk Update Textbox1 * Textbox2 *
The code for it is as below,
btnColOk = new GridButtonColumn();
btnColOk.ButtonType =
GridButtonColumnType.ImageButton;
rgTest.MasterTableView.Columns.Add(btnColOk);
btnColOk.ImageUrl =
@"~\Images\tick.png";
btnColOk.CommandName =
"btnColOk_Click";
Now in the ItemCommand Event, the code is as below,
protected
void rgTest_ItemCommand(object source, GridCommandEventArgs e)
{
if (e.CommandName == "btnColOk_Click")
{
GridDataItem dataItem = (GridDataItem)e.Item;
ImageButton btn1 = (ImageButton)dataItem["btnColOk"].Controls[0];
btn1.Click +=
new ImageClickEventHandler(btn1_Click);
}
}
Now when i click on any ImageButtons, am getting an error as
"An error has occurred because a control with id 'rgTest$ctl00$ctl04$ctl00' could not be located or a different control is assigned to the same ID after postback. If the ID is not assigned, explicitly set the ID property of controls that raise postback events to avoid this error. "
But am not able to specify an id for 'btnColOk' GridButtonColumn.
Can anyone please help me in this?
Thanks
Sujith
