Run sqlStatment (Dqldatasource) when I open modal

Question

User-909867351 posted

I fullcalendar I have the following code:

eventClick: function (calEvent, jsEvent, view) {                
                $("#HiddenField2").val(calEvent.id_cliente); 
                $("#HiddenField1").val(calEvent.id);
                $("#modalConsulta").modal();

I pass the values of calEnvent.id_cliente and calEvent.id_cliente to modalConsuta. I have to run one sqldatasource select statment to get all the data from my table like this one

SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectCommand = "select * from clientes where id=?";
        SqlDataSource1.SelectParameters.Add("@a", HiddenField2.Value);
        SqlDataSource1.DataBind();

and show the values on modalConsulta. 

Any help on this issue?

Thank you

Answer 1

User475983607 posted

A standard ASP.NET Web Forms Update Panel is required to invoke an SqlDataSource because an SqlDataSource is a member of the of the page class. 

A very common approach is using AJAX or fetch to invoke an HTTP request to an HTTP endpoint.  Then writing a bit of JavaScript to update the DOM. 

Answer 2

User-909867351 posted

If I have one button with the sqlStatment on my modal I can run it (with click event) like this

$("#HiddenField2").val(calEvent.id_cliente); 
                $("#HiddenField1").val(calEvent.id);
                
                $("#Button4").click();               
                $("#modalConsulta").modal();

And works fine. My problem: How can I hide Button4 after click?

Answer 3

User475983607 posted

And works fine. My problem: How can I hide Button4 after click?

$("#Button4").hide();

jQuery Reference

https://api.jquery.com/hide/

Answer 4

User-909867351 posted

I try it but no luck

The Button is still visible

$("#Button4").click();  
                $("#Button4").hide();
                $("#modalConsulta").modal();

Maybe after sqldatasource complets the sql statment I will put the button visible=false. I don't understand why hide() is not working.

Answer 5

User475983607 posted

I don't understand why hide() is not working.

Have you verified the code is running by setting a break point?

Maybe you are using a content page and need to use the following construct?

$("#<%=Button4.ClientID%>").hide();

We cannot see all the relevant code so we are guessing how your code works at this point.

Answer 6

User-909867351 posted

The problem is click() works in Button4 and hide() does not work

My source code

<input type="hidden" name="HiddenField1" id="HiddenField1" value="67" />
                        <input type="hidden" name="HiddenField2" id="HiddenField2" value="3" />
                        <input type="submit" name="Button4" value="Procura" id="Button4" />

Why click() works ans hide does not work?

Answer 7

User475983607 posted

The problem is click() works in Button4 and hide() does not work

My source code

<input type="hidden" name="HiddenField1" id="HiddenField1" value="67" />
                        <input type="hidden" name="HiddenField2" id="HiddenField2" value="3" />
                        <input type="submit" name="Button4" value="Procura" id="Button4" />

Why click() works ans hide does not work?

The click happens before the hide().  If the click is a full page refresh then the button CSS (state) is generated on the server which overwrites the HTML.  Please use your debugging tools.