how to retrieve integer value from database & store it in integer in .net

Question

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{

   SqlCommand cmd = new SqlCommand();
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "select FromYear from Factory where Cal_ID='" + DropDownList1.SelectedItem.Text + "'";
    cmd.Connection = con;
    con.Open();
    dr = cmd.ExecuteReader();
    dr.Read();
    d = dr[0].ToString();
   //d =(string) Label4.Text;
    con.Close();

  }

I want integer value from database

use: int d = dr.GetInt32[0]; also check: stackoverflow.com/questions/7388475/… — fops
– fops, Commented Jan 4, 2014 at 11:36
If you want, then why don't you just do it: ∫i=Convert.ToInt32(dr[0];int i = Convert.ToInt32(dr[0]); — user176134
– user176134, Commented Jan 4, 2014 at 11:37

Taenjai Kaewdee · Accepted Answer · 2019-06-15 15:56:36Z

3

try

SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select FromYear from Factory where Cal_ID='" + DropDownList1.SelectedItem.Text + "'";
cmd.Connection = con;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
int d = dr.GetInt32(0);
con.Close();

dr.GetInt32(0) should read an int at position 0

edited Jun 15, 2019 at 15:56

Taenjai Kaewdee

33 bronze badges

answered Jan 4, 2014 at 11:35

MichaC

13.7k2 gold badges49 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bogdan Sahlean Over a year ago

Please use the parameters ("select FromYear from Factory where Cal_ID=@param) avoiding string concatenation: SqlCommand with Parameters

o3o · Accepted Answer · 2014-01-04 11:50:46Z

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{

   SqlCommand cmd = new SqlCommand();
   cmd.CommandType = CommandType.Text;
   cmd.CommandText = "select FromYear from Factory where Cal_ID='" + DropDownList1.SelectedItem.Text + "'";
   cmd.Connection = con;
   con.Open();

   d = GetYear(cmd).ToString();

   con.Close();
}

the "dirty" work is done by GetYear :

private const DEFAULT_YEAR = 2000;
private int GetYear(System.Data.IDbCommand command) {
   int year = DEFAULT_YEAR;
   using (System.Data.IDataReader reader = command.ExecuteReader()) {
      if (reader.Read()) {
         year = GetIntOrDefault(reader, 0);
      }
   }
   return year;
}

private  int GetIntOrDefault(System.Data.IDataRecord record, int ordinal) {
   if (record.IsDBNull(ordinal)) {
      return DEFAULT_YEAR;
   } else {
      return record.GetInt32(ordinal);
   }
}

Yocto Karthi · Accepted Answer · 2015-11-29 13:35:25Z

0

string InvAmountQuery = "SELECT InvAmount FROM Registration WHERE Email='" + useremail + "' ";
SqlCommand InvAmountcom = new SqlCommand(InvAmountQuery, conn);
int InvAmount = Convert.ToInt32(InvAmountcom.ExecuteScalar().ToString());

edited Nov 29, 2015 at 13:35

answered Nov 29, 2015 at 13:34

Yocto Karthi

214 bronze badges

Collectives™ on Stack Overflow

how to retrieve integer value from database & store it in integer in .net

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related