ASP.NET

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();
                           }
                  }

West1989 wrote:

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

vid nandha wrote:

Do u have more video links or articles for that????

yesu prakash wrote:

How to change the image of the clicked image button in a gridview.