c# - WPF MS SQL Stored Procedure times out -

my application needs data store procedure. in query program stored procedure works fine;

exec mystoredprodure @prama1 = '01' 

in wpf times out. here code;

using (sqlconnection con = new sqlconnection(constring)) {     con.open();     sqlcommand cmd = new sqlcommand();     cmd.commandtype = commandtype.storedprocedure;     cmd.parameters.addwithvalue("@prama1", "01");     cmd.commandtext = "mystoredprodure";     cmd.connection = con;     sqldataadapter sda = new sqldataadapter(cmd);     datatable dt = new datatable("mystoredprodure");     sda.fill(dt);      foreach (datarow dr in dt.rows)     {        //do code     }     con.close(); } 

it timing out right on sda.fill(dt). should noted select , inserts work fine.

i believe you're missing sda.selectcommand = cmd; before fill. how use dataadapter stored procedure , parameter