Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.
Populate textbox from database using ajax
Hi, I have the following scenario: An SQL 2000 database with a table containing the columns UserID and UserName. A webpage with TextBox1 and TextBox2.
I need to use AJAX or Jquey to accomplish the following: When I type the patient ID in txtPatientId textbox and press the Tab key, txtMRN will populate with the corresponding MRN number.
How do implement this this is what I have but is not working.
I need to use AJAX or Jquey to accomplish the following: When I type the patient ID in txtPatientId textbox and press the Tab key, txtMRN will populate with the corresponding MRN number.
How do implement this this is what I have but is not working.
[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static string GetDynamicContent(string contextKey)
{
string outputString = string.Empty;
string strConn = ConfigurationManager.ConnectionStrings[""].ConnectionString;
SqlConnection dbConnection = new SqlConnection(strConn);
SqlCommand dbCommand = new SqlCommand
("SELECT TPM300_PAT_VISIT.vst_ext_id AS VisitID, FROM TABLE ......"
return outputString;
<asp:TextBox ID="txtMRN" runat="server" MaxLength="15"></asp:TextBox>
<asp:DynamicPopulateExtender ID="txtMRN_DynamicPopulateExtender" runat="server"
Enabled="True" PopulateTriggerControlID="btn_Go" ServiceMethod="GetDynamicContent"
TargetControlID="txtMRN" ContextKey="txtPatientId">
</asp:DynamicPopulateExtender>
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
@TOnyReba,
On the server :
You need a to create a web service to receive the request from the server.
Your web service return the MRN number
On the client side just call
On the server :
You need a to create a web service to receive the request from the server.
Your web service return the MRN number
[WebMethod]
public static string GetMRN(string PatientID)
{
string outputString = string.Empty;
string strConn = ConfigurationManager.ConnectionStrings[""].ConnectionString;
SqlConnection dbConnection = new SqlConnection(strConn);
SqlCommand dbCommand = new SqlCommand
("SELECT TPM300_PAT_VISIT.vst_ext_id AS VisitID, FROM TABLE ......WHERE .... = " + PatientID
// ... get MRN
return strMRN;
}
On the client side just call
<script type="text/javascript">
function getMRN() {
var PatientID = $get('<%= txtPatientId.ClientID %>');
if(PatientID.value == '') return;
PageMethods.GetServerData(PatientID.value, OnSucceeded, OnFailed);
}
function OnSucceeded(result, userContext, methodName) {
var MRN = $get('<%= txtMRN.ClientID %>');
MRN.value = result;
}
function OnFailed(error, userContext, methodName) {
alert(error.get_message());
}
</script>
what do i use forthe patientID parameter
this are my textboxes
this are my textboxes
<asp:TextBox ID="txtPatientId" runat="server" MaxLength="15"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ErrorMessage="*" ControlToValidate="txtPatientId"></asp:RequiredFieldValidator>
<asp:Button ID="btn_Go" runat="server" onclick="btn_Go_Click" Text="Lookup"
UseSubmitBehavior="False" CausesValidation="False" />
</td>
<td>
MRN:
<asp:TextBox ID="txtMRN" runat="server" MaxLength="15" ReadOnly="True"></asp:TextBox>
<asp:DynamicPopulateExtender ID="txtMRN_DynamicPopulateExtender" runat="server"
Enabled="True" PopulateTriggerControlID="btn_Go" ServiceMethod="GetDynamicContent"
TargetControlID="txtMRN">
</asp:DynamicPopulateExtender>
>what do i use forthe patientID parameter
>>>>When I type the patient ID in txtPatientId textbox and press the Tab key, txtMRN will populate with the corresponding MRN number.
Check line 3 : var PatientID = $get('<%= txtPatientId.ClientID %>');
>>>>When I type the patient ID in txtPatientId textbox and press the Tab key, txtMRN will populate with the corresponding MRN number.
Check line 3 : var PatientID = $get('<%= txtPatientId.ClientID %>');
Where is StrnMRN declared?
[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static string GetMRN(string PatientID)
{
string outputString = string.Empty;
string strConn = ConfigurationManager.ConnectionStrings[""].ConnectionString;
SqlConnection dbConnection = new SqlConnection(strConn);
SqlCommand dbCommand = new SqlCommand
("SELECT TPM300_PAT_VISIT.vst_ext_id AS VisitID, TPM300_PAT_VISIT.med_rec_no AS MRN WHERE TPM300_PAT_VISIT.vst_ext_id = '" + PatientID + "'", dbConnection);
-->>>> return strMRN;?????????????
}
}
SqlDataReader rdr = cmd.ExecuteReader();
String strMRN;
if(rdr.Read()) {
strMRN = rdr[1];
}
return strMRN;
thanks for helping me so far
I get this error
strMRN = rdr[1];
cannot convert object to string..
do I need to cast?
I get this error
strMRN = rdr[1];
cannot convert object to string..
do I need to cast?
ok this doesnt give me errors,,,
while (rdr.Read())
{
string strMRN = rdr.GetString(1);
}
return sb.ToString();
}
now how do I call this code , what does it trigers it on my aspx ?
while (rdr.Read())
{
string strMRN = rdr.GetString(1);
}
return sb.ToString();
}
now how do I call this code , what does it trigers it on my aspx ?
try your web service alone and confirm it run fine
the next step is to call it with ajax/page method
>now how do I call this code , what does it trigers it on my aspx ?
It seems you don't want to look my links in your other post...
OK, back to ID:35778108 > On the client side just call
the next step is to call it with ajax/page method
>now how do I call this code , what does it trigers it on my aspx ?
It seems you don't want to look my links in your other post...
OK, back to ID:35778108 > On the client side just call
Premium Content
You need an Expert Office subscription to comment.Start Free Trial