Saturday, 1 September 2012

No mapping exists from object type System.Web.UI.HtmlControls.HtmlInputText to a known managed provider native type.

No mapping exists from object type System.Web.UI.HtmlControls.HtmlInputText to a known managed provider native type.
    cmd.Parameters.Add("@stud_rollno", txtstudroll);
              cmd.Parameters.Add("@paidfee", txtpaid);
              cmd.Parameters.Add("@remain_fee", txtremain);

that is incorrect that why you are getting error like that.
now to corect it

cmd.Parameters.AddWithValue("@stud_rollno", txtstudroll.Value);
               cmd.Parameters.AddWithValue("@paidfee", txtpaid.Value);
               cmd.Parameters.AddWithValue("@remain_fee", txtremain.Value);

cmd.Parameters.AddWithValue | insert record in asp.net

  cmd.Parameters.AddWithValue | insert record in asp.net
  cmd.Parameters.AddWithValue | insert record in asp.net
try
           {
               con.Open();
               //SqlCommand cmd = new SqlCommand("insert into feesentry_tb (stud_rollno,paidfee,remain_fee)values(8,456,555)",con);
               SqlCommand cmd = new SqlCommand("insert into feesentry_tb (stud_rollno,paidfee,remain_fee)values(@stud_rollno,@paidfee,@remain_fee)", con);
               cmd.CommandType = System.Data.CommandType.Text;
               cmd.Parameters.AddWithValue("@stud_rollno",9);
               cmd.Parameters.AddWithValue("@paidfee",233.4);
               cmd.Parameters.AddWithValue("@remain_fee",4565.34);
               cmd.ExecuteNonQuery();
              //DataTable dt = new DataTable(); 
           }
           catch(Exception ex)
           {
               Response.Write(ex);
           }


            finally
            {
               con.Close();
            }

insert record in asp.net simple program with c#

insert record in asp.net simple program with c#
insert record in asp.net simple program with c#
try
           {
               con.Open();
               SqlCommand cmd = new SqlCommand("insert into feesentry_tb (stud_rollno,paidfee,remain_fee)values(8,456,555)",con);
              // cmd.CommandType = System.Data.CommandType.Text;
              cmd.ExecuteNonQuery();
             
              
               //DataTable dt = new DataTable();
              
              
           }
           catch(Exception ex)
              {
              
               Response.Write(ex);
           }
           finally
           {
               con.Close();
           }

asp.net display code with c# | try-catch-finally in asp.net

asp.net display code with c# | try-catch-finally in asp.net
In this article i have shown to display value in to database using c# using gridview

           try
            {
               con.Open();
               string query = "select * from feesentry_tb";
               SqlCommand cmd = new SqlCommand(query, con);
               SqlDataAdapter da = new SqlDataAdapter(cmd);
               DataTable dt = new DataTable();
               da.Fill(dt);
               grdvw.DataSource = dt;
               grdvw.DataBind();
              
            }
            catch (Exception ex)
            {
                Response.Write(ex);
            }
            finally
            {
                con.Close();
            }
      

Friday, 31 August 2012

Perfect number program source code in vb.net | login

Perfect number program source code in vb.net | login
How to write  Perfect number program code in vb.net using for loop and next
 Dim sum As Integer = 0
        Dim i As Integer
        For i = 1 To Convert.ToInt16(TextBox1.Text) - 1
            If (Convert.ToInt16(TextBox1.Text) Mod i = 0) Then
                sum += i
            End If
        Next
        If sum = Convert.ToInt16(TextBox1.Text) Then
            MsgBox("It is perfect no")
        Else
            MsgBox("It is no perfect no")
        End If