c# - Database query ignores the first row from the table -




i'm having problem getting result of first row table. ignores , results second row instead.

the query needs result highest or equal value column_b value given in textbox1.

i.e if enter 12 textbox1, result should be: column_a = 1,5 | column_b = 18,5 ignores first row , gives result of column_a = 2,5 | column_b = 25

example of table being used:

 +----------+----------+ | column_a | column_b | +----------+----------+ |   1,5    |   18,5   | |   2,5    |    25    | |    4     |    34    | |    6     |    47    | +----------+----------+

the code:

//table used database     string tableused = "main_table";  //connecting database oledbconnection connection = new oledbconnection("provider=microsoft.jet.oledb.4.0;data source=data\\db\\database.mdb"); connection.open();  //database query     oledbcommand select = new oledbcommand(); select.connection = connection; select.commandtext = "select top 1 column_a,column_b " + tableused + " column_b+0 >=" + textbox1.text + "+0 order column_b+0 asc";  //reading query output    oledbdatareader reader = select.executereader();         while (reader.read())         {          label5.text = (reader[0].tostring());          label6.text = (reader[1].tostring());         }         reader.close();         connection.close();

anyone have solution problem?

you using text data type numeric values.

what's happening +0 code querying values of 18.50, 250 etc. , 250 larger or equals input +0, e.g. 120. 18.50 smaller, not returned in result set.

microsoft access lot of implicit conversion, yes, cannot trust doing.

if want numeric values, use numeric data types.


Comments

Post a Comment

Popular posts from this blog

php - SPIP: From Tag directly to an article -

i work spip , plugin called tagsphere works fine tags in spip. have tag groupe put 1 article tag. when click on tag in tagsphere send me before menu can see articles linked tag. want send me directly article without see tag menu before. here code model of thagsphere: <div id="tagsphere-#env{id_article}"> <ul> <boucle_mot(mots){id_groupe ?}> <li>[<a href="#url_mot">(#titre)</a>]</li> </boucle_mot> </ul> </div> anybody idea? if want skip tag page, have link directly article. <b_article> block prevents display tag if no article linked. <div id="tagsphere-#env{id_article}"> <ul> <boucle_mot(mots){id_groupe ?}> <b_article> <li> <a<boucle_article(articles){...
Read more

jquery - isAjaxRequest always return false -

i got error message 404,'model has not been saved' following code my action controller public function actionextend($id) { $model=$this->loadmodel($id); if(yii::app()->request->isajaxrequest) { $model->todate = date('y-m-d h:i:s a',(strtotime('next month',strtotime(date('y-01-d'))))); if($model->save()) { yii::app()->end(); } else { throw new chttpexception(404,'model has not been saved'); } } } the jquery call $("#buttonextend<?php echo $this->post_row;?>").click(function(e){ $.ajax({ type: "post", url: "<?php echo yii::app()->createurl('post/extend', array('id' => $data['id'])); ?>", }); }); why not ajax call ? thank help i found response, missed } , function ...
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode ...
Read more