ASP.NET

Page.ClientScript.RegisterClientScriptBlock(this.GetType(),  "openWindow", "window.open('DemoPage1.aspx')", true);

String stringURL = url + "?queryString=" + strSelect;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "openWindow", "window.open('" + stringURL + "')", true);

<script type="text/javascript">
function myfunction(str1)
{
window.location.href='Default2.aspx?id='+str1;
}
</script> 

DA.SelectCommand.CommandTimeout 

mjc225 wrote:

OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM Events WHERE ([EventStartDate]>=StartDateExport) AND EventEndDate>=#12/1/2009#", cn); //This doesn't work.

West1989 wrote:

try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "exec GetBooksByCategory @ID";
cmd.Connection = Connection;
cmd.Parameters.Add(new SqlParameter("ID", categoriID));
return cmd.ExecuteNonQuery();
}

public int LoadByCategories(int categoriID)
            {
                  Connection.Open();
                  try
                  {
                        SqlCommand cmd = new SqlCommand();
                        cmd.CommandType = System.Data.CommandType.StoredProcedure;
                        cmd.CommandText="GetBooksByCategory";
                        cmd.Connection = Connection;
                        cmd.Parameters.Add(new SqlParameter("@ID", categoriID));
                        return cmd.ExecuteNonQuery();
                  }
                  finally
                  {
                        Connection.Close();
                  }
            }

West1989 wrote:

cmd.Parameters.Add(new SqlParameter("ID", categoriID));

DataBinding: 'System.Int32' does not contain a property with the name 'ID'. 

public void LoadByCategories(int categoriID)
                  {
                           Connection.Open();
                           try
                           {
                                    SqlCommand cmd = new SqlCommand();
                                    cmd.CommandText = "exec GetBooksByCategory @ID";
                                    cmd.Connection = Connection;
                                    cmd.Parameters.Add(new SqlParameter("ID", categoriID));
                                    cmd.ExecuteNonQuery();
                           }
                           finally
                           {
                                    Connection.Close();
                           }
                  }