I am new to sql server.

Dim mydataconnection As New OleDbConnection(ConfigurationManager.ConnectionStrings("DBO").ConnectionString)

       Dim cmd As String = "select prod_name,prod_quan,delivery_date,uname and many more from table1& where date between #stardate# and #enddate#"
       Dim mycommand As New OleDbCommand(cmd, mydataconnection)
       Dim mydataadapter As New OleDbDataAdapter(mycommand)
       'Dim mydataset As New DataTable
       'mydataadapter.Fill(mydataset)
       mydataconnection.Open()
       Chart1.DataSource = mycommand.ExecuteReader(CommandBehavior.CloseConnection)

       ' Set series members names for the X and Y values
       ' set series members names for the X and Y values as u need 
       Chart1.Series("Series1").XValueMember = " prod_name"

       Chart1.Series("Series1").YValueMembers = "prod_quan"

       ' Data bind to the selected data source
       Chart1.DataBind()