Object cannot be cast from DBNull to other types.mscorlib at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) at MySql.Data.MySqlClient.Driver.LoadCharacterSets(MySqlConnection connection) at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection) at MySql.Data.MySqlClient.MySqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at DBClass.selectData(String query, String constr) in d:\Inetpub\vhosts\webitsolution.in\httpdocs\App_Code\DBClass.cs:line 30 at Webitsolution.offers.Page_Load(Object sender, EventArgs e) in d:\Inetpub\vhosts\webitsolution.in\httpdocs\offers.aspx.cs:line 46Object cannot be cast from DBNull to other types.