Hello sir, I am getting error("Invalid attempt to call Read when reader is closed.") even though there should be data present. while executing the reader second time.Can u help me to resolve the problem. MY CODE:

SqlCommand cmd6 = new SqlCommand("select productid,serialno,qnty,price,tax,total from invoicetran where qotranid='" + ddlqono.SelectedItem.Text + "' and company_id='" + company_id.Text + "' ", myconnection);

        myconnection.Open();
        SqlDataReader myDataReader16 = default(SqlDataReader);
        myDataReader16 = cmd6.ExecuteReader(CommandBehavior.CloseConnection);
      
       while ((myDataReader16.Read()) == true)
        {
            if (myDataReader16.HasRows == true)
            {
                invproductid.Text = myDataReader16\["productid"\].ToString();
                invserialno.Text = myDataReader16\["serialno"\].ToString();
                invtot1.Text = myDataReader16\["total"\].ToString();
                qnty2.Text = myDataReader16\["qnty"\].ToString();
                invprice.Text = myDataReader16\["price"\].ToString();
                invtax.Text = myDataReader16\["tax"\].ToString();
                untprice.Text = (Convert.ToDecimal(invprice.Text)).ToString();
                unttax.Text = (Convert.ToDecimal(invtax.Text)).ToString();
                unttot.Text = (Convert.ToDecimal(untprice.Text) + Convert.ToDecimal(unttax.Text)).ToString();
                SqlCommand cmd4 = new SqlCommand("select productid,qnty from stock where productid='" + invproductid.Text + "' and status='A' and company\_id='" + company\_id.Text + "'  ", myconnection1);
                myconnection1.Open();
                SqlDataReader myDataReader9 = default(SqlDataReader);
                myDataReader9 = cmd4.ExecuteReader(CommandBehavior.CloseConnection);
                while ((myDataReader9.Read()) == true)
                {
                    productid11.Text = myDataReader9\["productid"\].ToString();
                    qnty1.Text = myDataReader9\["qnty"\].ToString();
                }
                myDataReader9.Close();
                myconnection1.Close();
                if (qnty1.Text == qnty2.Text)
                {
                    SqlCommand cmd5 = new SqlCommand("update  stock set status='NA' where productid='" + productid11.Text + "'and company\_id='" + company\_id.Text + "'  ", myconnection2);
                    m

i have used the dropdownlist with data from database Whenever i run my application it always shows the first item of the dropdownlist as my selected item.How can avoid this Plz hel me?

How can i upload the images with various extension in folder using php

My Format is ("HH:MM")

     DateTime date1 = System.Convert.ToDateTime(txtstarttime.Text);

    DateTime date2 = System.Convert.ToDateTime(txtendtime.Text);
    TimeSpan ts = new TimeSpan();

    ts = date2.Subtract(date1);
    DateTime dt = DateTime.MinValue.Add(ts);
     txttottime.Text=ts.Hours + ":" + ts.Minutes + ":" + ts.Seconds  ;

I have used this but it Produce error when the given values are greater than 24

Hai! How to Calculate Total Elapsed time from given starting value and ending value when the the given values are greater than 24(ie Meter Readings)(for eg:Starting time=1015:35,Ending time=1058:15) Plz Send any Ideas, Thank You

In Master Page: --------------

In Content Page: ----------------

                                     generate\_wysiwyg('textarea2');

What You see what you get script(wysiwyg.js) for textarea is not working in content page

Only serialno of the particular product

Public Function PopulateList() As DataSet

    Dim cmd As New SqlCommand("select qt.department as dept, qt.custid as cusid, q.qotranid as qotranid,q.qoid as qoid,q.productid as proid,q.productname as pname,q.description as descr,q.qnty as qnty,q.price as price,q.tax as tax,q.total as total from quotation q ,quotetran qt where q.qotranid='" & ddlqo.SelectedItem.Text & "' and qt.qotranid='" & ddlqo.SelectedItem.Text & "'  ", myConnection6)
    myConnection6.Open()

    Dim myDataReader As SqlDataReader
    myDataReader = cmd.ExecuteReader()
    While (myDataReader.Read()) = True

        pid = myDataReader("proid")
        Dim ad As New SqlDataAdapter("SELECT q.productid,s.productid,s.serialno as serialno from stockserialno s,quotation q where q.qotranid='" & Trim(ddlqo.SelectedItem.Text) & "' and q.productid=s.productid  and s.status='A' and s.productid='" & productid1.Text & "'  ", myConnection3)

        ad.Fill(ds1, "stockserialno")
       
    End While
    myDataReader.Close()
    myConnection6.Close()

Return ds1
End Function

I have tried above code but it display all the items in every row,but I need to display only those items that coresponding to paricular row.how can i do that?

I have tried but it display all the items in every row,but I need to display only those items that coresponding to paricular row

Public Function PopulateList() As DataSet

    Dim cmd As New SqlCommand("select qt.department as dept, qt.custid as cusid, q.qotranid as qotranid,q.qoid as qoid,q.productid as proid,q.productname as pname,q.description as descr,q.qnty as qnty,q.price as price,q.tax as tax,q.total as total from quotation q ,quotetran qt where q.qotranid='" & ddlqo.SelectedItem.Text & "' and qt.qotranid='" & ddlqo.SelectedItem.Text & "'  ", myConnection6)
    myConnection6.Open()

    Dim myDataReader As SqlDataReader
    myDataReader = cmd.ExecuteReader()
    While (myDataReader.Read()) = True

        pid = myDataReader("proid")
        Dim ad As New SqlDataAdapter("SELECT q.productid,s.productid,s.serialno as serialno from stockserialno s,quotation q where q.qotranid='" & Trim(ddlqo.SelectedItem.Text) & "' and q.productid=s.productid  and s.status='A' and s.productid='" & productid1.Text & "'  ", myConnection3)

        ad.Fill(ds1, "stockserialno")
        Return ds1
    End While
    myDataReader.Close()
    myConnection6.Close()

End Function

How to get the values from database for checkboxlist in the datalist? I have tried something but it display only final record? I want to display all items of particular record? How can I do? plz help me

I have tried but I don't whether I am right or wrong. Following is my coding : Page Load

If Not (Page.IsPostBack) Then
Dim dataSource As DataView

        'Retrieve item from cache if anything is not there then we have to add to the cache


        dataSource = Cache("CheDataSet")

        If dataSource Is Nothing Then

            Dim Conn As SqlConnection
            Dim Cmd As SqlDataAdapter

            'Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("con2"))
            Cmd = New SqlDataAdapter("select \* from tblcutomer2", myConnection)

            Dim ds As New DataSet
            Cmd.Fill(ds, "clientadd")

            dataSource = New DataView(ds.Tables("clientadd"))
            Cache("CheDataSet") = dataSource

            CacheMsg.Text = "Dataset was Created directly from the Datebase. Here the Cache was not used but the Cache was Created,so check for the performence next time."
        Else

            cacheMsg.Text = "Dataset was Retrieved from cache which was created earlier."
        End If

        ddlcus.DataSource = dataSource
        ddlcus.DataTextField = "clientname"
        ddlcus.DataValueField = "intcustid"

        ddlcus.DataBind()
        ddlcus.Items.Insert(0, "-Select-")
    End If

Selected Index event:

Dim cmd As New SqlCommand("select intcustid,clientadd as address from tblcutomer2 where intcustid='" & ddlcus.SelectedItem.Value & "' ", myConnection)
myConnection.Open()
Dim myDataReader As SqlDataReader
myDataReader = cmd.ExecuteReader()
While (myDataReader.Read()) = True

        txtcusadd.Text = myDataReader("address")
    End While
    myDataReader.Close()
    myConnection.Close()

But it takes more time to display address of the selected customer.Can you plz suggest me to reduce the time

I saw C# coding to filter ajax toolkit script when web page loading in the followwing code project link "http://69.10.233.10/KB/aspnet/fastload.aspx" but my application in vb.net. while converting that C# code to Vb.net it causes some error. so please help me by sending relevent vb.net code.

I have binded customer name in that dropdownlist from customer table,my customer table contain more than 5000 records

Hi My web page loading become very slow after using ajax toolkit.so please tell me how to filter Ajax toolkit scripts when web page is loading using vb.net code. I developed my application using vb.net.so I need vb.net source code.

I am begginer,I don't know about data caching,will you plz send me any link to populate me in right direction Thank you

How to increase the speed of dropdownlist selected index change event while more than 10000 records in the database? I have five dropdownlist in a single page,values for that dropdownlist binded from the database when another dropdownlist selected index change event,it takes more time. Plz help me

I have used collectionpager for datalist pagination,its works fine but i am using dropdownlist for sorting the content in the datalist.Here the dropdownlist event is not properly working while using collectionpager .Plz help me? Thanks in Advance..